Can I use a formula URL button to create an email using an email client and redirect to the initial report?

I have put an App in the Exchange called URL formula for Dummies. It is a starter guide to making URL formula buttons.

Hiya, I had a look at this last week and didn't really find anything that matches this issue, I'm also using the magic buttons app which has helped a bit.
The issue I'm seeing is when the command for the email is run it plonks the mailto command in the URL which then shows a blank page.  I can't seem to the mailto command without impacting the URL, which is a tad annoying.

Can you post your current code.?

I think it might work if you put the mail to command is the last step in the URL formula and also send that checkbox to open a new window

This is what I have at the moment.

var text URLONE = URLRoot() & "db/" & [_DBID_ACTIVITIES] 
& "?a=API_AddRecord&_fid_148=" & URLEncode ([Record ID#])
& "&_fid_157=" & [Related Company] 
& "&_fid_7=Email Sent";

var text URLTWO = URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=dr&rid=" & URLEncode([Record ID#]);

var text URLTHREE = "mailto:"& URLEncode([Email]);

$URLONE 
& "&rdr=" & URLEncode($URLTWO) 
& URLEncode("&rdr=" & URLEncode($URLTHREE))

I'm not keen on opening a new page as it will get messy for the users.
If I run $URLONE & & $URLTWO I update the activities and end up where I want to be.

Once I add $URLTHREE something like:

"&rdr=mailto%3customername%2540company.ac.uk"

gets appended to the URL which then shows a blank page. 

When I did try it with new page it shows the activities but the main page goes blank because of the mailto getting into the URL.  

I don't know if a solution to your situation.  Essentially you need to do two things at the same time, which is to redisplay the record and also to open a new page.

what happens when you do this

$URLONE 
& "&rdr=" & URLEncode($URLThree)

ie omit the URLTWO step.



 

Yes, I get an even longer URL.  This shows the URL from the first and third steps... And it shows a blank page as I suspect the MailTo gets in the way. 

QBCOMPANY.quickbase.com/db/bn4dxunyy?a=API_AddRecord&_fid_148=9780&_fid_157=16726&_fid_7=Email%20Sent&_fid_142=11-05-2018%2001:52%20PM&apptoken=XXXXXXXXXXXXXXXXXXXX&rdr=mailto%3NAME%2540COMPANY.co.uk