Jump to content

User alerts upon opening the database


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

Recommended Posts

I do hope that I have I am posting this question in the correct folder...

One function of my company's database is to keep track of the proposals requested of us. Each proposal has a due date. My goal is to run a script when the database opens that alerts the appropriate personnel to an impending deadline.

Each record in the proposals table has a corresponding "due date" and "lead analyst" (i.e.the person writing the given proposal). Is it possible to write a script that searches all of the proposals for ones due within, let's say, three days, and then alert the corresponding lead analyst? We don't want to miss deadlines after all...

Thanks for any help you can provide.

Link to comment
Share on other sites

Are you having a problem with the scripting part ?

Just freeze the screen and check the date field by

( if Get(currentdate) - 3 > the_Specifice deadlinefield_value) and take the users to a layout to show the found set if the count is > 0.

The script should be a "start up" script, set at the File Option in FM 8.5.

I hope this make sense to you.

Xoomaster

Link to comment
Share on other sites

This topic is 6328 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.