How to set some values be autogenerated and some be manually entered using table.recordUpdates in bulk update query

Hi Retool team,

I want to let the end-users update existing records directly on the table without entering data into forms or text input components.
In this case,

  1. Can I use bulk update via primary key action alone without having another query using updating an existing record action?
  2. If some updated values are autogenerated and some require users to manually enter, how can I revise {{ Table.recordUpdates}} in the bulk update query? Right now, {{ Table.recordUpdates}} only update values that are manually modified in a row.

Thank you in advance for the help!

Hi @doris.l :wave: thanks for reaching out with these questions!

You may find it particularly helpful to check out the Adding a new record to your database or API section of the documentation; I think the content there should nicely address your questions, but please feel free to let us know if you have any other questions too!