Hi

I am running a small travel agency business in my home-office.
Using FileMakerPro as a reservation system and just purchased your SeedCodeCalendarPro to add calendar future to my reservation system.

I have already made a relationship between,
"Tour name" in my reservation system and "title" in Edit Appointment on CalendarPro.

Cool thing is that when I type some "Tour name" into title field in Edit Appointment, CalendarPro bring "check-in date" from reservation system to "date" in Edit Appointment.
Likewise, "end date" will be sync with "check-out date" in reservation system automatically. That's great.

I have also customized Edit Appointment mini window adding "DueDepositDate" and successfully bring the due date from reservation system to Edit Appointment mini window.
(please see an attached screen-shot)

But that "DueDepositDate" does not show on the Month view.

Can you please tell me how I can modified CalendarPro to show "DueDepositDate" in Month view?



Thank you for your support.[/img]

Congrats on your mods!

So when you added that field to the detail view you used a relationship from your table to CalDailyAppointments.

To do this on the monthview you'd need 7 relationships to 7 instances of your table (one each to the TOs we use for the month view: CalMonthAppointments1, CalMonthAppointments2, etc.

OR, just create a calc in Appointments that pulls the DueDepositDate into Appointments and show that calc field in the month view.



Much simpler. Remember each of the 7 portals needs the DueDepositDate calc from the correct table occurrence, I'd copy and paste the Title field already there for each column and then switch the newly pasted field to your DueDepositDate calc.

Hope that helps.

Thanks for a quick reply.
Let me see how much I can do that...

John

I have made some changes and now I see the "DepositDueDate" on Month view.
Please take a look it at this picture.


You see "2010/01/13" in Month view (yes!!) , but I would like to make "2010/01/13" appear to Jan 13th column.

Would it be possible?
Or it would be better to hire you ??

Please advice..

Jimi O

So you'd like the appointment to show up on the DepositDueDate AND the regular start date? Or just on the DepositDueDate?

Just on the DepositDueDate.

Well, then you want to use the DepositDueDate as the relationship match in then calendar's month relationships instead of ApptDateStart etc. Unfortunately, it sounds like this field is in another table, so you have a couple options.

1. Figure out a way to make an indexed (stored) calc of DepositDueDate in the appointments table, probably by setting that value with a script or auto-enter calc. Then make ApptDateStart_k and ApptDateEndCalc_k into calcs referencing DepositDueDate, or

2. Script a regular import from the table containing DepositDueDate into the calendar's appointments table, bringing that date into AppptDateStart_k, or

3. Point the calendar at the table in which DepositDueDate naturally lives. This can be a *lot* of work, so I'd try no. 1 or 2 instead. (No2 gives you the most flexibility in my opinion)

Let me know what you think.

Woo,,
It is not easy for me to understand the things you have told me...
See how much I can do,,

Thanks anyway!