Adding Fields

To add a field to the day or gantt view, create a relationship from CalendarRows to SampleEvents like this:

CalendarEventUIDCalc_FirstValue = _id

Where  _id is the primary key (the unique ID) in your events table. All this relationship is for is to allow you to add fields right from your events table to the daily view.

Next go to the Day or Gantt Tab of the calendar in layout mode (see [[Calendar Tabs | Editing the Calendar Layouts]] if you don't know how to get to the day tab in layout mode). Then simply add fields from your event table-- that would be a field from Sample Events in the original calendar file.

    Get ( LayoutTableName ) = "SampleEvents" ; // the table occurrence for Source No 1
        Case (
          $$sc_Mode = "Month" ;  SampleEvents::MYField ;
          $$sc_Mode = "Week Sched" ; GetField ( $$sc_FieldForSummary ) ;
          GetField ( $$sc_FieldForSummary ) // Default for other modes
        )
    ; GetField ( $$sc_FieldForSummary ) // Default for other sources/tables
  )

  Case (

'''Day View'''

You can place any fields from your events table right on then Day view of the calendar, and you can even make these fields enterable if you'd like, but there are a few caveats about that below.

To add a field to the day view, create a relationship from CalendarRows to SampleEvents like this:

Next go to the Day Tab of the calendar in layout mode (see [[Calendar Tabs | Editing the Calendar Layouts]] if you don't know how to get to the day tab in layout mode). Then simply add fields from your event table-- that would be a field from Sample Events in the original calendar file.

Next, change the Refresh Window step at the end of the "Refresh Calendar..." script to use the Fluch Cached Join Results option. If you're on a Mac you can leave it like this but if you're on windows or want the best possible performance you can wrap it in an If statement so it uses the Flush option only when $$sc_Mode = "Day Sched" and uses a regular refresh elsewhere.

! Changing the fields that display per tab

'''Overview.''' Yes. The section above describes how you can add your own fields to the Day view, but you can also change what shows up on other views. In this example we'll describe how to set the Month view to show just a field in your events table called "My Field", leaving the other views to show the field(s) you've mapped to the calendar's Summary.

'''The Modification.''' Begin by backing up a copy of your file. ;-)

to the code below where "SampleEvents" is the name of the table occurrence for Source No 1 in your file, and "SampleEvents::MYField" is the name of the field you wish to show on the month view. Note that the case statement here lets you specify different settings for other views as well, and leaves the mapped field, represented by GetField ( $$sc_FieldForSummary ) as the default for other views and other sources.

! Can I show different fields on some views of the calendar?

!! Can I show different fields on some views of the calendar?

1. Edit the script "Write One FileMaker Event in iCal Format" and find the line where we're setting the variable $scical_Summary.

2. Change that calc from this...

to this...

Case (

           $$sc_Mode = "Month" ;  SampleEvents::Status ;

)

To add a field to the day view, first go to the Day Tab of the calendar in layout mode (see [[Calendar Tabs | Editing the Calendar Layouts]] if you don't know how to get to the day tab in layout mode). Then simply add fields from your event table-- that would be a field from Sample Events in the original calendar file.

Note that we have a relationship from Calendar Rows to Sample Events: all this relationship is for is to allow you to add fields right from your events table to the daily view. This relationship is true only if there are no are overlapping events: if there are, we don't show any individual fields.

Note that if you allow entry to fields in your events table you may edit information that should cause an event to move or change color. Yet FileMaker won't know to do this just because you edit the field. In such cases you'll need a script trigger on your field (we recommend the OnObjectSave trigger) that will call the script "Refresh Calendar { UseExistingData ; DontRefresh }". Don't send any parameters to the script.

You'll see that the status field in our calendar example is set up this way.

Note that if you allow entry to fields in your events table you may edit information that should cause an event to move or change color. Yet FileMaker won't know to do this just because you edit the field. In such cases you'll need a script trigger on your field (we recommend OnObjectSave) that will call the script "Refresh Calendar { UseExistingData ; DontRefresh }". Don't send any parameters to the script.

Most of the formatting of how things look in the calendar is done on the Source No X layout(s) where you specify which field (perhaps a calc) is used for the Summary-- that is the event attribute we show on all the calendar screens. Using a calc for your Summary field lets you show  whatever you like on the calendar (perhaps a user's initials and then the event description, for example).

But on the Daily View you have a bit more room and may want to show something besides just the Summary.

Note that we have a relationship from Calendar Rows to Sample Events: all this relationship is for is to allow you to add fields right from your events table to the daily view. This relationship is true for the first event (if there are are overlapping events) and for the first row of the event's time (if the event spans multiple rows). 

Note that if you allow entry to fields in your events table you may edit information that should cause an event to move or change color. Yet FileMaker won't know to do this just because you edit the field. In such cases you'll need a script trigger on your field (we recommend OnObjectSave) that will call the script "Refresh Calendar { UseExistingData ; DontRefresh }". Don't send any parameters to the script.

To add a field to the day view, first go to the Day Tab of the calendar in layout mode (see [[EditLayouts | Editing the Calendar Layouts]] if you don't know how to get to the day tab in layout mode). Then simply add fields from your event table-- that would be a field from Sample Events in the original calendar file.