Formulas

Formulas - Date

Date. F ormulas available: AddDays. AddMonths. AddYears. Today. ToDate. Examples of use case of Date formulas:. AddDays. Add 3 days to the specified date 2020/01/01 AddDays(@my_date,3) AddMonths. Add…

Sofia Teran
Updated 2 months ago by Sofia Teran

Formulas - Comparison

Comparison. F o rmulas available: IsEqual. IsNotEqual. IsGreater. IsGreaterOrEqual. IsLess. IsLessOrEqual. IsSet. Examples of use case of Comparison formulas:. IsEqual. Check if input from the user i…

Dilyara Mukhamedgaleyeva
Updated 2 months ago by Dilyara Mukhamedgaleyeva

Formulas - Regex

Regex. F ormulas available: RegexText. Examples of the use case of Array formulas:. RegexText. Example 1: Let's imagine that you want to have a specific number of digits: Add a text block instead of…

Sofia Teran
Updated 6 hours ago by Sofia Teran

Formulas - Math

Math. Formulas available: Product. Quotient. Remainder. Subtract. Sum. ToFloat. ToInteger. Examples of use case of Math formulas:. Product. Apply 20% discount Product(@price, 0.8) Quotient. Get % of…

Dilyara Mukhamedgaleyeva
Updated 2 months ago by Dilyara Mukhamedgaleyeva

Formulas - Array

Array. Formulas available: Contains. GetValue. IndexOf. Length. List. Slice. Push. Examples of use case of Array formulas:. Contains. Check if array @products = ["chair","table","sofa","lamp"] contai…

Dilyara Mukhamedgaleyeva
Updated 2 months ago by Dilyara Mukhamedgaleyeva

Formulas - Logical

Logical. F ormulas available: And. If. Not. Or. Examples of use case of Logical formulas:. AND. Let's take a look on this example: if email contains "gmail.com" AND the age is over 18 And(Contains(@e…

Sofia Teran
Updated 2 months ago by Sofia Teran

Formulas - Object

Object. F ormulas available: GetValue. ToJSON. Examples of use case of Object formulas:. GetValue. Get value from the key "Name" GetValue(@response,"Name") Get value from the first item of the array…

Dilyara Mukhamedgaleyeva
Updated 2 months ago by Dilyara Mukhamedgaleyeva

Formulas - String

String. Formulas available: Capitalize. Contains. Length. Lower. Replace. Slice. Split. Title. ToString. Upper. Examples of use case of String formulas:. Capitalize. The first lowercase letter of the…

Sofia Teran
Updated 2 weeks ago by Sofia Teran

Contact