Does anyone know how to send an email update (via ...
# suiteanalytics
i
Does anyone know how to send an email update (via saved search, on record update) when a specific checkbox has been set to True? The when new value is column looks like a string. I'm wondering if anyone here knows what is the accepted value.. is it T, 'T', 't', t, true???
a
Try 1 if not 'T'
m
I think checkbox fields use
Yes
and
No
in that context (same as in formulas)
i
1 and 'T' didn't work
i'll try Yes
not sure tho if it's Yes or 'Yes' or 'yes' or yes lol
I hate it when it's not documented anywhere šŸ˜•
m
In a formula, it'd be
'Yes'
but in your use-case I'm pretty sure it's just
Yes
(and I believe it's case-insensitive)
a
I have also used 'TRUE' and 'FALSE' before as well.
i
Yes and 'TRUE' don't work either
m
Odd, I figured it'd be the same as referencing a checkbox field in a formula. Maybe it's the same as it displays in System Notes, which would be
T
, have you tried that yet?
p
I’d just use a copy of the saved search with the checkbox test in the criteria
i
@MTNathan T worked.
šŸ‘ 2
at least we know now lol
Thanks!
šŸ‘ 1