Dependent Dropdown Question

[rickmcdata]

Hi Ya’ll

I’m a non-dev generalist and my background is in tech docs and I’m building my first app.

It’s a four-level selector tool to provide decision support for healthcare workers.

I have a google sheets tool that I built with some simple dropdowns and formulas. I’m a total hack, but it works fine. Now I want to create a mobile app that I can show SMEs, get feedback, and quickly update on my own.

• All data is in one google sheet table
• App content will be read-only
• Initial selection has 9 unique values that will not change
• Using valid-if on the other 3 selections

For now, I just want to get one view working:

1. Select four criteria
2. Display the result as details of that row/record on the screen

I’ve watched the Dependent Dropdown video and poked around in the sample app. The issue I have is in order to display the dropdowns, I need to “add”.

How do I get the all four dropdowns to just display on the screen?

[MultiTech]

Hey @rickmcdata, welcome to the community.

First: you might check out the following post; it’s full of tons of helpful tips to help you get stared with using the community to find answers.

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

---

rickmcdata:

The issue I have is in order to display the dropdowns, I need to “add”.

I’m guessing the problem you’re having is that the dropdowns are all programmed into your sheet - but they’re not automagically working in your app… yes?

You’ll need to “Add” the options for your dropdowns into your Enum columns by either:

1. adding the options direction into the Enum options (hard-coding them in other words); or
2. creating a valid if/suggested values formula that pulls the values from another table or from a formula or something.

Bottom line, you’ve got to provide options to the system (AppSheet that is) in order for there to be anything for the system to use.

[rickmcdata]

Thanks for the reply!

MultiTech_Visions:

’m guessing the problem you’re having is that the dropdowns are all programmed into your sheet - but they’re not automagically working in your app… yes?

The sheet I am using as source for my app in Appsheet is data only. No formulas.

MultiTech_Visions:

1. adding the options direction into the Enum options (hard-coding them in other words)

Yeah, I’m going to hardcode enums now and figure out the formulas down the line.

I was hoping to find a read-only product selector in the sample apps, but haven’t found one. I’ll just build the product selector sample app myself when I get this figured out. Appsheet seems like a great solution.