Save form values into multiple Excel rows?

hominid4 21 Dec, 2010
I'm creating a form with text fields that is in the format of:

Client_Name_1
Client_Email_1
Client_Phone_1

Client_Name_2
Client_Email_2
Client_Phone_2

Client_Name_3
Client_Email_3
Client_Phone_3


I have this data dumping into a SQL table. Is it possible so that when this form is submitted and exported into Excel that each respective value grouping is it's on Excel row? Such as:

Excel Headers:
CLIENT NAME | CLIENT EMAIL | CLIENT PHONE

Excel Rows:
Client_Name_1 | Client_Email_1 | Client_Phone_1
Client_Name_2 | Client_Email_2 | Client_Phone_2
Client_Name_3 | Client_Email_3 | Client_Phone_3


Thanks!,
Wesley
CF 3.2
GreyHead 21 Dec, 2010
Hi Wesley,

Yes. . . but only by either hand-coding the database save so that each client is in a separate row; OR by hand-coding the Excel export to break up the combined records into separate rows. Either of these is possible which to use would depend on the overall application.

Bob
hominid4 21 Dec, 2010
Makes sense, thanks!

- Wesley
This topic is locked and no more replies can be posted.