Expression step reference

Result: multiplied_result: 21

(Regex) replace

String.prototype.replaceAll() - JavaScript | MDN

"{{ value }}".replaceAll("r", "t")

Variables:

Result (output type: Text): "Betty Blocks"

Strip HTML

"{{{ value }}}".replace(/<[^>]*>?/gm, '')

Variables:

Result (output type: Text): "Betty Blocks" 

"{{ value }}".length > {{ limit }} ? "{{ value }}".substring(0, {{ limit }}) + '...' : "{{ value }}"

Variables:

Calculations

Result (output type: Number): 3

Result (output type: Number): 4

You can use this action step from the Block Store to count the number of records in a collection based on the take. The default take is 50, and the maximum is 200. 

Sum collection

The total price of a collection of prices (for example, an invoice)

{{ orderlines.map(item => item.line_price).reduce((a, b) => a + b, 0) }}

Result (output type: Number): 5

Date formats

Date today

new Date().toISOString().substring(0,10)

Result (output type: Text): "2023-01-27"

Date formatting

new Date("{{ date }}").toLocaleDateString("{{ locale }}", {{ options }})

new Date("2022-12-23T08:41:50Z").toLocaleDateString("nl-NL", { weekday: 'long', year: 'numeric', month: 'short', day: 'numeric' })

Result (output type: Text): "vrijdag 23 dec. 2022"

"<ul>{{#names}}<li>{{ name }}</li>{{/names}}</ul>{{^names}}Sorry, no people to list!{{/names}}"

Variables:

Result (output type: Text): "<ul><li>John Doe</li><li>Chuck Norris</li></ul>" 

Loop through collection with results + function

"<ul>{{#names}}<li>{{../fullName}}</li>{{/names}}</ul>"

Variables:

Result (output type: Text): "<ul><li>Doe, John</li><li>Norris, Chuck</li></ul>" 

Loop through collection without results

"<ul>{{#names}}<li>{{ name }}</li>{{/names}}</ul>{{^names}}Sorry, no people to list!{{/names}}"

Variables:

Result (output type: Text): "Sorry, no people to list!" 

HTML escaped value

"{{ customer_name }}"

For example, to decode special characters from a response.

"{{{ customer_name }}}"

Hide comments

"<p>This is shown!{{#show}} Psst, this is never shown{{/show}}</p>"

Variables:

Result (output type: Text): "This is shown!"

Advanced expressions

Format phone number

Format a phone number to a certain format, in this format, the first 3 letters are separated (the location code) and surrounded by brackets ().

function formatPhoneNumber() { 
  // Return empty text if there is no phone number 
  if (!"") return ""; 

  // Only get numbers from text 
  const onlyNumbers = "".replace(/[^0-9]/g, ""); 
  
  // Format phone number like "(123) 456-7890" 
  return "(" + onlyNumbers.substring(0, 3) +") " + onlyNumbers.substring(3,6) +"-" + onlyNumbers.substring(6, 10); 
}();

Variables:

Result (output type: Text): “(123) 456-7890”

Monday of week

Retrieve the date of a Monday from a week and year you provide.

function getMondayOfWeek() { 
  const date = new Date(2025, 0, (1 + ( - 1) * 7)); 
  const offset = date.getTimezoneOffset(); 
  return new Date(date.getTime() - (offset * 60 * 1000)).toISOString().split('T')[0]; 
}();

Variables:

Result (output type: Text): “2024-06-17”

Get element from array

Get a specific element from an array given an index (number).

“{{ array }}“.split(“,”)[{{ index }}]

Variables:

Filter record from collection

This filter expression is used to filter an element from a (custom) collection. In this example, the output type array is used.

The expression itself is a good example of how you can deal with collections in the Expression step.

[{{ collection.map(item => item.id) }}].filter(item => item !== {{ record_id }})

Variables:

Result (output type: Array): [{ id: 1, title: “Element 1" }, { id: 3, title: “Element 3” }]

Base64 decode

Decode Base64 back to string.

((str) => {
  const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=';
  let output = '';

  let i = 0;
  str = str.replace(/[^A-Za-z0-9+/=]/g, '');

  while (i < str.length) {
    const e1 = chars.indexOf(str.charAt(i++));
    const e2 = chars.indexOf(str.charAt(i++));
    const e3 = chars.indexOf(str.charAt(i++));
    const e4 = chars.indexOf(str.charAt(i++));

    const c1 = (e1 << 2) | (e2 >> 4);
    const c2 = ((e2 & 15) << 4) | (e3 >> 2);
    const c3 = ((e3 & 3) << 6) | e4;

    output += String.fromCharCode(c1);
    if (e3 !== 64) output += String.fromCharCode(c2);
    if (e4 !== 64) output += String.fromCharCode(c3);
  }

  return output;
})("{{ value }}");

Base64 encode

Encode a string to Base64 back to string.

((str) => {
  const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=';
  let output = '';

  let i = 0;
  while (i < str.length) {
    const c1 = str.charCodeAt(i++);
    const c2 = str.charCodeAt(i++);
    const c3 = str.charCodeAt(i++);

    const e1 = c1 >> 2;
    const e2 = ((c1 & 3) << 4) | (c2 >> 4);
    const e3 = isNaN(c2) ? 64 : ((c2 & 15) << 2) | (c3 >> 6);
    const e4 = isNaN(c2) ? 64 : isNaN(c3) ? 64 : (c3 & 63);

    output += chars.charAt(e1) + chars.charAt(e2) + chars.charAt(e3) + chars.charAt(e4);
  }
  return output;
})("{{ value }}");

Some expressions have also been turned into a block. Have a look at this list to see what steps are already available in the Block Store.

If you have any expression formatting you would like to report and add to the list, reach out to us via email: vitalii.nemchenko@bettyblocks.com