Solved: How to search items with specific features and sho...

you_tube · 06-07-2019 09:31 AM

Dear my friends
Please download from this link my excel file

I have this data in my app.
For instance I want to show or search only properties with price between 100000$ and 250000$ with the number of bathrooms between 5 and 7 with “Luxe” or “Superluxe” possibilities in main page of my app.

How can i do it in appsheet?
Is there any way?
I hope to tell what i mean?

Thank you for your support

LeventK

@you_tube
I believe it will be more useful for you to use go over the option that @Aleksi had proposed above. Open the app editor and go to Data >> UserSettings. You have 10 user specific fields there. Activate and adjust them as per your needs. Then you need to create a slice of your table as Aleksi had explained. You can start here:

View solution in original post

Aleksi

Something like…
AND(
[PRICE]>=100000,[PRICE]<=250000,
[BATHROOMS]>=5,[BATHROOMS]<=7,
IN([POSSIBILITIES],{Luxe,Superluxe})
)

you_tube

Thank you very much for your help.
I’m beginner in appsheet.
Where should i copy it?
I want to have this ability in appsheet that can change it without coding in different ways.
Change bedroom ,price , and …
Did you see realtor app yet?

I’m trying to build like this.

Aleksi

That formula would work for example with a slice.

you_tube

But where can i see the result ?

I copied price code but i didn’t see the result in main page of app.
Please tell me more about it because I’m beginner in appsheet

Lynn

Hi @you_tube You need to make a view from your slice to see it. UX> views> new view. Select the slice as the data source.

you_tube

Thank you very much.
That is the answer of my question.
But another question is that how can i set a flexible filter like Realtore app that i could filter by any price or other features like numbers if bath bedroom or …

Is there any way to have a filter buttons on top of the app to search easily in our data?

Mike_A

You might want to take a look at this example app. It should help you build what you are looking for (or at least get you closer):
https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266...

you_tube

Thank you very much.
The app isn’t same that i want.

Unfortunately I can’t find how can i creat such this filter!

Mike_A

I am not sure I understand what you mean by “connect to my app”. The demo I app I provided is just an example to look at. It shows you how the slices and views are used to allow user selection (filtering). I assumed you might look at the design approaches and decide what adjustments you might make for your specific app. There is not “filter” object that can be added to an appsheet app. you use a combination of slices and views to accomplish this.

you_tube

I think it’s so hard to do this !

Mike_A

It’s not a single step but can be done. I would encourage you to stick with it and learn the multiple steps involved. I can understand your concern as there is a bit of a learning curve here…

you_tube

I wish appsheet had plugins to do this!

Excel has filters that we’ve created in all coloumns but after import it in appsheet we didn’t see any filters!

I’ll work on it.
Thank you

Mike_A

You can use the Appsheet search bar (but that’s unstructured). Can also try the “Assitant”.

To get an excel type “filter” will take a bit more work

you_tube

I searched in the internet but I couldn’t find a functional example !
Anybody is there to have a functional example of search by filter?

you_tube

This site is great app builder with filter capabilities.
https://www.openasapp.net

But we can’t edit app offline!

Lynn

@you_tube Maybe you could get some ideas from here or from the sample apps.

https://www.appsheet.com/SampleApps/Index/account

you_tube

I’m looking for an app to use filter like excel.
But in appsheet filtered didn’t apply as i want!

Aleksi

It sounds that you want to filter the table view with field by field, is that correct?

you_tube

Yes
like excel that you can filters items to see items tht you want and Everytime you can clear all and apply another filters with another features.
In appsheet now we can only arrange items by names or amount from largest to smallest or inverse.

Aleksi

One option is to filter data with Usersettings but it needs save.

you_tube

I couldn’t find it in user setting?
Can you tell me more where is it exactly?

Aleksi

It’s not already there, you need to change one of those columns for your own needs. You can choose what ever from that settings page.

you_tube

Can you send me an example in appsheet?
How can I do it?

Aleksi

Basically you need to upadate for example 4 columns in the Usersettings table. When the user fills these 4 fields in their own device, you can filter the slice with a formula like…
AND(
[Price]>=Usersettings(Lowest Price),
[Price]<=Usersettings(Highest Price),
[Bathrooms]>=Usersettings(Lowest Bathrooms),
[Bathrooms]<=USersettings[Higset Bathrooms)
)

you_tube

Ok
I understand next step.

But in first step we have 9 coloumns in the usersettings as you see in the picture.

How should i update those coloumns?
What words should I add or …?
In which box should I add ?

I’m a beginner!

Aleksi

Remember that you can choose any of them and you can update those columns as you want. In generally it’s the same than updating your normal table/column structure.

Aleksi

Check this article… https://help.appsheet.com/data/user-settings/user-settings-the-essentials

you_tube

I looked at this page.
But it seems this is not what i mean.
I want to have a filter to control and search all of parameters of properties.
Like Realtor app

I think there is no way in appsheet!
Install Realtor app to find what i mean

LeventK

@you_tube
You can construct your own Advanced Filter with a Form UX and when the form is saved you can direct the user to a filtered view with the selections on the form. We had once done the same to a property manager client.

LeventK

@you_tube
Check this app in my portfolio. Go ahead and try Advanced Filtering. Isn’t this what you are asking for?

you_tube

Thank you for your reply

I think this is what I mean.
Can you more explain how to do it?
Where do we creat Form ux? And how?
Can you share your app to see data ?

LeventK

@you_tube
Basically you need to construct a FILTERING table in your gSheet with all the filtering components you would like to include and import this table to your app. Than go to UX in the editor and assign a FORM Type view to this table. Name it as you like i.e. Advanced Filter etc.

Secondly you need to construct an Action with all the conditional criteria resulting to a LINKTOFILTEREDVIEW deep link. You need to assign this action to the Form Saved property of your Form View constructed above. When selections are made and the form is saved, the Form Saved action will be triggered and take you to the filtered view that you have specified.

The app is under my portfolio named as Land Resource and you are free to take a copy of it from here > https://www.appsheet.com/portfolio/245151

you_tube

Thank you so much
I will try.

LeventK

You’re welcome

LeventK

@you_tube
Also please consider the solution that @Aleksi had already proposed. As UserSettings are device specific, it’s a more robust solution than mine provided you don’t have/need filtering criteria more than 10.

you_tube

Yes of course

But I need a functional example for aleksi solution to find how to do it

LeventK

@you_tube
I have a community sample app which I use to reply posts as a showcase/proof of concept. I will try to build a sample there for you. Give me a couple of hours pls.

you_tube

Thank you very much.

you_tube

I tried to looking at your app.
I’m beginner and I think it was so complicated.

I have a very simple excel data that you can see in the link:

and I think your app is so professional.
I should learn more about appsheet and try to add filter button

My app is very simple
I have 5 coloumns
Area
Bedroom
Bath
Price
Possibilities

I want only to have advanced filter button to filter these 5 coloumns.

Is there any possibility to share my app with you ? (I don’t know how)

How to search items with specific features and show in main page