Jul 8th, 2011, 3:44 PM
Hi Paul,
Regarding problem #1, remarkably, this is a bug that somehow got missed for all this time. I've listed a fix here: http://forums.formtools.org/showthread.p...22#pid5322
It's fixed in 2.1.0 which will shortly become the standard build.
Yeah... this is Excel being "helpful". It's an unbelievable pain.
One solution is to spend time messing around with Excel to prevent it from auto-converting the content, but honestly, I've never had much luck persuading it not to. Another option would be to change the values actually being saved to something that won't confuse Excel. "1 to 3" perhaps....?
Is your form an API or POST form?
- Ben
Regarding problem #1, remarkably, this is a bug that somehow got missed for all this time. I've listed a fix here: http://forums.formtools.org/showthread.p...22#pid5322
It's fixed in 2.1.0 which will shortly become the standard build.
Quote:However, "1-3" is showing on my results (in Excel view) as "01-Mar-11" ie 1-3 is showign as 1st March. The same applies to 3-5 (03-May-11).
Yeah... this is Excel being "helpful". It's an unbelievable pain.
One solution is to spend time messing around with Excel to prevent it from auto-converting the content, but honestly, I've never had much luck persuading it not to. Another option would be to change the values actually being saved to something that won't confuse Excel. "1 to 3" perhaps....?
Quote:Also, is there a way to stop people submitting the same form multiple times? (other than re-captcha)
Is your form an API or POST form?
- Ben