Auto Compute Form Based On User

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?

Yes

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

3 Likes

Thank you!!! Exactly what Iā€™m looking for!

2 Likes