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?
LinkedIn
Twitter
