Change report link within parent table report
I have a parent table report with a link to the default child table report to show all associated child records. The issue I am facing is that the link takes me to the default report of that child ...
Forum Discussion
Mark,
I have gone through the other thread's post and think I understand it.
However, it isn't working as I thought it should.
My thought is that I am to blame for not doing it correctly ... as is typically the case.
So to give a bit more detail:
I have my parent table report where I have created a URL Formula to take me to the report of the child table.
That is working. It takes me directly to the customized report instead of the default report.
However, what is not currently working is that it is showing me all records from the child table. It should only show me records from the child table related to the parent table.
I have the URL coded with filters as per the thread/post you shared, but I don't think they are working correctly.
I am trying to filter for the Parent Record ID# of the child records, so that only the child records related to the parent record are showing.
The related parent record ID# fid in the child table is 22. Yet when I click the link, the URL comes up with some triple digit fid being filtered.
In order for filtering to work via URL formulas, do they have to be columns that one can normally filter, as in on the left hand side? The Parent record ID# is not a filterable field by default.
Here is the code I have so far:
URLRoot() & "db/" & [_DBID_Table_1] & "?a=q&qid=7&nv=1&v0=" & URLEncode([Job ID#])
Also strangely, my child table is called Notes, but the table Alias is Table_1. All of my other tables have a matching table alias. I found that strange ......
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
I have gone through the other thread's post and think I understand it.
However, it isn't working as I thought it should.
My thought is that I am to blame for not doing it correctly ... as is typically the case.
So to give a bit more detail:
I have my parent table report where I have created a URL Formula to take me to the report of the child table.
That is working. It takes me directly to the customized report instead of the default report.
However, what is not currently working is that it is showing me all records from the child table. It should only show me records from the child table related to the parent table.
I have the URL coded with filters as per the thread/post you shared, but I don't think they are working correctly.
I am trying to filter for the Parent Record ID# of the child records, so that only the child records related to the parent record are showing.
The related parent record ID# fid in the child table is 22. Yet when I click the link, the URL comes up with some triple digit fid being filtered.
In order for filtering to work via URL formulas, do they have to be columns that one can normally filter, as in on the left hand side? The Parent record ID# is not a filterable field by default.
Here is the code I have so far:
URLRoot() & "db/" & [_DBID_Table_1] & "?a=q&qid=7&nv=1&v0=" & URLEncode([Job ID#])
Also strangely, my child table is called Notes, but the table Alias is Table_1. All of my other tables have a matching table alias. I found that strange ......
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendWhen you run the actual report manually (not from the button) does it pause to ask you the question as to what is the related parent? ie does is report qid 7 have an <ask the user> filter?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- No, it does not.
After reading your question above and then going back to the thread/post you linked, I think the thread/post is a bit clearer now.
Do I need to link to a specific report in a child table? Yes.
Do I need to show only the records in the child table report related to the parent record? Yes.
Does my child table report ask the user some input questions? No.
Perhaps if I understood a bit more in depth how a report can ask a user questions ... that might clarify a few things for me ....
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------- MarkShnier__YouPlease go to that report and add an extra filter.
Where related parent equals and then in the blank box, if he option for <ask the user> is not offered, then literally type this into the box.
<ask the user>
When you run the report it should pause and ask you a question.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Holy bazinga Batman!!! That blew my mind!!
I had no idea I could require a user to provide answers to a query for a report to be visible.
Thank you for that info.
Also, I was able to get the report link to work and take me to the correct report, for the correct parent record id#.
I appreciate the insight.
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------