Empty Number fields are grouped as 0 by “Group Records By”

[Gattopardi]

Hi Brendan,

I’ve noticed what seems to be a grouping issue with Number fields in Tap Forms Pro.

If a Number field contains a value and I delete that value, the field correctly appears empty. However, when I use this field with Group Records By, the record is placed in the 0 group, as if the empty field actually contained the value 0.

I checked the value with a script:

var value = record.getFieldValue(‘fld-0de…….’);

if (value === undefined) {
return “UNDEFINED — no value”;
}

return “VALUE: ” + value;
For the affected record, the script returns:

UNDEFINED — no value

So the Number field really is empty and does not contain 0. It seems that Group Records By is treating undefined and the numeric value 0 as the same grouping value.

Would it be possible for empty Number fields to remain in a separate empty group, rather than being grouped together with records whose value is actually 0?

Thanks!

[Brendan]

Hi Gattopardi,

I’ll look into that. For now though you could simulate that with a Calculation field or a Script field which returns whatever value you want to distinguish 0’s from nil values. Then just set the Group Records By option to that field.

But it probably made more sense to me at the time to group nils and 0’s together with the Group Records by function. But I can see how you would want them separate.

Thanks,

Brendan

[Author]

Posts