I have a simple spreadsheet with a date in column A, an event description in column B, a number (of hours worked) in column D, a calculated number (hours worked * hourly wage) in column E, and some other description in column F. I want my different contributors to be able to record how many hours they have worked for me at an event, and have them input data through google forms, as I do not want them to be able to access my whole spreadsheet.
So each new input through the form would result in a new row in my spreadsheet, with data for columns A,B,D and F input through Forms, and data in column E being calculated form column D. Column C is empty.
I have two questions regarding this (edit: please only answer the question marked as number 1., and when that is answered, I will move on the the next one):
- As column C is always either empty or filled with data manually later, after the row has been added, I need some way to make the form "skip" this column. How is this achieved?
- Rows and data that have already been input by contributors often need to be updated manually inside the spreadsheet, or deleted completely, rows need to be reordered, so I think the easiest solution would be to have some sort of "add-and-forget" method of adding the new rows. By this I mean having Forms just input data into the spreadsheet, and then letting me do whatever I want with this data. Is this achievable? If not through Forms, maybe through some other way?