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
------------------------------