search

clyall / FormEmailer

Fork of Henrique Abreu's FormEmailer for Google Sheets
20 stars 4 forks source link

Enhancement - Conditional send to different emails #57

Open oscar601 opened 3 years ago

oscar601 commented 3 years ago

Beautiful piece of code upgrading previous work. Is there a way to add an enhancement that would allow for the form response to be sent to different email addresses based on one of the columns?

Example) Column A = email 1 send to email 1

Column A = email 2 send to email 2

GGJapon commented 2 years ago

Hello oscar601, I believe this feature is mentioned in the installation file explanations: https://github.com/clyall/FormEmailer/blob/master/README.md#formulas-location It reads: "To change the recipients of an email based on any rule (that you can write as spreadsheet formula, which can be really complex, depending only on your skills). e.g. You can get information provided in the form to lookup a table and retrieve a different recipient list. Or even no recipient, which to FormEmailer, means: do not send" Thanks

Beautiful piece of code upgrading previous work. Is there a way to add an enhancement that would allow for the form response to be sent to different email addresses based on one of the columns?

Example) Column A = email 1 send to email 1

Column A = email 2 send to email 2