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 want to only show products from the products table that match the vendor ID that comes from the order(vendor ID) table chosen on Choice #1 Unfortunately when I do this [image] It returns empty, that is why it would be awesome to be able to debug the values in order to understand what is going on, but I can’t find any way to print those values anywhere on the screen. Again, if you have any suggestion I will super appreciate it. Thanks for your time.

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://solitary-grain-6435.glideapp.io/ racking my brain in pages: https://dashing-earthquake-3610.glide.page/ When I add the filter to the second choice field (description) the choice field disappears. I’ve tried the entire method in other ways besides the form. Nothing works. Thanks for your help!

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	388	November 23, 2021
It's posible to create this logic inside a Edit Form? Ask for Help	8	454	January 28, 2022
Newbie Question - Choice component and filters Ask for Help	1	238	December 7, 2023
Filtering Options In Choice Component Ask for Help	1	351	October 19, 2021
Help to filter a choice component from screen values Ask for Help	9	374	April 24, 2023

Populate choice box depending on another choice box

Related topics