Customised Google Form for tracking stock

Web, Mobile & Software Dev Web Development Posted 3 years ago


Hours to be determined
Less than 1 week

Expert Level

I am willing to pay higher rates for the most experienced freelancers


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.

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1

Other open jobs by this client ({{ jobsCount }})

About the Client

(4.98) 26 reviews

Melbourne 11:53 PM

140 Jobs Posted
33% Hire Rate, 4 Open Jobs

$9,413 Total Spent
47 Hires, 14 Active

$10.91/hr Avg Hourly Rate Paid
756 Hours

Member Since Jan 29, 2013