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?

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

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 :slight_smile:

Thank you very much.

3 Likes

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

1 Like

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:


from @GreenFlux

2 Likes