Do you have users who love submitting zeros on forms? What if I told you there’s a way to prevent that using Groovy?

It’s common for users to input zeroes during planning either as placeholders or by habit.

But these zeroes, while harmless at first glance, can introduce noise into reporting, consume unnecessary storage, and create confusion in downstream calculations.

This is where a small Groovy script can make a big difference.

operation.grid.dataCellIterator({DataCell cell -> cell.edited}).each{
     if(it.data == 0){
        it.setFormattedValue("#MISSING");
	}
}

Hopefully this is helpful to you.