Lotus formula to filter calendar entries containing certain text

Question

I'm fairly new to Lotus Script and Formula language. I'm trying to make a view that only shows certain calendar entries - the view selection looks like

  SELECT Form = "Appointment" | AppointmentType = "0" | AppointmentType = "2"| AppointmentType = "3"

It's pretty simple but seem to works okay. Next step is that I do not want to show documents where part of the subject contain "Accepted:". How is this achievable?

Thank you.

Answer 1

You can use @Contains for this purpose.

!@Contains("Subject"; "Accepted:")

You'll need a logical And with the existing selection:

SELECT (Form = "Appointment" | AppointmentType = "0" | AppointmentType = "2"| AppointmentType = "3") & (!@Contains("Subject"; "Accepted:"))