Empty records in database

On a website that I made, I created with chronoforms an form that lets the customer order meat and which afterwards is saved automatically in a database. Afterwards this data can be downloaded as a csv file.
Now the problem is that when 80 people have ordered the meat they want to buy some of the data have empty fields. However the customer is sure that he filled it out correctly. As I made a required name, phone and email field he didn't get an error message saying that these fields were required. The fields for the meat are not required as they can chose what meat they want to buy. And yet I get blank records
Attached is my form I created.

Can anyone help me???😟

Hi Web-itc,

I'm not sure what the problem is here. I checked the site with the login you sent. There are only two records saved for this form and neither of them seem to have any missing data.

I also suggested a week ago that you add serverside validation to check for missing data but I didn't see any sign that you have added that.

Bob

Indeed at this time there are no empty records as they deleted the old records.

The problem is that i don't know where to put and How to proceed with the server size validation. I only have 3 fields that are required. The rest is custom.

For this i would require soms help. Thank you in

Hi Web-itc,

Please see this FAQ

Bob

That is the point. I don't know what to fill in with input names. What do I need to do with my custom fields? Soms of the fields may be empty because the customer can choose what he wants to buy. He does not need to fill out all the fields.

Hi Web-itc,

True, and I can't tell you how your form needs to be validated :-(

I guess that you could use Custom Serverside validation and check that at least one meat order is entered.

Bob

Hi Bob

I just checked the backend of the site and I saw that there is now an empty record in the database. Could you just have a look at this using the login codes? The only thing we see is CF_id. All the rest is empty. However Name, phone and mail are required??! Would captcha do anything whit this? Or can I check using php validation? But I don't know anything of php-scripts.

Hi Web-itc,

Have you added the serverside validation?

Is there an IP address in this 'empty' record?

Bob

Hello Mr Jane

I have now created the server validation. But it now gives me an error eventhough the field is filled out.

Hi Web-itc,

I just checked your forms - I don't see any sign that you have added ServerSide validation to any of them :-(

On the Rundsvlees it looks as though you save the Data to the Session on the Confirmation page but you may not be getting it back from the Session (use the Session to Data action for this) before the DB Save action.

If you temporarily add Debugger actions to your form you will be able to see what data is present at different points in the process.

Bob