Skip to main content

Hi All,

I have a Table in the form that shows the data from the SQL database. Is there any way to Edit those data in the form and the data should also be updated in the database?

Hi @Dems 



 



In theory it is possible but would require an extensive and complex workflow to interpret the input from the form and translate that into table queries.



 



Really for table manipulation you need to elevate the form table data to a list level, then it is a fairly simple workflow to manage related data, Another and honestly better option would be to use external content types that would sync the SP list to SQL, again this can be complex to set up but would be the most supportable solution.



 



https://learn.microsoft.com/en-us/sharepoint/dev/general-development/external-content-types-in-sharepoint



 



 


Thank you for your response @Jake .



But I want to edit the data requested from SQL in Nintex form using JavaScript. for instance, I have displayed exact same table from SQL in Nintex form and I want to add edit button to each records displayed in the form. when edit button is clicked, the data can be edited and must be updated in the SQL database. Is there any possible ways to edit the data using JS ?



I have attached the image of  data that I have displayed in the Nintex form from SQL.


Hi @Dems 



 



It is possible to edit SQL data in table using Nintex Classic forms with JS but it would need to be coded, sadly however I can only advise you on a course of action.



 



I recommend building a solution that works similar to below popping up edit into a modal screen and use AJAX to manage the data.



 



https://codepen.io/AlexSkorkin/pen/qYpVdO



 


Hey @Jake
I think this is the general solution but How we can push the edited data into the SQL database?

Hi @Dipeshh 



 



You would either need to pass the data via an Ajax call built with the JS or Store the data into a SP field via the Nintex form as XML/JSON, parse that with workflow and then use workflow actions to update SQL.



 



 


Reply