Add two rows from one form: I’m trying to create a single form that adds two rows to a sheet from the one form.
I have a truck that delivers gravel. I want to record both the hours driven by the truck in a day, and the weight of the gravel delivered to a customer.
I would prefer two rows on a single sheet as this creates an easy CSV export from sheets to accounting software in the form of “Item, Qty, Value, Date, Operator” which works for both “Truck, 7, $120, 12/12/18, Bob” and “AP20 Aggregate, 310, $8, 12/12/18, Bob”
, but I want the driver to simply select the truck he was driving and then right below that the total gravel he delivered.
Is this possible? Thanks, Lyndon