Filemaker Filter Portal By Dropdown

[@martineaglen]

Great video and great channel. Thanks

[@boonkidjackson8300]

Thank you! This is exactly what i need

[@osks]

Very nicely done!

[@mgig9649]

Thank you very much. I loved the video and it helped me in a small personal project I am doing.

[@GerryHoch]

I am not sure if you are still looking at these comments but if i have multiple portals on my form, how do I use this tutorial on a specific portal?

[@thethinkstudio1200]

You can create a field for searching a specific portal. Call it like portal_A_searching - and then double click the portal on the layout and filter portal by field and then select the portal_A_searching field and then filtered based on the fields inside the portal.

[@lnebw99]

I don't understand the underlying technique. Do you drop the global in a self relationship gYear AND Year, and in the same time perform a find in the front table? Interesting that all tutorials (I have seen) on filter portals seem to use only self related tables, which I find less useful - I can just perform a find in a list of this table. Showing a sub-set of related records from other tables would be more useful.

[@thethinkstudio1200]

Yeah, I have a second video that I need to upload that shows multiple table filters along with multiple drop-down fields - filtering for one table. I figured out a way to have it be very dynamic where if each drop-down is empty it shows all records, if one drop-down is selected, it shows that result, and if both have data it shows that result. There are a ton of ways to meet a single end goal.

[@victorleon5887]

Hey Cameron, great tutorial! This helped me create a filter. Question for you: how can I do this with 2 dropdowns that speak with each other? For instance, I have a dropdown with years (2020, 2021, 2022) and a second dropdown with months (Jan, Feb,...) If someone filters by year, they can further filter by month. Is this possible?

[@thethinkstudio1200]

Yes it’s possible. In the script you doing the searching in on object modify. You’ll have to create multiple of statements. If is empty (year) & not is empty (month) This will search for all the month selected but no year selected. Else if not is empty (year) & not is empty month This will search for selected year and month Else if not is empty year & is empty month This will search for select year but no month End If Extra tip if you want the user to select year before selecting a month. Then you could hide object (month field) if is empty (year field) If you need a video let me know.

[@victorleon5887]

@@thethinkstudio1200 Your response time is impeccable and very much appreciated. If you're able to produce a quick video, I would be forever grateful. I learn by following.

[@thethinkstudio1200]

@@victorleon5887 thank you. I’ll try and complete tonight for you.

[@victorleon5887]

@@thethinkstudio1200 Hi Cameron, did you get the chance to play with this?

[@thethinkstudio1200]

@@victorleon5887 i will make sure to do tonight.

[@ChrisBates-sn2nb]

You went way to fast on the scripting part. I have no idea how you show All Records. Filemaker scripting dumbs it down so much it actually makes it harder than if you just typed it all out. I know you can't just type "show all records.'

[@thethinkstudio1200]

Yes you type "Show all records" in the script editor as a script step

[@IdeationInvestigation]

You didn't show the relationship graph, so it wasn't clear which table you were in at each step

[@thethinkstudio1200]

I only made one table so that’s the only table throughout the whole video. You can also see name in for each layout around top left of design view!