Expressions Category

Introduction to expressions and formulas

Expressions are used in Kissflow to create formulas and settings for fields and steps. The importance of data types Expressions in Kissflow are strongly typed to the data type you are working with.…

Computing fields using Formula Builder

You can write expressions and create formulae for your computed fields with the help of our all-new 'Formula builder'. What is Formula builder? The Formula builder is an inbuilt tool in Kissflow…

System fields

Kissflow automatically captures data about every item that goes through a flow. For example, when a user creates a new item, Kissflow automatically stores who created the item and what time it was…

Text expressions

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 expression as a string.…

Number and currency expressions

Number and currency expressions are similar. However, many functions, methods, and operators may not work when evaluating numbers and currencies together.…

User expressions

User fields point back to a particular user in your system. Data about that user is pulled from the user management table. Fields Any user field that you created on your form can be a part of an…

IF function

The IF function returns one value if a boolean expression is true and another value if it is false. The syntax is: IF(<logical_test>,<value_if_true>,<value_if_false>) For these examples,…

Logical expressions

Logical expressions are Boolean, meaning they return either a value of TRUE or FALSE. Boolean values won’t display directly on a form. They are used in two situations:…

List expressions

Fields The following fields use a list data type: Dropdown Checkbox/multi-select Checklist This expression generates a user list: Lastcompletedstep().assignees() Example fields Field ID Field type…

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

Date and datetime expressions are very similar but cannot be mixed. Timezones and format settings for date fields are set at the account or user level.…

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

Using AI formula builder In addition to the existing formula builder, the AI add-on simplifies computing and managing formulas. Enterprise plan users can effortlessly incorporate computed fields…

Handling input behavior for various fields in AI evaluation

For computed fields, you can use AI Evaluate to test the formulas, whether created manually or generated using AI prompts, before going live. AI Evaluate provides pre-filled sample data for testing.…