Go to report with custom filters Formula URL or Report Link
Hey Qrew,
I have a question that feels like it would be really easy but the lack of documentation around formula URLs is complicating it.
I want a button in a form in table A, that takes me to a custom report (report 11) in table B, only showing records where FID 83 in table B is equal to [Related Deal ID] in table A. I have this formula URL:
URLRoot() & "db/" & [_DBID_PROPERTY_METRICS] & "?a=q&qid=11
Which takes me to the right report, but no filter on it. I edited it with this information:
URLRoot() & "db/" & [_DBID_PROPERTY_METRICS] & "?a=q&qid=11&_fid_83=" & [Related Deal ID]
But it just gets me to the same report, no filter. I'm not sure how to feed the following query into the URL either:
"{83.EX.'" & [Related Deal ID] & "'}"
All the prior discussions seem to circle back to "use a report link", but, while the report link does lead to the right table, with the right filtering, I can't figure out how to get the right report displayed. I would have to edit the default columns to show the columns I want to see, which I don't want to do. I could do the "show records in form" option in the form rules, then have the users click on "full report", but I want it to just be a button.
So does anyone know any of the following:
- 1: how to feed filters into a URL to a specific report
- 2: how to edit a report link field to link to a specific report
- 3: where I might find documentation around what parameters I can feed into a URL to manipulate it? All the QB help articles are frustratingly introductory.
------------------------------
Thomas Otten
------------------------------