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.

Group/Team Registration: CSV export and all registrants in same column

  1. John
    Member

    Using GF for a race registration form. Each team has about 5 team members where we need to collect name, email, phone, gender, age. We have Racer 1, Racer 2, Racer 3, etc fields.

    This is all working in GF but wondering about tweak when we export CSV. We will have over 200 teams and over 1,000 racers and it would be great to have all the Racers info in the same column (without having to copy/paste in excel).

    When we export CSV all fields are horizontal(normal csv export behavior). How could we have each racer info get saved in DB under appropriate column? (So each racer would be on their own row in DB and CSV)?

    This url is a screenshot of how we would like CSV to open and 2 of the Racer input fields on active site.
    http://highwaters.net/files/csv-export.jpg

    Yes I know this is a pretty advanced tweak. Not sure if there is something I can add to the GF fields to make them get stored in a new row and maybe a group ID number linking all the racers together so you know they are on the same team.

    Thoughts? Thanks.

    Posted 7 years ago on Monday March 11, 2013 | Permalink
  2. David Peralty
    Administrator

    Gravity Forms doesn't store information this way. Someone with intermediate PHP/mySQL knowledge could split up your data and store it in your own table as needed, so that you could have the data in there in a easier to use way. Gravity Forms won't do this, even with customization.

    The only other way to do this would be to have them submit a fresh form for each racer of the 5. Then it would be stored as above. If you want them to submit only one form, then this isn't possible with Gravity Forms data submission and recording set-up.

    Posted 7 years ago on Monday March 11, 2013 | Permalink
  3. John
    Member

    Thanks for the info, that helps me to know to explore the php/mysql route for this feature.

    Posted 7 years ago on Monday March 11, 2013 | Permalink
  4. David Peralty
    Administrator

    Cool, take a look at our documentation: http://www.gravityhelp.com/documentation/page/Developer_Docs specifically gform_after_submission.

    All my best!

    Posted 7 years ago on Monday March 11, 2013 | Permalink