Forum Discussion

AnneTheisen's avatar
AnneTheisen
Qrew Trainee
9 years ago

Adding a button to one report that references a report from another table filtered by Record ID#

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) ...
Branding and app management
Relationships
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
I think that I understand what you want.

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.