hi everyone, i’m struggling with filters.
i can’t figure how to filter data with multiple conditions.
Create an App which objective is to share news. Users are classified by 3 differents categories : Job, Location and Status.
The Objective: each user only has access to the news that concerns him. (right job, right location, right status)
In user sheet, 3 colums : Job, Location and Status
In news sheet 3 colums : Job, Location and Status
with ‘Glide Relation’, i can filter all news by just one categorie (either job or location or status), but I can’t figure out how to do a filter with 3 differents categories at the same time…
In googlesheet, it’s easy with query+OR+AND. But in glide …
someone had any idea ?