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

(Sk Ski) #1

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) #2

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

(Sk Ski) #3

thanks

your advice

(Aleksi Alkio) #4

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) #5

감사합니다 ^^ Translate

(Sk Ski) #6

Thank you

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

(Faustin Ngassa) #7

@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!