Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
5 years ago

Formula URL Button Not Triggering Notification

Hi everyone,

I have a button that creates a task on my task table and updates the status of the record on the current table (Proposals table).  The button is working fine.  However, I have a notification set to fire when the status changes and it is not running. Having a hard time troubleshooting this one.  Here is the code on the button and I also attached a snapshot of the notifications.

//Button to start review process with Project Solutions Review

//Set formula variable to assign a new task to Project Solutions for Review
var text URLPSReviewTask = URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_AddRecord" &
"&apptoken=8nd4ztc8b3ed4us3hn7bgqbxmi" &
"&_fid_6=" & URLEncode("Review Proposal: ") & URLEncode([Project Name]) &
"&_fid_8=" & URLEncode(Today()) &
"&_fid_9=" & URLEncode(WeekdayAdd(Today(),1)) &
"&_fid_12=" & [Related Opportunity] &
"&_fid_21=" & [Project Number] &
"&_fid_23=" & "Opportunity" &
"&_fid_24=" & "Assigned" &
"&_fid_28=" & "Opportunity" &
"&_fid_36=" & URLEncode("Auto assigned by Start Project Solutions Review Process Button on Proposals Table") &
"&_fid_52=" & URLEncode([Project Solutions]) &
"&_fid_69=" & URLEncode([Project Coordinator]);

//Set formula variable to change the status to Project Solutions Review
var text URLPSReview = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=8nd4ztc8b3ed4us3hn7bgqbxmi" &
"&_fid_25=" & "" &
"&_fid_26=" & "" &
"&_fid_28=" & URLEncode("Project Solutions Review Requested") &
"&_fid_29=" & URLEncode("Project Solutions Review") &
"&_fid_47=" & URLEncode(Today()) &
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]);

$URLPSReviewTask & "&rdr=" & URLEncode($URLPSReview)

------------------------------
Ivan Weiss
------------------------------
  • I assume that fid 29 is the Status field?

    What value is on the field for the Notification recipient on a test record, ie the field [Project Solutions]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      Mark, yes 29 is the status field and when I hit the button the status does change appropriately.

      The [Project Solutions] field is a lookup field coming from a few layers high:

      Projects<Opportunities<Proposals  the field is in the Projects table (and used throughout my entire app)  In this case since it is a test field I assigned Project Solutions to me and I do see that on the field in the form.

      Now one thing I did not mention is I copied the entire app to a test app to run the tests.  So i am not running in the native app I developed this in, but a test copy of the app.  i did update the tokens and as I mentioned the button is creating hte task and changing the status so I know it is working.

      ------------------------------
      Ivan Weiss
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Does the [Project Solutions] field have an email address or user in it for the record you are testing on?

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------