Report report with dynamic filter applied?
HI, Is it possible to load a report with dynamic filter applied ? I tried saving the bookmark of a report with applied filter but that didn't work https://kbi.quickbase.com/db/bpydq29yx?a=q&qid=...
Forum Discussion
I apologize in advance for more questions. I'm still unable to get this working.
My reports opens without the filter
------------------------------
Gunsham Lakhiani
------------------------------
My reports opens without the filter
- As Jason suggested , I've tried replacing %20 with \" ,
- As Tom suggested , I made a formula which %22 with \"
- As Adam in detail suggested , I copy pasted form browser and replaced %22 with \" and wrapped in a quote
------------------------------
Gunsham Lakhiani
------------------------------
Below is my rich text formula button that opens in a new tab. I did notice that if the report did not have records when I dynamically filtered that it looked like no filters applied. I ended up using the table to table to create a summary of all records in that status and only if there were records in that status did the button show. No harm in hiding the button if nothing is there to show. I know you can do the same with a URL Formula field as well but I almost never use those.
// Original URL https://MYQUICKBASEURL/db/bpnnzrjnw?a=q&qid=8#dynamic/{%22sidebar%22:[{%22facetid%22:12,%22data%22:{%22value%22:%22WHERE I INSERTED MY SEARCH PARAMETERS%22}}],%22searchString%22:%22%22,%22ver%22:1}
// Begin button style
var text bgcolor = "#006666";
var text bgcolorm = "#00b3b3";
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; box-shadow: 3px 3px 1px #888888; background:" & $bgcolor & "; color: " & $txtcolor & "; border-radius: 3px; padding: 5px 8px; display: inline-block; font-weight: normal;font: 700 24px/1 \"Calibri\", sans-serif; \" onMouseOver=\"this.style.backgroundColor='" & $bgcolorm & "'\";\" onMouseOut=\"this.style.backgroundColor='" & $bgcolor & "'\"; text-align: center; text-shadow:none;";
// End button style
var text URL= URLRoot() & "db/bpnnzrjnw?a=q&qid=8#dynamic/{\"sidebar\":[{\"facetid\":12,\"data\":{\"value\":\""&URLEncode([Project Name])&"\"}}],\"searchString\":\"\",\"ver\":1}";
If([# Approved Costs]>0,
"<a " & $style & " target='_blank' href=" & $URL
& "> Approved Costs </a>","")
------------------------------
Jason Johnson
------------------------------
// Original URL https://MYQUICKBASEURL/db/bpnnzrjnw?a=q&qid=8#dynamic/{%22sidebar%22:[{%22facetid%22:12,%22data%22:{%22value%22:%22WHERE I INSERTED MY SEARCH PARAMETERS%22}}],%22searchString%22:%22%22,%22ver%22:1}
// Begin button style
var text bgcolor = "#006666";
var text bgcolorm = "#00b3b3";
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; box-shadow: 3px 3px 1px #888888; background:" & $bgcolor & "; color: " & $txtcolor & "; border-radius: 3px; padding: 5px 8px; display: inline-block; font-weight: normal;font: 700 24px/1 \"Calibri\", sans-serif; \" onMouseOver=\"this.style.backgroundColor='" & $bgcolorm & "'\";\" onMouseOut=\"this.style.backgroundColor='" & $bgcolor & "'\"; text-align: center; text-shadow:none;";
// End button style
var text URL= URLRoot() & "db/bpnnzrjnw?a=q&qid=8#dynamic/{\"sidebar\":[{\"facetid\":12,\"data\":{\"value\":\""&URLEncode([Project Name])&"\"}}],\"searchString\":\"\",\"ver\":1}";
If([# Approved Costs]>0,
"<a " & $style & " target='_blank' href=" & $URL
& "> Approved Costs </a>","")
------------------------------
Jason Johnson
------------------------------