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

There seem to be some extra characters in the middle. The \n does not belong and you were missing an & URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_208=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

Do I need the apptoken?Below is what I have and I am receiving an error message: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4" & [Record ID#] &"& _fid_208=1"&"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

I suggest that you go into Settings and then Application Properties and uncheck the box which requires application tokens.Then i suggest that you review the formula which I posted and use it instead of your formula. You formula is missing the &rid= part which tells the formula which record ID to update.

The App token have to be required, so would I apply that right after the EditRecord& apptoken =???"

It would look like this with an app tokenURLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4"& "&_fid_208=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

create a button that will trigger email notification

MichaelMichael2
Qrew Member
8 years ago
What if I want to send out an entire report, like a report I'm subscribed to daily, but on demand at the click of a button. I suppose I could use the api but the report subscription is working like I like it I just may need it more than daily.
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.

Forum Discussion

create a button that will trigger email notification