From Web Form to FileMaker Database: Odd Characters, Bounce Backs
I hope you can help us with this, as it's causing a lot of problems!
We have a webform that sends information to our database. But we often get bounce-backs (rejected by FileMaker). These bounce backs are often a result of odd characters (e.g., " There is however no ‘correct’ means by which a theory or research should be applied - these are all left up to the student making the interpretation and analysis").
We had guessed that these were most likely the result of people pasting from Word (or some other text editor). Thus, we created editing buttoms above each field. This, however, caused an additional problem. With those, our FileMaker database was showing html coding (or something similar (e.g., "There is however no ‘correct’ means by which a </em>theory <em> or research should be applied - these are all left up to the student making the interpretation and analysis.</p>"
What can we possibly do to fix this issue? Can FileMaker 11's database read HTML (i.e., can we change a setting?).
Here's hoping someone out there can help us out!
All the best,
Our webform without the editing buttons and a shot of our database itself (note the html):