I have a Google spreadsheet that I want to publish so it can be used by my customers (re-sellers) to generate a product quote for their customers.
The spreadsheet will need to be view only.
I need to write a script so that after entering data in required fields the user can print the quote to their local printer, e-mail a copy to the customer (an input field) with a blind copy to a fixed address, copy certain fields to an "Output" sheet and then e-mail a csv of the Output sheet to an e-mail address.