The fetch records statement is a Deluge data retrieval operation that queries records from a Creator form based on a criteria expression. It returns a list of matching records that the script can loop through, extract values from, or count. It is the standard way to read existing data from within a Creator workflow or function.
The basic syntax is records = FormName[CriteriaExpression];. The criteria can reference field values, comparison operators, and logical operators. For example, orders = Orders[Status == "Pending" && Customer == input.CustomerName]; retrieves all pending orders for the current submitter. The returned list supports iteration with for each loops and size checks with records.size().
Fetch records queries run against Creator’s data store on every execution. For forms with large record counts, adding indexed criteria fields improves query speed. Avoid fetching all records from a large form without criteria, as this can slow workflow execution and hit record fetch limits. Where possible, scope criteria to narrow the result set before iterating.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.