I am trying to create a filter in Adalo related to data in Airtable. I work on a category page.
When the user click on one category (i.e. environment), he will see the content related to “environment”. Adalo does not integrate multiple value cell (if there is more than one category per cell), whereas most of my content can have 1 category and 1 subcategory. In Airtable, I have thus created a second column with a subcategory. Each content should be able to appear in both category and subcategory in Adalo.
Also, there is an additional filter in the formula which is “Status = live” (to only display the content that are Live on Airtable, and not the draft content). So far my formula looks like this: AND(({Categories}=‘user cat’),({Status}=‘Live’)). It works for one category but I don’t know how to integrate the subcategory in the formula. Any idea?
Hi @J_Begoood,
Just for the reference - AND operator in Airtable can have more than 2 arguments. See here: Formula Field Reference - Overview | Airtable Support
Best regards, Victor.