Hi, I have the following elements:
findings_tbl___finding_num (text)
findings_tbl___due_date (date)
findings_tbl___fb_sent (yes/no)
findings_tbl___add_fb_req (yes/no)
findings_tbl___status (dropdown)
The condition for a cron email I need to setup is this:
IF today is less than 7 days from due_date AND (fb_sent = 'no' OR add_fb_req ='yes' OR status = 'open')
then
send an email with the following body text:
"The following finding n. (findings_tbl___finding_num) needs some attention.
Could you please give me some help on the code to write in the condition field?
Thanks a lot
findings_tbl___finding_num (text)
findings_tbl___due_date (date)
findings_tbl___fb_sent (yes/no)
findings_tbl___add_fb_req (yes/no)
findings_tbl___status (dropdown)
The condition for a cron email I need to setup is this:
IF today is less than 7 days from due_date AND (fb_sent = 'no' OR add_fb_req ='yes' OR status = 'open')
then
send an email with the following body text:
"The following finding n. (findings_tbl___finding_num) needs some attention.
Could you please give me some help on the code to write in the condition field?
Thanks a lot