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.

Create Custom HTML Forms for SharePoint with this jQuery Plugin

CRUD Operations In SharePoint REST API Using jQuery AJAX

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.