Skip to main content

API : How can I filter with "has none of"?

  • June 10, 2021
  • 1 reply
  • 34 views
F

Hi there,

Hope you’re doing well !

Can someone help me to formula-translate “has none of” please ? :slightly_smiling_face:

What i need to do is to make a webhook call to filter some results and only take the ones which does not contains “SFR or Orange” in “which_network”.

Thanks a lot

1 reply

K
Forum|alt.badge.img+10
  • Katerie
  • Inspiring
  • June 10, 2021

OR(FIND("SFR", ARRAYJOIN({which_network})), FIND("Orange", ARRAYJOIN({which_network})))

This will return 1 if either of the two terms appear in the multi-select field, and otherwise returns 0. This will let you duplicate the “has none of” behavior.

To set it up so that it will also return 1 if the field is empty, use:

IF({which_network}, OR(FIND("SFR", ARRAYJOIN({which_network})), FIND("Orange", ARRAYJOIN({which_network}))), 1)

That will allow you to filter to only get items that have some selection other than “Orange” or “SFR”. This is not quite the same as the “has none of” filter, but it might be useful for your purposes.

ScottWorld
Terms & ConditionsAccessibility statement