Can somebody help me if there is a formula or function that have the same use case of SQL "LIKE" (eg. WHERE CustomerName LIKE '%or%') function and show the results on a list on screen? Any workaround for this? (classic builder)
=FILTER(client, "client[name] LIKE "%test%"")
something like this
figured this one out by:
=FILTER(client, "SEARCH(""test"", client[name]))
Hi @Jimballoon,
I'm so happy to hear you were able to figure this out!
Please let us know if you have any other questions.
Thank you, Evelyn
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.