Noob here. Working on AppSheet for a small company. Traditionally, I would have an Employee ID and a Customer ID included as fields for Employees and Customers data sets. Am I correct to say such ID fields are no longer necessary? Duplicate data records will some how be figured out by AppSheet? Thanks. SW
It depends.
I follow this criteria about ID/Key columns.
Always UNIQUEID()
and hidden.
This means that ID is just used as a reference to relate tables on the backend.
If you are talking about the ID that is shown on the ID Card, this is just another field of the table that should not serve another purpose rather than extra info from an AppSheet app perspective (IMO).
Anyway, you need a key column on your tables.
When it comes to the Key of each row, yes, appsheet doesnโt allow to enter the same Key value twice.
But, you shouldnโt be using manual Key values.
If you need to have some sort of ID column that is not the Tableโs key, you could create a Valid_If expression
Thanks, Oscar!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |