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.
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.