Using Forms to search

[Kam_Rezvani]

Hi,

I am new to AppSheet and trying to set up multi-field search Form that looks like follows:

So far, I have not been able to find the options to replicate this in AppSheet. I believe a form like this cannot be used for search purposes in AppSheet. Each field completed adds an ‘AND’ filter to the query.

How do I go about implementing this functionality in AppSheet? Thanks for your help and guidance in advance.

[Aleksi]

Hi, you would need to create Dashboard with two views… one for typing (with quick editable detail view) and then sliced table view where the data is filtered depending on your selections.

[Kam_Rezvani]

Thank you for the tip. It would be helpful if I could see a sample app that is similar to what I am trying to accomplish here. I looked through some the existing sample apps and didn’t see anything similar. Is there one you can point me to? It is a multi-field search function.

[Aleksi]

Let me check my sample apps if there is anything similar…

[Aleksi]

Check the sample app called “Filtered Dashboard” from www.appsheet.com/portfolio/531778

[Jorge_Santos]

Hi Aleski.

Im trying to do something very similar to what you have done. but i cant nail it.
I´ve Check you “Filtered Dashboard” in detail, and added a second field in the “dahsboard” from which i can make a composite search (Color).

The problem is the following:
I need the Field color to be a combobox form the field “color” (Sheets: Data; Appsheet Table: Data)
And that i cannot do!!!

Is there another way a can make the field color in your dashboard a combobox that reads form the table?

Im i doing this the wrong way? Can you tell me what is the correct way?

in the slicer i changed the formula to: and(ANY(Filter[NUMBER])<=[NUMBER] , ANY(Filter[Color])=[Color])

Many thanks in advance!!!
Jorge

[Fabian_Weller]

May this be helpful?

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…

[Jorge_Santos]

Hi Fabian.

Sorry for the delayed reply!
Thanks for you reply and solution. i will download the app and take a long hard look at it!!!

Cheers
Jorge