Hi there guys, hope you can help me to solve because I spent the whole night on that without experiencing any success
I have a list of product requested which is (for exemple) : A,B,C,D
I need now to display the users that can provide this items . Using the function :contains list i will see only the user(s) which own all products requested. If there is no user which owns all the items the RG will be empty.
I want to avoid that because sometimes needs of customer can be satisfied by multiple users.
so let’s say that in my db there are the following users
User 1 owns " A,F,Z"
User 2 owns “G,H,I”
User 3 owns “B,C,E”
User 4 owns “D,H,I”
Okay so my RG should display User 1, user 3 and user 4
I tried all functions but with no success
I’m sure that I was so close
A great thank you to the hero of the day
Additional informations:
In the first case ( one user own all the products i used this formula on the RG : “Search for users:filtered” and in the filtered section this: " Advanced : Search for order’s requested products contains list This user’s ownings"
The db is structured as follows:
User : “ownings” is a list of products
Products : products from catalogue
Order: "requested products " is a list of products
Here you have the app in editor : https://bubble.io/page?id=testforsellerbuyer
The application offers the right to edit , so if you made some mistakes use the page backup to restore the previous situation
the user "user@test.com" owns all the product
use this link to test changes : https://testforsellerbuyer.bubbleapps.io/version-test?id=1518220148672x323478448204696200