AnsweredAssumed Answered

Condition: If a field value equals other field

Question asked by Eben Saputra on Jul 27, 2018
Latest reply on Jul 27, 2018 by Sanford Whiteman

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.

Outcomes