Write script for Google Spreadsheet

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.

I now understand that the spreadsheet cannot be view only as then my customers cannot enter any information and use the spreadsheet.

I need however to be able to protect against one customer seeing the details another customer has entered if they are using the spreadsheet concurrently. Looking for advice on how to achieve this.

I have decided not to proceed with this project. Being new to this website I can't work out how to cancel it so will just let it expire.

Thanks everybody for your interest.

Until next time ...

Taidot: Google Web Toolkit, Java, Javascript

Näytä lisää: script print spreadsheet google, write spreadsheet google script, write an e mail, spreadsheet script google, spreadsheet script, script google spreadsheet, publish google spreadsheet to web, address write, google sheet script print, spreadsheet google, Google Sheet Script, google script spreadsheet, csv spreadsheet, spreadsheet input, google web toolkit, google sheet, customer spreadsheet, spreadsheet csv, spreadsheet copy csv, google publish, google spreadsheet sheet, copy quote sheet, script copy data web, Google spreadsheet script, product quote

Projektin tunnus: #4256673