How to change the eligible values on a drop-down list in a form?

Juan Carlos Reguera

Hi,

I want to display two drop-down list fields on a form (Model and Serial Number). The values ​​in the serial number field should be conditioned by the one selected in the "Model" field.

Is there a way to do it?

Thank you for your cooperation.

Paul Newcome

Unfortunately not. How many different Models do you have?

Andrée Starå

Hi @Juan Carlos Reguera,

Recently I developed something similar for a client, and I ended up adding columns for each option.

In your use-case, it would be something like,

If Model A is selected in the form, it would show the serial numbers in the Model A Serial number column through the Logic feature.

Would that work?

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!

Paul Newcome

@Andrée Starå That is along the lines of what I was thinking. Hahaha. That's why I asked how many Models there are.

Juan Carlos Reguera

Thanks for your answer.

Unfortunately, both the quantity on Model and Serial Number values ​​are high and very changing, so I need an automatic process to do it. (Conditional filters on the displayed fields or something similar)

Thank you very much for your quick response.

Keep up well.

Paul Newcome

Andree may have other ideas, but if having different fields for each Model to display the appropriate Serial Number values is not an option then I am left with suggesting that you Submit A Product Enhancement Request when you have a chance.

Andrée Starå

@Juan Carlos Reguera

Ok. You would need to look at other options. How many different Models could there be?

Juan Carlos Reguera

Hi, Andrée.

I'm working with about 70 differents models.

Thanks in advance.

Regards.

Andrée Starå

@Juan Carlos Reguera

Happy to help!

A solution that would be perfect for this use-case is the premium add-on, Data Uploader. Is that an option?

We could use it to sync the values to the different columns and then build it with logic to show the correct dropdown list for the selected model in the form.

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader