Bulk update without primary key

💬 App Building
3

Hi @Mahaveer_Ukrani,

One feasible solution is transforming fetched data from DB into Retool JS Variable with artificial ID.

  1. Create Retool JS variable

  2. Generate artificial ID with UUID package and transform it. Save it to created JS variable in onSuccess event handler.

    image
    image778×772 26.6 KB

  3. You can now use the artificial ID as the primary key for each row. To insert or update new records in the Retool table component, utilize the saveAs event handler with the changesetArray and newRows attributes of the table component. Refer to this link for implementation details: Table Save Action - Set Table Value In A Variable - #2 by mitchmess

  4. For bulk updates, you could use the JS variable while ignoring the artificial column.