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
------------------------------
Original Message:
Sent: 11-15-2019 00:00
From: Gunsham Lakhiani
Subject: 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=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}
------------------------------
Gunsham Lakhiani
------------------------------