Basically, what we have is a system for teachers to submit purchase requests via a google form. This google form populates a google spreadsheet that the school admin staff can view and approve individual purchase orders. What we need is to be able to automatically produce a nice printable form from each row of data (individual purchase request). I believe this should be possible via google scripting in google spreadsheets.
Ideally a print/save button would appear next to each row of data as the spreadsheet becomes populated with new requests from said google form. This button would either produce a pop-up window with the printable form, or prompt to save a PDF of the printable form onto the local disk, whichever is easier to implement.
Here's the example spreadsheet: [url removed, login to view];usp=sharing
Form: [url removed, login to view]
Example of printable form that would be prefilled with data from spreadsheet: [url removed, login to view]
The end result would be a script/etc with steps to install it or embed it, and some explanation of how we could extend it to include extra data in the printable form, or to change the form layout.
Let us know if the budget's too low for this sort of project.
4 freelancers are bidding on average $268 for this job
Experienced developer with high levels of problem solving and analytical skills. Quick and committed to deadlines with an eye towards perfection and quality in work. ISTQB certified Tester as well