Edit userlist formula field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
We assign users into a PROPERTY MANAGERS user list on a 'PROPERTY' table, and would like to default the users into an ASSIGNEDTO field on a TASKS table related to the property.  However, we would like to be able to then edit the user list on the task to add or change users assigned to the task. Any direction would be appreciated.

Thanks, Ron
Photo of Ron

Ron

  • 50 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
I would suggest doing lookup down to the the tasks table and then have an Override field and then a field field which is calculated. 

On the view form you would just show the calculated final field.


IF(not IsNiull([my Property managers List User Override field]), [my Property managers List User Override field],


       [default lookup field])
Photo of Ron

Ron

  • 50 Points
Worked great, thanks. Ron