Display a list of products based on booking status

[gucaetan]

Hi everyone!
First, sorry about my english.

I’m trying to building an app to control rent bounce inflatable bookings and I’m new if Bubble.
I need only show the products in a list, that are available for that especific order date. I already do that in other system, but in Bubble, wihtout programating, it’s being very difficult for me

. If, anynone can help me, I really appreciate.

The structure it is like that:

I have the Data types:

• ORDER, where I save data about event date, shipping address, account, start hour…
• ORDER ITEM, where I save data about product, quantity, unit price, total price, order…
• PRODUCT, where I save data about name, category, description…
• PRICEBOOKENTRY, where I save data about product prices, catalog used (because, I can have more than one price catalog)…

The sequence it is:

• Create an account, order, select the pricebook, select products to create order item.

I need just show to the user, the products that have available to the date choosed in the order. So, I need check if the quantity available it is gretter than stock product quantity in that day.
Let me know if it was clear.

Something like that:

[geesonofgee]

A simple approach will be to add a constrain to the source of the repeating group (RG) where the product’s “date created /modified” as the case may be = “selected order date” then make sure to check “ignore empty constrain”

@gucaetan

I need just show to the user, the products that have available to the date choosed in the order.

As for this am not clear on what you want to achieve