Forum Discussion

Qrew Cadet

4 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

GeorgeBramhall1

Qrew Member

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

QuickBaseJunkie

Qrew Captain

4 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
Qrew Member
4 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
------------------------------
- QuickBaseJunkie
  Qrew Captain
  4 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
  ------------------------------