OK, so if you want to make a URL formula which will behave as a report link with a filter, here we go.
Make a perfect report of Completed tasks, but make it use the <ask the user> feature for a filter on the Project.
Then run the report and answer the question using any project and observe the URL. That URL is what we need to replicate in code.
URLRoot() & "db/" & [_DBID _TASKS] & "?a=q&qid=99&nv=1&v0=" & [Record ID#]
So that says go to my company's URL
and then to the tasks table as obtained from the advanced properties of the tasks table
and then the ? means that the internet has delivered the click to your table and now we are talking to QuickBase,
and action = query (ie run a report)
and the report # (query ID) is ... whatever you see in the URL for the query ID#, ie the report # and the number of values to be supplied is 1 (nv=1)
and the answer to the zeroth question (its starts numbering at zero) is the [Record ID#] of the project we are on.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------