Skip to main content
Question

Magic Buttons Code - Return Instead of Redirect

  • November 8, 2019
  • 0 replies
  • 90 views

I'm using code that I got from the Magic Buttons app for the % complete bar. I've added a few things to it and it works great except for one thing... I want to select a little green box while on a report and it refresh and return to where I was originally. It's currently taking me to the record after clicking. I had thought the "location.reload();" part meant it would return instead of redirecting, so I'm not sure how to fix this myself. 

var date todaysDate = Today();
var text star = "<img" & " src=\"" & "https://images.quickbase.com/si/16/228-rect_green.png\">";
var text notstar = "<img" & " src=\"" & "https://images.quickbase.com/si/16/226-rect_gray.png\">";
var number numberstars = (Floor([% Complete] * 10));
var number numbernotstars = 10 - $numberstars;
//10 is the number of units, because 10 is 1/10th of 100.

var text urlten =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=10";

var text urltwenty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=20";

var text urlthirty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=30";

var text urlforty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&apptoken=c9bkn8zd9zgnanc25bhq6cvh87cr" &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=40";

var text urlfifty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=50";

var text urlsixty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=60";

var text urlseventy =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=70";

var text urleighty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=80";

var text urlninety =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_143=In Progress" &
"&_fid_99= null" &
"&_fid_166=90";

var text urlhundred =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Task ID] &
"&_fid_99="&$todaysDate&" " &
"&_fid_143=Completed" &
"&_fid_166=100";

"<span alt=\"" & ToText($numberstars) & " of 10 \" title=\"" & ToText($numberstars) & " of 10 \" class=\"NoWrap\">" &

If($numberstars >= 1, "<a href=\"javascript:" & "$.get('" & $urlten & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlten & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 2, "<a href=\"javascript:" & "$.get('" & $urltwenty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urltwenty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 3, "<a href=\"javascript:" & "$.get('" & $urlthirty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlthirty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 4, "<a href=\"javascript:" & "$.get('" & $urlforty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlforty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 5, "<a href=\"javascript:" & "$.get('" & $urlfifty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlfifty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 6, "<a href=\"javascript:" & "$.get('" & $urlsixty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlsixty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 7, "<a href=\"javascript:" & "$.get('" & $urlseventy & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlseventy & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 8, "<a href=\"javascript:" & "$.get('" & $urleighty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urleighty & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 9, "<a href=\"javascript:" & "$.get('" & $urlninety & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlninety & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
If($numberstars >= 10, "<a href=\"javascript:" & "$.get('" & $urlhundred & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/228-rect_green.png'></a>",
"<a href=\"javascript:" & "$.get('" & $urlhundred & "', function(){" & "location.reload();" & "});" & "void(0);\"><img src='https://images.quickbase.com/si/16/226-rect_gray.png'></a>") &
"</span>"​

#magicbuttons ​​​​​

------------------------------
Courtney F.
------------------------------
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
The issue seems to be coming from the whole row being clickable. 

Uncheck allow editing and allow viewing on the report, and the green bar will work as you want it to, i.e. click and return to report. 

If you want users to still be able to view/edit records from that report, you can make custom icons for that report




------------------------------
Everett Patterson
------------------------------