How to format Frontpage Form

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.

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
_____________________________________________


"khan74" <khan74@discussions.microsoft.com> wrote in message newsB6353E7-3391-4C05-8CF4-F1618B1C993B@microsoft.com...
| 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.

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
> _____________________________________________
>
>
> "khan74" <khan74@discussions.microsoft.com> wrote in message newsB6353E7-3391-4C05-8CF4-F1618B1C993B@microsoft.com...
> | 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.
>
>
>

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
_____________________________________________


"khan74" <khan74@discussions.microsoft.com> wrote in message news:57F51304-0F9E-4E5F-B85A-0D0ED3155CF9@microsoft.com...
|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
| > _____________________________________________
| >
| >
| > "khan74" <khan74@discussions.microsoft.com> wrote in message newsB6353E7-3391-4C05-8CF4-F1618B1C993B@microsoft.com...
| > | 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.
| >
| >
| >

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
> _____________________________________________
>
>
> "khan74" <khan74@discussions.microsoft.com> wrote in message news:57F51304-0F9E-4E5F-B85A-0D0ED3155CF9@microsoft.com...
> |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
> | > _____________________________________________
> | >
> | >
> | > "khan74" <khan74@discussions.microsoft.com> wrote in message newsB6353E7-3391-4C05-8CF4-F1618B1C993B@microsoft.com...
> | > | 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.
> | >
> | >
> | >
>
>
>

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

--

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


"khan74" <khan74@discussions.microsoft.com> wrote in message news:5D8CDF12-97B0-405F-ABFB-1E211D79F70B@microsoft.com...
| 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
| > _____________________________________________
| >
| >
| > "khan74" <khan74@discussions.microsoft.com> wrote in message news:57F51304-0F9E-4E5F-B85A-0D0ED3155CF9@microsoft.com...
| > |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
| > | > _____________________________________________
| > | >
| > | >
| > | > "khan74" <khan74@discussions.microsoft.com> wrote in message newsB6353E7-3391-4C05-8CF4-F1618B1C993B@microsoft.com...
| > | > | 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.
| > | >
| > | >
| > | >
| >
| >
| >