Hi! I am trying to populate Choice Box #2 depending on option form Choice Box #1. I can’t seem to find a way to use filters to “tell” glide to only show those rows that match Choice Box #1 selection. Is there anyway this can be achieved? Thanks a lot!

@Yakito here’s a working example. [image] Screen Recording 2021-04-15 at 06.35.47 AM Link to copy back: https://tdslab.glideapp.io/

In your choice component #2, is there not an option to filter by screen’s choice component 1 value?

Hi! thanks for reaching back. I do see the the value when I set the filter [image] The thing is that the choice list is coming up blank, that’s why I was wondering if I could place in a text the values for “vendor ID” and “screen vendor ID” Again, thanks for your help

If it’s the second choice component in the screen, shouldn’t the filter be vendor ID is not screen’s first choice component value. Is that value available at all to you? I believe it works normally in a form, not sure how it functions in an add environment.

Thanks again for your time @ThinhDinh ! So, basically this is my DB structure. I have an orders table and a products in order table linked by order id. This is the “add items” screen for the products in order table. On Choice #1 the user selects the order from the order table On Choice #2 I wan…

Currently to do this easily, you can use a detail screen by building whatever you need there. I’m going to sleep now, but tomorrow, unless my dear friend @ThinhDinh has already intervened, I’ll send you a working example.

Thanks a lot! will try to replicate that with my setup. I will get back to mark it as solution. Thanks a lot for your time and help!

Thanks a lot for your help @Roldy and @ThinhDinh Also, Happy Birthday @ThinhDinh Have a beautiful day! :cake: :birthday: :fireworks:

Hello @ThinhDinh ! Can you tell me if this same method for filtering a choice based on the selection in the first choice works with pages? I’ve been trying for days to get this to work in pages, but I was able to get it to work in an app the first time with no assistance. works in app: https://sol…

I haven’t touched Pages much. Can you record a video of the supposed bug in Pages? Thanks a lot!

Populate choice box depending on another choice box

Ask for Help

SantiagoPerez November 6, 2021, 12:09am 19

Topic		Replies	Views
Problem selecting "Screen" values in a CHOICE component Ask for Help	5	381	November 23, 2021
It's posible to create this logic inside a Edit Form? Ask for Help	8	422	January 28, 2022
Newbie Question - Choice component and filters Ask for Help	1	234	December 7, 2023
Filtering Options In Choice Component Ask for Help	1	340	October 19, 2021
Help to filter a choice component from screen values Ask for Help	9	343	April 24, 2023

Populate choice box depending on another choice box

Related topics