printable form from google spreadsheet row of data

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 4

Project Description

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.

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online