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!
Logic in Custom Field
We have Custom Item Fields that contain logic within a CASE clause.
The logic looks up a Checkbox field and compares the value to 'Yes' or 'No' and formats a string of free form text based on that value.
The syntax in the formula field is as follows:
CASE
WHEN
{custitem_field}='No'
THEN
CONCAT('*',{custitem_other_field})
ELSE
{custitem_other_field}
END
The above seems to work fine, on the item itself. We can pull up a tab with the custom field on it and it always displays correctly.
The issue arises when attempting to view this custom field within a