Text expressions

Updated 3 weeks ago by Neil

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. Strings are parts of text expressions. 

Example fields

For all of these examples, let’s assume that we have the following text field:

Field ID

Field Type

Value

text1

Text

Stark Industries

Functions

A function goes at the start of the expression. 

Function

Description

Syntax

Output

Concatenate

Connects up to 255 strings

CONCATENATE(text1, “, Inc”)

Stark Industries, Inc

Methods

Methods come after the fieldID and are called up with a dot operator. 

Function

Data type

Description

Syntax

Output

toUpperCase

Text

Makes all characters upper case.

text1.toUpperCase()

STARK INDUSTRIES

toLowerCase

Text

Makes all characters lower case.

text1.toLowerCase()

stark industries

trim

Text

Removes any spaces at the start and end.

text1.trim()

Stark Industries

replace

Text

Replaces case-sensitive characters with others.

Specify which occurrence of the character you want to replace.

text1.replace("s", "x")

text1.replace("s", "x", 2)

Stark Induxtriex

Stark Industriex

find

Number

Shows the first location of a character in a string.

Add from which position to start looking.

It is case sensitive by default; to make it insensitive, add true(). 

text1.find("s")

text1.find(“s”, 12)

text1.find(“s”, 1, true())

11

16

1

substring

Text

Shows a defined range of characters in the string.

text1.substring(1,3)

Sta

length

Number

Shows the number of characters in a string.

text1.length()

16

Converting values to a text field

The toText method converts different data types to a text field. 

Here are some more sample field IDs and values:

  • NumField = 24.526
  • CurField = USD $24.52
  • DateField = 05/29/1971
  • Datetimefield = 05/29/1971 9:35 AM

Change

Description

Syntax

Output

Number to Text

Converts a number value to a text value.

Add formatting options to give placeholders. 

When decimal places are inlcuded, the number will be rounded.

numfield.totext()

numfield.totext(“.00”)

numfield.totext("0000")

“24.526”

“24.53”

"0024"

Currency to Text

Converts a currency value to a text value.

Add formatting options. 

curfield.totext(“0.00”)

“24.50”

Date to Text

Converts a date value to a text value.

DD=Day

MM=Month

YY, YYYY=Year 

datefield.totext(“DD/MM/YY)

“29/05/71”

Datetime to Text

Converts a datetime value to a text value.

HH=Hour

MM=Minute

AM/PM displays AM or PM

datetimefield.totext(“DD/MM/YY HH:MM AM/PM”)

“29/05/71 09:35 AM”


How did we do?