Im stuck looping trough a list repeatable/selectable to create new things in database

[Shimon]

Hi im pretty new to bubble and i watched and read articles and documentation but i cant wrap my head around this i need some help please

here in the first screenshot i demo the page where a user can create a order and add multiple items to that newly created order
i didn’t configure the + button yet since I’m not sure which route I’m going to take
This repeatable group data source comes from my items table where i have all items stored and I’m pulling the item description - item ID etc.
what i wanna achieve is like this when a user clicks on the + button this item with the information from the fields should be pushed into a hidden group

now when the user clicks on save draft or create order i wanna start a workflow which will

1. Create a new orders record with the basics PO# And delivery date
2. Create separate order items records for each of my repeating group info pulling the value’s of the input fields and linking it to the original items table via itemID and of course linking it to the order which was created for this
3. at the same time previewing the hidden group with all items populated so its a nice user experience

i cant get my head around how to get this working
the populated data is from one data type
and i need to get the value’s from each and save as a new data type

thank you

[hi.luisacosta]

If you are new to bubble, I would simplify the experience here.

1. Select (Pickles) and create a Order_Item and Add to your order, then you display the inputs for quantity etc.

Then you don’t need to trigger a workflow that creates a list of things.

Would that be enough?

[Shimon]

so youre saying on tapping add should run the workflow to save is that correct ?

[hi.luisacosta]

Basically I think when you arrive to this screen, you should already create the Order.

The status = draft. If they exit, you can just delete the order later (like in 24 hours).

Anyway, now that you have an Order. When someone selects an Item like “pickles” from a list of Items. You create the Order_item at that moment, save it to this Current Order. NOW the user can edit the Order_Items fields like Quantity.

then, when they click CREATE order… it’s really just a status change to “Submit”

This is a simpler way to create and manage this experience.

[Shimon]

i understood
now how do i pull from the database the QTY for this specific newly created thing?

[hi.luisacosta]

The user needs to input it.

So you need to change up your design. The shortlist should be “order_items” and you can use auto-binding to edit the Field values.

In order to add new Order_Items, the user needs to add items to their Order_Items. Maybe you can use a sheet with all the available items, then set the QTY to 1 as a default

[Shimon]

but the items data im pulling from the “items” data type and i wanna save it as a new entry to “order_items” together with the additional input fields

[hi.luisacosta]

Right… which is not directly possible with a simple method using bubble because you cannot access the input in the repeating group row to get that data.

So my simple route is to change how it works by first having the user select what Items he wants to order, then he can change the amount when it’s saved as Order_Item.

This current setup you have will be too complex to explain here on how to achieve it. I don’t personally think it’s worth the trouble. The options to do so are Orchestra Plugin (not sure if works on Native Mobile) or custom JSON.

[Shimon]

got it thank you will figure it out