Change default value of Text - Multiple Choice field on newly added record based on logged in user

This would be done using a form rule.

make a field called [Current User] with the formula of 

User()

Then have a form rule 
when multiple conditions are true

All of 
When [my Text - Multiple Choice field] equal (blank) 
When [Current user] equals [email protected]

Action:
Change 
[my Text - Multiple Choice field] to "Fred"

Make sure you uncheck that hidden checkbox at the bottom so that the rule fires all the time.


Then,  when that rule is working,  copy the rule to make a new rule and change it to cover Barney.

You should be able to do a "Test as User" to test this.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------