Event Script and calculated value

[mr_vodka]

Here is one for those that have used the EventScript Plugin (Gaston Forgues: softs4humans.com).

Have you ever encountered an instance where Field B needs to be a calculated value for lets say something like Field B = Left (Field A; 2). This needs to be with the option of, 'Do not replace' checked.

However, then the user needs to change Field B because he does not want the default value set. So they change it via a pull down menu. Now here is the issue...

Once a value is selected via the pulldown menu, it needs to use the EventScript plugin to trigger a certain script. However, since there is already a calculated value there of the previous Left function, how can I now envoke the Event Script???

Has anyone ever encountered this issue?

I have put together a very raw mock file to demonstrate what the issue is.

Event_Problem.zip

[mdpres]

mr_vodka

I have several fields setup like you are describing. The way I make them work, is global storage. I changed your Contact field to global and it works fine, but I dont know if that would work for your situation.

Best of luck,

Dean

[mr_vodka]

Unfortunately, I can not use a global field. I have inherited this mess of a database and I can not change anything major to it else break it. My boss does not want me to redo it because that would take too much time.