I want to send an email every day at 12:00 p.m. to each record that matches a specific criteria.
Trigger: At a scheduled time
Actions 1: Find Records
Actions 2: Send Gmail
When I run the application with the above settings, the email addresses of the...
I came up with the following formula.
IF({Registration date}=BLANK(),
‘’,
SWITCH({PLAN},
‘A’,
SWITCH({TYPE},
‘1’,DATEADD({Registration date},30, “days”),
‘2’,DATEADD({Registration date},30, “days”),
‘3’,DATEADD({Registration date},30, “days”)
),
‘B’,...
