Create new thing from repeating group on screen

Hi there,
I want to create new thing based on repeating group.
Here are my types.
Type 1: “Products type”
fields are Product name and Product price.

Type 2: “Order type”
fields are Product name and Number of order.
Product name is linked to Product type.

When user log in, I show the list of products by using repeating group.
Each row of the repeating group displays product name, price and blank input where user can add number of order for that specific product.

After that, when user click “submit order”,
I want to create new things on Order type based on the information from repeating group.

For example,
User sees repeating group like below
1 Apple $3 [ ]
2 Orange $6 [ ]
3 Grape $10 [ ]

User can add number they want to order
1 Apple $3 [5]
2 Orange $6 [3]
3 Grape $10 [9]

Then, my Order type DB should be
Apple 5
Orange 3
Grape 9

I eliminated other fields to make it simple.
In real DB, “Order type” has Order date, Order User to be filtered.

Does anyone know if this is possible?
If so, how can you do this?
I tried to use schedule workflow. but I don’t know how to extract the data in each cell in repeating group.

Thank you for detailed and well-constructed answer so quickly.
However, I have a few questions.

Q1 You said, “Use the “Make changes to a list of things” action to create new Order entries.” but I want to create new thing. Does “Make changes to a list of things” create new thing?

Q2 Where should I place the “Submit order” button? inside repeating group or outside?
Hopefully I want to create all order things by clicking submit button once.

Q3 Related to this operation “In the “List to change” field, use the “List of inputs” option and select the repeating group’s list of products.” I couldn’t find “List of inputs”.
Can you give me the instruction for this?
(Using do a search for and set constraints?)

Thank you for your help. I really appreciate your advices.

This topic was automatically closed after 70 days. New replies are no longer allowed.