Report Showing Only Non-Related Records?
I have a table report on one of our scheduling apps that is supposed to display staff assignment records that share a date with the DAY record being edited but not the staff assignments related to tha...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp (probably)
When you go to McDonald's they try to sell you the full meal deal but in fact if you insist they will just sell you fries.
Similarly, when you make a relationship, you get a report link field included in the deal but there is nothing stopping you from creating a report link field on its own.
A Report link field just runs any report off any table in your whole Realm (not even just that app) and it adds the extra filter of the two fields in the report configuration need to match each other.
So ....
I am assuming from the description you posted that the D record is for a particular date and hence the day record knows the date.
Presumably the staff assignment records also know the date.
So, create a Report Link field and configure the two date fields to match.
That will allow you to show all the Assignments and which Day they are assigned to.
Now going this far will not allow you to filter as to which records are or are not assigned to the D record you were on.
If you need that to happen then it can be done but it's a little more complicated. And the user would have to push a button on that record.
Let me know whether I got you at least partway into understanding a solution.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
When you go to McDonald's they try to sell you the full meal deal but in fact if you insist they will just sell you fries.
Similarly, when you make a relationship, you get a report link field included in the deal but there is nothing stopping you from creating a report link field on its own.
A Report link field just runs any report off any table in your whole Realm (not even just that app) and it adds the extra filter of the two fields in the report configuration need to match each other.
So ....
I am assuming from the description you posted that the D record is for a particular date and hence the day record knows the date.
Presumably the staff assignment records also know the date.
So, create a Report Link field and configure the two date fields to match.
That will allow you to show all the Assignments and which Day they are assigned to.
Now going this far will not allow you to filter as to which records are or are not assigned to the D record you were on.
If you need that to happen then it can be done but it's a little more complicated. And the user would have to push a button on that record.
Let me know whether I got you at least partway into understanding a solution.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thanks for the reply, Mark!
I think I've already made it to that point. I have a report table on the form that displays all staff assignment (SA) records on the date of the current D record, related or not, it's the last bit (removing the related SA records from that report) that has me stumped and from your reply a little worried about the alternative here.
Ideally, and from a user experience standpoint, I would like the records in this report to be filtered automatically (without the user needing to push a button). There is no situation where those records would need to be shown in that report so I think asking someone to click a button to achieve something we're doing automatically right now is a step in the wrong direction and I'm going to get pushback from users on that one.
------------------------------
Ryan Huffman
------------------------------
I think I've already made it to that point. I have a report table on the form that displays all staff assignment (SA) records on the date of the current D record, related or not, it's the last bit (removing the related SA records from that report) that has me stumped and from your reply a little worried about the alternative here.
Ideally, and from a user experience standpoint, I would like the records in this report to be filtered automatically (without the user needing to push a button). There is no situation where those records would need to be shown in that report so I think asking someone to click a button to achieve something we're doing automatically right now is a step in the wrong direction and I'm going to get pushback from users on that one.
------------------------------
Ryan Huffman
------------------------------
- MarkShnier__YouMy suggestion would be to hide the report until the user pushes the button. I can see a way fo the report link field to know which record the user is on unless they are willing to push a button.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------