Change the value of a field based on the selection in another field - In a FORM

Dave Mead

Hi,

This question is based on using a Form for entering data.

I was wondering if I can change the value of a field based on the selection in another field. e.g. If I select TBD in a dropdown it will show a red flag.

I have a field with a default White Flag - I need to flip it to Red as a warning if a user is entering data that will be flagged later.

I need to use a TBD as they may not have the data on hand and it is an indicator to get it - otherwise I would simply only give them valid options in the drop down :)

All I can seem to do in the Form is show fields or not.

Andrée Starå

Hi @Dave Mead

Do you want the flag to change in the form or in the sheet?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Dave Mead

Form as described in my question.

Andrée Starå

@Dave Mead

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could structure the form using Form Logic to show a message or another field with the flag as red when the user selects TBD.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Dave Mead

Thanks. My first impressions are that Forms need some more options.

That may help. I can create 2 fields. 1 set as a white flag and 1 as a red flag.

Can I lock the values so the user cannot change them?

It is also an excess number of fields :(

Andrée Starå

@Dave Mead

Happy to help!

You can't lock the value, but you can hide it so they can't change it.

Make sense?