custom function with generic field parameter ?
I have a SINGLE TABLE with two fields:
City1: Is a lookup that returns the value of the City in a related table. It works.
City2: Has an auto-enter value of : City2=City1 It works
However, if the user changes City2 and does not capitalize the entry properly I want to return City2=proper(city2). I tried this in the VALIDATION calculation section but got nothing but errors.
So, I wrote a script that was called from the City2 field scriptTrigger. It works.
That script is: INSERT CACULATED RESULT [SELECT; PROPER(VISITORS::CITY2)]
THIS SCRIPT DOES THE JOB. However....
I would like to generalize the script so that it can receive the name of the field as a parameter. (This would avoid having to duplicate this cript for each field ugh...)
I can setup the parameter but can't figure out how to refer generically to a field.
All help is appreciated.
Thanks fo reading