Forum Discussion
MarkShnier__You
Qrew Legend
Is there a relationship in place where 1 Employee has Many Warnings?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
BrianDunk
3 months agoQrew Cadet
There is a relationship setup where an employee has many Incidents (records) that have the warnings on them.
------------------------------
Brian Dunk
------------------------------
- MarkShnier__You3 months agoQrew Legend
You can make a summary field on the relationship looking for the maximum of that field, Then use a form rule or the URL formula button you say users are clicking on, to populate that Previous Verbal Warning field. Until you actually save the record, the Previous Verbal Warning Date / Time is in fact the most current one - the Maximum of that field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------