Functions
Mass Update Records in a Zoho Creator Database
Every price rises, every category gets renamed, every field eventually needs backfilling. The pattern is always the same: select the records you mean with a criteria set, loop them, write the change. The whole technique is two lines — what matters is ...
Work Around Deluge Iteration Limits in Zoho Creator
Deluge caps how many records a single loop may touch. Hit that ceiling and your script stops part-way through, often without an error that makes the cause obvious. Two patterns get around it, and both work by making each individual loop smaller ...
Generate Random Numbers in Zoho Creator
Deluge has no random(). That is a surprise the first time you need a reference code, a raffle winner or a sampling key. There are two honest ways around it, and which one you want depends on whether anybody would benefit from predicting the result. ...
Calculate Standard Deviation in Zoho Creator
Averages hide the thing you usually want to know. Two products can sell the same annual volume while one ships steadily and the other spikes once a quarter — and only the second one wrecks your inventory planning. Standard deviation is what separates ...