Newer, amateur, developer here...I need some help figuring out a calculation. We are using FMP to track student tardies in our school and I need use a timestamp to return a class period.
1st Period Time Frame 7:00am - 7:59am (I would need the calculation to read any timestamp between that time frame and return the value of 1st Period)...
2nd Period Time Frame 8:05am - 8:54am (return the value of 2nd period, etc..)
I then am looking to summarize the number of tardy notations by class period....so I would need to display the student has 6 notations in the 1st period time frame, 0 notations in the 2nd period, 4 notation in 3rd period, etc...
Any help that can be provided would be magnificent!