Forum Discussion

AnneTheisen's avatar
AnneTheisen
Qrew Trainee
8 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) 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.

Branding and app management
Relationships
reports and charts

18 Replies

Sort By
Show More
  • AnneTheisen's avatar
    AnneTheisen
    Qrew Trainee
    8 years ago
    Yes it does.  The Table Alias for all my other tables is the same (with the addition of _DBID_) but for some reason for this table, the alias is different .. rather than _DBID_Incident Timeline ... it is _DBID_TABLE_1.  I didn't think to check this before.  Using the alias resolved the problem.  And, the Link Text also displays correctly.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    The table alias never changes after it is created.  So initially you created the app and did not give the table a name, so it defaulted to call itself Table_1 for evermore as the table Alias.  Then you decided that was not such a good name for your table and gave it a more meaningful name.
    • ChristyBeller's avatar
      ChristyBeller
      Qrew Member
      7 years ago
      Im trying to add a calculated column to a summary report that links to table report from another table. I have a summary report in my JOBSITES table that I want a clickable link or button in that report that takes me to a table report in my INSPECTIONS table.  The first problem is I cant seem to get it to add a calculated column to the summary report no matter what.  Not sure if its permissions or if I just cant put a calculated column in a summary report. Sorry Im a newbie.