DanielJohnson2
3 years agoQrew Trainee
URL Button to send API call, open email, then reload
I'm trying to get a button that updates a record, opens the email client to send an email, and then reloads the report it's on, but I keep getting sent to a blank page. I can get the email client to open and for the API call to work successfully, but I can't get the report page to reload. Here's the button formula:
------------------------------
Daniel Johnson
------------------------------
var text URLONE = URLRoot()
& "db/"
& Dbid()
& "?act=API_EditRecord&apptoken=abcdefg123456&rid=" & URLEncode([Record ID#])
& "&_fid_6=Ready for Compliance Review"
& "&_fid_7=compliance@domain.com";
var text URLTWO = "MailTo:compliance@domain.com"
&"?subject=" & URLEncode([PROJECT + Project source]) & " for Compliance"
& "&body=" & URLEncode([PROJECT + Project source]) & " for Compliance attached.";
var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& "&rdr=" & URLEncode($URLTHREE)
Thoughts?------------------------------
Daniel Johnson
------------------------------