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) 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
  • 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.
  • AnneTheisen's avatar
    AnneTheisen
    Qrew Trainee
    9 years ago
    I receive a "Formula error -- Unknown Field."   It states the table does not contain a field "_DBID_Incident Timeline" - this is the name of my table.  Just to be sure, the field type is a formula URL and not just URL.  Also, will the "ask the user" be pushed in by the formula?  I don't want my users to have to know what this value is.
  • AnneTheisen's avatar
    AnneTheisen
    Qrew Trainee
    9 years ago
    URLRoot()  & "db/" & [_DBID_Incident Timeline] & "?a=q&qid=16&nv=1&v0=" & [Record ID#]
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    Your [_DBID_Incident Timeline] is incorrect.  Go back and copy and paste it correctly.  My guess is that it need an underscore between Incident and Timeline
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    Did you simply add in an underscore or did you check the advanced properties of the incident timeline table and  copy and paste the table name into the square brackets?  It is trying to tell you that the table name is incorrect.
  • AnneTheisen's avatar
    AnneTheisen
    Qrew Trainee
    9 years ago
    I replaced this with the Table Alias and it works like a champ.  I'm sorry if this is something I should have known to do.  Thank you!