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
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.