Hi,I have a database with a form that is basically a canned email (a user selects from a series of choices that then prefills the body appropriately). We also have a freeform text section where the user can input additional information. This form has a SendTo field and there is then code to do a @Mailsend with the preselected message and the freeform text to the email addresses in the To and CC fields.
I’ve noticed many users making spelling errors in the free form text area so I’ve added a button to run the notes spell checker. The problem is, users don’t seem to be using it. I had previously tried to have the Spellchecked run automatically when they clicked the Send button but found that while the spelling errors were corrected on the form, the email that was sent still had the original incorrect spellings.
Can anyone offer any advice on how I can make this work? The code to my Send button is below. If there’s a better way to do it rather than in the send button(Querysend perhaps?) please let me know.
@If(LetterBody= “”; @Return(@Prompt([Ok]; “Reminder”; “Select a message type from the action button.”)); @Success);
@If(SendTo= “”; @Return(@Prompt([Ok]; “Reminder”; “Please enter an email address in the To: field”)); @Success);
@Command([ToolsSpellCheck]);
@PostedCommand([FileSave]);
@MailSend(SendTo;CC;“”;Subject;CannedText+@NewLine+@NewLine+Freeformtext;[PriorityHigh]);
@PostedCommand([FileCloseWindow])
Subject: RE: Spell Check & @MailSend
I’m not sure if this was available in 6.5 or not, but at least in later versions you could specify that a field should show spelling errors dynamically by selected Enable instant spell check.
Subject: RE: Spell Check & @MailSend
Thanks for the suggestion Graham, unfortunately doesn’t look like that property is available in 6.5.6
I was thinking perhaps if I can’t figure out how to have it properly do the spell check/send together automatically, perhaps I can force an edit on my Send button to require the spell check be executed first via the seperate button (have the spell check button also set a hidden field value and have the send button look for that field value otherwise it halts).
Edit-Hmm I tried doing an edit and it appeared to work however it seemed that the free form field would revert to the old spelling often times before I clicked the Send button. This leads me to believe it’s something with the way I have that particular field setup and not a problem with the Code in my Send Button.
Subject: RE: Spell Check & @MailSend
I’m seeing the same thing. I put the spell check into the save button on the form so the basic format is@Command([ToolsSpellCheck]);
@Command([FileSave]);
@Command([CloseWindow]);
You can see spelling errors correct on the form, then revert to the original back-end value at the save.
If you manually run spell check, then do the save, the data remains ‘corrected’.
There is nothing on the form that would remember the origingal values of the fields and revert them at the save.
I’ve tried @PostedCommand([FileSave])/CloseWindow, no effect. I suspect that it’s some weird order of execution that’s causing the problem.