You can use this code as the field's custom Format script:
if (event.value.toUpperCase()=="Y") event.value = "Yes";
else if (event.value.toUpperCase()=="N") event.value = "No";
else event.value = "";
Works perfectly, exactly what I was looking for, thanks again Gilad.
You're welcome. Just keep in mind this code doesn't change the actual value of the field, only the display value.
If you want to change the actual value use it as a Calculation script.
ok. I'll try it both ways to fully understand what this means. Thanks.
Hi Gilad, just another quick question regarding this script. I have at least a dozen different sizes like 1 5/8", 2 3/8", 2 78", 4", etc. How can I apply this bit of code to do the same this as with the yes/no. Is is possible to use an alphabet code like - type into the text field (a) for 1 5/8", (b) for 2 3/8", (c) for 2 7/8" and so on and the last option would be other?
Sure. There doesn't have to be any relation between the entered value and the new one.
if (event.value.toUpperCase()=="A") event.value = "1 5/8\"";
Yeah, I got it. This is a very cool feature. My job just got easier. Thanks, bro.