Formula Builder in Servicenow(Tokyo Release)

ServiceNow’s Tokyo release allows you to write formulas for column values.

By using predefined functions and formulas, you can calculate the value of a column without writing a script. Calculate the column value type using a predefined function or a nested formula using the predefined functions.

Formulas provide citizen-developers with an Excel-like experience for creating calculated fields in Glide tables without writing JavaScript.

The formula choice is added to the calculated value section, which is available in “Advanced view” as a plugin, “com.glide.formula” that gets activated along with the platform core plugin.

Functions, variables, operators, and constants can be used in the formula.

• Functions: Pre-defined functions that operate on Strings, Numbers & Date-Time values and evaluate conditions. SUM, REPLACE, and TIMEDIFF is examples.
• Variables: In the Glide environment, column names are variables that need to be resolved to actual values during formula evaluation.
• Operators: Supports the following logical operators to compare two values: Formula

= Equals, <> Not Equals, > Greater than, < Less than, >=

Greater or Equals, <= Lesser or Equals

• Constants: Strings (or) numeric values are enclosed in double-quotes. Example: “Hello”

Formula functions are available in the “Formula Function (sys_formula_function_list)” table.

The Tokyo release supports 20 formula functions.