Report report with dynamic filter applied?

I used a button yesterday and got a little help from someone on this. Note the URLEncode field as the value and also replace the %20 with \"


URLRoot() & "db/bpnnzrjnw?a=q&qid=8#dynamic/{\"sidebar\":[{\"facetid\":12,\"data\":{\"value\":\""&URLEncode([Project Name])&"\"}}],\"searchString\":\"\",\"ver\":1}"

------------------------------
Jason Johnson
------------------------------

For others reading this that aren't familiar with how you derived the string, open a report, apply the dynamic filters you want to use, then copy the URL from your browser then make the following modifications to the string:

Example copy & paste from browser:

https://XXXXXXXXX.quickbase.com/db/XXXXXXXXX?a=q&qid=6#dynamic/{%22sidebar%22:[{%22facetid%22:7,%22data%22:{%22value%22:%22Activity%201%22}},{%22facetid%22:10,%22data%22:{%22value%22:%22Yes%22}},{%22facetid%22:15,%22data%22:{%22value%22:%222018%22}}],%22searchString%22:%22%22,%22ver%22:1}

Search and replace %22 with \" and wrap the whole string in quotes

"https://XXXXXXXXX.quickbase.com/db/XXXXXXXXX?a=q&qid=6#dynamic/{\"sidebar\":[{\"facetid\":7,\"data\":{\"value\":\"Activity%201\"}},{\"facetid\":10,\"data\":{\"value\":\"Yes\"}},{\"facetid\":15,\"data\":{\"value\":\"2018\"}}],\"searchString\":\"\",\"ver\":1}"

There is no need to change the characters for the dynamic values. Copy & paste the modified string into a formula URL field and add that field to a report or form and it will open the report with the dynamic filters applied.

Tom's code should work, but you don't have to replace the %20. For that matter your original code should work if you just wrap it in quotes and add the backslashes

"https://kbi.quickbase.com/db/bpydq29yx?a=q&qid=19#dynamic/{\"sidebar\":[{\"facetid\":16,\"data\":{\"value\":\"B/L%20Awaiting\"}},{\"facetid\":16,\"data\":{\"value\":\"B/L%20Sent\"}},{\"facetid\":16,\"data\":{\"value\":\"Payment%20Received\"}}],\"searchString\":\"\",\"ver\":1}"​

This version of my example works

"https://XXXXXXXXX.quickbase.com/db/XXXXXXXXX?a=q&qid=6#dynamic/{\"sidebar\":[{\"facetid\":7,\"data\":{\"value\":\"Activity%201\"}},{\"facetid\":10,\"data\":{\"value\":\"Yes\"}},{\"facetid\":15,\"data\":{\"value\":\"2018\"}}],\"searchString\":\"\",\"ver\":1}"​

------------------------------

Adam Keever
------------------------------