Skip to main content
Question

dynamically filter a saved chart report

  • Nov 11, 2026 5:44 PM UTC
  • 1 reply
  • 12 views

Forum|alt.badge.img+2

I'm trying to open an existing chart report with a dynamic filter passed through a URL. Using ‘qid=117&query=...’ opens the chart but ignores the filter, and ‘dvqid=117&query=...’ applies the filter but opens a temporary table report instead. Is there a way to dynamically filter a saved chart report?

1 reply

Forum|alt.badge.img+11

A saved chart ignores query=. You can use an “Ask the user” filter instead:

  1. Under Filters, choose your field and set the value to <ask the user>.
  2. Save
  3. Open it with the value in the URL:
https://yourrealm.quickbase.com/db/yourtableid?a=q&qid=117&nv=1&v0=YourValue

The nv=1 url parameter means you’re passing one value, and v0 is that value. Without nv=1, Quickbase shows the prompt instead of the chart. If the value is text, wrap it in URLEncode() if you’re building the URL in a formula.

It’s not as dynamic as you may want, but hopefully opens up some room.