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 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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.