i have an email script which lists the entries in a note field in the message that goes out.
All of the relationships are working and the message lists all the notes attributed to the trouble report. Now they want to have a check box on the note to make it private or not. This will allow the technicians to talk between themselves and not have it go into an email to the user. (sometimes they are mean..)
I tried a few permutations of
If (etr_note::etr_note_private = 0) without any success. Just thought of the following while writing this , would it work?
&List (If (etr_note::etr_note_field = 0))