I have a little problem I'm trying to find a solution for. I'm playing around with the Last() and Max() functions on a related table called Notes which stores notes for each customer.
The problem is, the Notes table contains a field for "Note Type" which can be system generated (emails sent, status changes, etc. ) which I don't want these functions to look at.
Not sure how to go about this. I would like to basically exclude any note type that is not a user generated note so that I can see when the last time a user actually manually entered a note on a customer.
I've been trying to google search this and see if it exists and found a few Max() and Last() functions but they're as helpful on this as the FileMaker functions reference is - which doesn't give an example of how I can come up with a solution for this.
I'm hoping one of you clever experienced developers can help point me in the right direction so I can have this valuable data in my solution.
Thank you very much for any input!