Intelligence Center
Search…
⌃K

Formulas

A sheet full of Wized formulas to give you an overview about common use cases

Sort array

Filter a list of data. TIP: If you want to sort a loaded array, make sure to save it to a variable after sorting. This makes sure you can use the sorted version of the array everywhere without needing to include this sort function everywhere. Example: Sorted by name
{{r.4.d.sort((b,a)=>a.name>b.name ? 1 : -1)}}

If condition: Example 1

Example: Is true when request is running or has executed successfully
{{r.7.$.isRequesting || r.7.$.hasRequested && r.7.$.statusCode == 2}}

If condition: Example 2

Example: Returns name if name is present, otherwise returns “No name defined”
{{r.7.d.name ? r.7.d.name : “No name defined”}}

Invert boolean

Often used inside of if conditions.
{{!r.3.hasRequested}}

Format timestamp by locale

Example: Returns the date & time
{{
const options = { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric', hour: "numeric" };
new Date(r.7.d.created_at).toLocaleDateString('en-US', options) + " " + new Date(r.7.d.created_at).toLocaleTimeString('en-US')
}}

Get timestamp

Example: Get the current timestamps in seconds (UNIX)
{{Math.floor(Date.now() / 1000)}}

Convert number to string

The value type string is used for text.
{{String(120)}}

Convert any value to Boolean

The value type boolean means true or false. Example: Will return "true", because the string is not empty.
{{Boolean("this is a test")}}

Add value to array

Used for example to add an id to an array of other id's. (Add item to list of liked items) Example: To get the new list, you need to return the list after adding the item. => "r.1.d;"
{{
r.1.d.push("2187289703");
r.1.d;
}}

Find item in array

Example: Find an item in an array and return it.
{{r.5.d.items.find( i => i.name === "Peter" )}}

Remove item from array

Used for example to remove an id from an array of other id's. (Remove item from liked items) Example: Find index of item you want to remove, remove item from array, then return edited array;
{{
const index = r.5.d.items.findIndex( i => i.name === "Peter" );
r.5.d.splice(index, 1);
r.5.d;
}}

Trigger events on elements

This can be useful in actions & after request actions if for example you want to trigger the execution of a Webflow interaction. Example: Select element with id 'test' and trigger manual click event
{{document.querySelector('#test').click()}}

Select and manipulate an element on your page

Example: Editing first found element with class ‘’white-text’
{{document.querySelector('.white-text').innerHTML = "Hello!}}