Limit List Options

AppSheet AppSheet Q&A
1

I’m trying to figure out a way to limit options in column 2 based and answer given in column 1. Think of it as manufacturer/model situation. Column one user selects manufacture column to automatically limits options to models from that manufacturer.

I’ve created a reference sheet that lists the manufacturers in column 1 and the models in separate columns based on manufacturer.

Not sure what type of “Valid_If” equation to use. Or even if this is the right process.

Basic example. Uses selects Ford. the next option would be limited to only Ford models.

Thanks in advance

2

Hi @cmunson,

Welcome to AppSheet community!

Could you take a look at following sample app and article on concept of depedent dropdowns

Article : https://help.appsheet.com/en/articles/961554-dependent-dropdown

Sample App:
https://www.appsheet.com/samples/How-to-create-a-dropdown-menu-with-values-that-depend-on-earlier-choices?appGuidString=f9584a6f-935d-48e6-85ec-050b85b93aea

2 Likes
3

Perfect. Thank You!

1 Like
4

Short Answer:

Data > Column > {Your_table}

Manufacturer column:
Pencil icon > Data Validity > Valid If: {Your_table}[Manufacturer]

Model Column:
Pencil icon > Data Validity > Valid If: {Your_table}[Model]

1 Like