1) In Notepad in the CVS file just paste the headers (tab separated) with a crlf (enter key) after the last one
Note: the sequence needs to be the same as the form field sequence in your form
Then, as I indicated Do Not include Field Names in your form properties
- unselect the options to Include field names and set the form to save to Text Database using tab as separator
2) Form field names can not have spaces in them
Rename all Rental CarX fields to RentalCarX
3) Form results are saved in the form field sequence in the form page
(Except for text area fields which are Always added at the end - so don't use them for CSV)
Presume you want the data to look like this
Jane Doe Meeting SFO MPS Yes Sue Soo Training SFO NYC NO Bob
Jone Meeting SFO ATL YES
That means your form fields in the form (and CVS headers) need to be in the same sequence in the form
(view Code/Html view to verify the sequence and also look at the Saved Fields list sequence in Form Properties)
The sequence would be
Name1 Trip1 Homeloc1 destination1 RentalCar1 Name2 Trip2 Homeloc2 destination2 RentalCar2 Name3 Trip3 Homeloc3 Destination3
RentalCar3
Note:
To prevent the submit and reset buttons from saving their values delete their names in form field properties
--
| Sorry- I am having a hard time explaining what I am trying to do. I have one
| form that allows the user to input travel information for up to 15 trips
| (example below with 3 trips). The results field names populate excel as one
| long record rather than listing each trip, - this will be hard to analyse.
| I want to avoid having users input one trip at a time- to list one record at
| a time. Is there anyway to force the form to created a new record on the
| results page.
|
| 3 trips entered on one form:
| Name Trip Type Home Loc Destination Rental Car
| Jane Doe Meeting SFO MPS Yes
| Sue Soo Training SFO NYC NO
| Bob Jone Meeting SFO ATL YES
|
| Results for one form appear as follows:
| Name1 Name2 Name3 Trip1 Trip2 Trip3 Homeloc1 Homeloc2 homeloc3
| destination1 destination2 Destination3 Rental Car1 Rental car2 Rental Car3
| Jane Doe Sue Soo Bob Jone Meeting Training Meeting SFO SFO SFO MPS NYC ATL
| YES NO YES SUBMIT
|
| How do I make the results for each trip report to a new line- with the
| headers listed once?
|
| Thank you for your patience. I am not that familiar with Frontpage.
|
| "Stefan B Rusynko" wrote:
|
| > Don't understand at all what you mean by
| > "15 lines/records asking for the same header info"
| >
| > Do you have 1 or 15 forms
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > |I plan to save the file as a csv. I think I should better explain my issue.
| > | My form has 15 lines/records asking for the same header info- so they don't
| > | have to submit info 15 times. The form then submits all the records as one
| > | delimited record in excel each time to form is submitted. Please help!
| > | Thanks- Khan
| > | "Stefan B Rusynko" wrote:
| > |
| > | > How are you saving the form results
| > | > - if to a file for analysis by Excel it should be a csv tab delimited (w/o field names)
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | My form asks users to submit several lines of information. The results
| > | > | simply list across excel name name1 name2 rather than listing each record on
| > | > | a separate line.
| > | >
| > | >
| > | >
| >
| >
| >
