FP Form Results

Using: FP 2003
Objective: Trying to develop form that will send results to individual's email AND store them in xls spreadsheet.
Code: Bottom of this message

Tested it twice
- once the results did in fact go into the email account - - but they did NOT track in the xls file.  
-second attempt did NOT go into email, but put results in form_results.csv file instead of one_day_pass.txt that code dictates.   Form properties allows both fields to be activated - send to email and send to file....in both tests mentioned above I had both options selected.

<form method="POST" name="One_Day_Pass" target="_blank" action="--WEBBOT-SELF--">
      <!--webbot bot="SaveResults" U-File="../_private/One_Day_Passes.txt" S-Format S-Email-Address="Becca.Reynolds@aa.com" S-Email-Format="TEXT/PRE" -->
      
Thx
BeccaJReynoldsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nprignanoTechnical ArchitectCommented:
Everything above seems to check out.  When you say first attempt, second attempt - what did you diffently between the two attempts?




BTW - you should not be saving to a .txt - you should save to either an HTML file or CSV so the results can be seperated logically.

Also, is the email not being sent, or are you not recieving it?  If your email server has Spam Filters, it is entirely possible that the email server is blocking these emails because the sender address can easily be flagged as Spam.



nprignano
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hhammashCommented:
Hi,

I prefer if you replace excel with Access and use this white paper.

http://support.microsoft.com/kb/275251

Maybe you can replace Access with Excel in the above white paper.

Or if you insist on using excel,  make your process in two steps:

step 1
- create the form
- post the form to the database
- create a confirmation page
Step 1 will send the data to the database and open a confirmation page.

step 2
- in the confirmation page itself create a hidden form and get the data from the original form
- make this form post to the email

Step 2 will send the data to the email.

The user should process the form in the second page.  Make sure that you put anything that tells the user that he/she should press submit.

hhammash
0
nprignanoTechnical ArchitectCommented:
you cannot send results to an .xls file - if you want to use your results in an xls file, you will have to import them from the csv file that you save them to.


using the method hhamash is describing will allow you to write to a database - but you will also have to pull that data from the db to use it in your xls file.



using hhamash's method will require signifcant coding, though.  so, it all depends on how much functionality you are looking for from your form results.


nprignano
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

hhammashCommented:
Hi,

Form results can be sent to excel
http://support.microsoft.com/?kbid=308692

0
nprignanoTechnical ArchitectCommented:
I stand corrected.


its good to see you back here.  i was beginning to think i was the only FP expert contributing on regular basis (besides corey of course).


nprignano
0
hhammashCommented:
Thank you nprignano,

I am glad to be back,  I can see the amount of work you and Corey have been doing. The past few months were very difficult.


Thank you
0
nprignanoTechnical ArchitectCommented:
no objection.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.