Good Morning! We are working on a customized searc...
# suiteanalytics
d
Good Morning! We are working on a customized search alert to send employees once they have expense reports paid (on creation alerts). Since these are single record transactions, I did find how to list transaction details using the Custom Message subtab but have a few questions. 1. Is there any way to add a total to the message body results, similarly to scheduled summary sends? (I do have a total on my search, I am thinking this is just a limitation of single record alert) 2. Alternatively, is there any way to make transaction amount in the subject line show up as a positive number (i realize it's technically a debit from the bank but I'm hoping maybe there's a way around it)
s
I haven’t tested this, but you could try FreeMarker’s absolute value function to force it to always displays a positive value,
{amount?abs}
: https://freemarker.apache.org/docs/ref_builtins_number.html#ref_builtin_abs
d
I got my hopes up! Unfortunately, the email subject line came through with ERROR: Invalid Expression instead. But thank you for the idea. I'll keep that handy to test in other areas where it might work better.
Figured a workaround! Used the {amountpaid} field id instead. Thanks for getting me thinking in that direction
👍 1
s
Yeah, NetSuite uses an older version of Freemarker, so not everything in their documentation is supported. And the email templates seem to have even more limitations to them than the PDF templates. Glad you found something that worked.