PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

List with multiple column export to individual columns

Gravity Support Forums » Plugin Support » Gravity Forms

  1. nalwor
    Member

    Hi Team,

    I'm using the Advanced Form > List field with mutliple columns. When i try exporting the entry data in to an excel document the values for this list field all appear in one cell. is there anyway to get these values in to individual cells?

    Hope you can help,

    Thanks,
    Scott

    Posted 13 years ago on Thursday February 9, 2012 | Permalink

  2. David Smith
    Member

    Hi Scott,

    Standard functionality is that each row becomes a column with the value for that column being the combine values entered for that row separated by a pipe character.

    Example:
    This: http://grab.by/bXbC
    Is exported like this: http://grab.by/bXbK

    Is this what you are seeing or are all columns and their respective values displaying as a single value?

    If this is what are you are seeing, there is unfortunately no way to customize this without creating some sort of custom export functionality. We tried to make this as intuitive and useful as possible, but we acknowledge that there might be a better way. Any suggestions?

    Posted 13 years ago on Tuesday February 14, 2012 | Permalink

  3. nalwor
    Member

    Hi David,

    Thanks for your reply. Yes this is what I'm seeing.

    Is there anything you recommend to get around this?

    http://img594.imageshack.us/img594/470/form1.png
    http://img19.imageshack.us/img19/7769/excel1k.png

    Thanks,
    Scott

    Posted 13 years ago on Tuesday February 21, 2012 | Permalink

  4. nalwor
    Member

    Are there any other fields i can use instead of the 'List' field with mutliple columns?

    Posted 13 years ago on Tuesday February 21, 2012 | Permalink

  5. David Smith
    Member

    Hi Nalwor,

    Can you show more of your columns in the export? From the column you did show it looks like it is functioning correctly.

    There are no other fields that support multiple columns.

    Posted 13 years ago on Wednesday February 22, 2012 | Permalink

  6. nalwor
    Member

    Hi David,

    Here is a picture of all the columns: -

    http://img406.imageshack.us/img406/1584/capturelvv.png

    Is there anything you can suggest so the values are exported in to separate cells and that it looks the same as the picture? I really want to keep with using Gravity Forms but if there is no way to do this then i may have to look at other solutions.

    Thanks
    Scott

    Posted 13 years ago on Wednesday February 29, 2012 | Permalink

  7. nalwor
    Member

    Is there anything you can suggest?

    Thanks
    Scott

    Posted 13 years ago on Wednesday March 14, 2012 | Permalink