Loading demo links...
What to study for each N16741GC10 domain
Understand Saved Searches Formulas and Functions
Covers when and how to use the Function dropdown and Formula Editor, the available formula field types, NetSuite field syntax with curly braces and joins, simple formulas, and the various functions available in saved searches.
Key skills
Function dropdown, formula field types, Formula Editor, field syntax, simple formulas, available functions
Understand how to manipulate Text, using formulas and concatenation options in Saved Searches
Covers manipulating text in saved search formulas, including SUBSTR and INSTR, upper and lower case functions, LENGTH, concatenation options, and the numeric formatting functions ROUND, TRUNC, FLOOR and CEIL listed in this domain.
Key skills
SUBSTR, INSTR, UPPER, LOWER, LENGTH, ROUND, TRUNC, FLOOR, CEIL, concatenation with ||
Understand how to apply Conditional Logic in Saved Searches
Covers applying conditional logic in saved searches with NULLIF, NVL, NVL2 and COALESCE, CASE expressions including operators and selector syntax, DECODE, and using Matrix searches to group information and display it in a grid format.
Key skills
NULLIF, NVL, NVL2, COALESCE, CASE expressions, CASE operators, CASE selector syntax, DECODE, Matrix searches
Understand Saved Search Date Functions and Datatype Conversion
Covers saved search date functions and datatype conversion, including adding and subtracting months from dates and applying date and datatype conversion types to saved searches.
Key skills
ADD_MONTHS, date arithmetic, TO_DATE, TO_CHAR, TO_NUMBER, TRUNC dates, MONTHS_BETWEEN, LAST_DAY, datatype conversion
Understand how to apply and modify Saved Searches for HTML Consumption
Covers applying and modifying saved searches for HTML consumption, including TO_DATE conversion in that context, HTML syntax and tags, text formatting with bold, italics and break tags, span and div tags, and adding links and images.
Key skills
Formula (HTML), HTML tags, bold and italics, br tag, span and div tags, links, images, TO_DATE