selecting drop down value on save

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have created an alternative form for a functional group holding their own role to create a project when required. In usual primary role I have certain required fields defaulted. So for the alternative role using a dedicated form, I need to force certain values in the drop downs before record is saved.  For example the project status field is usually defaulted to 'Parked' status in the table but in the alternative form I want this to save  "Active' in this field. Tried form rules but no luck. Will appreciate if someone could help.  

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
It should be able to work with form rules.

I would create a formula numeric field called [Record ID# mirror].  Make it just equal to the [Record ID#].

When multiple conditions are true

When [Record ID# mirror] is equal to (blank)
User is in the Role xxxx
Change my feld to Active


Then
 At the bottom uncheck the box to be the rule fires unconditionally all the time.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks. Works like charm.