Customer Feedback Survey

The famous Kirk Trachy, self proclaimed Quick Base Evangelist  and Quick Base Staffer has his Magic Buttons app available for download in the Exchange.

This code here as a Rich Text field will allow the user to clock to select a Progress Bar for the % completion  on a project.

If you like this behaviour we can figure out how to chop it down to a 5 button size.  You do not  need to use those chicklet squares for the images, there could be other images.

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([% Project Completed] * 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=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=10";

var text urltwenty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=20";

var text urlthirty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=30";

var text urlforty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=40";

var text urlfifty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=50";

var text urlsixty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=60";

var text urlseventy =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=70";

var text urleighty =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=80";

var text urlninety =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_143=90";

var text urlhundred =

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_28=Completed" &
"&_fid_153=Completed" &
"&_fid_143=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);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlten & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 2, "<a href=\"javascript:" & "$.get('" & $urltwenty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urltwenty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 3, "<a href=\"javascript:" & "$.get('" & $urlthirty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlthirty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 4, "<a href=\"javascript:" & "$.get('" & $urlforty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlforty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 5, "<a href=\"javascript:" & "$.get('" & $urlfifty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlfifty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 6, "<a href=\"javascript:" & "$.get('" & $urlsixty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlsixty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 7, "<a href=\"javascript:" & "$.get('" & $urlseventy & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlseventy & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 8, "<a href=\"javascript:" & "$.get('" & $urleighty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urleighty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 9, "<a href=\"javascript:" & "$.get('" & $urlninety & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlninety & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
If($numberstars >= 10, "<a href=\"javascript:" & "$.get('" & $urlhundred & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
"<a href=\"javascript:" & "$.get('" & $urlhundred & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
"</span>"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------