Need a Google sheets Script Jedi...
08-16-2016, 10:31 AM,
Post: #2
RE: Need a Google sheets Script Jedi...
I don't know Google Script well. I've messed about with it. It's functional.

You probably won't find an off-the-shelf solution for that, and instead should break the project into smaller chunks.

You'll probably find something that sends an email when a new row is added. From there, you can learn to customize that email by retrieving values X and Y. Finally, you can set up your email addresses in a separate sheet/tag/thing where Column A is location and Column B is email, and select the appropriate value from that area.

The devil is in the details.

I'd start with something like this, get it working, then modify it.
http://stackoverflow.com/questions/13778433/spreadsheet-email-trigger
bedstuy Wrote:mocking a pair of $500 jeans is a form of class warfare... why do you hate my social status?


Messages In This Thread
RE: Need a Google sheets Script Jedi... - roo - 08-16-2016, 10:31 AM

Forum Jump: