all form fields to email

[blair]

hi
can anyone tell me how i can get my my form to send me all its fields in the email even if the field hasnt been filled in.
i need this as i want to copy and paste the info to a spreadsheet so i can prepare some other info. but the emailed form fields are in different place depending on the customers selections ( my form is http://www.the-sweetie-cart.co.uk/eventbookingform.php ) therefore upsetting my spreadsheet links.?

i tried setting up a csv file but i am not sure if i am accessing it properly as i have tested it a few times and the info is written on it from my first test but further tests arnt on it. the way i accesed it was i changed the php to csv in my browser address bar and the spreadsheet appeared but that means other people could access the info? but as i say only my first test is on it

is there any other way i can go about getting all the info from a submitted form ?

[Vasili]

Re: all form fields to email

You might try simply "pre-entering" a value in each field (creating a "Label"), such as "Your Entry Here" (which respondants overwrite) .... which would then all come through to you showing the fields with "Your Entry Here" to indicate a default or 'nil' entry.

Maybe better to use a "non-actionable" or "non-computative" character instead, actually, such as a simple question mark (?) if you object to the clutter of text.

[blair]

Re: all form fields to email

thanks for the reply
i did at one point try putting a space in that box but that didnt work would text be any different ?

[Vasili]

Re: all form fields to email

Yes ... a space is not recognized as data, whereas a simple question mark or other 'non-computative' symbol or text (since you are importing into Excel which uses symbols in formula to compute, so avoid asterik, forward slash, etc.) will successfully be submitted as it is a real "character."

[blair]

Re: all form fields to email

thanks again for the quick response
i am working on it just now (as i have been for days lol

1 slight problem the fields that are giving me the problem are the check boxes my clients will have about 40 of these and and they have to pick 15 you see ,

oh and another thing when i try to insert a radio button blue voda stops responding then closes ? changing the subject sry but i noticed this a few days ago and happens every time i try to insert one strange !

[Vasili]

Re: all form fields to email

Your computer apparently does not have sufficient RAM to perform the tasks of updating a large BV page file.

Close other programs in the background (including browsers), limit pages open in BV, and think about cleaning your Temp folder in your browser as well (using PREVIEW a lot as well as visiting a lot of sites on the Net will slow down overall peformance unless the Temp folder is kept lean).

[navaldesign]

Re: all form fields to email

There is no way to have the radio buttons and checkboxes in the mail (and file) because if not checked, they simply are NOT submitted.

Only solution:

Use ABVFP and set it to store the data in a database. At that point you can export (through CPanel, phpMyAdmin) a CSV file that will contain all columns (fields)

It is important, for your scopes, that in the VERY FIRST SUBMISSION you check ALL fields checkboxes and radio buttons so ABVFP will correctly create the database table.