Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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
0
BeccaJReynolds
Asked:
BeccaJReynolds
  • 4
  • 3
2 Solutions
 
nprignanoCommented:
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
 
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
 
nprignanoCommented:
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
hhammashCommented:
Hi,

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

0
 
nprignanoCommented:
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
 
nprignanoCommented:
no objection.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now