I am trying to insert use an action to insert a row into a MYSQL database table. In my specific use case, I have to auto increment the existing MYSQL primary key with the action. I think the topic in the Appsheet community link below indicates that a possible workaround is to use 2 different key columns.
Do this mean using two different key columns (.e. ID fields) in the MYSQL database?
- One key column, the original database Primary Key
- And the other key column, a database field specifically for Appsheet
Car_ID (existing Primary Key)
Car_ID_Appsheet (newly created field for use in Appsheet as the Appsheet UniqueID)
Using this approach:
Will the Appsheet ‘Data: Set the value of columns in this row’ Action
insert a new row to the database table, if the database Primary Key (i.e. Car_ID) is set to
Will the UNIQUEID() expression create a random value, for the Appsheet ID (i.e. Car_ID_Appsheet), that will be populated in both the database and in Appsheet?