Discussions

Expand all | Collapse all

Change a text multiple choice value when another field changes

  • 1.  Change a text multiple choice value when another field changes

    Posted 03-01-2018 22:46
    I am trying to find out if there is a way to change the value in a drop-down box when a value in another field within the table changes.  

    Example:

    If field A (formula-text field) changes to "Done", I want Field B (Text-multiple choice) is change to "Finished".

    Thoughts??  Thank you!


  • 2.  RE: Change a text multiple choice value when another field changes

    Posted 03-01-2018 23:02
    Can you tell me more about this formula Text field. You can use a form rule as long as the field is changing as a result of a user editing the record.


  • 3.  RE: Change a text multiple choice value when another field changes

    Posted 03-01-2018 23:32
    Formula text field is exactly a numeric (summary) type.  When a certain number comes into this field, it changes the value in a formula text field.  I want to be able to change the value in the multiple choice field too.  


  • 4.  RE: Change a text multiple choice value when another field changes

    Posted 03-01-2018 23:39
    The only way to do this will be to make a new field which is a formula field which is based on the Done field and the manual field. Multiple choice field.


  • 5.  RE: Change a text multiple choice value when another field changes

    Posted 03-01-2018 23:41
    What if you simply made Field B a formula text field instead of a text multiple choice field. 
    Sample formula:
    if
    (
    [Field A]="Done"
    ,"Finished"
    ,"Pending"
    )


  • 6.  RE: Change a text multiple choice value when another field changes

    Posted 03-02-2018 16:46
    What would the formula look like if I did what you are saying?


  • 7.  RE: Change a text multiple choice value when another field changes

    Posted 03-02-2018 16:57
    You would need to say in words what the formula should do and then i can help you with the syntax


  • 8.  RE: Change a text multiple choice value when another field changes

    Posted 03-02-2018 16:59
    When Vehicle Status ID changes to 1, then Vehicle location changes to DELIVERED.


  • 9.  RE: Change a text multiple choice value when another field changes

    Posted 03-02-2018 17:13
    The formula for a new formula text field called [Vehicle Location or Delivered]

    will be 

    IF([Vehicle Status ID] = 1, "DELIVERED", [Vehicle location])