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

[dbweb]

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.

[dbaum · Accepted solution]

---

@dbweb wrote:

Is this done for convenience as it's easy to just default to "USEREMAIL()"

---

Yes, that's my assumption.

---

@dbweb wrote:

I have many columns that I'm already using the ID value from my Users table

---

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.