Skip to main content
Question

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
I just ran into the exact same problem with the new report Style. I don't have a solution yet either.  Using the old report style it retains the dynamic filters but not on the new report style. Maybe we can call it a bug and get Quickbase to fix it.

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