Closed

printable form from google spreadsheet row of data

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.

Skills: Javascript

See more: printable spreadsheet data form, printable forms spreadsheets, printable spreadsheet forms, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, script google spreadsheet, script for google forms, google spreadsheet scripting, google spreadsheet example, google-docs.com, google docs.com, google. docs, edit pdf form, docs google com, docs. google, what is google docs, spreadsheet google, how to google docs, google script spreadsheet, google google docs, google docs sharing, google docs is, google docs how to

About the Employer:
( 0 reviews ) United States

Project ID: #4664521

4 freelancers are bidding on average $268 for this job

Vayne

Hello, Would like to discuss project details. Regards, Vayne.

$250 USD in 7 days
(14 Reviews)
4.4
svoyski

Hello. I'll provide a well commented script with all the necessary explanations. The script will be activated with a single click on a custom button or a menu. Your budget is quite reasonable. Please let me know if you More

$233 USD in 14 days
(2 Reviews)
3.9
dirving

Good afternoon charterts, I have read through your project proposal and I know I can get this done quickly and professionally for you. I would propose the that instead of trying to somehow code buttons in to the Goo More

$368 USD in 7 days
(4 Reviews)
3.1
Suresh1689

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

$222 USD in 20 days
(0 Reviews)
0.0