Hey all, some tables to set the stage (with an arbitrary food theme): [image] Basic stuff right? Next step: a ‘recipe maker’, i.e. narrowing down possible food items by the selected category or categories. Like this: [image] UPDATE for clarity: selecting “fruit” as category should provide selec…

Here’s my take on it. A bit more complicated than I’d want to but it appears to work for all cases. I initially arrived at the same formula as @Ander , but as you @mr_motus observed it breaks for more than 1 category. This is because Contains is inherently an OR function. The solution for this need…

@mr_motus Maybe this will help, as a starting point. You can customize it to your specific requirements.

Wow, thanks for the trouble. I will play around with it for a bit and report back later. Cheers!

Here’s my report: it works great :grin: (at least when selecting just 1 category). The solution seems so simple, but I’d never have come up with it! Currently, selecting more than 1 category leads to a bigger selection. E.g. selecting “fruit” & “green” leads to a list with all fruit items AND all g…

@Dalmo_Mendonca Nice work! :muscle: I was pursuing that same solution, but didn’t quite get it all put together. Good to know that at least I was headed in the right direction!

Dear @Dalmo_Mendonca , Impressed about your creative approach and sharing it in the community. :hatching_chick: Amicable, //JP

@Dalmo_Mendonca , that is very impressive! I’m still trying to wrap my head around what exactly is going on here, but it definitely works. Thank you so much, this will be a very nice quality of life improvement for me! EDIT: A MODE.MULT function would’ve been nice by the way: [Pre filter].Mode.Mult(…

It would all be easier with a ContainsAll function! Glad to help. I’d love to see your progress with this later on. I was playing with something similar, thought I’d paste the full recipes text in a column, then use the natural language package to autocategorize it. Wasn’t sure on how to do the se…

Good point! Didn’t even consider ContainsAll() anymore. I will add it to my request thread. I should have something ready to share in a few days. To be continued…

[image] Dalmo_Mendonca: Btw, I’d like to see some dev explan why this worked: [image] As the color shows, the parser identifies CurrentValue as a row of Food item DB inside the Filter scope, but that way the formula makes no sense. It only makes sense if CurrentValue was the current category …

Dear @Dalmo_Mendonca , See the post below, your wish came through as ContainsAll() is now available :slight_smile: [image] Three New Formulas - ToTime(), ContainsAll() & ContainsOnly() News from Coda Hey everyone Wanted to share a quick update that we’ve added a few new …

Apples & Oranges: select items using an advanced category filter. Is this possible?

Jean_Pierre_Traets June 18, 2019, 11:08am 12

Dear @Dalmo_Mendonca,

See the post below, your wish came through as ContainsAll() is now available

Topic		Replies	Views
Help with Filtering Formula Showing Repeated Results Across Rows	10	263	August 7, 2025
Filter results shown in a select control?	4	1705	February 15, 2019
Multiple Controls Issue with Table	7	96	January 22, 2026
Use one table to filter another?	11	908	December 3, 2022
Interactive filter	2	606	April 23, 2020

Apples & Oranges: select items using an advanced category filter. Is this possible?

Related topics