How to add list box in alert mail??

[priyav24]

Hello Everybody,

                               I have an requirement from a customer, where they want to receive an "alert mail" if the 'voucher amount=0'.

I have did this by alert by using the condition 'sum(voucheramount)=0' which is working fine.

For the mail message, "=Text('These records need your attention..')& ','& AccountName",I want what are accounts that need thier attention..Is it possible to show the accounts which voucheramount=0 ...

Thanks in Advance,

Priya

[Siva_Sankar]

Try creating the expression to show the accounts that are 0. use this in aler message.

regards.

siva

[priyav24]

i tried this "if(voucheramount=0,accountname)" in the message of the Alert which is  not fetching any values

[priyav24 · Accepted solution]

Thanks for all,

Finally got the solution by using the concat function which will show all the account names separated  satisfying the condition...

by ";"..

=Text('These records need your attention..')& ','&concat(AccountName,';')