All Collections
Getting Started
Add mathematical formulas and advance expressions
List of Functions you can use in Expressions
List of Functions you can use in Expressions
List of pre-made expressions available in Crove.
Gourav Manchanda avatar
Written by Gourav Manchanda
Updated over a week ago

Tips

  • To add any variable in the function defintion you need to add a Dollar($) Sign before it.
    SUM($price, $tax) ✅
    SUM(price, tax) ❌

  • Name of all the functions should in Upper Case.
    SUM(2,4) ✅
    Sum(2,4) ❌

Date & Time Functions

  1. NOW() – Returns the current date and time as a date value. You can use this date value in other date functions. E.g. 11/2/2021, 7:07:20 AM. You can also use NOW() function to return timestamp of your time zone. Eg. NOW(‘Asia/Kolkata’), NOW(‘America/Detroit’).

  2. WEEKDAY(date) – Returns a number representing the day of the week of the date provided. Eg. WEEKDAY(NOW()) – This will show 2 on the preview.

  3. YEAR(date) – Returns the year specified by a given date. E.g. YEAR($DateVariable) – This is show the year corresponding to the date entered by the user in Crove Forms or passed to the variable using any Crove Integration.

  4. MONTH(date) – Returns the month of the year a specific date falls in, in numeric format.

  5. HOURS(time) – Returns the hour component of a specific time, in numeric format. E.g. HOURS(NOW()) will show “7”. (example continued from the first function defintion)

  6. MINUTES(time) – Returns the minute component of a specific time, in numeric format.

  7. SECONDS(time) – Returns the second component of a specific time, in numeric format.

  8. TODAY() – Returns today’s date in DD/MM/YYYY format.

Currency Functions

  1. CURRENCYINNUMBERS(number,locale) – Converts a number into currency (Locale – “INR”/”USD”). This function rounds off the currency to 2 digits after the decimal. E.g. CURRENCY

  2. CURRENCYINWORDS(number,locale) – Converts a number into currency in words. (Locale – “INR”/”USD”)

Math Functions

  1. SUM(value1, value2,….) – Returns the sum of a series of numbers.

  2. MINUS(value1, value2) – Returns the difference of two numbers. Equivalent to the `-` operator.

  3. MULTIPLY(value1, value2,….) – Returns the multiplication of a series of numbers.

  4. DIVIDE(value1, value2) – Returns the result of division two numbers.

  5. AVERAGE(value1, value2,….) – Returns the numerical average value in a dataset, ignoring text.

  6. ROUND(value, scale) – Rounds a number to a certain number of decimal places according to standard rules. E.g. ROUND(34.7899,2) will be converted to 34.79

String Functions

  1. CONCAT(value1,value2,….) – Returns the concatenation of two or more values. E.g. CONCATENATE(“Hello”,”World!”) will show the be converted to HelloWorld!

  2. ISBLANK(value) – Checks whether the referenced variable is empty.

  3. ISEMAIL(value) – Checks whether a value is a valid email address.

  4. LOWER(text) – Converts a specified string to lowercase.

  5. UPPER(text) – Converts a specified string to uppercase.

  6. REPLACEALL(text, pattern, new_text) – Replaces all occurences of the given text. REPLACEALL(“here here here”,”here”,”there”) this will be changed to there there there

  7. REPLACE(text, pattern, new_text) – Replaces only the first occurence of the given text. REPLACE(“here here here”,”here”,”there”) this will be changed to there here here

  8. ROMAN(number) – Formats a number in Roman numerals.

Did this answer your question?