Save copy of record with new id
Confluence User - 20 Jun, 2017
My use case requires the ability to bring up a form with fields populated from an existing record and then after changing a name field save it with a new id. I have tried creating a form which uses the JDBC Binder and then referencing it in a Userview Form Element. In the relevant Datalist I added a hyperlink with the URL of the Form element in the Userview and which passes the id of the record to the SQL Query for the JDBC Binder (SELECT * FROM app_fd_eido_procEpisodes WHERE id = ?) in the Form. This works and loads the Form. However, when Save is clicked the changes are written back to the same original record rather creating a new record with a new id. How can I accomplish the intended result?
forms;datalists