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 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
------------------------------
URLRoot() & "db/bpnnzrjnw?a=q&qid=8#dynamic/{\"sidebar\":[{\"facetid\":12,\"data\":{\"value\":\""&URLEncode([Project Name])&"\"}}],\"searchString\":\"\",\"ver\":1}"
------------------------------
Jason Johnson
------------------------------
%20 is actually a URL encoded space ( ), so I believe all of the %20 should be replaced with a space. %22 is a URL encoded quote ("), and those are the ones that should be replaced with \". I think the following formula should work:
------------------------------
-Tom
------------------------------
URLRoot() & "db/" & Dbid() & "?a=q&qid=19#dynamic/{\"sidebar\":[{\"facetid\":16,\"data\":{\"value\":\"B/L Awaiting\"}},{\"facetid\":16,\"data\":{\"value\":\"B/L Sent\"}},{\"facetid\":16,\"data\":{\"value\":\"Payment Received\"}}],\"searchString\":\"\",\"ver\":1}"------------------------------
-Tom
------------------------------