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 ...