Formatting Text/email address

[Steve Railsback]

I'm looking for a way to format text when moving to the next field. I've looked at Typeahead and Clairvoyant. But these appear to apply when lists are needed. I'm looking for something that will add additional text to the entered data. I have emails that all have the same server information. I would like to just type the user name and have FM add the "@yaddayadda.com". I cannot set the field to have a default "@yaddayadda.com" because the db is used for an online directory that displays email. Email information will appear online when there is data in the field.

Thanks all!!

-steve

[-Queue-]

Attached is one method using a modification time field. Because modification time doesn't update until after a record is first committed and then modified again, record creation should be scripted and include an Exit Record/Request step.

FormatEmail.zip

[Steve Railsback]

Nice little trick. Not exactly what I'm looking for but it does give me some ideas. Trying to avoid adding new fields (this DB is cluttered enough). I "love" fixing other other's DB's! Thanks for the help!

[-Queue-]

Well, you could do away with the modification time field and use Left( GetField("Email"), 0 ) & serial as the trigger calc. But FM 6 has no way to accomplish this without using at least a trigger field and a calculation field, unless of course you want to script the process. FM 7 has a nice auto-enter functionality that makes this technique obsolete. But for previous versions, it's the only way.