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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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
------------------------------
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
------------------------------
- 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__YouWell 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
------------------------------- that worked perfectly, once I figured out that I was supposed to be editing the field relationship for the report link. thanks for all your help!
------------------------------
Katlyn Allen
------------------------------
