One filter for two fields (select if one has the value)

[Pedro_Rodriguez]

Hello,

I have a table like this:

Id      Ran1    Ran2    

1        12         24          

2                      12           

3         17        20           

4          24       14           

I need one filter with all possible values of Ran1 & Ran2 where, if I select x values, it applies to Ran1 or Ran2. For instance, if I select in that filter values 12 and 14, I would get:

1        12         24          

2                      12          

4          24       14           

I've tried creating a new field concateneting Ran1&Ran2 with a delimiter, and using a trigger that selects ='*'&RanFilter&'*' in that concatenated field. But this doesn't work when I select more than one value.

Any ideas?

Tanks!

[Taoufiq_Zarra · Accepted solution]

attached 😁

[Brett_Bleess · Accepted solution]

Pedro, did Taoufiq's post and example apps help you with your use case?  If so, please be sure to return to your thread and on his post, use the Accept as Solution button to mark that as the solution giving him credit for the help and letting other Members know this worked.  We do expect our Members to close out their threads if possible, especially if they have received posts.  If you did something different, please consider posting that and then mark that post, and if you need further help, leave an update.

Regards,
Brett