> I tried this in the VALIDATION calculation section but got nothing but errors.
Not into the validation option, but into the auto-enter option for the field City2:
Proper ( City2 )
I can't use Auto-Enter for City2 because it is set to: City2=City1 .
In the event that the user types over City2, I want to be able to put into proper format
and would like to modify my 'specific', script that references City2 to be more 'general' and to be useable by other fields as well.
(I know I can just duplicate the script designating a different field but it seems, intuitively that I should be able to pass a parameter specifying the field name and then have Proper(field) act on the passed (field) parameter.
I hope I am being clear. Thanks for reading.
I don't mean to act like a stalker, but you posted this query before, and (purely in the spirit of trying to be helpful), I have re-tested my original response and it still works for me to do what you asked:
Enter into the *auto-enter* tab, as Daniele says, the following:
This works for me:
CityC= "" ; CityV ;
Proper (CityC )
I have tried this again, and it works for me that:
- if someone types in a City1 it automatically inserts it in City2
- if they overtype a different City2 it will accept that, and also replace it with proper case.
- in fact it can be extended so that it someone enters City1 wrongly it will convert it to proper case as well:
NameSecond = "" ; Proper (NameFirst) ;
Proper (NameSecond )
Thanks for the reply. You are right, I misunderstood and was working the problem from the perspective of Validation instead of Auto-Enter.
I see your solution's logic and appreciate your contribution.
BTW, in my 'journey' to more FM understanding I went down the rocky road of writing my first custom application and linked it to a script trigger. It worked and I learned a lot. But, I like your 'simpler' and equally effective solution more.:smileyvery-happy:
Pleased to have helped.