-
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…
-
dateDiff function
The dateDiff function calculates the difference between two specific points in time. It is designed to be flexible, allowing you to measure differences in various units (like days, months,…
-
calendarDays function
The calendarDays function is designed for precision tracking of durations where the start and end dates both represent active periods of time. Unlike standard subtraction,…
-
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.…