Could anyone help please I am trying to write a CA...
# generale
EB
04/12/2021, 8:18 AMCould anyone help please I am trying to write a CASE, WHEN formula for an inline html field but keep getting an error when trying to save and not sure where I am going wrong....if anyone could help it would be greatly appreciated 🙂
n
Netsuite Tragic
04/12/2021, 8:24 AMPlease post your formula
e
EB
04/12/2021, 8:27 AMCASE {
WHENÂ
{custbody86} = T
THEN
       '<div style="color:#365529;background-color:#d3e6cb;width:100%;font-size15px;padding20px;text-align:center;">' ||
           'This ' ||
           '<span style="font-weightbold;font size18px;">' ||
               ' WILL ' ||
           '</span>' ||
           'send an automatic email' ||
       '</div>'}
[ELSE
       '<div style="color:#782d31;background-color:#f5e4e5;width:100%;font-size15px;padding20px;text-align:center;">' ||
           'This' ||
           '<span style="font-weightbold;font size18px;">' ||
               ' WILL NOT ' ||
           '</span>' ||
           send an automatic email' ||
       '</div>']
END
EB
04/12/2021, 8:28 AM(my custom field is a checkbox so not sure if 't' and 'f' is the correct way to denote the conditions) and many thanks for looking!
n
Netsuite Tragic
04/12/2021, 9:19 AMtry this
CASEWHEN {custbody86} = 'T'THEN'<div style="color:#365529;background-color:#d3e6cb;width:100%;font-size:15px;padding:20px;text-align:center;">This'<span style="font-weight:bold;font-size:18px;"> WILL </span>send an automatic email'</div>'ELSE'<div style="color:#782d31;background-color:#f5e4e5;width:100%;font-size:15px;padding:20px;text-align:center;">This<span style="font-weight:bold;font-size:18px;"> WILL NOT </span>send an automatic email</div>'ENDNetsuite Tragic
04/12/2021, 9:22 AMI removed all of the concatenating and the opening set of {} and the closing [].
e
EB
04/12/2021, 10:16 AMThanks! It still didn't like it for some reason I had to add the ' between each statement and it accepted the below:
EB
04/12/2021, 10:16 AMCASE
WHEN {custbody86} = 'T'
THEN '<div style="color:#365529;background-color:#d3e6cb;width:100%;font-size15px;padding20px;text-align:center;">' ||
'This' ||
'<span style="font-weightbold;font size18px;">' ||
'WILL' ||
'</span>' ||
'send an automatic email' ||
'</div>'
ELSE
'<div style="color:#782d31;background-color:#f5e4e5;width:100%;font-size15px;padding20px;text-align:center;">' ||
'This ' ||
'<span style="font-weightbold;font size18px;">' ||
'WILL NOT' ||
'</span>' ||
'send an automatic email' ||
'</div>'
END
EB
04/12/2021, 10:16 AMThanks for your help 🙂
3 Views