My form data isn't saving to the database correctly

Published on Oct 9, 2012 09:14

ChronoForms will automatically save data to a database table if you have added a DB Save action (or actions) to the form On Submit event. Here is a useful checklist:

The DB Save action has been added to the form and is configured to save to the correct table.

The table has a numeric primary key (it will if you used the ChronoForms 'Create table' icon). It must be an integer and not a string.

The form input names you want to save match the table column names **exactly**

None of the input or column names contain spaces, dashes, or other special characters except for underscore '_'

The input and column names all start with a letter.

Any Checkbox Group or Multi-Select dropdown must have an array name ending in [] e.g. my_dropdown[]

Any array data from a Checkbox Group or a Multi-Select dropdown has been converted to a string. Use a Handle Arrays action before the DB Save action to do this.

If you are using a Model ID then make sure that all the data is stored in the correct sub-array of $form->data for example $form->data['my_model_id']

Category: CFv4 Working with the database

Comments:

You need to login to be able to post a comment.