Title: Extra fields added when data is submitted
Last modified: August 20, 2016

---

# Extra fields added when data is submitted

 *  Resolved [cgrray](https://wordpress.org/support/users/cgrray/)
 * (@cgrray)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/)
 * I’m using FS Contact form, Contact Form DB and Contact Form to DB Extension Edit.
   The first time I set up the form and submitted it, all the data showed up in 
   the right place in the database. I changed the table headers to these: Visit 
   Date,Name 1,Name 2,Name 3,Name 4,Country of origin,Other Country,Visit Reason,
   Other Reason,Phone,Notes. The data were displayed properly on a page using these
   shortcodes:
 *     ```
       [si-contact-form form='2']
       [cfdb-table form="Visits2" show="Visit Date,Name 1,Name 2,Name 3,Name 4,Country of origin,Other Country,Visit Reason,Other Reason,Phone,Notes"]
       ```
   
 * When I submitted a second data set the database had 4 extra columns in it. The
   Visit Date column was empty and a new column with the visit date was added with
   the header ex_field1. The text I put in the Name 1 field on the form was in a
   new column with header ex_field2. The column headed Name 1 was empty. Name 2 
   and Name 3 columns were empty because I didn’t put anything in them. After them
   are two more columns with the headers ex_field6 and ex_field8, both empty. Then
   come columns with the headers Name 3,Name 4,Country of origin,Other Country,Visit
   Reason,Other Reason,Phone,Notes. All empty because I put nothing in them.
 * [http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/](http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Thread Starter [cgrray](https://wordpress.org/support/users/cgrray/)
 * (@cgrray)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/#post-3545412)
 * The form works fine with just Contact Form DB but when I use DB Extension Edit
   to edit the field headers the problem above occurs and I paid $50 for the DB 
   Extension Edit plugin. 🙁
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/#post-3545443)
 * I want to better understand this. The editor only affects the admin page where
   you view the database data. It should have no impact on the field names that 
   are saved in the DB. Is there a difference between what you see in the admin 
   panel and what you see using a short code?
 * As for the ex_* fields, that is how FSCF names fields. CFDB just saves what it
   is given. If you change your form definition in FSCF, CFDB will just pick up 
   what FSCF gives it.
 * Also: (not sure if this applies to you; kind of hard to follow your explanation)
   if you have a form with a field called “A” CFDB will save it as “A”. If you use
   the editor to change that column name to “B”, it will do so for all the saved
   entries. BUT when you get a new submission, it will be listed as “A” because 
   that is in the form definition. If you want to rename a field/column, then you
   must rename it in the FSCF form definition for future entries, and change the
   column name in the editor for already saved entries.
 *  Thread Starter [cgrray](https://wordpress.org/support/users/cgrray/)
 * (@cgrray)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/#post-3545451)
 * Thanks for responding. Looking ast this part of your response; “If you want to
   rename a field/column, then you must rename it in the FSCF form definition for
   future entries, and change the column name in the editor for already saved entries.”
   All the fields I’m referring to are Extra Fields. I don’t see any place to rename
   them in the FSCF form definition.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/#post-3545452)
 * I know you can set the field names in CF7 but I don’t know with FSCF if you can
   change the “ex_field1” names. But in the update I am just putting out today (
   2.5.1), if you are using [cfdb-table] or [cfdb-datatable] then you can change
   the names on the table column headers like this:
 * `[cfdb-table form="Form: 1" headers="ex_field1=First Name,ex_field2=Last Name"]`
 *  Thread Starter [cgrray](https://wordpress.org/support/users/cgrray/)
 * (@cgrray)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/#post-3545456)
 * I guess it doesn’t work with FSCF. Thanks for the update. That will help.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Extra fields added when data is submitted’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [cgrray](https://wordpress.org/support/users/cgrray/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/extra-fields-added-when-data-is-submitted/#post-3545456)
 * Status: resolved