Forum Discussion

Qrew Member

3 years ago

Button to check a box, open a URL, and reload while in Edit

This one has been giving me trouble for about a week now. What I am trying to do is create a button that will open a print (I have a field that extracts the URL of a file attachment field), check a bo...

Qrew Assistant Captain

3 years ago

I had a similar question earlier and @Mark Shnier (YQC) had this suggestion:

"var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=tokenmID&rid=" & [Record ID#] & "&_fid_80=1";

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

$URL
& "&rdr=" & URLEncode($RefreshPage)"

------------------------------
Paul Peterson
------------------------------

MattJones
Qrew Member
3 years ago
Hi Paul,

Thanks for the answer, but unfortunately I can't get that to work any better than my current formula. Since I also have to add another variable to open the print. I end up with this:

var text URL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_203=1" ;

var text URLTWO = [Customer Print URL (Lookup):];

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

$URL
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($RefreshPage))

It will open the print and check the box, but it doesn't refresh the page, which means it has to be manually refreshed to show that the checkbox has been checked. I'm only ever able to get it to perform one redirect. It will either check the box and refresh, but not open the print, or check the box and open the print, but not refresh.

------------------------------
Matt Jones
------------------------------