pbrad For consistency of input, I would like to either force users to work only with Caps Lock on or convert all input into upper case. Is there a universal way to do this?
aware_support2 You can convert user input into upper case by adding a rule for each attribute where this should be enforced, for example: Job.Description = TO_UPPER_CASE(Job.Description)
pbrad So eighteen years later and a few lessons under my belt, I would tend to use a stored procedure for this situation in order to avoid the overhead of excessive rules.
numberz Forgive me but, how? I tried to just enter the same info that I had in a Rule, as a process, but nothing happened. Is there more to this?
pbrad It would work in an object or process rule. If you would like to provide more details, I can be of more help. Pete
BLOMASKY You would still need a rule to trigger the process. i.e. IF BO WAS CHANGED OR BO IS NEW THEN CallProcessToUpperCase If you are comfortable writing a SQL Trigger, then that can be run on your server after records are changed (or inserted) Bruce
