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

ColemanDuCharme

Qrew Trainee

3 years ago

As an update: I found out that I have to request access to allow emails to be sent to non quickbase users, and have just had that switch flipped (I now have the ability to do so) by submitting a support ticket to quickbase.

So, I am creating separate email notifications, one for each park manager. In the "notification when" field, I am using "additional criteria" to specify that when the "park" field contains a specific park, it will be sent to the manager listed in that specific email notification.

It seems like this is my solution. However, if I am doing this wrong, or there is a better way to do this, I would appreciate any feedback.

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

JeffPeterson1
Qrew Captain
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
------------------------------
- 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
    ------------------------------