I keep trying to give AppSheet a try but OMG i just want to throw my computer out the window. And mind you not I have been doing development for 16 years using php and nodejs.
OK here is my dilemma. I am using a MySql database to hold my table.
Table 1: Equipment
Fields: id (auto increment) / name / model / serial_number / status
Table 2: Equipment_Service
Fields: id (auto increment) / equipment_id / description / service_comment / status
I added both in my appsheet and set up the tables. The system added _RowNumber to each table. I than related the two via the equipmnet_id.
When you try to create a new equipment the equipment_id shows as required and cant be set to blank. Also you can not unself the key option as you will get “key needs to be set”, i than set up the _RowNumber as key but that still did not work.
I than set up the formula to UniqueID() only to get the error “cannot use an app formula”
So what is the point of a key if you cant set it to be automatically unique???