2 Replies Latest reply on Jul 27, 2018 10:25 AM by Sanford Whiteman

    Condition: If a field value equals other field

    Eben Saputra

      Hey guys,

       

      I want to create an appointment reminder where it can show multiple appointments in one email

       

      Let' say a client is going for treatment at these clinics, in one same day

      Appt 1: Place A

      Appt 2: Place A

      Appt 3: Place B

       

      And we want to show clinic info, for different places they will go to

      The catch is, we don't want to show duplicate info. In this case, we only want to show "Place A" info once in the email

       

      How can I achieve this?

      I have been looking at smart list condition, but the don't have anything close to "if fields 1 equal to ANY fields 2 or 3"

       

      There are 150+ clinics btw, so typing "if fields 1 equal to <clinic name>" one by one is out of the question.