WorkSmart Platform
Search…
🚫
Zero code, Unified Platform
📁
Files Manager
📈
Custom Database Apps
Create a Custom Database App
Columns
Column Types
Text
Multi-Line
Number
Auto Number
Currency
Date/Time
Duration
Yes/No
Choice – Drop Down, Radio Button, and Check Box
Email Address
Phone/Fax No.
URL
Formula
Adding a New Column
Modifying Existing Column
Removing a Column
Sharing an App
Views
Forms
Plug-ins
Relationships
User Permissions
Notification Settings
Automation Rules
Workflow Process
Custom Workflows
Modifying Database App Details
Save As Template
Transferring Ownership of Database App
Exporting Data
Delete a Database App
Formula Functions
➡️ Spreadsheet To Smart Apps
📝
Kanban WorkFlows
📋
Reports Management
✔️ Smart Dashboards
📚
Sites Management
📖
Address Book
📜
Billing and Payment
💫
Portal Administration
👤
My Account/Profile
Powered By GitBook
Formula
Formula field value of the field is not stored within the database record, but is calculated on the values of other fields within that record. The calculation is called a formula. This formula consists of values from other fields and the results of functions.
Available Formula Functions
Operators:
  • = plus
    – = minus
  • = multiply
    / = divide
    ( ) = precedence
​
Additional options for Form fields:
  • Formula: Enter calculation, formula, and functions. Press “@” key to get the list of functions available to choose. Fields has to be enclosed in square brackets “[ ]”. Go to Function Reference to see all the functions available.
  • Fields: Field list available to be inserted in formula. You can click field name in field list to insert in formula field at cursor position.
  • Display Format: Specify which field formatting details will be used to format the resulting formula value.
​
​
Previous
URL
Next
Adding a New Column
Last modified 1yr ago
Copy link