AnsweredAssumed Answered

custom function with generic field parameter ?

Question asked by synergy46 on Feb 21, 2009
Latest reply on Feb 22, 2009 by Sorbsbuster

Title

custom function with generic field parameter ?

Post

:smileysurprised:

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

 

 

Outcomes