SOLVED: SEE POST FROM KAMILLE
I have a database of students in Uganda and I am building a separate table to help the administration track student temperatures (government requirement for school re-opening). The table is simple and the nurse will use a basic form (Select student name, enter date/time, enter temp).
In the Student table, I’d like to add a field that shows the most recent temperature taken and the date. The Rollup field works well for the date using the MAX(values) aggregation formula, but I can’t figure out how to show the most recent temperature (as opposed to the max or min).
Any suggestions on how to show the most recent number added within a set of values? I’ve seen a few other posts on this, but I couldn’t find a clarification.
I realize the “Most Recent Temp” field in my screenshot is a text field. I’ve placed that there for illustrative purposes only until I can figure this out.