ChrisFaye1
4 years agoQrew Cadet
Using Rich Text Button in Report w/out losing report filtering
Hi,
Working through a button update. Our team is using the button in a filtered report. When the button is clicked the report is refreshed and thus clears out all the filtering - so instead of being able to click through all the records efficiently the user needs to click one, re-filter the report and then click the next. Any solves to fix this?
Thank You!
Chris
Current Formula:
var text URLONE = URLRoot() & "db/" & Dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_17=" & URLEncode(UserToName(User()))
& "&_fid_16=true"
& "&apptoken=*****"
& "&rdr="
& URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl());
var text URL = $URLONE;
//button colors
var text bgcolorone = "#e5a652";
var text txtcolorone = "white";
var text styleone =
"style=\"text-decoration: none; width: 150px; text-align: center; background:" & $bgcolorone & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolorone & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
var text bgcolortwo = "#ffffff";
var text txtcolortwo = "black";
var text styletwo =
"style=\"text-decoration: none; width: 300 px; text-align: center; background:" & $bgcolortwo & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolortwo & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
If([Update Completed]=true,
"<a " & $styletwo & "'> Completed </a>",
"<a class='SaveBeforeNavigating'" & $styleone & " href= '" & $URL & "'> Complete? </a>"
)
------------------------------
Chris
------------------------------
Working through a button update. Our team is using the button in a filtered report. When the button is clicked the report is refreshed and thus clears out all the filtering - so instead of being able to click through all the records efficiently the user needs to click one, re-filter the report and then click the next. Any solves to fix this?
Thank You!
Chris
Current Formula:
var text URLONE = URLRoot() & "db/" & Dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_17=" & URLEncode(UserToName(User()))
& "&_fid_16=true"
& "&apptoken=*****"
& "&rdr="
& URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl());
var text URL = $URLONE;
//button colors
var text bgcolorone = "#e5a652";
var text txtcolorone = "white";
var text styleone =
"style=\"text-decoration: none; width: 150px; text-align: center; background:" & $bgcolorone & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolorone & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
var text bgcolortwo = "#ffffff";
var text txtcolortwo = "black";
var text styletwo =
"style=\"text-decoration: none; width: 300 px; text-align: center; background:" & $bgcolortwo & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolortwo & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
If([Update Completed]=true,
"<a " & $styletwo & "'> Completed </a>",
"<a class='SaveBeforeNavigating'" & $styleone & " href= '" & $URL & "'> Complete? </a>"
)
------------------------------
Chris
------------------------------