Change a text multiple choice value when another field changes

Question

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!

quickbasecoachd · Answer

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 · Answer

Formula text field is exactly a numeric (summary) type.&nbsp; When a certain number comes into this field, it changes the value in a formula text field.&nbsp; I want to be able to change the value in the multiple choice field too.&nbsp;&nbsp;

quickbasecoachd · Answer

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 · Answer

What if you simply made Field B a formula text field instead of a text multiple choice field.&nbsp;Sample formula:if([Field A]="Done","Finished","Pending")

jasonbeaver · Answer

What would the formula look like if I did what you are saying?

Forum Discussion

Change a text multiple choice value when another field changes

Related Content

Using Grid Edit to Edit Multiple Records at Once

Moving Fields from One Table to Another

Changing/setting record owner

Edit Multiple Records at Once with Grid Edit

Historical Date Change Tracking