I am using Google Cloud SQL for my app (actually transfer everything from google sheet to Google Cloud SQL) and reorganizing all the data. I have some compulsory things that have been asked for this database: I must use primary keys auto_increment for all my tables.
I have seen in the documentation some explanation about the different ways : https://help.appsheet.com/data/data-integrations/using-data-from-mysql
Everything is well explained but I can not use the RANDBETWEEN() function solution. Indeed, the most of my tables must have increasing IDs over time. Therefore, I imagined another solution:
Put this formula in the initial value: =MAX(table[id_column])+1 Make my id_column KEY HIDDEN REQUIRED in appsheet
This solution seams to be working, but I am asking myself if I missed something. Does anybody already tried this or has an idea about the troubles I might have using this solution?
Thanks a lot