Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Email Alerts / Customize Message & Formulas
When creating an email alert from a saved search, one has the option of using a formula with the results:
Use the syntax <%=formula%> to add formulas to the text. Formulas can include {fieldID} references.
In the example below, how do I incorporate text strings in the results?
For example, the formula below returns the results as expected:
<%=Case when {custrecord_muv_customer} Is Null Then {custrecord_muv_contact} End%>
But what I would really like to return is:
<%=Case when {custrecord_muv_customer} Is Null Then "SomeText or the actual FieldName:" {custrecord_muv_contact} End%>
I can't find a way to incorporate text into the formula without it returning an error (I've tried single and double quotes). Is there a workaround to this?