Forum Discussion

ColemanDuCharme's avatar
ColemanDuCharme
Qrew Trainee
4 years ago
Solved

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's avatar
    JeffPeterson1
    4 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's avatar
ColemanDuCharme
Qrew Trainee
4 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's avatar
    JeffPeterson1
    Qrew Captain
    4 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's avatar
      ColemanDuCharme
      Qrew Trainee
      4 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's avatar
        JeffPeterson1
        Qrew Captain
        4 years ago
        Is the field where you hold their email address actually an 'email' type field or is it a text field?

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