Skip to main content
Question

URL Button to send API call, open email, then reload

  • February 10, 2022
  • 0 replies
  • 37 views

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:

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
------------------------------
This topic has been closed for replies.

  • Author
  • Registered
  • February 10, 2022
I also wrapped the last redirect line in a URLEncode() and I'm getting the same result: a blank page with the URL in the top bar.

------------------------------
Daniel Johnson
------------------------------