If "x" then "c"

[Leather Knight]

I have 2 databases linked together, one is a calendar, the other a contact manager. I want to have a field called "Reminder_c" show the data in field "Title" located in the calendar, but only when the current date is equal to the date set on the calendar for "Title". So when it is Feb 28th 2008, if there is an appointment in the calendar for that date, it will show up in the field "Reminder_c". Any advice?

[Lee Smith]

Feb 28th 2008, if there is an appointment in the calendar for that date, it will show up in the field "Reminder_c". Any advice?

A calendar, what calendar are you working with?

Lee

[Leather Knight]

I am using SeedCode's Calendar.

[Lee Smith]

If this is the Free calendar, and I'm betting that it is, you probably will not be able to interact with it. This quote is in their information.

How Do I Export Appointments to iCal?

The iCal export in SeedCodeCalendar is only available in the Pro Calendars, unfortunately not in this free version. The same applies to your ability to ”subscribe” to SeedCodeCalendar from iCal, which is similarly available only in the enhanced versions.

A full calendar solution, that would allow you do to this, will cost you money. Having made a few, they are not simple, and require a good deal of time. Cheaper to purchase one of the commercial products for about $100 than to devote the time you will need.

Do a search at Search FileMaker and you will get lots of leads.

HTH

Lee

[Fitch]

I don't see what iCal has to do with the original question.

The basic calc you'd need Kevin would be something like this:

Case( Get( CurrentDate ) = appointment date; Title )

[Leather Knight]

Thanks Fitch, yes, this is exactly what I am looking for. I knew it was something simple. I use the free version, and then I modified it alot, a whole lot, to do what I needed. Since I am making the app to be customized, I just needed a starting point and that is why I didn't spend $300.00 for something I was gonna butcher anyway. But this is what I needed...

Again Thanks Fitch.

[Lee Smith]

he wants to interact with the calendar, iCal was an example.

Before giving a Calculation, which was what I was going to do originally, I decided to get the more information about how the flag was suppose to work.

The calculation is double entry, and I was aiming to make a single entry.

Lee

Edited February 23, 2008 by Guest

[John Sindelar]

Hi Kevin,

Sorry I go to this a bit late but Tom's calc is right on. I might add that if you want this to match the date you're looking at in the calendar regardless of what day it actually is, use you could use CalFilterDateGlob instead of Get ( CurrentDate ).

And we built the free version for exactly what you're using it for: it's for folks to tear apart and make into what they need.

Enjoy it!

[Leather Knight]

Hi John,

Actually I am using this free version to learn how I can meld it into my app, then I want to buy the full dev version for all the neat fetures you have implemented. I am just finetuning some of these skills. The calendar facinates me especially since I haven't a clue on how to make one..lol.. But ok I will try that for showing the appointment date as due. I will let you know if it works.

[Leather Knight]

I tried this and it isn't working...

Case

(Get ( CurrentDate ) = Appointments::ApptDate ; Appointments::ApptTitle ; "No Appointments" )

-------------------------------

I also tried:

Case

(Calendar::CalFilterDateGlob = Appointments::ApptDate ; Appointments::ApptTitle ; "No Appointments" )

with references from the calendar module to the main menu module having the current date and CalFilterDateGlob being equal. Still nothing. Not sure where I am going wrong...

[Lee Smith]

Hi John,

I'm glad to see you joined in on this thread. There is nothing better than to have the questions answered by the author of product.

Lee

[John Sindelar]

Hi Kevin. Sorry for the delay: just got back from a short vacation. The calc mentioned above would be defined from the perspective of the appointment. If you want something from the perspective of the day (are there any appointments today) you'd use the related appointment field like this (define this from the context of CalendarDaily):

If ( not isempty ( CalDailyAppointments::ApptTitle ) ; "No Appointments" ; CalDailyAppointments::ApptTitle )

If that doesn't help, tell us a little bit more about the context from which you're trying to display this (i.e. where does it go?)

[Leather Knight]

Thanks john,

I tried that, but all it shows all appointments for all days.

I have the calendar and a main menu db. They are related by the current date. I want a field to show if there is an appointment in this field on the Main Menu db from the calendar. If the current date is "X" and there is an appointment in the calendar for this same date, then in the field it will show the text from the apptitle field. If there is no appointment, then the field says "No Appointment".

[John Sindelar]

Ah. Sounds like you already have an unstored calc in your Main Menu Db that returns the current date. If so, relate this to the Appointments table in the calendar where your field equals ApptDateStart_k. Then you can do something like:

If ( not isempty ( YourRelationshipToAppiointments::ApptTitle ) ; "No Appointments" ; YourRelationshipToAppiointments::ApptTitle )

Edited March 6, 2008 by Guest

[comment]

Ahem... the "not" seems misplaced.

[John Sindelar]

Indeed.

[Leather Knight]

ApptDateStart_k is not present in any of the tables.

[John Sindelar]

Hi Kevin, I'm not sure which version of our calendar you're using, but there is a start date in the appointments table: that is the field you'll want to use in your relationship.

[Leather Knight]

The fields I find in the Appointments are:

_c_CommonOne

ApptDate

ApptDesc

ApptReminder (the one I am using for Appointment Reminder)

ApptID_kprime

ApptTimeEnd

ApptTimeStart

ApptTitle

CurrentDate (I made)

z_ApptDateWeekOfYearCalc

zz.BlackMagic.cr

But unless I am missing something, I do not see a "Start Date" field. I am using version 1.4 of your free one.

[Leather Knight]

I got it! I made 2 relationships in the main menu relating to the calendar. One was current date in Menu to "=" calendar field "CalFilterDateGlob", then the other to go from Appointments to calendar "CalFilterDateGlob = ApptDate" and the reminder field was from the Appointments relation.

And boom, it works flawlessly. Now on to try to make it show up and stay on the menu for the day prior to the appt date and the date of the appt...

Thanks John...