Jump to content

Creating an appointment tickler


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

Recommended Posts

I wan to create a basic appointment tickler that will pop up when a medical database is first started up.

I would like a layout to pop up that lists the appointments from the current date out to 7 days from the current date. I was told I might be able to do it using something along Get (CurrentDate)...Get(CurrentDate)+7.

Is this done with a startup script or with thhe defining of the fields in the layout? Can anyone show me how I would write a startup script that would make this happen?

The table with the medical appointment data is called MedAppoint. The fields I want to show are MedAppName (name of person the appointment is for), MedAppDate (date of the appointment)& MedAppType (type of appointment). I have a layout I created for this called MedAppTick (the tickler layout).

Thanks!

Link to comment
Share on other sites

You would do it with a startup script that you set in the file options. The script would look something like:

Enter Find Mode // make sure pause and specify are unchecked

Go to layout (MedAppTick)

Set Field (MedAppDate ; Get(CurrentDate) & "..." & Get(CurrentDate) + 7 )

Perform Find // make sure pause and specify are unchecked

Link to comment
Share on other sites

This topic is 5696 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
 Share

×
×
  • Create New...

Important Information

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