Check if one of the ids in a list is present in the table

tecnologia4 · 2025-02-05T19:17:18.149Z

I have a filter table, where it has the fields: id(number), name(text) and filtered(boolean)

Screenshot from 2025-02-05 16-09-051520×652 111 KB

I also have another table called files
where there is the filter list field, which is basically of type filters (table)

Screenshot from 2025-02-05 16-09-391511×488 72.8 KB

I have a repeating group, and I would like to display only files for which any of the filters are yes

example: one of my records has a list in the filter list field with the ids: [36, 37, 38] if one of the ids is yes in the filters table, then show the file

What I’ve achieved so far is: show the file if all filters are selected:
example: if 36 is selected, nothing appears, but if 36, 37 and 38 are selected, then the file appears

with this formule

Screenshot from 2025-02-05 16-16-08731×366 32.8 KB

How can I do it so that, if any of the ids are yes, the file appears, instead of needing to select all the filters it has?

system · 2025-04-16T19:17:57.571Z

This topic was automatically closed after 70 days. New replies are no longer allowed.