I have a workflow rule that should only email a specific group when 1 of 4 values change.
The logic is this:
OR(
[_THISROW_BEFORE].[A]<>[_THISROW].[A],
[_THISROW_BEFORE].[B]<>[_THISROW].[B],
[_THISROW_BEFORE].[C]<>[_THISROW].[C],
[_THISROW_BEFORE].[D]<>[_THISROW].[D])
The problem is, anytime the table has a data change, it ignores the condition and sends users unwanted emails.
Iโve tried [_thisrowafter]; also with no luck. I have 3 other Automation bots in the same app, and they seem to work fine.
Lastly, i have similar logic in the Old โBehavior > Workflowโ area that is working fine, using the sameโฆ
OR โฆ old value <> new/current value
approach
any ideas?
Make sure the =
/<>
quirk isnโt a problem.
I default the values to zero, so the left side should also have a value. I have similar logic in the old workflow, so I was wondering if it might have something to do with the new automation features. Iโll take another look and make sure itโs not the quirk and report back.
Thanks Steve
Bonjour,
Je rencontre le mรชme problรจme, avez vous trouvรฉ une solution?
Cordialement
Renaud
Please contact support@appsheet.com for help with this.
@Steve and others - I wanted to follow back up on this. Support provide me with this logic, and the bot appears to be firing correctly now.
OR(
(โxโ & [_THISROW_BEFORE].[a])<>(โxโ & [_THISROW_AFTER].[a]),
(โxโ & [_THISROW_BEFORE].[b])<>(โxโ & [_THISROW_AFTER].[b]),
(โxโ & [_THISROW_BEFORE].[c])<>(โxโ & [_THISROW_AFTER].[c]),
(โxโ & [_THISROW_BEFORE].[d])<>(โxโ & [_THISROW_AFTER].[d]))
Iโm not sure what the โxโ does, but support was aware of the issue. Iโm not sure if this will continue to work after the issue if fixed (I think it will).
Happy Appโing
The โxโ works around The Quirk:
https://community.appsheet.com/search?q=@steve%20quirk
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |