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
Text Equation Examples

Text Equation Examples

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

CHAR

The CHAR function generates a character from a numeric value. The result is going to be based on the corresponding character of the numeric input read as an int ASCII code. The input should be a value from 0-255. For a character guide, please click here.

Below is a sample equation using the CHAR function.

2022-01-20_21-00-24.png

Below are the results of this sample equation using the CHAR function.

1kh362K-z5kUmRaxgKdldF-hLTgobILjeg.png

CONCAT

The CONCAT function concatenates the given comma-separated inputs. This function requires at least one value, however, two or more should be present for there to a difference between the input and the produced value.

There are two main types of use cases for this function:

  1. Input with a single field combined with static text (CONCAT: Use Case 1)
  2. Input with multiple fields combined with static text (CONCAT: Use Case 2)

CONCAT: Use Case 1

Below is a sample equation using the CONCAT function with a single field combined with static text. 

2022-01-20_21-05-13.png

Taking a closer look at this sample equation, we can see that (a) is the field and (b) is the static text. When adding text into your function, ensure that it is within single quotes.

dMR2022-01-20_21-05-13.png

Below are the results of this sample equation using the CONCAT function with a single field combined with static text. 

QYtTmHRtSzRQAvwtoac7isjD4Is9XWLcNw.png

CONCAT: Use Case 2

Below is a sample equation using the CONCAT function with multiple fields combined with static text. 

2022-01-20_21-09-32.png

Taking a closer look at this sample equation, we can see that (a) and (c) are the fields and (b) is the static text. This example shows the use of CHAR to place a space between the two fields. No more than 254 total fields and static text instances can be used within the CONCAT function.

bKi2022-01-20_21-09-32.png

Below are the results of this sample equation using the CONCAT function with multiple fields combined with static text. 

GqFm74e2qYJpDv1RncPoB2JzRPNhPduCow.png

 

LOWER

The LOWER function generates the lowercase representation of your given values. The expected input for this function is a single field.

Below is a sample equation using the LOWER function.

2022-01-20_21-13-03.png

Below are the results of this sample equation using the LOWER function.

8uX-FhO6A4BoGE68AqILy1S9masGlr_8rA.png

 

UPPER

The UPPER function generates the uppercase representation of your given values. The expected input for this function is a single field.

Below is a sample equation using the UPPER function.

2022-01-20_21-14-19.png

Below are the results of this sample equation using the UPPER function.

5kbNQnLGQ60ZVSHw63RASIauXYp5UyT_AA.png

 

REVERSE

The REVERSE function generates the reverse representation of your given values. The expected input for this function is a single field. 

Below is a sample equation using the REVERSE function.

2022-01-20_21-15-13.png

Below are the results of this sample equation using the REVERSE function.

oaHeNz23Menx21kEHF_FGQIonPVDgQ090A.png

 

LENGTH

The LENGTH function generates a numeric representation of the number of characters in your given values. The expected input for this function is a single field. 

Below is a sample equation using the LENGTH function.

2022-01-20_21-16-10.png

Below are the results of this sample equation using the LENGTH function.

mdj_A5QxB36Y7dYMSN8YSmYB7L_einZayg.png

 

REPLACE

The REPLACE function replaces a defined set of characters with another defined set of characters within your given values.

The REPLACE function expects three values as input. Referencing the image below, (a) is the field that will display the replacement of value (b) to value (c), (b) is the text to replace, and (c) is the text that will replace the prior (b) value. You may use fields for values B and C or custom text. Custom text must be enclosed within single quotations (') and all values must be separated with a comma. As a reminder, the entire formula must be enclosed within the function parentheses.

2022-01-20_21-19-55.png

For instance, say you have a Sales Rep field and you would like to replace every entry of "Edward" with "Eddie". You can accomplish this with a REPLACE function as illustrated above.

The result of this equation will appear as such:

equations-replace-eddie-result.png

At this time, the REPLACE function can only be used within field values that do not contain spaces.

 

     

    How did we do ?

    Previous Article
    Number Equation Examples
    Next Article
    Multi-Function Equation Examples
    Article Navigation
  1. CHAR
  2. CONCAT
  3. LOWER
  4. UPPER
  5. REVERSE
  6. LENGTH
  7. REPLACE
  8. Back to top
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational