Set the default value to to a specific user on a List - User field

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I'm trying to set the default value to a List - User field to a specific user instead of the current user. Is this possible? If so, any assistance would be appreciated.
Photo of Dan

Dan

  • 30 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
Not tested but you can make a formula List user field with the value of the default user and then use a form rule to populate if its blank.  Post back if you need help with the formula
Photo of Angela

Angela

  • 20 Points
I could use help with the formula, please. :-)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
not tested by try this

Make a formula List User field type called [Default List User] with the formula

ToUserList(User())

Then make a formula rule that says that when the list user field is empty change the value to the value in the field [Default List User],  

Uncheck the checkbox at the bottom of the rile so that it fires all the time.
Photo of Angela

Angela

  • 20 Points
Thanks so much!
Photo of Dan

Dan

  • 30 Points
Thanks for the response. Could you tell me a little on how to do that. I tried playing around with it but I cannot get it to work.