Class Schedule Conflict Detector

[PELE]

Good Day

Greetings from the Philippines

Im working on a subject loading system for a community school, As illustrated below, I have two layouts the first one is the layout for data input interface. The second one, is the layout where the operator can choose a class schedule and insert into the first layout. My problem is how to implement a schedule conflict detector in case there is one and prompt the user of the conflicts. Can you show me how to implement
 either in scripting or calculation method.

Appreciate the help thanks in advance.

Best regards,

Pele

 

[Wim Decorte]

You definitely do not want to use a calculated field for this.  Roll it into the scripted workflow that creates a class schedule entry.

The easiest way to do this is to do a find in the existing schedule and warn the user but then you have to handle the UI nicely so that the user does not see the find happening.  Using an ExecuteSQL() call in your script is going to be more elegant that way.