I'm looking to collect weekly sales reports from a number of sales teams spread across different countries. Ideally I want the data from each weeks sales report to drop into a row (with the week number and/or week end date) in my master sheet. Some of the data in the master sheet will be pre-populated (overal targets/budgets etc). Once each report has been submitted, the team should not be able to go back and change prior weeks reports.
- Doing this with web forms seems problematic, as each web form submission appears to work by creating a new row, and not by populating an existing one. This means my teams can potentially overwrite some (target) data each week, and are also not forced to use the specific "end of week" or "week of the year" dates we use for our accounting policies
- Doing this with sharing rows & using alerts seems an incredible PITA as I would need to manually set up a separate alert, linking it to a different line corresponding to every single week of the year, as otherwise (if I give a regular reminded to update multiple lines) I cant prevent previous data being accessed and overwritten
What am I missing here? Do I just have to live with some pre-populated fields in a web form and trust my users to get it right each week?
