I want to create a button on a report that references a timeline report from another table. Both tables are in the same application and linked by Record ID#. I want the timeline report (child table) that is launched from then main report (parent table) to be filtered to show only records that link. Also, I want to change the name of the button but the "Text Link" field doesn't appear to be overwriting the URL.
I've tried: "https://my company.quickbase.com/db/tableID?a=q&qid=16" - with "16" being the report number in the child table. I get the all timeline records not just those associated with the parent record. I tried adding & [Record ID#] at the end and received an error.
I've tried: URLRoot() & "db/" & [_DBID_Child Table Name] & "?a=q&qid=16&nv=1&v0=" & [Record ID#] and failed to get the desired results.
I also tried: URLRoot ()&"db/"&Dbid(child table ID)&"?a=q&qid=16&nv=1&v0="&[Record ID#] and this errors out completely.
I've filled in the box for "Link Text" but this doesn't override. I have checked "Don't show 'http:..." I've checked "Display as a button" and "Display in bold" which does work.
Make your perfect target report and include a filter with an <ask the user> for the filter for the records that you want on the report. I can't quite tell what that is, but likely it's whatever the Parent record ID# is.
Then make a formual URL field like this
URLRoot() & "db/" & [_DBID_Child Table Name] & "?a=q&qid=XX&nv=1&v0=" & [Record ID#]
where XX is your report ID.
That should work. I think that you did everything correct except that you did not first build an <ask the user> report.