Bubble Edit null out "0" value

Bubble Edit null out "0" value

lcoglcog Posts: 22Questions: 5Answers: 0

I’m using the Bubble feature of the Editor and when I want to set a numeric field to null it doesn’t work if the existing value is 0 (the underlying database field is numeric). If it is any other value I can highlight the value, delete it and click on Update and it works. If I use the main editor form I can null out an existing 0 (or any other value), it appears to only be in the Bubble editor that I have this issue. Is there a way I can get bubble edit to allow a 0 to be nulled out?

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 49,056Questions: 1Answers: 7,171 Site admin
    Answer ✓

    Normally if I want to combine numeric fields with a null value, I'd use the ifEmpty() formatter. Then if the user submits an empty string null will be written to the database. That allows them to still submit 0 if needed.

    If you want 0 to be written as a null, then a custom set formatter is the way to do it.

    Allan

  • lcoglcog Posts: 22Questions: 5Answers: 0

    Thank you.

Sign In or Register to comment.