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

    📗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
📘 Data Components
Custom Component Helpers

Custom Component Helpers

Strings

Lowercase uppercase capitalizeFirst
capitalizeEach titleize sentence
reverse truncate center
newLinetoBr santize inflect
ordinalize    

Collections

eachProperty

Math

add subtract divide
multiply floor ceil
round    

Numbers

toFixed toPrecision toExponential
toInt toFloat digitGrouping

Comparisons

is isnt gt (greater than)
gte (greater than or equal to) lt (less than) lte (less than or equal to)
or and  

Dates

formatDate now timeago

 

String

lowercase

Turns a string to lowercase.

Parameters: none.

Usage:

//field_100 = "THIS IS A TEST STRING"

{{lowercase field_100}} this is a test string

 

uppercase

Turns a string to uppercase. Opposite of {{lowercase}}.

Parameters: none.

Usage:

//field_100 = "this is a test string"

{{uppercase field_100}} THIS IS A TEST STRING

 

capitalizeFirst

Capitalizes the firs word in a string.

Parameters: none.

Usage:

//field_100 = "this is a test string"

{{capitalizeFirst field_100}} This is a test string

 

capitalizeEach

Capitalizes each word in a string.

Parameters: none.

Usage:

//field_100 = "this is a test string"

{{capitalizeEach field_100}} This Is A Test String

 

titleize

Capitalizes all words within a string. 

Parameters: none.

Usage:

//field_100 = "this_is_a_test_string"

{{titleize field_100}} This Is a Test String

 

sentence

Capitalizes the first word of each sentence in a string and converts the rest of the sentence to lowercase.

Parameters: none.

Usage:

//field_100 = "this is string 1. this is string two."

{{sentence field_100}} This is string 1. This is string two.

 

reverse

Reverses a string.

Parameters: none.

Usage:

//field_100 = "this is a test string"

{{reverse field_100}}
gnirts tset a si siht

 

truncate

Truncates a string given a specified length, providing a custom string to denote an omission.

Parameters:

length [int] - The number of characters to keep (Required)
omission [string] - A string to denote an omission (Optional)

Usage:

//field_100 = "This is a longer test string that will be truncated."

{{truncate field_100 10 "..."}} This is a lo...

 

center

Centers a string using non-breaking spaces.

Parameters:

spaces [int] - The number of spaces. (Required)

Usage:

Please note the triple curly braces since this will output HTML. 

//field_100 = "this is a test string"

{{{center field_100 10}}} this is a test string

 

newLineToBr

Converts new line characters \n to line breaks <br>.

Usage:

//field_100 = "this is a \n test string."

{{{newLineToBr field_100}}} this is a <br> test string.

 

sanitize

Sanitizes strings for safe use in URLs and file names.

Parameters:

replacement [string] - A replacement character (Optional)

Usage:

//field_100 = "this is a test string & so is this."

{{{sanitize field_100 "-"}}}
this-is-a-test-string--so-is-this-

 

inflect

Returns the plural or singular form of a word based on a count.

Parameters:

singular [string] - The singular form of the word. (Required)
plural [string] - The plural form of the word. (Required)
include [boolean] - whether or not to include the count before the word. (Optional)

Usage:

field_100 = 0
field_101 = 1

{{inflect field_100 "lead" "leads"}}
{{inflect field_101 "customer" "customers" true}}

lead
1 customer

 

ordinalize

Turns a number into an ordinal string. 

Usage:

//field_100 = 3
//field_101 = 1
//field_102 = 22

{{ordinalize field_100}} {{ordinalize field_101}} {{ordinalize field_102}} 3rd 1st 22nd

 

Collections

Working with collection is generally only applicable with certai fields and pipe responses. 

Iterating through a one to Many connection field. 

//obj.field 47 = {"DVWQWRNZ49": "John", "4MXQJdrZ6v": "Steve"}

{{#eachProperty obj.field_47}}
	{{value}}
{{/eachProperty}}

 

Math

add

Returns the sum of two numbers.

Parameters:

value [int] - The number to add to the expression. (Required)

Usage:

//field_100 = 100

{{add field_100 5}}

105

 

subtract

Returns the difference of two numbers. Opposite of add

Parameters:

value [int] - The number to subtract from the expression. (Required)

Usage:

//field_100 = 100

{{subtract field_100 5}}

95

 

divide

Returns the division of two numbers.

Parameters:

value [int] - The number to divide the expression. (Required)

Usage:

//field_100 = 100

{{divide field_100 10}}

10

 

multiply

Returns the multiplication of two numbers.

Parameters:

value [int] - The number to multiply the expression. (Required)

Usage:

//field_100 = 100

{{multiply field_100 10}}

1000

 

floor

Returns the value rounded down to the nearest integer.

Usage:

//field_100 = 100.5

{{floor field_100}}

100

 

ceil

Returns the value rounded up to the nearest integer.

Usage:

//field_100= 100.6

{{ceil field_100}}

101

 

round

Returns the value rounded to the nearest integer.

Usage:

//field_100 = 100.69

{{round field_100}}

101

 

Numbers

toFixed

Returns exactly digits after the decimal place. The number is rounded if necessary, and the fractional part is padded with zeros if necessary so that it has the specified length.

Parameters:

digits [int] - The number of digits to appear after the decimal point. (Optional)

Usage:

//field_100 = 5.53231

{{toFixed field_100 3}}

5.532

 

toPrecision

Returns the number in fixed-point or exponential notation rounded to precision significant digits.

Parameters:

precision [int] - The number of digits. If omitted, it returns the entire number (without any formatting). (Optional)

Usage:

//field_100 = 555.322

{{toPrecision field_100 4}}

555.3

 

toExponential

Returns the number in exponential notation with one digit before the decimal point, rounded to fractions digits after the decimal point.

Parameters:

fractions [int] - An integer specifying the number of digits after the decimal point. (Optional)

Usage:

//field_100 = 5

{{toExponential field_100 5}}

5.00000e+0

 

toInt

Returns an integer.

Parameters: none.

Usage:

//field_100 = '22.2abc'

{{toInt field_100}}

22

 

toFloat

Returns a floating point number.

Parameters: none.

Usage:

//field_100 = '22.2abc'

{{toFloat field_100}}

22.2

 

digitGrouping

Adds thousands separator to a number.

Parameters:

separator [string] - A string to use as a digit group separator. (Optional)

Usage:

//field_100 = 2222222

{{digitGrouping field_100}}

2,222,222

 

Comparisons

is

Conditionally render a block if the condition is true.

Parameters:

value [string|int] - the value to test against.

Usage:

//field_100 = 5

{{#is field_100 5}}
    Field 100 is equal to 5
{{else}}
   Field 100 is not equal to 5
{{/is}}

-or with strings-
//field_100 = "Lead"

{{#is field_35 "Lead"}}
This customer is a Lead
{{else}}
Customer is not yet a lead.
{{/is}}

 

isnt

Conditionally render a block if the condition is false. Opposite of is.

Parameters:

value [string|int] - the value to test against.

Usage:

//field_100 = 5

{{#isnt field_100 5}}
    Field 100 isn't 5!
{{else}}
    Field 100 is 5
{{/isnt}}

Never mind :(

 

gt

Conditionally render a block if the value is greater than a given number.

Parameters:

value [string|int] - the value to test against.

Usage:

//field_100 = 5

{{#gt field_100 8}}
    Field 100 is not greater than 8
{{else}}
    Field 100 is greater than 8
{{/gt}}

Output: Field 100 is greater than 8

 

gte

Conditionally render a block if the value is greater or equal than a given number.

Parameters:

value [string|int] - the value to test against.

Usage:

//field_100 = 5

{{#gte field_100 5}}
    Field 100 is greater than or equal to 5
{{else}}
     Field 100 is NOT greater than or equal to 5
{{/gte}}

Output: Field 100 is greater than or equal to 5

 

lt

Conditionally render a block if the value is less than a given number. Opposite of gt.

Parameters:

value [string|int] - the value to test against.

Usage:

//field_100 = 5

{{#lt field_100 3}}
    Field 100 is less than 3
{{else}}
    Field 100 is not less than 3
{{/lt}}

Output:  Field 100 is not less than 3

 

lte

Conditionally render a block if the value is less or equal than a given number. Opposite of gte.

Parameters:

value [string|int] - the value to test against.

Usage:

//field_100 = 5

{{#lte field_100 5}}
    Field 100 is less than or equal to 5
{{else}}
    Field 100 is NOT less than or equal to 5
{{/lte}}

Output: Field 100 is less than or equal to 5

 

or

Conditionally render a block if one of the values is truthy.

Parameters:

values [string|int] - the values to test against.

Usage:

field_100 = true
field_101 = false

{{#or field_100 field_101}}
    Field 100 OR field 101 is true
{{else}}
    Neither Field 100 OR field 101 are true
{{/or}}

Outptut: Field 100 OR field 101 is true

 

and

Conditionally render a block if both values are truthy.

Parameters:

values [string|int] - the values to test against.

Usage:

field_100 = true
field_101 = false

{{#and field_100 field_101}}
    Field 100 and Field 101 are both true
{{else}} Field 100 and Field 101 are NOT both true {{/and}} Output: Field 100 and Field 101 are NOT both true

 

Dates

formatDate

Formats a date into a string given a format. Accepts any value that can be passed to new Date(). 

Parameters:

format [string] - The format string, according to these tokens: 
Format directives:
Date (Year, Month, Day):
  %Y - Year with century (can be negative, 4 digits at least)
          -0001, 0000, 1995, 2009, 14292, etc.
  %C - year / 100 (round down.  20 in 2009)
  %y - year % 100 (00..99)

  %m - Month of the year, zero-padded (01..12)
          %_m  blank-padded ( 1..12)
          %-m  no-padded (1..12)
  %B - The full month name (``January'')
          %^B  uppercased (``JANUARY'')
  %b - The abbreviated month name (``Jan'')
          %^b  uppercased (``JAN'')
  %h - Equivalent to %b

  %d - Day of the month, zero-padded (01..31)
          %-d  no-padded (1..31)
  %e - Day of the month, blank-padded ( 1..31)

  %j - Day of the year (001..366)

Time (Hour, Minute, Second, Subsecond):
  %H - Hour of the day, 24-hour clock, zero-padded (00..23)
  %k - Hour of the day, 24-hour clock, blank-padded ( 0..23)
  %I - Hour of the day, 12-hour clock, zero-padded (01..12)
  %l - Hour of the day, 12-hour clock, blank-padded ( 1..12)
  %P - Meridian indicator, lowercase (``am'' or ``pm'')
  %p - Meridian indicator, uppercase (``AM'' or ``PM'')

  %M - Minute of the hour (00..59)

  %S - Second of the minute (00..60)

  %L - Millisecond of the second (000..999)
  %N - Fractional seconds digits, default is 9 digits (nanosecond)
          %3N  millisecond (3 digits)
          %6N  microsecond (6 digits)
          %9N  nanosecond (9 digits)
          %12N picosecond (12 digits)

Time zone:
  %z - Time zone as hour and minute offset from UTC (e.g. +0900)
          %:z - hour and minute offset from UTC with a colon (e.g. +09:00)
          %::z - hour, minute and second offset from UTC (e.g. +09:00:00)
  %Z - Time zone abbreviation name

Weekday:
  %A - The full weekday name (``Sunday'')
          %^A  uppercased (``SUNDAY'')
  %a - The abbreviated name (``Sun'')
          %^a  uppercased (``SUN'')
  %u - Day of the week (Monday is 1, 1..7)
  %w - Day of the week (Sunday is 0, 0..6)

ISO 8601 week-based year and week number:
The week 1 of YYYY starts with a Monday and includes YYYY-01-04.
The days in the year before the first week are in the last week of
the previous year.
  %G - The week-based year
  %g - The last 2 digits of the week-based year (00..99)
  %V - Week number of the week-based year (01..53)

Week number:
The week 1 of YYYY starts with a Sunday or Monday (according to %U
or %W).  The days in the year before the first week are in week 0.
  %U - Week number of the year.  The week starts with Sunday.  (00..53)
  %W - Week number of the year.  The week starts with Monday.  (00..53)

Seconds since the Epoch:
  %s - Number of seconds since 1970-01-01 00:00:00 UTC.

Literal string:
  %n - Newline character (\n)
  %t - Tab character (\t)
  %% - Literal ``%'' character

Combination:
  %c - date and time (%a %b %e %T %Y)
  %D - Date (%m/%d/%y)
  %F - The ISO 8601 date format (%Y-%m-%d)
  %v - VMS date (%e-%^b-%4Y)
  %x - Same as %D
  %X - Same as %T
  %r - 12-hour time (%I:%M:%S %p)
  %R - 24-hour time (%H:%M)
  %T - 24-hour time (%H:%M:%S)
//field_100 = 2021-05-01

{{formatDate field_34 "%m/%d/%Y"}} 
<br>
{{formatDate field_34 "%I:%M%p"}}
<br>
{{formatDate field_34 "%F"}}
<br>
{{formatDate field_34 "%Y%m%dT%H%M%S%z"}} 2021-05-20
05/19/2021
05:00PM
2021-05-19
20210519T170000-0007

 

now

Returns the current date.

Parameters:

format [string] - The format string

Usage:

{{now}}
{{now "%m/%d/%Y"}}

Thu Jul 26 2012 23:41:02 GMT-0400 (AST)
07/26/2012

 

timeago

Returns a human-readable time phrase from the given date.

Usage:

//field_100 = 2021-05-01

{{timeago field_100}}

4 days ago

How did we do ?

Previous Article
Custom Component
Next Article
Writing Your Own Component Helpers
Article Navigation
  • Strings
  • Collections
  • Math
  • Numbers
  • Comparisons
  • Dates
  • String
  • lowercase
  • uppercase
  • capitalizeFirst
  • capitalizeEach
  • titleize
  • sentence
  • reverse
  • truncate
  • center
  • newLineToBr
  • sanitize
  • inflect
  • ordinalize
  • Collections
  • Math
  • add
  • subtract
  • divide
  • multiply
  • floor
  • ceil
  • round
  • Numbers
  • toFixed
  • toPrecision
  • toExponential
  • toInt
  • toFloat
  • digitGrouping
  • Comparisons
  • is
  • isnt
  • gt
  • gte
  • lt
  • lte
  • or
  • and
  • Dates
  • formatDate
  • Format directives:
  • now
  • timeago
  • Back to top
    Developer portal Tadabase Community
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational