If delete digits from a currency field starting on the separator, no change is detected (ver 10.2)

asked on August 21, 2018 • Show version history

This is a weird one and is occurring in all my tables.

I have several columns that are being totaled in a field below the table.

The formula is not the issue, but here it is anyway:

Total formula:

=SUM(lodgingTable.lodgingAmount_Due)

The issue is if I delete digits from this number (1,000) starting at the separator (,) then no change is detected.

If I select the ",000.00" from that field,

then press the delete button,

then click anywhere else,

the total is not updated:

I have tried setting timeouts with javaScript, but have not had any luck with this. It is acting like the form does not see any change occur.

Any suggestions? Is this a known issue?

Thanks,

Chris

UPDATE:

I create a fresh new form and the issue is perpetuating:

UPDATE 2:

I had a pretty good suggestion by @Susan Sloan to omit the separator value. I did this and the problem is still there.

UPDATE 3:

Make sure the total field is a currency field with the 'currency display' checked:

When the 'currency display' is not checked in the total field the error does not occur.

1 0

Question