Help converting a GSheets formula to AppSheet

Hello everyone,
I need help converting a GSheets formula to AppSheet.
My goal is to be able to filter a view according to a column - let’s call it [CODE].
Using the advanced search DEMO, I can filter a code, but currently in GSheets I use a field like this:
123 + 456 + 367
With Substitute () and Query () I can get a filter from these 3 rows, but in AppSheet I can’t get that view.

The search field cannot be enumList because the goal is to make copyPaste something like (with a variable number of entrys):

123 + 456 + 367

and get something like this:

FILTER ("PRODUCTS", OR (123 = [CODE],
456 = [CODE],
367 = [CODE])
)

It’s possible?

0 5 958
5 REPLIES 5
Top Labels in this Space