Discussions

Expand all | Collapse all

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

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

    Posted 04-24-2019 14:52
    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.


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

    Posted 04-24-2019 14:58
    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.


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

    Posted 04-24-2019 15:09
    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. 


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

    Posted 04-24-2019 15:11
    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.


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

    Posted 04-24-2019 15:14
    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?


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

    Posted 04-24-2019 15:17
    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.


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

    Posted 04-24-2019 18:47
    thanks.