form results order

D

DBF

I have a form which allows a user to enter several fields.
Currently the resulting data as displayed in the confirmation page come out
in a strange order: the data from the text boxes first, then the date and
time data created automatically, and then the data from the two text areas.
However, I would like the resulting data to be displayed in a different
order on the confirmation page.
How do I go about this?
Thanks,
Dave
 
S

Stefan B Rusynko

You need to create a custom confirmation page and point your form to it instead of using the default confirmation page
- File New page and pick the Confirmation Page Template
Add/Change the sequence of you field names in the custom page

- In your form page right click the form for form in properties



| I have a form which allows a user to enter several fields.
| Currently the resulting data as displayed in the confirmation page come out
| in a strange order: the data from the text boxes first, then the date and
| time data created automatically, and then the data from the two text areas.
| However, I would like the resulting data to be displayed in a different
| order on the confirmation page.
| How do I go about this?
| Thanks,
| Dave
|
|
 
D

DBF

Okay, that worked for the confirmation page.
However, I also send the results to a plain text file and to my email as
plain text. Any way to change the order of those?
For some reason,when I send it to a file as a ".csv" the order remains as it
is supposed to, i.e. the order of the fields on the page, but I really don't
want a csv file since it would be too much work to put it back into the
format I need.
Thanks,
Dave

Stefan B Rusynko said:
You need to create a custom confirmation page and point your form to it
Click to expand...
instead of using the default confirmation page
 
S

Stefan B Rusynko

You can't change sent / saved results from the FP forms handler to txt files or emails
textbox fields will always be last

FYI a .csv is just a delimited txt file




| Okay, that worked for the confirmation page.
| However, I also send the results to a plain text file and to my email as
| plain text. Any way to change the order of those?
| For some reason,when I send it to a file as a ".csv" the order remains as it
| is supposed to, i.e. the order of the fields on the page, but I really don't
| want a csv file since it would be too much work to put it back into the
| format I need.
| Thanks,
| Dave
|
| | > You need to create a custom confirmation page and point your form to it
| instead of using the default confirmation page
| > - File New page and pick the Confirmation Page Template
| > Add/Change the sequence of you field names in the custom page
| >
| > - In your form page right click the form for form in 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
| > _____________________________________________
| >
| >
| | > | I have a form which allows a user to enter several fields.
| > | Currently the resulting data as displayed in the confirmation page come
| out
| > | in a strange order: the data from the text boxes first, then the date
| and
| > | time data created automatically, and then the data from the two text
| areas.
| > | However, I would like the resulting data to be displayed in a different
| > | order on the confirmation page.
| > | How do I go about this?
| > | Thanks,
| > | Dave
| > |
| > |
| >
| >
|
|
 
D

DBF

You must mean that you can't format text which is sent as a text file, since
you most certainly can save and/or email the form results as a text file.
The problem with the csv file is it puts the data into quotes, which means I
have to strip the quotes off as I move the text to the file I need to use it
in.
Or am I missing something?
Thanks,
Dave

Stefan B Rusynko said:
You can't change sent / saved results from the FP forms handler to txt files or emails
textbox fields will always be last

FYI a .csv is just a delimited txt file




| Okay, that worked for the confirmation page.
| However, I also send the results to a plain text file and to my email as
| plain text. Any way to change the order of those?
| For some reason,when I send it to a file as a ".csv" the order remains as it
| is supposed to, i.e. the order of the fields on the page, but I really don't
| want a csv file since it would be too much work to put it back into the
| format I need.
| Thanks,
| Dave
|
| | > You need to create a custom confirmation page and point your form to it
| instead of using the default confirmation page
| > - File New page and pick the Confirmation Page Template
| > Add/Change the sequence of you field names in the custom page
| >
| > - In your form page right click the form for form in 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
| > _____________________________________________
| >
| >
| | > | I have a form which allows a user to enter several fields.
| > | Currently the resulting data as displayed in the confirmation page come
| out
| > | in a strange order: the data from the text boxes first, then the date
| and
| > | time data created automatically, and then the data from the two text
| areas.
| > | However, I would like the resulting data to be displayed in a different
| > | order on the confirmation page.
| > | How do I go about this?
| > | Thanks,
| > | Dave
| > |
| > |
| >
| >
|
|
Click to expand...
 
R

Rick Budde

Comment in-line
-----Original Message-----
You must mean that you can't format text which is sent as a text file, since
you most certainly can save and/or email the form results as a text file.
The problem with the csv file is it puts the data into quotes, which means I
have to strip the quotes off as I move the text to the file I need to use it
in.
Click to expand...

What is the "file you need to use it in"? For instance,
most spreadsheet & database programs will read CSV files
directly.
Or am I missing something?
Thanks,
Dave

You can't change sent / saved results from the FP
Click to expand...
forms handler to txt
files or emails
textbox fields will always be last

FYI a .csv is just a delimited txt file




| Okay, that worked for the confirmation page.
| However, I also send the results to a plain text file and to my email as
| plain text. Any way to change the order of those?
| For some reason,when I send it to a file as a ".csv"
Click to expand...
the order remains
as it
| is supposed to, i.e. the order of the fields on the
Click to expand...
page, but I really
don't
| want a csv file since it would be too much work to put it back into the
| format I need.
| Thanks,
| Dave
|
| | > You need to create a custom confirmation page and
Click to expand...
point your form to
it
| instead of using the default confirmation page
| > - File New page and pick the Confirmation Page Template
| > Add/Change the sequence of you field names in the custom page
| >
| > - In your form page right click the form for form in 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
| > _____________________________________________
| >
| >
| | > | I have a form which allows a user to enter several fields.
| > | Currently the resulting data as displayed in the
Click to expand...
confirmation page
come
| out
| > | in a strange order: the data from the text boxes
Click to expand...
first, then the
date
| and
| > | time data created automatically, and then the data from the two text
| areas.
| > | However, I would like the resulting data to be
Click to expand...
displayed in a
different
| > | order on the confirmation page.
| > | How do I go about this?
| > | Thanks,
| > | Dave
| > |
| > |
| >
| >
|
|
Click to expand...


.
Click to expand...
 
S

Stefan B Rusynko

No I meant you can't change the field order (for textbox fields) if you save a .txt or send by email




| You must mean that you can't format text which is sent as a text file, since
| you most certainly can save and/or email the form results as a text file.
| The problem with the csv file is it puts the data into quotes, which means I
| have to strip the quotes off as I move the text to the file I need to use it
| in.
| Or am I missing something?
| Thanks,
| Dave
|
| | > You can't change sent / saved results from the FP forms handler to txt
| files or emails
| > textbox fields will always be last
| >
| > FYI a .csv is just a delimited txt file
| >
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| | > | Okay, that worked for the confirmation page.
| > | However, I also send the results to a plain text file and to my email as
| > | plain text. Any way to change the order of those?
| > | For some reason,when I send it to a file as a ".csv" the order remains
| as it
| > | is supposed to, i.e. the order of the fields on the page, but I really
| don't
| > | want a csv file since it would be too much work to put it back into the
| > | format I need.
| > | Thanks,
| > | Dave
| > |
| > | | > | > You need to create a custom confirmation page and point your form to
| it
| > | instead of using the default confirmation page
| > | > - File New page and pick the Confirmation Page Template
| > | > Add/Change the sequence of you field names in the custom page
| > | >
| > | > - In your form page right click the form for form in 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
| > | > _____________________________________________
| > | >
| > | >
| > | | > | > | I have a form which allows a user to enter several fields.
| > | > | Currently the resulting data as displayed in the confirmation page
| come
| > | out
| > | > | in a strange order: the data from the text boxes first, then the
| date
| > | and
| > | > | time data created automatically, and then the data from the two text
| > | areas.
| > | > | However, I would like the resulting data to be displayed in a
| different
| > | > | order on the confirmation page.
| > | > | How do I go about this?
| > | > | Thanks,
| > | > | Dave
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|
 
D

DBF

Actually, I want to use the resulting data in a Adobe Framemaker file, which
is then converted back into a web page with WebWorks.
I can just cut and paste from the .txt file, which is what it sounds like I
will have to do. It's just that I could do it in one operation if it was in
the proper order already, whereas now I have to do, somewhere in the
process, four or five cut and paste operations.
Dave

Rick Budde said:
Comment in-line
-----Original Message-----
You must mean that you can't format text which is sent as a text file, since
you most certainly can save and/or email the form results as a text file.
The problem with the csv file is it puts the data into quotes, which means I
have to strip the quotes off as I move the text to the file I need to use it
in.
Click to expand...

What is the "file you need to use it in"? For instance,
most spreadsheet & database programs will read CSV files
directly.
Or am I missing something?
Thanks,
Dave

You can't change sent / saved results from the FP
Click to expand...
forms handler to txt
files or emails
textbox fields will always be last

FYI a .csv is just a delimited txt file




| Okay, that worked for the confirmation page.
| However, I also send the results to a plain text file and to my email as
| plain text. Any way to change the order of those?
| For some reason,when I send it to a file as a ".csv"
Click to expand...
the order remains
as it
| is supposed to, i.e. the order of the fields on the
Click to expand...
page, but I really
don't
| want a csv file since it would be too much work to put it back into the
| format I need.
| Thanks,
| Dave
|
| | > You need to create a custom confirmation page and
Click to expand...
point your form to
it
| instead of using the default confirmation page
| > - File New page and pick the Confirmation Page Template
| > Add/Change the sequence of you field names in the custom page
| >
| > - In your form page right click the form for form in 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
| > _____________________________________________
| >
| >
| | > | I have a form which allows a user to enter several fields.
| > | Currently the resulting data as displayed in the
Click to expand...
confirmation page
come
| out
| > | in a strange order: the data from the text boxes
Click to expand...
first, then the
date
| and
| > | time data created automatically, and then the data from the two text
| areas.
| > | However, I would like the resulting data to be
Click to expand...
displayed in a
different
| > | order on the confirmation page.
| > | How do I go about this?
| > | Thanks,
| > | Dave
| > |
| > |
| >
| >
|
|
Click to expand...


.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Split form 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Page numbering with Merged Document and IF statements 1
Link a text box based on drop down box with four options MS Word 365 0
How do I clear a form? 0
Adding data to MS Access from csv file 0
Office 365 Outlook adding unwanted HTML to Email Body 0

Top