Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago

Notification and Reminder Emails

Do I need to have user licenses, to simply send out notification or Reminder emails? For example, can I do the following (is it possible, and does it breach any QB terms of agreement):

Set up 200 users, put them in an app, but set their app access to 'None', hence not using the user license. Set up 200 records for those users with their name in a user field. Now use that user field to fire off whatever emails I want to them.

Obviously they couldn't click on any links in the email, but will this work and are there any rules against it?

------------------------------
Mike Tamoush
------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      Justin,

      I've used the open notification before, the problem is the following: If I have 200 employees, and they are not users but simply need an email, using the open setting I would need to create 200 separate emails for reminders/notifications. If they are in a user field, I can just create one email.

      ------------------------------
      Mike Tamoush
      ------------------------------
      • JustinTorrence's avatar
        JustinTorrence
        Qrew Cadet

        Here's a hacky solution:

        1. Create a table of Recipients, with one email field
        2. Create a table called Emails with a Subject (Text), Body (Text), and Recipient (Email) field
        3. Create an open notification on the emails table that is sent to the email in the Recipient field when a new record is created
        4. Create a new pipeline that takes the following steps:
          1. At XX:XX time, Query the Recipients table for a list of emails
          2. For each Recipient:
            1. Create a new record in the Emails table, setting the Recipient, Body and Subject
        You could also use Automations to do something similar

        ------------------------------
        Justin Torrence
        Quickbase Expert, Jaybird Technologies
        jtorrence@jaybirdtechnologies.com
        https://www.jaybirdtechnologies.com/#community-post
        ------------------------------