Forum Discussion

Qrew Trainee

3 years ago

Send email to a specific email address based on the value in a field when a new record is added to table?

We have a lot of restrooms in our parks. I have created a simple system that allows anyone (everyone on the internet) to scan a QR in whichever restroom they are in, and it automatically takes them to...

NotificationsEmail

JeffPeterson1
3 years ago
You could assign a manager to each park, then when the notification goes out you use a field holding the email address to determine who it goes to. This way, you only need 1 notification.

Example:

We send tickets out to field reps, when a job is cancelled, it sends a notification to the assigned field rep:

------------------------------
Jeff Peterson
------------------------------

JeffPeterson1

Qrew Captain

You could assign a manager to each park, then when the notification goes out you use a field holding the email address to determine who it goes to. This way, you only need 1 notification.

Example:

We send tickets out to field reps, when a job is cancelled, it sends a notification to the assigned field rep:

------------------------------
Jeff Peterson
------------------------------

ColemanDuCharme

Qrew Trainee

3 years ago

Thanks Jeff, that seems like the best way to do it. However, the option, "the email address listed in the field: x" is not showing up for me. The only option I have is a text box where I manually enter an email address that it gets sent out to.

------------------------------
Coleman DuCharme
------------------------------

JeffPeterson1
Qrew Captain
3 years ago
Is the field where you hold their email address actually an 'email' type field or is it a text field?

------------------------------
Jeff Peterson
------------------------------
- ColemanDuCharme
  Qrew Trainee
  3 years ago
  
  I do not have a "manager" field in the "reported restroom issues" table. Will adding an email field allow that to be selected as an option?
  - MarkShnier__You
    Qrew Legend
    3 years ago
    The Park should have an email address for the Park Manager. Look that up down to the Issues table.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------