Jump to content

Class Schedule Conflict Detector


This topic is 2741 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

 

Layout1.png

layout2.png

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2741 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.