Iterate

Use the Iterate node in NocoDB workflows to loop through a list of items (array). The node runs a set of actions for each item, one at a time. Use it to process many records or data entries in a batch.

Iterate Node

Ask NocoAI

Copy a prompt, paste it into NocoAI in any base, and replace the words in [brackets] with your own.

  • Every [morning], email each [Owner] their [overdue tasks]
  • When a [project] is marked [Done], set each of its linked [tasks] to [Closed]
  • Every [Monday], create a [check-in] record for each [active client]

Configuration

  • Loop over: Select Each item in a list or A number of times.
  • List: Specify the array of items to iterate over. The array can come from previous nodes in the workflow.
  • Number of times: With A number of times, enter a whole number, or select a value from an earlier step.

How It Works

  • The Iterate node gets an input array and processes the items one after the other.
  • For each item in the array, the workflow runs the actions in the For each item branch. Thus you can handle each item separately.
  • When the For each item branch is complete for all items, the workflow continues through the When done branch.
  • A loop is built for up to 4,000 items. A longer list can stop the run with A loop can run over at most 4000 items, followed by the name of the node. Filter the list, or lower the Limit of the node that builds it.

Repeat a number of times

To run the same steps a set number of times, select A number of times in Loop over and set Number of times. The branches then read Each time and When done.

  • The number must be a whole number of 0 or more, up to 4,000. A run stops when the value is not a whole number or is above 4,000.
  • A value of 0 runs no passes and goes straight to the When done branch.
  • In the loop, Current Number holds the number of the pass, from 1. Use it where the list mode gives Current Item.

Iterate set to repeat 3 times, with the Each time and When done branches

The workflow execution history has the logs for each iteration. Use them to monitor how NocoDB processes each item. Learn more.

Use cases

  • Send personalized emails to a list of contacts
  • Update many records in a database
  • Make reports for each item in a dataset

Availability

  • Available on the NocoDB Cloud Plus plan and higher, and on all self-hosted deployments, including Community Edition.
  • A number of times needs the NocoDB Cloud Business plan or higher, or a licensed self-hosted deployment on Self-hosted Business or higher. Each item in a list is unaffected.

Last updated on

Latest product updates?See Changelog
Stay in the loop? Follow us onLinkedInLinkedInYouTubeYouTubeXX