Auto Compute Form Based On User

[Sam_Sulkey]

I am trying to use a formula to Auto Compute some columns in a form based on the User that is adding a new record. I know I can use USERNAME() and USEREMAIL() in a formula and it works for those columns, but I would also like it to fill in the Users phone # and some other things. Do I create a user spreadsheet and ref the columns in the form?

[Marc_Dillon]

Sam_Sulkey:

Do I create a user spreadsheet

Yes

You can make your life easy by setting an Email column as the key column, then you can easily use dereference expressions.

help.appsheet.com

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.

[Sam_Sulkey]

Thank you!!! Exactly what I’m looking for!