We need a Google Form that tracks stock delivered from our factory to our shops on a daily basis. Each day and each shop will have its own Google Form, and at the end of the day, a report will be generated and sent to the manager. The idea is to see whether the amount of stock that we expect to see at the end of the day is equal to the amount of stock that is actually in the shop. The amount of stock we expect to see at the end of the day = Starting Amount - Sales - Breakages + Further Additions - Expired Stock. See attached excel spreadsheet for more detail.
The form/ report will need to have the following features:
A) I do not know if this is possible, but we would like a form that can be used on an ipad and be added to cumulatively. By "adding to cumulatively" I mean:
- Person A inputs Data A into the Google Form at t1
- Person B adds Data B at t2, but Person B can see Data A on the Google Form
B) one type of data (the End of Day Count) which is inputted at the end of the day is also to be used as the data for the start of the day for the following day's form (see spreadsheet for more detail).
C) We need to extract data from the Vend point of sales system. Ideally this would be done automatically through the API and webhooks. Ideally there would be a button on the form which fetched this data and uploaded it into the google spreadsheet underlying the google form.
D) We will need to have simple calculations in the google spreadsheet underlying the google form. It would be good if the output values from these calculations were visible in the google form, or that when the form is submitted, the underlying spreadsheet executes simple mathematical operations, then a report is sent out that contain the final result. Please refer to the attached excel spreadsheet to see what calculations I am talking about.
Essentially we are looking for a google spreadsheet that has a user interface that works like a google form, and that can extract data from Vend.