Dynamic Dependent Choices

Hi @Rasha

If what you write is what I’m thinking… you are right 150%: the relations don’t work in a form.
While the form is loaded, there is no saved data in your fields/entries so there is no a key field (value) to create relations. Just later when the form is sent, the user data is available and everything begins working.

I noticed this when I was creating the Private section (with Sig-In User) and due to it, I used an only one choice component in the form. This is a case where I can’t figure out a workaround, sorry.

Have a nice night!

Saludos
Gavp

You understood perfectly! Thanks for confirming @gvalero. I suspected that was the reason behind the 1 component decision in the Private section. You have a good night as well. Salut.

1 Like

Hi @gvalero

Very nice App. I’ve tried to duplicate what you’ve done in your app, however, my choice section is not immediately populating the spreadsheet. Can you help me understand why that is.

Hi
My APP can be copied as a template and then you can see its all configuration.

Saludos @pluhg

Hi All,
I used already the template presented above. It works if you are showing your data. If you are entering data, this one won’t work. I hope glide can create a component to have a dependent choice. When you make your first choice, Glide should be able to go to your google sheets, get your list for the second choice without the need to have this first choice already in google sheets. On a regular spreadsheet, the moment you have your first choice in the cell, your selection for the second choice will be available. When you choose your choice in Glide, still not in the Google sheet cell yet. You need to press “done” to have the data in the google sheet then the second choice will be available. I can see a lot of people that want to have this available. And this is what I am looking for. Sorry for not using all the correct words to explain that. I am a self learner and the computer vocabulary is not the best thing I have but I am beIng able to do great things with Glide. Thanks all.

Hey, I wanted to do the sam thing @AsiaOffTheBoat asked, but can not open your App (

Can you show us your current data structure? I think the setup will work if you have this.

Yeah here, choices are staying in form when you click on of accounts

I want appear sub-categories connected to category, when I select category

So do you want to use these in a form environment, or do you want to click the Categories items and be able to see sub-categories inside?

In form environment for now