Forum Discussion

Qrew Assistant Captain

9 years ago

create a button that will trigger email notification

I show the example below in an earlier post but I can't get it to work URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "_fid_208=1"&"\n&rdr=" & URLEncode(URLRoot() & "db/"...

NotificationsEmail

roles and permissions

Tables and fields

QuickBaseCoachD

Qrew Captain

8 years ago

If you are the Admin, you can go to the Subscription setup page and click the button to send out a test Subscription., That basically forces out the Subscription at will. It does take a few minutes to get though the queue and get processes.

If you want to make a URL formula button to force out a Subscription, you can mimic the URL that you see when you click that button.

URLRoot() & "db/" & [_DBID_TABLE_NAME_GOES_HERE] & "?a=SendSubscription&ID=XX"
Replace XX with the Subscription number you see in the URL when working with the Subscription.

UrsulaLl
Qrew Assistant Captain
7 years ago
What do you mean "go through the queue"? I ask because I have a email that triggers if a particular button is checked. Last night the records were all checked at around 10:30, but the emails did not go out until 11:07 pm. No other emails were sent out, so I am curious what the queue would have had that could have held up those emails.
QuickBaseCoachD
Qrew Captain
7 years ago
Are you talking about a button which forces out a Subscription? like .... & "?a=SendSubscriptin&ID=1
UrsulaLl
Qrew Assistant Captain
7 years ago
nope, i mean just a simple email notification trigger on a checkbox. I actually did some research on the emails. Turns out it was stuck in the SparkPost queue, not the Quickbase queue. Never happened before, so it was very strange.