Discussions

 View Only
  • 1.  Formula URL Button Not Triggering Notification

    Posted 07-14-2020 18:06
      |   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 07-14-2020 18:10
    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 07-15-2020 08:14
    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 07-15-2020 08:16
    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 07-15-2020 08:23
    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 07-15-2020 08:26
    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 07-15-2020 08:47
    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
    ------------------------------