Forum Discussion
JackFretwell
7 years agoQrew Assistant Captain
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?
: /
- EverettPatterso7 years agoQrew CaptainThat 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)) - JackFretwell7 years agoQrew Assistant CaptainThank 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.
- JackFretwell7 years agoQrew Assistant CaptainThere'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?- NickCharalambou6 years agoQrew CadetDid you get this to work? I have the same issue and cannot make it work.
Nick
------------------------------
Nick Nick
------------------------------
- EverettPatterso7 years agoQrew CaptainSorry for the late response, been having issues logging into the forums at work.
qid = report ID