Hello, I have built an application whereby I retrieve a filtered list of records from SQL Server TABLE-A and display it to a user in a table object (table_selected) through ReTool.
I wish the user to be able to select multiple rows in the table on the screen (table_selected), and then click a SUBMIT button to add the selected rows to a new TABLE-B in SQL server.
I have been playing around with the table_selected.selectedRow.data property but I cannot for the life of me figure out how to change that data into the appropriate JSON required in a bulk insert query for my database TABLE-B.
Any tips or how to guides would be appreciated.
Bonus points for how to translate different field names