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
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
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
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
This topic is locked and no more replies can be posted.
