I was just looking at the plugins and there is a plugin that removes the duplicates for you in a dropdown. Take a look. If I find it I will send you the link.
@J805 hey, quick questions on building a real estate listings platform on bubble. How can I only show a listing for a period of time when user had paid for that time frame?
i am trying to figure out how to do the database of that. I have 6 products the users can buy before uploading the listing: each product is a month. Not sure if I should have a product type with the different fields and manually create the products and link it to property to with a product field in property? I am a bit confused, how would I then add the range of time it would be listed for?
I think there are probably a few different ways to do this.
The first thing that popped into my mind would be to set an API Endpoint backend workflow that you could schedule. If the listing would be posted immediately and only for a month, you would just need one workflow to ‘turn it off’ in 1 month.
You could have a data field set to ‘display yes/no’ and have the scheduled workflow just turn this to ‘no’. In your repeating group you would only show the ones that have this data field set to ‘display yes/no’ set to ‘yes’.
No problem. On the backend you can choose API Endpoint.
Then for the ‘key’ type in listing. The type will be your listing type. Then your first step will be a ‘make changes to a thing’. This will be ‘listing’ (or whatever you called your key) and change the field to ‘no’ to turn it off.
On the front end, after they pay, choose Schedule an API Workflow (Endpoint) and make sure you choose Current Date + 1 Month for when to schedule it. It will ask you which listing to send back. Just pick the one you need to update.
the api workflow is genius. I am stuck now trying to implement it in the workflow after the user pays. Because the user might pay for more than one product, ex: listing + featured listing I am not sure how to tell the schedule API workflow to only trigger when the user has bought specifically that product.
So for instance, I did a product type and manually created the products with their fields by name, price, description and in my type ‘listing’ i have a product field which is a list of products. So I want to tell the API workflow trigger when the in the 'listings products list there is product x".
Payments are so hard. You make a great point , its supposed to be a 1 time payment but at the same time the payment should be able to auto renew. So for instance, you pay for a 6 months listing but your property hasnt being sold if you accept on auto renew payment you get a 20% discount on your next 6 months. Not sure if that answers your question.
At this point and after your help I understood the API webhook, its a very cool feature which i didnt know it existed.
The more I think about it the more complex I feel it is.
To upload a listing you need to pay and you have 4 types of products. 3, 6, 9 and 12 months.
You also can pay to feature the product, so if you feature it it goes on top of the page.
I guess I could do another API workflow just for that and in the RG state that listings with that have the feature active are shown first.
Should I also make API workflows for the other products, 3,6,9 and 12? Does that mean that I also need to add 4 fields to the type listing?
That is complicated. Maybe you can do something like this, just as an example:
Sign the user up for a subscription
Based on the time frame they choose you can set a backend workflow to trigger after 3, 6, 9, or 12 months. You can cancel the subscription only if something is triggered for that listing. If the user canceled this subscription and extended it, then don’t let the workflow run and cancel it. But instead create a new scheduled API workflow at the correct time.
That’s just a thought. I hope that makes sense. There is obviously a lot to consider.
Glad it worked.
