I have suppliers that ship multiple samples from overseas. I would like a form that they fill out where they make one entry to the form for all samples, and it connects the shipping information to each item without multiple entries. They would provide the shipping information - ship date and freight carrier, tracking number… Then they can list out the sample item numbers, names, recipient for each sample shipped. When the person hits submit, a line item with the shipping information is created and each sample on the list is a subitem. That way they don’t have to make a submission for each item. See image attached for example.
Form question example for the line item. Each would be a column on the board.
• Supplier name
• Freight carrier
• Tracking number
• Ship date.
Form questions example for each subitem in spreadsheet format. Each would be a column on the board.
• Item no
• Item name
• Sample type.
• Qty
• Recipient