How can we Help?

Generic selectors
Exact matches only
Search in title
Search in content
Home » Functions Available in Basic Expressions

Table of Contents

Please read this before using basic expressions on Crove:

  • Use correct function defintion to avoid errors.
  • To add any variable in the function defintion you need to add a Dollar($) Sign before it. E.g. SUM($price1,100) ✅ SUM(price,100) ❌ (price1 is a variabel here)
  • Name of all the functions should in Upper Case. SUM(2,4) ✅ Sum(2,4) ❌
  • “date” – You can access this by either using the NOW() function or let the user enter the date. (Add a date field in the form by changing the field type)
  • “time” – You can access this by using NOW() function or passing a timestamp using any Crove Integration.
  • “value1, value2,….” – These can be any variables that you create or any constant. E.g. SUM(2,$TotalAmount), this function is valid ✅

The following functions can be implemented using Basic Expressions on Crove:

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.
Math Funtions
  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. AVERAGE(value1,value2,….) – Returns the numerical average value in a dataset, ignoring text.
  4. 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. 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
  3. CURRENCYINWORDS(number,locale) – Converts a number into currency in words. (Locale – “INR”/”USD”)
  4. ISBLANK(value) – Checks whether the referenced variable is empty.
  5. ISEMAIL(value) – Checks whether a value is a valid email address.
  6. LOWER(text) – Converts a specified string to lowercase.
  7. UPPER(text) – Converts a specified string to uppercase.
  8. 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
  9. 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
  10. ROMAN(number) – Formats a number in Roman numerals.

Table of Contents

Automate Repetitive Documents

And use workflows to save countless hours which you spend in creating documents manually.

© 2021 Crove.app. All rights reserved

Marketed By: