hi there I want to search data on multiple ta...

[Sk_Ski]

hi there I want to search data on multiple table in one app table located in google spread sheet

as you see there is a lot of sheet

i have diffcult in making searching app on every sheet

is it possible to search data in all sheet?

[Steven_Coile]

I don’t believe you can search in more than a single table (worksheet) with AppSheet.

[Sk_Ski]

thanks

your advice

[Aleksi_Alkio]

Steve is correct. One workaround is to create a simple search form which would show you from which table you can find the data.

[Sk_Ski]

감사합니다 ^^ Translate

[Sk_Ski]

Thank you

I must find another tools except appsheet Appsheet is good tools to search But it has limitation

[Faustin_Ngassa]

@Sk_Ski A workaround I have found is to create a virtual column that concatenates the columns I want to search on

and then set that virtual column as LABEL.

Example:

In my inventory app, I want the user to be able to search the Product table by item code [Product Code] OR by item description [Description]

1- In the Products table, I created a virtual column [_Code_Description] with the app formula CONCATENATE([Product Code]), " ", [Description])

2- In the *Products table I set the [_Code_Description] as Label

Now in the app, all fields that reference the Products table bring up a search field in which whether you enter the code or a word in the description, you get the item.

Do not give up on AppSheet, it is awesome!

[Ing_Fred_Fiifi_]

Am interested in this kindly do sample for me please