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.
1 Answer
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
-
Thanks Buddy , can we retrieve External list data same like normal custom list using RESTApi? this is my query actually.Mohammad Tahir– Mohammad Tahir2019-10-08 11:05:10 +00:00Commented Oct 8, 2019 at 11:05
-
1Yes, you can see the official document here: docs.microsoft.com/en-us/sharepoint/dev/general-development/…LZ_MSFT– LZ_MSFT2019-10-09 01:15:16 +00:00Commented Oct 9, 2019 at 1:15