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?
You can make your life easy by setting an Email column as the key column, then you can easily use dereference expressions.
Thank you!!! Exactly what I’m looking for!