This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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?
Specifically:
One key column, the original database Primary Key
And the other key column, a database field specifically for Appsheet
For example:
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
auto increment?
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?
LinkedIn
Twitter
