Skip to main content
Question

Formula URL Button Not Triggering Notification

  • July 14, 2020
  • 0 replies
  • 32 views

Forum|alt.badge.img+11
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------