How to ensure unique IDs in Appsheet
1 min readApr 6, 2024
Here’s how to ensure unique IDs in your data, even without a built-in database function:
Two key considerations:
- Database-generated IDs: Whenever possible, try to have unique IDs generated directly within the database you’re using. This is generally the most reliable and efficient approach.
- Google Sheets as your database? If you’re using Google Sheets as your data source, here’s a formula you can leverage:
=CONCATENATE("ID-", TEXT(MONTH(NOW()),"00"), RIGHT(TEXT(DAY(NOW()),"00"),2), "-"…