Variable Operation
Last updated
Last updated
Built-in operations for variable modification.
There are 6 types of variable:
| Type | Storage | Example | Operation |
|---|---|---|---|
Click "Basic Actions" in the Action step and here are the "Set Variable Value" and "Clear Variable Value".
To clear text, number, boolean, date, datetime variable, please use the Clear Custom Field action.
To clear JSON variable, please use the Remove All Items operation in the JSON Operation.
"input value" operation is used to assign value to a variable. This operation works for any variable type.
"input value" for text variable can be used to connect several text variables. See the below picture for where to put original value and operated value.
With this operation, you can now do formula calculation directly in the Action Step - "Set Variable Value" and Condition Step - "Value".
Math operations and function supported:
+, -, *, e, pi, PI, abs(), min(), max(), ceil(), floor(), log(), pow(), round(), sqrt(), sin(), cos(), tan()
If the formula is invalid, the system will return 0 to number variable and empty to text variable.
Index starts from 0. Every character counts including space and punctuation.
In case sensitive situation, you have to put exactly "Hi" rather than "hi", "HI" or "hI".
This feature is useful when you need to generate one-time verification code or reference code.
Description: get part of the text.
in "natural logarithm", when you are calculating log2(8) = ? put 8 as "Value" and 2 as "Number".
Description: get approximate integer.
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Type | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Type | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Type | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Type | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
| Description | e.g. Before | e.g. After |
|---|---|---|
remove spaces before or after the text
" abc "
"abc"
get part of the text
"Hi, Sendly!"
"Sendly"
replace part of the text
"Hi, Flochat!"
"Hello, Flochat!"
to lower case
"Hi, Flochat!"
"hi, flochat!"
to upper case
"Hi, Flochat!"
"HI, FLOCHAT!"
as the name
"code: XXXX-####-xxxx"
"code: UBWT-3657-lkzb"
encode
"Hi, Flochat!"
"Hi%2C%20Flochat!"
decode
"Hi%2C%20Flochat!"
"Hi, Flochat!"
encode
"Hi, Sendly!"
"SGksIFVDaGF0IQ=="
decode
"SGksIFVDaGF0IQ=="
"Hi, Sendly!"
replace spaces with hyphens and remove the rest signs
"it's a good day"
"its-a-good-day"
get text before another text
name: Sendly, city: Melbourne
name
get text before last occur of another text
name: Sendly, city: Melbourne
name: Sendly, city
get text after another text
name: Sendly, city: Melbourne
Sendly, city: Melbourne
get text after last occur of another text
name: Sendly, city: Melbourne
Melbourne
as the name
500.59
6
as the name
n/a
56
as the name
7
8
as the name
7.8693
7.87
floor
6.55
6
ceil
6.55
7
get DataTime value from formatted text
00:00:00 30th Aug, 2020
2020-08-30 00:00:00
as the name
2021-01-01 00:00:00
2021-01-01 00:01:00
Text
letters, words, sentences...
Hi, Flochat.
cutting, change case, encode, decode...
Number
number
123.45
+ - x ÷, mod, power, log, root, round...
Boolean
either "yes" or "no"
yes
assign
Date
date
2021-03-30
format, add months/weeks/days
DateTime
date and time
2021-03-30 16:52:00
format, add months/weeks/days/hours/minutes
JSON
a series of variables
{"name":"jack", "age":"10"}
load, get, update, remove, count, sum, average, sort, shuffle, reverse...
