Forum Discussion
MarkShnier__You
Qrew Champion
One Associate has many Attendance
On the relationship, simply make a summary field to summarize the points.
Alternatively, make three summary fields to count the # of:
1/2 NF
Then duplicate that for the other two absence types
No doubt you will also need a time period filter on that. Be sure to have the filter be "relative", ie don't lock it in for the year 2022, but make it for "the current Year", or the Previous 1 year. You don't want to have to adjust the summary field properties each year.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
On the relationship, simply make a summary field to summarize the points.
Alternatively, make three summary fields to count the # of:
1/2 NF
Then duplicate that for the other two absence types
No doubt you will also need a time period filter on that. Be sure to have the filter be "relative", ie don't lock it in for the year 2022, but make it for "the current Year", or the Previous 1 year. You don't want to have to adjust the summary field properties each year.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
JoeBlouin
2 years agoQrew Member
Perfect. Worked like a charm. that opens up so many other options for me also. Thanks so much Mark!
------------------------------
Joe Blouin
------------------------------
------------------------------
Joe Blouin
------------------------------