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.