Skip to main content
Question

timeline temporary report not filtering correctly

  • June 17, 2022
  • 0 replies
  • 60 views
Currently I am setting a time line report for a project to create a Gantt chart.
How I have it setup is a projects will have multiple PO's to different vendors.  On each PO I can create multiple Gantt entries.  From the project I hit my formula url button to make a temporary report of all Gantt entries.

URLRoot() & "db/" & "table ID" & "?a=q" & "&qid=5" & "&query=" &
"{'15'.EX.'"& ToText([Project Number]) & "'}"

When I change "&qid=5" to 1 to use the list all report the filter I have in my formula works correctly.  But when it is set to "5" which is a time line report, the filtering does not work.

------------------------------
Russell Beaubien
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+16
  • MikeTamoush
  • Quickbase Alumni
  • June 17, 2022
I'm not sure the exact issue, but the way I test and set mine up is by creating the report I want (say list all, just make a copy of it), and then adding my filters as 'ask the user'. I run the report and select a dummy entry for ask the user, and then that gives me my URL that I can now edit for my purposes.

So, perhaps make an ask the user filter that mimics what you want on your list all report, run it, and see if it gives you the syntax you need.

------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement