I have a form for timesheet, that each row is a different job description, job number, hours booked to job etc.
I have it so when you submit, it fills in the response sheet in order from top to bottom.
Problem I have is I want to run some functions set by a trigger that sends a copy of the sheet, then deletes the data and resets it so the new responses start at the top, but I only want this trigger to run after all the response lines are filled. So basically I use submit to send each response, but I have several responses to input before this can happen.
Is there a script that lets the response sheet rows be filled with the data as if submitted, but won't run the trigger until the final submition? If this makes sense.
Thanks