save field without zero value

Prevent ChronoForms from converting null field values to zero during database updates.

Overview

The issue occurs because CF automatically changes empty optional fields to zero when updating records via a connection action.
Add a Custom Code action in the form's On Submit event to check for and unset any empty values before saving.

Answered
ChronoForms v5
id ideagrup 23 Mar, 2017
Hello friends,

I have a form where there are some fields that is not required to fill.

The value of these fields into mysql have a null value and i need them no to change.

But my problem is: When i update the record (This form is using connection action with chronoconnectivty) the chronoforms change the value null to value zero.

Can I change this???
Gr GreyHead 23 Mar, 2017
Answer
Hi ideagrup,

You can use a Custom Code action in the form On Submit event to check for and unset any values that you don't want saved.

Bob
This topic is locked and no more replies can be posted.