Skip to main content
Question

Change a text multiple choice value when another field changes

  • March 2, 2018
  • 0 replies
  • 62 views
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!
    This topic has been closed for replies.

    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.
    • JasonBeaver
    • Author
    • Quickbase Alumni
    • March 2, 2018
    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.  
    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.
    • ForrestParker
    • Quickbase Alumni
    • March 2, 2018
    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"
    )
    • JasonBeaver
    • Author
    • Quickbase Alumni
    • March 2, 2018
    What would the formula look like if I did what you are saying?
    You would need to say in words what the formula should do and then i can help you with the syntax
    • JasonBeaver
    • Author
    • Quickbase Alumni
    • March 2, 2018
    When Vehicle Status ID changes to 1, then Vehicle location changes to DELIVERED.
    The formula for a new formula text field called [Vehicle Location or Delivered]

    will be 

    IF([Vehicle Status ID] = 1, "DELIVERED", [Vehicle location])
    Terms & ConditionsAccessibility statement