I have a SQL database, I have configured BCS service in my SharePoint, using SharePoint Designer. It's means Now i have External list. What I want, i want read and insert this external list data through a custom form Note: This custom form our organization every employee they can access if it's success. it is possible? Please suggest me best way.
You can set permission for the external list, and using the OOTB list form to read and insert data to the external list.
If you still want to create custom form, we can using HTML code and jQuery code with REST API to get data or insert data to the list.
The following articles for your reference.