Hi we are trying to make a private page where a customer has to be logged in to see their purchases. Like lets say we sell recipes, then each custumer would only see the specific recipes they each bought.
So we have used custom filter on the data base and it used to show but now it will only show all or none, not the specific one. Also it never stays in there. Customers have to be able to come back and see their product.
Also would need to store this buy so we can see customers email and which product they bought.
We do get an error msg everytime we test the app about login, would that be an issue?
So explaines quickly:
customer chooses a product from a dropdown menu, clicks on a botton, that button directs to a buy botton on another page and then its supposed to be a buy and end them up on My Page to see their product. Hope it makes sense.
In order to create a filter, you need to link records in Users and Recipes collections somehow. In Adalo this is called “Relationships”. Otherwise you can’t create any efficient filter.
So there are 2 ways to do it:
either to create a many-to-many relationship between Users and Recipes. When a user buys a recipe, you update Logged-in User → Recipes → Add current recipe (I am assuming that you have a list of recipes and current recipe card / page).
or you can have a separate collection “Purchases”, each purchase is linked to one user and one recipe. Then you can create a screen with a list of Purchases, filtered by Logged-in User → Purchase. In order to access Recipe details, you can use relationship Purchase → Recipe.
Thank you. We do have the databases and relationships. So it must be something with the logged in user. We did report sign up issues to adalo and we are waiting for them to help.