Help converting a GSheets formula to AppSheet

[Sergio_Sa]

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?

[TyAlevizos]

Any chance you can share a reference design/ sample app and/or google sheet against which to work?

[Sergio_Sa]

Hello @TyAlevizos.

So it’s like this:
While creating a new SampleApp to explain you what my goal was, I could see that with a help column I achieved the goal.
Thank you however you made me make the App because I had tried in many ways and could not.
I leave here anyway how I got it:

I create a VC [RESULTADOS] - Type List with:

    FILTER("PRODUTOS",  
      IN([Código],[_THISROW].[Código]) 
      )

And create a Help Column [HelpCódigo] - Type Text

in Column [Código] - Type EnumLis t put the App Formula:

SUBSTITUTE([HelpCódigo]," "," , ")

This the result, and is important when you want to analyze some rows that you can copy from a spreadsheet

Thank you very much.

[Fabian_Weller]

Wow that’s cool. Thank you for sharing @Sergio_Sa

[Sergio_Sa]

UPDATE:
I share the workaround here to search for word fragments in multiple columns.
Hope it is useful for someone.

The formula used is:

 IFS(
    ISBLANK([HelpCódigo]),FILTER("PRODUTOS",TRUE),
    FIND('%',[HelpCódigo])> 0,
    FILTER("PRODUTOS",AND(CONTAINS([Search],[_THISROW].[S1]),CONTAINS([Search],[_THISROW].[S2]),CONTAINS([Search],[_THISROW].[S3]))),
    FIND('%',[HelpCódigo])= 0,FILTER("PRODUTOS",IN([Código],[_THISROW].[Código])
    )

and for [S1], [S2] AND [S3]:

IF(ISBLANK(INDEX(SPLIT([HelpCódigo],"%"),1))," ",INDEX(SPLIT([HelpCódigo],"%"),1))

Changing the INDEX number
Based on:

Search multiple columns with different criteria Tips & Tricks 💡

The built in search is very easy to use, but it only allows a single search term across all (searchable) columns. [36%20AM] A multi-term search can be built by constructing a Virtual Column of type List with elements of type Reference. The formula should return a list of keys from the table you want to search, and should update the list based on your search terms. FILTER("Order", AND( OR( ISBLANK([_THISROW].[Status]) , IN([Status] ,[_THISROW].[Status]) ), OR( ISBLANK([_THISR…

from @GreenFlux

[Kanha_PM_Office]

Great ! Thank you @Sergio_Sa