Documentation 'Data Formats'

Is there any documentation that explains what each option in 'Data Formats' does?

Practical examples!

I know that to some it may seem that I'm too lazy to test, but for us Wappler beginners, having documentation would save a lot of time testing options, sometimes even without knowing what they do.

I would go through the menus and see what specific ones you are not sure of in each category. There is a lot of formatters and most are pretty self explanatory. There is probably 50 or more formatters there. Each with it's own purpose. And the menu changes depending on what you have selected.

But we would love to help you with any that you are not sure of.

Hello friend. I understand there are many options and that documenting over 50 would be quite a task. I don't have a specific example; I just like to study the tools I use, which is why I asked.

I'd like to know what options I have in case I need them. As system developers, we are problem solvers, and without knowing all the options available, it's very difficult to think of a way to solve something. It would be similar to a doctor working without knowing the instruments they have to use in surgery. I know it's an extreme analogy, but that's how I sometimes feel without knowing what each of these formatting tools can do.

But thank you for the answer, and I will certainly ask here if I have any specific questions.

To be honest you will likely never need 90% of them. Out of all of them, and there is many, the only ones I regularly use are format date, truncate, convert to number and currency.

Decided to take a copy of the image that you posted and give it to Copilot with this reply:

Absolutely — I know this menu well. It’s the Server Connect Data Formatter menu in Wappler, and each category contains operations you can apply to values, arrays, objects, dates, and strings inside Server Connect or App Connect.

Here’s a clean breakdown of what each category generally does, and how you’d use them in real Wappler workflows.


:toolbox: What Each Category Does in Wappler’s Data Formatter

Conditional

Used to make decisions inside expressions.

Typical tools:

  • If / Else
  • Default value
  • Null coalescing
  • Check if empty

Example:
{{ query1.data.total > 0 ? 'Active' : 'None' }}


Operation

Basic arithmetic and logical operations.

Includes:

  • Add, subtract, multiply, divide
  • Modulo
  • Boolean AND / OR
  • Increment / decrement

Example:
{{ price * qty }}


Ternary Operation

A compact conditional expression.

Example:
{{ user.is_admin ? 'Admin' : 'User' }}

This is just a shortcut version of the Conditional category.


Date and Time

Formatting, converting, and manipulating dates.

Includes:

  • Format date
  • Add/subtract days, months, years
  • Convert timezone
  • Get timestamps
  • Extract parts (year, month, day, etc.)

Example:
{{ created_at.formatDate('yyyy-MM-dd') }}


General

A grab‑bag of common utilities.

Often includes:

  • Get length
  • Check type
  • Round numbers
  • Random values
  • Hashing (MD5, SHA1)
  • Encode/decode (base64, URI)

Example:
{{ text.length }}


Conversion

Convert between data types.

Includes:

  • String → number
  • Number → string
  • JSON encode/decode
  • Boolean conversions

Example:
{{ '42'.toNumber() }}


Transform

Transform the structure of data.

Includes:

  • Map
  • Reduce
  • Filter
  • Sort
  • Join / Split
  • Unique values

Example:
{{ products.map(p => p.price) }}


Manipulation

Modify strings, arrays, or objects.

Includes:

  • Replace
  • Trim
  • Substring
  • Uppercase / lowercase
  • Remove items
  • Merge arrays
  • Slice

Example:
{{ name.toUpperCase() }}


Analyze

Extract information or compute metrics.

Includes:

  • Count
  • Sum
  • Average
  • Min / Max
  • Find index
  • Search for value

Example:
{{ orders.sum('total') }}


:bullseye: How to Think About These Categories

Here’s a simple mental model:

Category Think of it as… Typical Use
Conditional Logic Show/hide, branching
Operation Math & logic Calculations
Ternary Inline if/else Quick decisions
Date & Time Calendar tools Formatting timestamps
General Utilities Length, hashing, random
Conversion Type casting Strings ↔ numbers
Transform Reshape data Arrays, lists
Manipulation Edit data Strings, arrays
Analyze Compute insights Totals, averages

If you want, I can also give you:

  • A cheat sheet for each category
  • Real examples from your InductEase workflows
  • A step-by-step guide on when to use which formatter
  • A visual map of how these formatters chain together in Server Connect

Just tell me what direction you want to take.

This method is faster than having to lookup the Wappler Docs

1 Like

Here you can find the data formatters in App Connect explained:

6 Likes

Those docs are fantastic! Thank you!

1 Like

Fantastic. Thank you very much, friend.

1 Like

Actually most of them are also explained on the wappler virtual academy

1 Like

I think his 90% dropped by at least half after Teodor's explanations....lol

1 Like

Hello. How do I access the virtual academy?