Ok so i understand where you are getting at with the first part using the Part formula. If i assume a maximum of 10 line items, ill create 20 fields (10 for each line item and 10 for each quantity).
The second part will write an automation to have each pair of fields converted into a child record. not sure how this would look, but i'll check it out.
The last part you have got me though regarding the automation deleting line items, please explain? Are you saying that if only 3 items are created the 4th automation will overwrite the previous ones?
