In our Zoho report, we have observed an issue where executing a function during a bulk edit operation runs the function multiple times—once for each selected report entry. This behavior is causing errors due to overlapping or redundant executions.
Our use case involves assigning a common ID to entries when users update data in bulk. However, due to the repeated function executions, the same ID is being processed multiple times, leading to unexpected behavior.
Current Approach:
Zoho allows us to write workflows triggered on form submission. We are using this method to track when a user interacts with the report. However, the workflow triggers multiple times, once per entry, during a bulk edit operation.
Requirement:
We need a solution or guidance to handle bulk edit operations such that the function executes only once for the entire bulk action, assigning a common ID to all selected entries without redundant executions.
Attached is a screenshot for reference.