Maybe this is a database setup issue but I have a form that contains the field “InspDue” and it ids an integer. I would like this particular record to have a blank or null under it but when i update it I get a zero?? How do i set the value as null when the text field is blanked
Just add a condition in the insert or update
So in server connect, click your database insert or update step and set the $_POST input as the value and as the condition, so if the user enters nothing then it does not send the input value to the server at all.
Here is an example of an update form i did where almost all the fields are not required.
1 Like
I’ll give this a try thanks!