Columns that reference Users....better to use Email or ID?

AppSheet AppSheet Q&A
,
1

I see many of the template / examples that store an association with a user based on Email address.

For example, the CRM template has a Notes table, and the Author is simply the User’s email address.

Is this done for convenience as it’s easy to just default to “USEREMAIL()”, or is there some other reason?

I have many columns that I’m already using the ID value from my Users table for the reference, but I want to make sure I’m not going against the grain or limiting myself in some way AppSheet convention wise.

Thanks in advance.

1 Like
2

Yes, that’s my assumption.

Although it can be less convenient in some situations, this is actually the more robust approach. For example, this approach more easily accommodates changes to a user’s email address.

1 Like