Is it possible to save the data back to saveable data page using a DT
If we are updating the data page with new records how to save it back to the saveable data page using a DT(data transform)
Accepted Solution
Updated: 16 May 2024 6:59 EDT
Maantic Inc
IN
Then in the data transform that is sourced in the data page, set all the values that you want to add in the data table except the primary key of the table. If the primary key is automatically generated for new records then you can keep it blank in the data transform. If you need to manually create a new primary key, then you have to set the value in the data transform, but keep in mind that that value should not exist as primary key in any other record in the table. After that you can trigger the savable data page and it'll insert a new record in the table with a new primary key.
Accepted Solution
Updated: 16 May 2024 6:59 EDT
Maantic Inc
IN
Then in the data transform that is sourced in the data page, set all the values that you want to add in the data table except the primary key of the table. If the primary key is automatically generated for new records then you can keep it blank in the data transform. If you need to manually create a new primary key, then you have to set the value in the data transform, but keep in mind that that value should not exist as primary key in any other record in the table. After that you can trigger the savable data page and it'll insert a new record in the table with a new primary key.