Character Count

[LXR]

I am looking for a way to create a field ( that displays the Character Count of another field (A). I want B to display the character count of A as you type in A.

Any ideas?

[jamesducker]

To get field B to update totally on-the-fly, without the user committing the record (i.e. clicking out of field A), you'd be looking at a script trigger, attached to field A and called whenever there's a keystroke.

The script would simply be:

set field [field B] = length(field A)

where fields A and B are both ordinary text fields.

Using a script trigger on keystrokes is quite resource-hungry though and I would recommend you steer clear of the whole idea unless you absolutely have to use it.

If you don't mind waiting for the user to commit the record then just define field B as a calculation field = length(field A). This approach is much kinder to the user's machine and will give better performance although obviously not the totally dynamic response that you may want.

Hope that helps.

James

[LXR]

Thank you very much for your help!

One more question -

How do you attach a script trigger to field A, called whenever there's a keystroke?