Showing 53 blocks

array: add to bottom of array

push

In pins

array (optional)
value
Yes
number
Yes
date
Yes
object
Yes

Out pins

Array

array: add to top of array

unshift

In pins

array (optional)
The array you want to put your new value on top of
value
Yes
number
Yes
date
Yes
object
Yes

Out pins

Array

array: aggregation buckets to flat array

v9.2.15

In pins

Array

Out pins

Flat
Transpose

template actions: array template

In pins

template_0
template_1

Out pins

Array

custom: array with numbers

creates a new array of given numbers.


In pins

Out pins

array

custom: array with values

creates a new array of given values.


In pins

Out pins

array

array: avg

returns the avarage number in the given array of numbers.

average

In pins

Array

Out pins

Number

array: avg on field

returns the avarage number for the given field in the given array of objects.

average

In pins

Array

Out pins

Number

value similarity: best match

returns an array of best matching values in this array of values.


In pins

text
e.g. Blueprinting is very cool
matches
Array [ Blueprinting is awesome, blueprinting is very awesome, blueprinting is nice ]

Out pins

matches
best match
index

array: concat

returns a joined array of two or more arrays.

multiple

In pins

array_1
array_2

Out pins

Array

array: count unique values

returns the number of unique items for the given array of values.


In pins

Array

Out pins

Number

array: count unique values on field

returns the number of unique items for the given field its values.

distinct, cardinality

In pins

Array

Out pins

Number

array: elseif

if.. then.. else if.. then.. else if.. default..

else, switch

In pins

default
else if
then

Out pins

array

array: empty

returns an empty array.


In pins

Out pins

Array

array: filter

returns an array for each item that returns true on the executed function.


In pins

Array

Out pins

Array
all items the executed function returned true on.
Iterator

array: find by key - value

returns the matching objects for the given key value pair.


In pins

array
key
value
Yes

Out pins

results
indexes

array: get aggregation buckets

In pins

Array

Out pins

Array

array: get at index

In pins

array
index

Out pins

object
Yes

array: get first item

In pins

array

Out pins

Item
Yes

array: get last item

In pins

array

Out pins

Item
Yes

array: get meta guids

returns an array of values with _meta.guid's of each object in the given array.


In pins

Array
Array with Objects (e.g. results of a search)

Out pins

Array
Array with guids

array: group by

In pins

Array
field

Out pins

Array
Array [{ group: Any *, items: Array [] }]

array: if

if.. then.. else..

branch, condition

In pins

true
false
boolean

Out pins

array

array: index of

get the index of the given value, -1 of not found.


In pins

array
value

Out pins

index

array: join

In pins

array
join with

Out pins

value

array: length

returns the total length of the given array.

size

In pins

array

Out pins

Length

array: map

creates a new array with the results of the provided function on every element in the array.


In pins

Array
Concurrency
how many times this function should be executed in parallel.

Out pins

Array
Iterator

array: match max on field

returns all objects that have a number equal to or smaller than the given number

highest

In pins

array
max
include equal (optional)
true

Out pins

array

array: match min on field

returns all objects that have a number equal to or bigger than the given number

lowest

In pins

array
min
include equal (optional)
true

Out pins

array

array: max

returns the highest number in the given array of numbers.

highest

In pins

Array

Out pins

Number

array: max on field

returns the highest number for the given field in the given array of objects.

highest

In pins

Array

Out pins

Number

array: min

returns the lowest number in the given array of numbers.

lowest

In pins

Array

Out pins

Number

array: min on field

returns the lowest number for the given field in the given array of objects.

lowest

In pins

Array

Out pins

Number

array: nested to normal

Accepts a nested array and returns a one dimensional array

v10.6.1

In pins

array

Out pins

Array

array: range

generates a new array based of the given start and end number.


In pins

start
end
step (optional)

Out pins

array

array: remove duplicates

Removes duplicate values from an array

deduplicate

In pins

Array

Out pins

Array

array: remove from bottom of array

pop

In pins

array

Out pins

Array
item

array: remove from top of array

shift

In pins

array

Out pins

Array
item

array: reverse

In pins

Array

Out pins

Array

array: select field values

returns an array with values of the given field in this array of objects.


In pins

Array

Out pins

Array

array: select fields

filters all other fields from the objects in this array.


In pins

Array

Out pins

Array

array: shuffle

In pins

array

Out pins

Array

array: slice

In pins

array
begin
end

Out pins

Array

array: sort array by field

In pins

Array
Sort By
A-Z / 1-9
Z-A / 9-1

Out pins

Array

array: sort array by multiple fields

In pins

Array
fields
sort

Out pins

Array

array: splice

In pins

array
The array you want to push your new value to
start
deleteCount

Out pins

Array

array: sum

returns the total sum of the given array of numbers.

total

In pins

Array

Out pins

Number

array: sum on field

returns the total sum of the given field within the array of objects.

total

In pins

Array

Out pins

Number
sum of field

array: swap

In pins

array
Index Item #1
Index Item #2

Out pins

Array

array: switch

Returns an array based of the given expression.

v10.4.45

In pins

expression
The expression to evaluate.
default (optional)
The default statement to be executed.

Out pins

output
Returns the array matching the expression.
match
Returns true in case a match was found.

array: transpose

transposes the given array of objects to an object with (key: sum).


In pins

array
key
sum-key

Out pins

object

array: with dates

of

In pins

date
date

Out pins

array

array: with objects

of

In pins

object
object

Out pins

array

Groups