Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
3 years ago

Email Notification Blast to ever changing QB User Email List via an automation.

I have an automation that adds records in a table. In that record is content that I want to send to an ever changing list of my QB users. Each Record added contains an email address for the recipient ...
Pipelines
Quickbase Automations
Quick_BaseJunki's avatar
Quick_BaseJunki
Qrew Captain
Hi George,

How is the body of the email set up? Does it use the Default or Custom Message?

If it's "default" or using the %recData%, you can change it to use the individual fields vs the whole form. This way you can leave off the field with all the emails.

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
GeorgeBramhall1's avatar
GeorgeBramhall1
Qrew Member
3 years ago
Hi Sharon,
I am using a Custom Message.
It appears the emails are coming over on the multi-record version.
Here is my custom message:
%RepeatOn%
[ACQ Notification - Description]

Click to place hold (you must be logged in to Terminus for this to work):
[ACQ Notification Hold URL]

Click here to log in to Terminus: https://terminus-skystone.quickbase.com/db/bnz8up522
IGNORE BELOW
%RepeatOff%


Should I be using %recData% instead of %RepeatOn% - %RepeatOff% ? I am not familiar with %recData%

------------------------------
George Bramhall
------------------------------
  • Quick_BaseJunki's avatar
    Quick_BaseJunki
    Qrew Captain
    3 years ago
    The repeat markers are used to repeat the info for each record in multi-record action. I think this may be where your issue is.

    The %recData% inserts a copy of the record based on the specified form. I don't believe you can use the %recData% with the multi-record version of the email.

    If the records are added in bulk, the 'mult-record' version will automatically be sent and per my note above, would include all the records. 

    There isn't a good in-between unless you can trick it into sending a single record version.

    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
    • GeorgeBramhall1's avatar
      GeorgeBramhall1
      Qrew Member
      3 years ago
      I was thinking maybe I could create an automation that would trigger a single notification all with the same content in them. Each trigger would some how be associated with a different email recipient. What do you think?

      ------------------------------
      George Bramhall
      ------------------------------
      • Quick_BaseJunki's avatar
        Quick_BaseJunki
        Qrew Captain
        3 years ago
        I can't quite visualize from your description, but I think you're on the right track. I've also used Pipelines for this type of thing as the 'do loop' will process records individually triggering a single record notification.

        ------------------------------
        Sharon Faust (QuickBaseJunkie.com)
        Founder, Quick Base Junkie
        https://quickbasejunkie.com
        ------------------------------