use a scriptTrigger to get fired when leave the field.
Script to be triggered should be:
- InsertCalculatedResult [TextFontRemove(TheField) ]
I see no other way yet but have 1 Script for every field.
Get familiar with other Text##Remove - Functions for Size and Color
Yes, thanks, I know how script this - but I had hoped that this could be
achieved somehow via the field settings...
Am 01.02.15 um 12:50 schrieb efficientbizz:
How to delete text formating in a field with a reference if
"typing" in manually?
Antwort von efficientbizz
in /Discussions/ - Komplette Diskussion anzeigen
Use the TextFormatRemove ( ) function, as pointed out by efficientbizz:
and instead of trying to use a script trigger, couple it with an auto-enter calculation in the field definition. It can be as simple as TextFormatRemove ( Self ).
Am 01.02.15 um 13:39 schrieb Mike_Mitchell:
and instead of trying to use a script trigger, couple it with an
auto-enter calculation in the field definition. It can be as simple as
TextFormatRemove ( Self ).
Well, exactly that did I want to do but does NOT work. If I add the
auto-enter caluclation and then want to define the reference the first
What do you mean, the "reference"?
Do you mean you're using a lookup?
If to do this via a script, are there ways to fire the script from different fields (trigger "on validation") without a parameter but the script recognizes which field did fire it? In order to use this information to automatically write the sanitized value back in to the right field.. Just in order to apply the script as easy as possible to other fields (or while copying a field and resetting its field value not to also have to think of stting the field also in a parameter or so)...
The checkboxes for auto-enter and lookup should actually be radio buttons, since these options are mutually exclusive.
Auto-enter also performs a lookup, but is much more flexible, because you can process the looked-up value within a longer calculation, e.g.:
this = Case ( not IsEmpty ( ZIPs::city ) ; ZIPs::city ; Self ) ;
// wont allow entering the city manually as long as the foreign key “zip” holds an existing primary key from Zips tables
TextFormatRemove ( this )
Yeah ... this.
Essentially, you use the auto-enter calculation to duplicate the functionality of the lookup.