I have a table called ‘Orders’.
I have a column called [Reference #] (Type: Text)
I have a column called [Size] (Type: Enum)
We are a watermelon shipper. [Reference #] is my companies reference number. [Size] is a list of different sized fruit that we sell (45ct, 36ct, 60ct, etc…). Each row of my table ‘Orders’ has consecutive [Reference #] values (ie 200001, 200002, 200003 etc…).
Problem: If for example, Reference #200001 calls for a split order of 45ct and 60ct and 36ct melons.
Help Needed #1: I need to be able to add multiple [Size] fruit to each individual [Reference #]
Help Needed #2: I need to be able to add a quantity amount for each of the newly added [Size]
Help Needed #3: I need to be able to show each [Size] and quantity on a gDoc template
TIA for any help, comments, or suggestions.