Requesting Chanuka Gift (can someone write this script)?

[barry685]

Appointment_range.png

Im trying to create a calendar and I need a script to populate a table with appointment records, based on presenting the user with the above dialog. The table is Appointments and 3 fields need to be assigned values.

Appt_ID is an auto increment field (Numerical)
Appt_Date
Appt_Time (shorttime)

At the end of the script the user should know it has been completed. Also the user must be prevented from adding appointment records to a day that has existing appointment records.

example of some filled records would be:

1 12/01/2012 9:00 am
2 12/01/2012 9:15 am
3 12/01/2012 9:30 am

Im trying to learn xbasic but I know at this point Im not capable of doing this.

Thanks
Barry

[Ray in Capetown]

Re: Requesting Chanuka Gift (can someone write this script)?

Barry
Your explanation is very scant. Is there anything the calendar must go on to do, and how should it look.
Also - "the user must be prevented from booking another appointment on the same day", you give examples of three appointments on the same day.
What you seem to want is probably not difficult but unless something different is required cant you just use a freeware calendar? If you explain more it would help.

[barry685]

Re: Requesting Chanuka Gift (can someone write this script)?

Hi Ray,
Im not concerned yet with the look of the calendar, but all I really need is a day view. I will create an embedded browse and limit the records to only one day. What I mean by not allowing the user to create existing appointment records is this. If I have previously used this dialog and created the the records for the month of March 2012 I don't want the user to be able to do it again. The appointment table will of course contain other fields, but that has nothing to do with this script.

[Stan Mathews]

Re: Requesting Chanuka Gift (can someone write this script)?

The only way I can think of to do what you suggest is to add a logical field to the table. When the user is through entering records for a particular day, an update operation/script is run that sets the logical field for all records for that day to true (false is the default - no value set).

You would have a short script for the table's cansaverecord event in the field rules. The script would check if there were records for the current day with the logical field set to true and if found the cansaverecord event would be cancelled.

[barry685]

Re: Requesting Chanuka Gift (can someone write this script)?

Hi,
I have a feeling that I'm still not making this clear enough. The purpose of the above dialog is to pre populate a series of days (more likely a complete year) with empty appointment records (other than the ID, Date, and Time fields).

For instance If I specify a date range of 1 week with a start time of 9AM, and an end time of 5PM, with 30 min intervals. The script should create 7 days of records with 16 records per day.

Now lets say I have run the script and created all the appointment records for the year 2012. I want to make sure that I cant run the script again and create the same records again for the year 2012 . In other words If a day of appointments has already been created the script should end with an error message letting me know that appointment records already exist for that date range.

Once the records have been created and Im actually using the calendar, the calendar form that I will design will only allow for the modification of the existing records, and will restrict both creation and deletion of records.

Thanks

[Peter.Greulich]

Re: Requesting Chanuka Gift (can someone write this script)?

I have done something like this. I'm trying to remember the methodology that I used. I don't think I literally compared for the existence of records but rather had a second table w. a start and end date in each record that was used to seed the first table as you want to do. If a new date fell within the range of a previous record, the operation didn't proceed. If I can remember where I did this, I'll report back. But I think it was something like this:


"Seed" table:

1. 1/1/11 - 12/31/11
2. 1/1/12 - 2/28/12
etc

"Calendar" table:
1/2/11
1/2/11
1/3/11
...
12/31/11
1/1/12
...
2/28/12

So if the user created a new date range in the "seed" table and one or more of the dates was in the previous date range records, the script wouldn't create the duplicate calendar records. I think that's what I did. Just don't remember exactly.

[Peter.Greulich]

Re: Requesting Chanuka Gift (can someone write this script)?

It was even simpler that that. There was nothing to prevent the user from entering a duplicate date range. Common sense dictated that they wouldn't. But once the script ran for a given date range a logical field was set to .T. so that the user couldn't run that same range again. In your case you could make it simpler and bullet proof it by just using a year field and set the field rule to "unique". Then they couldn't dupe the same year. Use the logical the same way i did so they don't run the script for a given year twice. If I find what I did I'll post the code for you. It was quite simple, nothing elaborate. Yours may be slightly more complex where you want time periods for each day.

[barry685]

Re: Requesting Chanuka Gift (can someone write this script)?

Hi Peter,
If a Time field was added to the table (that stored date and time) and that was set to unique only in the field rules. Would that prevent the script from creating duplicate records?

[Peter.Greulich]

Re: Requesting Chanuka Gift (can someone write this script)?

Hi Peter,
If a Time field was added to the table (that stored date and time) and that was set to unique only in the field rules. Would that prevent the script from creating duplicate records?

If you made an expression in your field rule validations, so "Uniqueness test" = "validation of expression must be unique" and the set the "unique expression" to something like cdate(date)+time() where date & time are the name of your fields.

[MoGrace]

Re: Requesting Chanuka Gift (can someone write this script)?

I think I misunderstood. Wouldn't a query on the table be sufficient to test if records for the date range exist? If they don't proceed, if they do pop up a warning box and end the script.

[Ray in Capetown]

Re: Requesting Chanuka Gift (can someone write this script)?

happy chanuka Barry, I await my chanuka gift
Attached, a working calendar as per your specs;- the settings and button to populate slots for the coming day/s appears only when viewing a blank day
This should be sufficient to prevent duplication unless you really try.

Just open the form "DayView" - well its actually the only form, look at the top of the list. You must widen the form - I didnt save resize after the last changes

Maybe someone can help - a small detail that I can't resolve,'=|

when you type in a date it accepts but selecting off the pop up calendar the date variable doesn't change.

[barry685]

Re: Requesting Chanuka Gift (can someone write this script)?

Hi Ray,
Thanks alot Its almost good
There seems to be a bug that regardless of what parameters I type in and I am entering 2 slots and 1 day, It keeps on creating records based on your defaults of 4 slots and 5 days.

[barry685]

Re: Requesting Chanuka Gift (can someone write this script)?

Ray,
If you want the form to stay open to the size you specify. Go into Form properties, Window Tab, and set the Size Width and Height to "Use form width" in the drop down.
Barry

[barry685]

Re: Requesting Chanuka Gift (can someone write this script)?

Hi Ray,
Found another problem After days are created when I change the starting date to another date to create new records I get the following error message;error_calendar.png

However after the error message it still creates the days.

[Ray in Capetown]

Re: Requesting Chanuka Gift (can someone write this script)?

Here is a readied and tested version