Discussions

Expand all | Collapse all

Formula URL Button Not Triggering Notification

  • 1.  Formula URL Button Not Triggering Notification

    Posted 24 days ago
      |   view attached
    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
    ------------------------------


  • 2.  RE: Formula URL Button Not Triggering Notification

    Posted 24 days ago
    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
    ------------------------------



  • 3.  RE: Formula URL Button Not Triggering Notification

    Posted 23 days ago
    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
    ------------------------------



  • 4.  RE: Formula URL Button Not Triggering Notification

    Posted 23 days ago
    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
    ------------------------------



  • 5.  RE: Formula URL Button Not Triggering Notification

    Posted 23 days ago
    It is a user field type.  I see my name as a link on the field in the test record and when I click on it, it displays my user record including my name and email address.  But the actual field itself is a user field

    ------------------------------
    Ivan Weiss
    ------------------------------



  • 6.  RE: Formula URL Button Not Triggering Notification

    Posted 23 days ago
    When you copy an App, all Notifications and Subscriptions get turned off (the green checkbox).  I'll bet the Notification is turned off.  :)


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



  • 7.  RE: Formula URL Button Not Triggering Notification

    Posted 23 days ago
    AHHHHHH YOU ARE RIGHT!

    I cannot tell you how annoying that is because everytime I copy an app I go through every table (and I have about 40 of them) deleting notifications so other users dont get them lol

    ------------------------------
    Ivan Weiss
    ------------------------------