Using Forms to search

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.

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.

1 Like

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.

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

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

1 Like

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

May this be helpful?

2 Likes

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

1 Like