Is it possible to dynamically change the default position/value of a dropdown based on a formula.

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
For e.g. Dropdown has 3 option: (X,Y,Z).
If field A has the value 1, Dropdown should have default value (or automatically sets to the value) of X and if field A has the value 2, Dropdown should have default value (or automatically sets to the value) of Y.
Photo of Naveed Ahmed

Naveed Ahmed

  • 250 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
I am sure you have considered the possibility of using a formula for field2 that is based on the value of field1. If you feel that it is not such a straight-forward situation, you can use dynamic form rules to just that. And to make it more generic, you can even use automations.
Photo of Naveed Ahmed

Naveed Ahmed

  • 250 Points 250 badge 2x thumb
Hi Surya, I do not understand. Will appreciate some clarity. One is a normal/regular field and the other (which needs to be made dynamic) is a drop-down. 
If you can use a formula field for field2, then it will not be a dropdown anymore. Which means users cannot change the value of field2 directly. It would be auto calculated based on the formula (for field2) Hope that clarifies.
Photo of Naveed Ahmed

Naveed Ahmed

  • 250 Points 250 badge 2x thumb
Okay thanks. I need it to be a drop-down. Can you suggest what else I can do keeping in mind the requirements i have. How would automation help?
You can create a dynamic form rule on the data entry form, where the user selects a value for field1. Then that form rule can check for the values of the value in field1 and change the value for field2 accordingly.

If you need further help, you could contact me from my profile information.
Photo of Naveed Ahmed

Naveed Ahmed

  • 250 Points 250 badge 2x thumb
thanks.