I have a table of car brands in an AppSheet database. This table has the columns "ID" and "Make." AppSheet automatically populates the first 10 rows with a unique ID and the car brand. I have a list of 40 car brands. I copy and paste this list into the "Make" column of the AppSheet database. Now I need to generate the unique IDs for these rows (see screenshot below).
Is it possible to generate the unique IDs directly in the AppSheet database table, or do I need to do it separately?
Solved! Go to Solution.
AppSheet database creates a field called Row ID that contains a UniqueID(โPACKEDUUIDโ) expression. You can omit creating an ID column and use Row ID as the row identifier And even if it doesn't look like by default, it's there.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |