Is it possible to export out a single GF List field to multiple columns/rows?

  • My Gravity Form has a list field which allows people to fill out multiple fields – first name, last name, address, etc. The user can click a ‘+’ button and add additional contacts in this fashion. When exported out, this List fields groups everything together so it looks like this (all in a single field).

    Name for Badge=Addie Sharp|Email [email protected]|Company Name=Sharp Guys|Address=777 Enfield Ln. Ln|City=Indianapolis|State=IN|Zip=42436
    Name for Badge=Sully Sharp|Email [email protected]|Company Name=Sharp|Address=714 Test Ln.|City=Indianapolis|State=IN|Zip=46236
    Name for Badge=Christine Sharp|Email [email protected]|Company Name=Sharpguys|Address=789 End Ln.|City=Indianapolis|State=IN|Zip=46236

    Would it be possible for these subfields to export to separate columns and if multiple, be shown in additional rows below the main record?

    • This topic was modified 8 years, 2 months ago by cpsharp.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    The plugin does not support this direclty. However you could write PHP code to create a transform class then add that transform to an export shortcode.

    Thread Starter cpsharp

    (@cpsharp)

    Michael,

    Thanks for the super quick reply- very appreciated. Do you do this type of custom PHP work on the side?

    Plugin Author Michael Simpson

    (@msimpson)

    Yes. We can either make the field break into columns when the submission is saved “Inbound” (how to do outlined here) or create a transform to split them out when they are display by shortcode or export “Outbound”. You can contact me at [email protected]

    The advantage of Inbound is everything is already converted. It shows as separate columns in the administration page. Fields are individually searchable. But this only works for new submissions, not those already saved.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Is it possible to export out a single GF List field to multiple columns/rows?’ is closed to new replies.