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.