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!
Spot the problem with this basic SQL code
OK, there is something simple that I am missing with this. I'd like to have a custom field which displays one of three Hyperlinks depending upon the value of a invoice field to take me to that carriers website.
The crux of the issue is to get this code to work in the forumlae field on my custom transaction body field. My code looks as follows but displays ERROR: Invalid Expression when I view the field on a transaction.
CASE
WHEN {carrier_code}="FASTWAY" THEN "http://www.fastway.com.au"
WHEN {carrier_code}="STARTRACK" THEN "http://www2.startrackexpress.com.au