Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • ๐Ÿ“–  Manual

  • ๐Ÿ‘‹Welcome

    Welcome to Tadabase

    What Is No-Code?

    Tadabase Support

    Getting Started With Tadabase

    Platform Overview

    ๐ŸงฐThe Data Builder

    Data Tables

    Fields

    Text Fields

    Personal Fields

    Number Fields

    Date Fields

    Option Fields

    File and Image Fields

    Equation Fields (Category)

    Equation Fields

    Connection Fields

    Date Equation Examples

    Records

    Record Logs

    Import Templates

    Export Templates

    Automating Tasks

    Number Equation Examples

    Text Equation Examples

    Multi-Function Equation Examples

    โœ๏ธPage Builder

    Page Builder Overview

    Layouts

    Pages

    Components Overview

    PDF Pages (Alpha)

    PDF Pages 2.0

    ๐Ÿ“—System Components

    System Components Overview

    Menu

    User Menu

    Breadcrumbs

    PDF Print (Alpha)

    Link Button

    Login

    Signup

    Profile

    HTML

    Image

    Subscriptions (Alpha)

    ๐Ÿ“˜Data Components

    Data Components Overview

    Form Component

    Table Component

    List Component

    Kanban Component

    Calendar Component

    Resource Component

    Map Component

    Timeline Component

    Accordion Component

    Card Component

    Chart Component

    Search Component

    Import Component

    Data Source

    Data Source Filtering

    Links

    Display Rules

    Inline Editing

    Data Component Visual Directory

    Custom Component

    Custom Component Helpers

    Writing Your Own Component Helpers

    ๐Ÿ™‹Users

    Users

    Roles

    Single Sign On (SSO)

    Adding Stripe Subscriptions

    ๐Ÿ”’Security and Reliability

    Tadabase Builder Security

    App Security

    User Security

    ๐Ÿ”—Integrations

    Zapier Integration

    Using Webhooks

    Saving files to Dropbox

    Adding PayPal payment buttons to your app

    Exporting records to Google Sheets

    Viewing data in Microsoft BI

    Chat Widgets

    REST API

    Using SendGrid for emails

    Saving files to AWS S3 Bucket (IAM Method)

    Incoming Webhooks

    Embeddable Components

    Saving Files to Custom S3 Bucket (Account Method, Recommended)

    PDF Forms

    Stripe Checkout

    JavaScript Callbacks and Actions

    Twilio Integration

    โš™App Settings

    General Settings

    Layout & Format Settings

    Custom Domain

    Customizing CSS

    Changing app themes

    Support Settings

    404 Error Page

    ๐Ÿ’ณAccount

    Plans

    Managing Your Account

    Sharing your app builder

    Managing your Apps

    ๐ŸงฉPipes

    Introduction to Pipes

    Adding Pipes

    Using Pipes

    PDF Gen V2

Categories
๐Ÿ“– Manual
๐Ÿงฐ The Data Builder
Multi-Function Equatio...

Multi-Function Equation Examples

Listed below are several examples of equations demonstrating various combined functions in action.

Please feel free to post in our Community if you're looking for something specific that is not listed below.

Combine Two Date Range Fieldsย 

We use the CONCAT and DATE_FORMAT functions to combine two Date Range fields together into one field.ย 

CONCAT(DATE_FORMAT({Date Range - Start Date},'%M'),' ',DATE_FORMAT({Date Range - Start Date}, '%d'),',',' ',DATE_FORMAT({Date Range - Start Date}, '%Y'),' ',' -',' ',DATE_FORMAT({Date Range - End Date},'%M'),' ',DATE_FORMAT({Date Range - End Date}, '%d'),',',' ',DATE_FORMAT({Date Range - End Date}, '%Y'),'<br>',DATE_FORMAT({2nd Date Range - Start Date},'%M'),' ',DATE_FORMAT({2nd Date Range - Start Date}, '%d'),',',' ',DATE_FORMAT({2nd Date Range - Start Date}, '%Y'),' ',' -',' ',DATE_FORMAT({2nd Date Range - End Date},'%M'),' ',DATE_FORMAT({2nd Date Range - End Date}, '%d'),',',' ',DATE_FORMAT({2nd Date Range - End Date}, '%Y'))


Create a random code

We use the CONCAT, CHAR, FLOOR, and RAND functions to generate a seven-digit string of the following.

  1. Random Number (ASCII 48-57)
  2. Random Number (ASCII 48-57)
  3. Random UPPERCASE letter (ASCII 65-90)
  4. Random lowercase letter (ASCII 97-122)
  5. Random lowercase letter (ASCII 97-122)
  6. Random Number (ASCII 48-57)
CONCAT(CHAR(FLOOR(48+RAND()*9)),CHAR(FLOOR(48+RAND()*9)),CHAR(FLOOR(65+RAND()*25)),CHAR(FLOOR(97+RAND()*25)),CHAR(FLOOR(97+RAND()*25)),CHAR(FLOOR(65+RAND()*25)),CHAR(FLOOR(48+RAND()*9)))


Detect if a field is blank or not

We use IF and LENGTH to check whether a field is blank and output text.

IF(LENGTH({Text})>0,CONCAT('text is not blank'),CONCAT('text is blank'))


Show a formatted price based on what option is selected.

We use IF, CONCAT, and FORMAT to show a Rent or Sales price formatted with two decimal places and a dollar symbol in front.

IF({Sale/Rent}='For Sale', CONCAT('$',FORMAT({Sales Price},2)), CONCAT('$',FORMAT({Rent Per Month},2)))




Detect if a Number is zero or blank

We use IF and LENGTH to detect if a number field has a blank or zero value.

IF({Number}!=0 && LENGTH({Number})>0,'FALSE','TRUE')


Output unique values from five different fields

We use CONCAT and multiple IFs to output an array of unique values based on five fields.

CONCAT({Text 1}, IF(!({Text 1}={Text 2}), CONCAT(', ',{Text 2}), ''), IF(!({Text 1}={Text 3} || {Text 2}={Text 3}), CONCAT(', ',{Text 3}),''), IF(!({Text 1}={Text 4} || {Text 2}={Text 4} || {Text 3}={Text 4}), CONCAT(', ',{Text 4}),''), IF(!({Text 1}={Text 5} || {Text 2}={Text 5} || {Text 3}={Text 5} || {Text 4} = {Text 5}), CONCAT(', ',{Text 5}),''))


Output the number of times a phrase or letter appears in a Rollup

We use FORMAT, LENGTH and some math to output the amount of times a letter appears in a Rollup Field

FORMAT((LENGTH({Rollup}) - LENGTH(REPLACE({Rollup},'A','')))/ LENGTH('A'),0)

ย 

How did we do ?

Previous Article
Text Equation Examples
Next Section
โœ๏ธ Page Builder
Article Navigation
  • Combine Two Date Range Fields
  • Create a random code
  • Detect if a field is blank or not
  • Show a formatted price based on what option is selected.
  • Detect if a Number is zero or blank
  • Output unique values from five different fields
  • Output the number of times a phrase or letter appears in a Rollup
  • Back to top
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational