JasonJohnson2
6 years agoQrew Cadet
Dynamic Filter from a Button
For another use case I made a button that would go to a report where is was set to ask the user. The button contained the following and it works great.
a=q&qid=11&nv=1&v0="&[Related Customer]
I now have a use case where I can't use the ask user but need to use the dynamic filter. I have tried using the following
"db/bpnnzrjnw?a=q&qid=8#dynamic/{%22sidebar%22:[{%22facetid%22:12,%22data%22:{%22value%22:%22"&URLEncode([Project Name])&"%22}}],%22searchString%22:%22%22,%22ver%22:1}"
I added in a URLEncode of the dynamic filtered field. The part after the field brackets in the formula is highlighted green until the next bracket end. It is like Quick Base wants to only recognize the second closing bracket as the closing bracket. Any ideas on what I can change to make this work? yes I realize I could make additional reports specifically for this button like the other button but there are other use cases I have if I can do this.
------------------------------
Jason Johnson
------------------------------
a=q&qid=11&nv=1&v0="&[Related Customer]
I now have a use case where I can't use the ask user but need to use the dynamic filter. I have tried using the following
"db/bpnnzrjnw?a=q&qid=8#dynamic/{%22sidebar%22:[{%22facetid%22:12,%22data%22:{%22value%22:%22"&URLEncode([Project Name])&"%22}}],%22searchString%22:%22%22,%22ver%22:1}"
I added in a URLEncode of the dynamic filtered field. The part after the field brackets in the formula is highlighted green until the next bracket end. It is like Quick Base wants to only recognize the second closing bracket as the closing bracket. Any ideas on what I can change to make this work? yes I realize I could make additional reports specifically for this button like the other button but there are other use cases I have if I can do this.
------------------------------
Jason Johnson
------------------------------
- Assuming you're using a Formula - URL field as a button, try replacing all of the %22 with \". I was able to get it to work using the same structure as you have by simply performing this replacement.
------------------------------
-Tom
------------------------------