Discussions

 View Only
Expand all | Collapse all

create a button that will trigger email notification

Shontay Smith

Shontay Smith08-16-2016 15:28

Shontay Smith

Shontay Smith08-16-2016 18:21

  • 1.  create a button that will trigger email notification

    Posted 08-15-2016 21:35

    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/" & Dbid() & "?a=dr&rid=" & [Record ID#])



  • 2.  RE: create a button that will trigger email notification

    Posted 08-15-2016 21:48
    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#])


  • 3.  RE: create a button that will trigger email notification

    Posted 08-16-2016 13:35
    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#])


  • 4.  RE: create a button that will trigger email notification

    Posted 08-16-2016 13:50
    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.


  • 5.  RE: create a button that will trigger email notification

    Posted 08-16-2016 14:02
    The App token have to be required, so would I apply that right after the EditRecord& apptoken =???"


  • 6.  RE: create a button that will trigger email notification

    Posted 08-16-2016 15:14
    It would look like this with an app token

    URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4"
    & "&_fid_208=1"
    & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])


  • 7.  RE: create a button that will trigger email notification

    Posted 08-16-2016 15:28
    thanks I got it to work


  • 8.  RE: create a button that will trigger email notification

    Posted 08-16-2016 16:54
    thx for letting me know.  now, btw, after the button is pushed, then if it is pushed again, the email will not fire as the trigger field is already set to 1 (true).  If you want it to fire every time and you tell me what the name is of your trigger field that field ID 208, then I can help you with that.


  • 9.  RE: create a button that will trigger email notification

    Posted 08-16-2016 17:37
    thanks you read my mind the field name is Send_Notification


  • 10.  RE: create a button that will trigger email notification

    Posted 08-16-2016 18:05
    var text NewToggle = IF([Send_Notification] = true, "0","1") // this will make the toggle be the opposite of its current value, but in text format.


    URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&apptoken=kn75dwb4y6nhrdtb89z2cnv9ay4"
    & "&_fid_208=" & $NewToggle
    & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])


  • 11.  RE: create a button that will trigger email notification

    Posted 08-16-2016 18:21
    Perfect you rock, thanks alot


  • 12.  RE: create a button that will trigger email notification

    Posted 04-11-2017 18:27
    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.


  • 13.  RE: create a button that will trigger email notification

    Posted 04-12-2017 11:54
    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.


  • 14.  RE: create a button that will trigger email notification

    Posted 03-30-2018 14:12
    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. 


  • 15.  RE: create a button that will trigger email notification

    Posted 03-30-2018 14:15
    Are you talking about a button which forces out a Subscription?  like .... & "?a=SendSubscriptin&ID=1


  • 16.  RE: create a button that will trigger email notification

    Posted 03-30-2018 14:18
    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.