Button to send mail and update activity
I almost have a button working. What I want to do is open an email to the contact and create an activity saying the email has been sent. So far I have this:- var text URLONE = "MailTo:" & URLEn...
Forum Discussion
Thank you for replying, I tried this, the differences being "a=q&qid=" which I'm really not sure what it does and enclosing the formula variables in <>, all I get is a really long web string in the browser.
var text URLONE = URLRoot() & "db/" & [_DBID_ACTIVITIES]
& "?a=API_AddRecord&_fid_148=" & URLEncode ([Record ID#])
& "&_fid_157=" & [Related Company]
& "&_fid_7=Email Sent"
& "&_fid_142=" & ToFormattedText(Now(), "DDMMYYYYHHMMSS")
& "&apptoken=cwfcy7gdzqrsyncqbi2bn4u4kr";
var text URLTWO = URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=q&qid=1";
var text URLTHREE = "mailto:"& URLEncode([Email]);
"<a href=" &
$URLONE
& "&rdr="& URLEncode($URLTWO)
& URLEncode("&rdr="& URLEncode($URLTHREE))
& "></a>"
Do you know what is meant to happen with the variables enclosed in <a href anchor?
: /
var text URLONE = URLRoot() & "db/" & [_DBID_ACTIVITIES]
& "?a=API_AddRecord&_fid_148=" & URLEncode ([Record ID#])
& "&_fid_157=" & [Related Company]
& "&_fid_7=Email Sent"
& "&_fid_142=" & ToFormattedText(Now(), "DDMMYYYYHHMMSS")
& "&apptoken=cwfcy7gdzqrsyncqbi2bn4u4kr";
var text URLTWO = URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=q&qid=1";
var text URLTHREE = "mailto:"& URLEncode([Email]);
"<a href=" &
$URLONE
& "&rdr="& URLEncode($URLTWO)
& URLEncode("&rdr="& URLEncode($URLTHREE))
& "></a>"
Do you know what is meant to happen with the variables enclosed in <a href anchor?
: /
- That was part of someone else's formula, I don't think you need that <a href anchor
var text URLONE = URLRoot() & "db/" & [_DBID_ACTIVITIES]
& "?a=API_AddRecord&_fid_148=" & URLEncode ([Record ID#])
& "&_fid_157=" & [Related Company]
& "&_fid_7=Email Sent"
& "&_fid_142=" & ToFormattedText(Now(), "DDMMYYYYHHMMSS")
& "&apptoken=cwfcy7gdzqrsyncqbi2bn4u4kr";
var text URLTWO = URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=q&qid=1";
var text URLTHREE = "mailto:"& URLEncode([Email]);
$URLONE
& "&rdr="& URLEncode($URLTWO)
& URLEncode("&rdr="& URLEncode($URLTHREE)) - Thank you again, It's almost there, I get the email opened and the activity updated but the QB takes me to a blank page with something like with the email included in the URL.
- There's a bit of code in the link above which I don't fully understand.
"a=q&qid = 153"
To me this means "action = query and query ID = 153", but without knowing what qid=153 means I'm stuck, but this seems to be the bit that returns to the original page. How do we store queries?- Did you get this to work? I have the same issue and cannot make it work.
Nick
------------------------------
Nick Nick
------------------------------
- Sorry for the late response, been having issues logging into the forums at work.
qid = report ID
