Change a text multiple choice value when another field changes

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
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!
Photo of Jason Beaver

Jason Beaver

  • 270 Points 250 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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.
Photo of Jason Beaver

Jason Beaver

  • 270 Points 250 badge 2x thumb
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.  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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.
Photo of Forrest Parker

Forrest Parker

  • 598 Points 500 badge 2x thumb
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"
)
Photo of Jason Beaver

Jason Beaver

  • 270 Points 250 badge 2x thumb
What would the formula look like if I did what you are saying?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
You would need to say in words what the formula should do and then i can help you with the syntax
Photo of Jason Beaver

Jason Beaver

  • 270 Points 250 badge 2x thumb
When Vehicle Status ID changes to 1, then Vehicle location changes to DELIVERED.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
The formula for a new formula text field called [Vehicle Location or Delivered]

will be 

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