🤖 How to select a preset number of records from the whole table and update them?

You could sort this with the Array aggregator and Iterator modules as shown in the pictures below.

  • The Search Records module would be set to search without any limit and the Array aggregator module would aggregate the record IDs.

  • The Iterator module would then use the output array with the Shuffle function that randomly re-arranges the item order in the array.


  • The filter after the Iterator module would then let only the first 8 records.


The described workaround would then effectively choose only 8 random records from all records in the table.


Helpful Links:
:make: Array aggregator Guide in Help Center
:make: Iterator Guide in Help Center

1 Like