Problem with move to MySQL - workflow email

@Aleksi @Phil I’m having trouble with a workflow now that I’m moving my app to a MySQL database. I have an ENUMLIST column that I am using in a workflow to send an email. If ENUMLIST options ‘1’, ‘2’, and/or ‘4’ appear in the list then send an email. If ONLY ENUMLIST option ‘3’ appears in the list then do not send an email. The workflow condition I’m using is (simplified)…

AND([TYPE]=“A”,
OR(IN(“item 1”, [ENUMLIST]), IN(“item 2”, [ENUMLIST]), IN(“item 4”, [ENUMLIST])))

The above condition works with my app on a GoogleSheet Db with any combination of items 1, 2, and/or 4 in the ENUMLIST.

However, with my app on a MySQL Db, I can send my workflow email only if a single item (1, 2, or 4) appears, not if multiple items appear. Help!

0 12 472
12 REPLIES 12
Top Labels in this Space