Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 06, 2020 12:41 PM
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.
Thanks,
Dave
Solved! Go to Solution.
Oct 06, 2020 02:05 PM
[Log]
table using an aggregation formula pointing at the {Last Date/Time Temp Taken}
field like this: IF({Date} = CONCATENATE(values), TRUE())
Oct 06, 2020 02:05 PM
[Log]
table using an aggregation formula pointing at the {Last Date/Time Temp Taken}
field like this: IF({Date} = CONCATENATE(values), TRUE())
Oct 06, 2020 04:47 PM
Thanks Kamille. That worked great!
I had to create a “Date Created” field in my “LOG” then use that new field in the IF statement "IF({Date Created} = CONCATENATE(values), TRUE())
Dave
Oct 06, 2020 05:10 PM
Glad you got it working! I see you’ve edited the first post to say the topic is resolved. You could set that officially by clicking the “Solution” button at the bottom of a reply.