Why is "Name" Made Key?

AppSheet AppSheet Q&A
1

I am refering to this sample app
https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders

In Customers table, why is “name” Made a KEY? There will be many customers with Same name. Wont this create any issues while Referencing & Reverse referencing between “Orders” table and “Customers” table?

2

Yes, it will be an issue if there are Customers of the same name.

1 Like
3

I have been using this app for more than 1 year now. I will add the UNIQUEID aas Key. But wont there be any issues if I deselect NAME as key?

4

If you change the key, you’ll have to edit the data of any references to that table as well.

5

Alternatively, copy all of the exiting Name column values to the new key column, so that existing references will continue to work. New rows will be given new keys using the new key formula.

4 Likes