Expressions Category

Introduction to expressions and formulas

Kissflow plans: ✓ Basic ✓ Enterprise Expressions are used in Kissflow to create formulas and settings for fields and steps. The importance of data types Expressions in Kissflow are strongly…

Computing fields using Formula Builder

Kissflow plans: ✓ Basic ✓ Enterprise You can write expressions and create formulas for your computed fields with the help of our Formula builder. What is Formula builder?…

System fields

Kissflow plans: ✓ Basic ✓ Enterprise Kissflow automatically captures data about every item that goes through a flow. For example, when a user creates a new item,…

Text expressions

Kissflow plans: ✓ Basic ✓ Enterprise Text expressions can be used with text fields. Text area fields cannot use expressions. Kissflow will sometimes refer to a sequence of characters in an…

Number and currency expressions

Kissflow plans: ✓ Basic ✓ Enterprise Number and currency expressions are similar. However, many functions, methods, and operators may not work when evaluating numbers and currencies.…

User expressions

Kissflow plans: ✓ Basic ✓ Enterprise User fields reference a specific user in your system; their details are retrieved from the user management table. Any custom user field you add to a form can be…

IF function

Kissflow plans: ✓ Basic ✓ Enterprise The IF function returns one value if a boolean expression is true and another if it is false. The syntax is: IF(<logical_test>,<value_if_true>,…

Logical expressions

Kissflow plans: ✓ Basic ✓ Enterprise Logical expressions are Boolean, meaning they return either a value of TRUE or FALSE. Boolean values won’t display directly on a form.…

List expressions

Kissflow plans: ✓ Basic ✓ Enterprise Some fields in Kissflow use the list data type, meaning they can hold multiple values at once. These fields include:…

Workflow step expressions

The lastCompletedStep() function retrieves information from your workflow's most recently completed step. You can access the approvers' names, the number of approvers, assignment time, approval time,…

Date expressions

Kissflow plans: ✓ Basic ✓ Enterprise Date and datetime expressions are very similar but cannot be used interchangeably. Timezones and format settings for date fields are set at the account or user…

How to display the names of multiple users from a lookup field in a text field

This article outlines how users can automatically populate a text field with the names of users selected in a multi-user lookup field. The goal is to present a readable,…

Extracting text from parentheses

Imagine you have a form where users enter their full name and ID in a single field, following a consistent format like Name (ID). For example, a user might enter Natasha (987334).…

Computing with data extracted from the Geolocation field

While the Geolocation field doesn't support direct computations, you can extract specific data using built-in methods. These values can then be used in formulas with other field inputs.…

Referencing section fields in a table using the parent field

You may have to reference values from one part of the form in another when building forms. In particular, when working with Sections and Tables in a form editor,…

AI formula builder

Kissflow plans: ✕ Basic ✓ Enterprise In addition to the existing formula builder, the AI add-on simplifies computing and managing formulas. Enterprise plan users can effortlessly incorporate…

Handling input behavior for various fields in AI evaluation

Kissflow plans: ✕ Basic ✓ Enterprise For computed fields, you can use AI Evaluate to test the formulas, created manually or generated using AI prompts, before going live.…