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.
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
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?
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
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |