IvanWeiss
5 years agoQrew Captain
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 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
------------------------------