Results 1 to 1 of 1
2012-02-20, 21:46 #1
- Join Date
- Jan 2008
- Thanked 0 Times in 0 Posts
Script to auto generate an email message (Google Spreadsheet)
I have a shared Google Spreadsheet where sales and engineering use different columns for reference. I would like to automate some functionality but as a very new Google Spreadsheet user, I don't know how to code this just yet.
Sales has a form with the following columns from this spreadsheet:
When they fill out the form to request a new Project ID, it fills in the remaining columns above and then engineering goes in to fill in the rest (not identified here). I would like to generate an auto-email to sales when they fill out this form so that they get an email back with the information they filled-out (for verification) as well as a new Project ID number which should be auto-generated with 'SIDPRJ' at the very beginning so that they look like SIDPRJ0001 and increase by 1 for each one.
Any advice, would be seriously appreciated.