Forum Discussion

katlyncowley's avatar
katlyncowley
Qrew Assistant Captain
5 years ago

reports linked in other forms

We have a report that shows a summary of all reported problems within the last 90 days for each of our locations. I have that report linked to our Service Request form so that we can see if the issue is reoccurring or not. I have the report only displaying the affected equipment in question. However, I would also like this to only show the location in question, instead of all of them. 


------------------------------
Katlyn Allen
------------------------------
Relationships
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    np,
    just make a concatenated field on the Service Request table in the format Store - Issue

    for example

    List("-", [Store], [Issue])

    Then make that same formula field on the IT Previous Problems table 

    Then configure the Report Link field on the Service Request form to match up those two fields.  Note that the report will only populate once the Service Request form is saved.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • katlyncowley's avatar
      katlyncowley
      Qrew Assistant Captain
      5 years ago
      I do not have a separate table for the Previous Problems. it's just a report within the Service Request table. is there a way to do it without creating a new table?

      ------------------------------
      Katlyn Allen
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Well then it's even easier. You just create that one field and link the report link to the same field in the same table. So in fact the configuration of the report link field will have the exact same field on the left and on the right.

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