Supported Formulae

Clappia supports form calculations and logic using Excel-like syntax, making it easy for anyone familiar with spreadsheets to create dynamic apps. Most standard Excel formulas work in Clappia, with a few variations and additional functions tailored for app workflows.

Click on this link to learn how to use a formula block in Clappia.

Clappia supports all basic arithmetic operations (addition, subtraction, multiplication, division, remainder) as well as logic-based formulas like IF, AND, and OR.
You can find the complete list of supported formulas in the table at the end of this article.

Examples

Date and Time Formulas

• Current Date:
  TODAY()
  (Returns today’s date.)
  
  
• Current Date and Time:
  NOW()
  (Returns the current date and time.)
  ‍
• Format Today’s Date
  Example: Convert today’s date into d-MMM-yyyy (Ex: 9-Sep-2025) format
  TEXT(TODAY(), "d-MMM-yyyy")
  ‍

• Time in 12 hour Format
  ‍TEXT({time_variable}, "hh:mm A")
  Converts the time to show AM/PM.
  

• Create a Date from Year, Month, Day:
  DATE(2025, 7, 21)
  (Returns 21-July-2025.)
  
  
• Shift Date by Months (e.g., 3 months later):
  EDATE(start_date, 3)
  (Returns the date 3 months after the start date.)
  
  
• Last Day of the Month:
  EOMONTH(start_date, 0)
  (Returns the last day of the current month of start_date.)
  
  
• Days Difference:
  DAYS(end_date, start_date)
  (Number of days between two dates.)
  ‍
• Compare Dates by Day and Month Only

         Example: Contract Renewal Reminder
         IF(TEXT(TODAY(), "dd-MMM") = TEXT({contract_end_date}, "dd-MMM"), "Renewal due today", "No")

• ‍Extract Day and Month from a Date String
  Example: Get 8-Sep from 8-Sep-2025SPLITSTR({date_string}, "-", 0) & "-" & SPLITSTR({date_string}, "-", 1)
  
  

• Extract Day/Month/Year:‍

          Extract the day from a date (e.g., 15 from 15/07/2025)
          DAY(date_variable)

          Extract the month from a date (e.g., 7 from 15/07/2025)
          MONTH(date_variable)

          Extract the year from a date (e.g., 2025 from 15/07/2025)
          YEAR(date_variable)

Text and String Formulas

• Format Numbers or Dates:

         Format a date as YYYY-MM-DD
         TEXT(date_variable, "yyyy-MM-dd")

         Format a number as currency (₹250.50)
         TEXT(amount, "₹0.00")

• Get Left/Right Characters:

         Return the first 3 characters of a name 
         LEFT(name, 3)

         Return the last 4 digits of a code
         RIGHT(code, 4)

• Get Text Length:

          Return the number of characters in a description
          LEN(description)
‍

• Check the First Letter of a Word/Phrase
  Example: Validate if a name starts with AIF(LEFT({name}, 1) = "A", "Valid", "Invalid")
  ‍
• Replace Text:
  
  Change the first 3 characters of "ORD12345" to "INV"
  REPLACE("ORD12345", 1, 3, "INV")
  
  

• Substitute Text:
  
  Change the first 3 characters of "ORD12345" to "INV"
  SUBSTITUTE("123-456-123", "123", "000")
  
  

• String Concatenation: Combine first_name, middle_name, and last_name into one string:
  first_name & " " & middle_name & " " & last_name
  (Note: Text strings must be enclosed in double quotes.)

Rounding Off Formulae

• Round off a number (some_number) to 2 decimal places:
  ROUND(some_number, 2)
  
  
• Round off a number (some_number) to the nearest 10:
  ROUND(some_number, -1)
  
  
• Round off a number (some_number) to the nearest 100:
  ROUND(some_number, -2)
  
  
• Round up a number (some_number) to the nearest 10:
  ROUNDUP(some_number, -1)
  
  
• Round up a number (some_number) to the nearest 100:
  ROUNDUP(some_number, -2)
  
  

Interest Calculation Formulae

• Compound Interest:
  base_amount * POW((1 + interest_rate/(100*12)), years*12)
  
  

If/Else Formulae

• Example: Show "Pass" if the score is greater than 50, otherwise show "Fail":
  IF(score > 50, "Pass", "Fail")
  
  

Nested Conditions

You can combine multiple conditions in a single formula using nested IF statements or logical operators like AND and OR.

Examples:

• Nested IF:
  If the score is greater than 80 show “Excellent”, else if greater than 50 show “Pass”, otherwise “Fail”.
  IF(score > 80, "Excellent", IF(score > 50, "Pass", "Fail"))
  
  
• IF with AND:
  Checks if both conditions are true.
  IF(AND(age > 18, city = "Delhi"), "Eligible", "Not Eligible")
  
  
• IF with OR:
  Checks if any one condition is true.
  IF(OR(role = "Manager", role = "Supervisor"), "Approved", "Pending")
  
  

Supported Formula Table

Note
The column “Appears in Formula Suggestions?” indicates whether the formula appears in the auto-suggestion dropdown when typing in the formula field. Some formulas may not appear in the dropdown but are still fully supported if entered correctly.