We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

FP Form Results

Medium Priority
328 Views
Last Modified: 2013-12-24
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
Comment
Watch Question

Technical Architect
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Commented:
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
nprignanoTechnical Architect

Commented:
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

Commented:
Hi,

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

nprignanoTechnical Architect

Commented:
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

Commented:
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
nprignanoTechnical Architect

Commented:
no objection.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.