Forum Discussion

MichaelClark's avatar
MichaelClark
Qrew Member
5 years ago

How do I link to records within the same table?

This question seems like it should have an easy enough answer, but for the life of me I cannot figure this out.  The hardest thing is to explain exactly what I want to happen, so here goes. I ha...
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion

A simple Report Link field and a formula text field may solve your issue. 

You do not need to have a relationship to have a Report Link field. That field type will run any report and filter where a field on the record matches a field in another table or in a table in another app, or the same table. 


So, for example if you created a formula text field To concatenation other fields together separated by say a hyphen, then the report link field would be configured with that formula field And will show records in the table which match the one you are viewing. 



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MichaelClark's avatar
MichaelClark
Qrew Member
5 years ago
Right now I am using the report field with filtering done by the actual report.

It will do for now, and if this is the only way to link reports from the same table to a new report in the table based on a field value, then so be it.  I really would like to have hyperlink buttons that have the address of the related reports based on the criteria I have just for the ease of placement and making it a bit more user friendly.

------------------------------
Michael Clark
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    If your actual objective is to show a hyperlink button to push to get a report then yes this is quite possible. I will post back when I get a chance.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    If you want to make a url formula button to run a report which need to be filtered by some field values in the record, you can do this:

    Make your perfect report which is filtered with <ask the user> questions.

    Run the report and answer the questions and observe the URL.

    then we will make a URL formula to mimic that one and have the button answer it's own questions.

    URLRoot & " db/" & dbid() & "?a=q&qid=99&nv=2&v0=" & URLEncode([my field 1]
    & "&v1=" & urlencode([my field 2])


    That says to  run the report number 99 which has 2 variables to be supplier and the variable zero (I don't know why by it starts counting at zero) is equal to that field 1 and then variable 1 (the 2nd variable) will be my field 2.

    The reason for the URLEncode is in case the data in the fields has some characters like spaces or special characters which are not allowed in URLs in the Internet.





    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------