Max Note Date Based on Note Type

Discussion created by danjamins on Feb 8, 2017
Latest reply on Feb 9, 2017 by siplus

Hi all,


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!