To edit the Data of a table in form

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

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.