Hi everyone,

I’m trying to set up a workflow in Zoho Creator where each row in a subform updates related records in another form automatically.

Here’s the situation:

• My main form (e.g., “Receipts”) contains a subform where each row selects a related record (through a lookup) and specifies an amount.

• When the main form is submitted, I want the workflow to:

  1. Loop through all subform entries.

  2. Identify the linked record in another form (using the lookup field).

  3. Update certain numeric fields like “Amount_Paid”, “Balance”, and a text field like “Status”.

I’ve tried using Deluge scripts with for each loops and update functions, but I keep running into errors like:

• Variable not defined

• In Criteria left expression is of type TEXT and right expression is of type NUMBER

• Variable repairRecord is not defined

Could someone please share a sample Deluge script or best practice for looping through subform rows and updating related form records correctly?

Thank you!