Action Table in CrocoClick automations

Use the array action to manipulate data arrays in your automations: search, filter, extract elements and perform calculations.

Written By Baptiste Lorreyte

Last updated 7 days ago

The Array Functions action is a Premium action in CrocoClick automations that allows you to manipulate lists of data directly within your workflows.

For example, it can be used to:

  • Analyze a list of products from an order

  • Filter data from a webhook

  • Performing calculations on values (prices, quantities, etc.)

  • Transform a list to send it to another action

In other words: you can process data directly within the automation, without using an external tool.

What is the Array action?

An Array is simply a list of data.

For example:

  • a list of products in an order

  • a list of users

  • a list of prices

  • a list of items sent by an API

The Table action allows you to:

  • find a value in a list

  • filter specific data

  • extract a specific item

  • transform a list

  • perform calculations

These functions are particularly useful when your automations process:

  • e-commerce orders

  • webhooks

  • API responses

  • Shopify line items

The benefits of the Table action

More powerful automations

You can filter or analyze data directly within the workflow.

No need to send data to Zapier or Make just to perform a calculation.

It also allows you to retrieve ALL custom values from a webhook, especially if some are in the form of a list or table.

Automated decisions

For example, you can:

  • detect whether a specific product has been purchased

  • calculate the value of an order

  • filter certain users

Reduced errors

Calculations and filters are automated, which results in fewer human errors.

Flexibility

Tableau actions allow you to create much more advanced automations.

How to configure the Tableau action

Step 1 — Open an automation

In CrocoClick:

Automatisations → Workflows 

Then open an existing workflow or create a new one.

Step 2 — Add the action

Click on:

Add Action 

Then select:

Array Functions 

Step 3 — Choose the function type

You can choose:

  • Find

  • Find by Index

  • Filter

  • Line Items

  • Math

Each function is used to manipulate arrays in a different way.

Step 4 — Configure the inputs

You must define:

  • the input array

  • the keys

  • the values

  • the conditions

depending on the type of action selected.

Step 5 — Use the generated value

Once executed, the action creates an output variable.

This variable can be used in:

  • other actions

  • conditions

  • messages

  • webhooks

Action Types Table

Tables typically come from:

  • Shopify triggers

  • Inbound Webhooks

  • Custom Webhook responses

1. Find

The Find action allows you to find a specific item in a list.

It works with a pair:

clé → valeur 

If an item matches, it is returned.

⚠️ Important: Find returns only the first matching element.

Example

You want to check if a specific product is included in a Shopify order.

Configuration:

Action Type : Find Array : Shopify → Line Items Key : id Value : ID du produit 

If the product is found, the matching object is returned.

2. Find by Index

This action retrieves an item at a specific position in the list.

Arrays always start at:

0 

Example:

Position

Value

0

Apple

1

Banana

2

Cherry

If you ask:

Index = 2 

The result will be:

Cherry 

3. Filter

The Filter action retrieves all elements that match a criterion.

Unlike Find, it can return multiple results.

Example

Filter all orders for a user.

Configuration:

Key : id Value : {{user.name}} 

Result: A list containing all of this user’s orders.

4. Line Items

The Line Items action allows you to reconstruct a table.

It is primarily used to transform data to adapt it to:

  • a Webhook

  • Google Sheets

  • the Email Builder

  • an e-commerce shopping cart

In summary:

Input → transformation → nouveau tableau 

5. Math

This action allows you to perform calculations on a list of numbers.

For example:

  • add up the prices of an order

  • find the maximum value

  • calculate an average

Available operations

Operation

Description

Sum

Adds all values

Min

Returns the smallest value

Max

Returns the largest value

Average

Calculates the average

Count

Counts the number of elements

Example

Calculate the total for an order:

Operation : Sum Array : prix des produits 

Result:

Total de la commande 

Frequently Asked Questions