Database set up for e commerce app

[gurudattyadav]

Hello User,

I am working on mobile app to have all grocery deals from various retailer .
Data base set up as follows:
User select city
Under city are category
Under category are various product.
From this list the user select the product

Now City and category screen are working fine.
However the with product screen , it show all the product and not limited to product in that city.

[dilon_perera]

Hi @gurudattyadav ,

Welcome to the community

Is it possible to attach some screenshots of your Database and filters in the lists?

The filter that you have added to the Products list that you have attached as a screenshot should work! But I see that there is another filter or filters as OR. For what are that filters?

Thank you

[gurudattyadav]

User database & records in the user database

City database & records

Category Database & Records

Product Database & records

Product Screen

No other filter in product screen

Thank you for your support, really appreciate.

[dilon_perera]

Thanks for the Screenshots!

The filter should works! What happens if you remove the filter and reload the tab and add the filter again?

For nor information is it possible to attach some screenshots of what are the products should appear in the list for that currently logged in user’s city and what are the products that are displays now?

[gurudattyadav]

Hi Dilon,

thanks a lot and appreciate your reply.
Earlier under product screen all product use to appear (all category and all city)

Now i can filter & see the product as per the user city , but need to solve filter related to product as per category. i see all the product under all category
please suggest , how can i filter product as per user selected category.
screenshot as follows:

this is my current product view, user city filter working but the category filter not working.
ex: under dairy category i see bakery item as well

[dilon_perera]

@gurudattyadav

thanks a lot and appreciate your reply.

Your Welcome!

You can add another filter as AND to the Products list like Current Product > City > City > is equal to > Current Category > Name. At the end there should be 2 filters in the Products list!

[gurudattyadav]

Thanks again fo your prompt reply
but i cannot see current category>Name in the filter , it show log in user

database set up for category and product

[dilon_perera]

Does the Current Category Data is available on the Product screen? You can see that selecting the Product screen and go to the Available Data section and you will see a missing message of the data is not available and if the data is available you will Current Category!

If you see a message like Current Category missing from this screen you need to delete that link action from that screen. Patrick explains this issue very well in these two videos! : Adalo Tutorial: Most Common Mistakes - Current Data Not Available On a Screen - YouTube , Adalo Tutorial: Most Common Mistakes - Current Data Missing From Screen, Data Loops and Flow Breaks - YouTube

[gurudattyadav]

Problem solved, Thanks a lot Dilon