I am sending this message since I need some help. I would like to display the comment button on the seller profile. So that the buyer user will be able to put comments, but I would like to display the comments button only if the buyer brought a items to the seller. Is anyone has a solution or method to do this ?
For information, I am using stripe and I have already a system with buyer and seller.
Are you using a form to write new comments or a comments component?
Whatever you use, you can integrate conditional visibility to get what you want.
I’m assuming you use Glide’s integrated buying flow. You would want to make a “mirrored” sheet of the App: Sales sheet.
Then, from the SKU name/SKU ID of each purchase, do a relation & lookup to return the Seller’s ID.
In the Profiles sheet, make a relation of the user email to the Sales sheet, then a joined list column to return all seller IDs the user has purchased from.
On each seller profile, show the comments component/comment form only when the seller ID is included in the list above.
I tested the solution again but it seems not working.
When I create a new user without any purchase, the joined list column return all seller IDs automatically in the new user row’s.
Sounds like this was the problem. If you got the structure right, I believe the sales rel should be the user’s email to the purchaser’s email column in your sales sheet. Then the joined text column returns the seller ID.