Title: User Defined Fields
Last modified: August 20, 2016

---

# User Defined Fields

 *  Resolved [just_mike70](https://wordpress.org/support/users/just_mike70/)
 * (@just_mike70)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/user-defined-fields/)
 * I downloaded the plugin today, and find it to be a really great tool.
 * I’ve been able to create a couple of reports and CVS exports, but I can’t seem
   to get the add fields.
 * I have a table, created by the theme author that reuses a field called element_value
   several times. I have name, address, city, state and zip going into those fields.
   The author uses a field called element_label to sort of index element_value, 
   so it would look like this:
 * element_label element_value
    John Doe 1 123 Main St 2 Springfield 3 IL 4 60609
   5
 * There are 21 of these fields.
 * I want to create mailing labels by exporting the data into a CVS, but as you 
   can see, the above layout would take quite a bit of manipulation.
 * What I was hoping to do was to add a fields called Name, Address, City, ST and
   ZIP to be formatted horizontally in columns instead of rows, as the table is 
   defined.
 * I don’t know enough at this point to get the “add field” set-up. I was able to
   set up a field called Name, but I can’t figure out how to use the rest of fields
   in the add field form to define it.
 * I know I wrote a lot, but if there is any chance someone can assist me, I needed
   to give you all a lot of detail.
 * Thanks,
 * Mike
 * [http://wordpress.org/extend/plugins/exports-and-reports/](http://wordpress.org/extend/plugins/exports-and-reports/)

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

 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/user-defined-fields/#post-3602540)
 * You’ll need to do a separate JOIN for each field you want to include in the report
   in that kind of format.
 * For an example, look at how this guy did his LEFT JOIN and added the select alias
   to the query:
 * [http://wordpress.org/support/topic/meta-data-in-excel?replies=7#post-3925614](http://wordpress.org/support/topic/meta-data-in-excel?replies=7#post-3925614)
 *  Thread Starter [just_mike70](https://wordpress.org/support/users/just_mike70/)
 * (@just_mike70)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/user-defined-fields/#post-3602610)
 * I thought I would let you all see how I solved this. I used a group_concat which
   reads multiple rows into one one long string field row until the group_id field
   changes value. It also separates fields with a comma for my excel import, and
   lastly I entered the label for the field as “name,address,city,state,zip” (without
   the quotes) which then allows me to import the first row as column labels. It
   all works well.
 * Thanks to Scott and others who made suggestions.
 * Mike
 * SELECT GROUP_CONCAT(element_value) as Name
    FROM wp_formmaker_submits GROUP BY
   group_id

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

The topic ‘User Defined Fields’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/exports-and-reports.svg)
 * [Exports and Reports](https://wordpress.org/plugins/exports-and-reports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/exports-and-reports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/exports-and-reports/)
 * [Active Topics](https://wordpress.org/support/plugin/exports-and-reports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/exports-and-reports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/exports-and-reports/reviews/)

## Tags

 * [add fields](https://wordpress.org/support/topic-tag/add-fields/)

 * 2 replies
 * 2 participants
 * Last reply from: [just_mike70](https://wordpress.org/support/users/just_mike70/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/user-defined-fields/#post-3602610)
 * Status: resolved