RepCalendar ( SelectedMonth ; SelectedYear )

CF to display calendar numbers in repeating fields.

Average rating: 4.2 (31 votes) Log in to vote

Don Wieland - Show more from this author
DW Data Concepts
http://www.dwdataconcepts.com

Sample input:

Calendar ( "September" , "2005" )

Sample output:

Rep 1 = ""
Rep 2 = ""
etc...
Rep 5 = 1
Rep 6 = 2
Rep 7 = 3
etc..
Rep 34 = 30
Rep 35 = ""
Rep 36 = ""
Rep 37 = ""

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let(
[

sMo = Extend(SelectedMonth);
sYear = Extend(SelectedYear);
sMonthNumber = Int ( Position("---JanFebMarAprMayJunJulAugSepOctNovDec"; Left( sMo; 3 ); 1; 1) / 3 );
sFirstDay = DayOfWeek(Date(sMonthNumber;1;sYear));
sLastDay = Date( sMonthNumber + 1; 1; sYear ) - Date( sMonthNumber; 1; sYear );
today = Get ( CurrentDate );
myrep = Get ( CalculationRepetitionNumber );
FirstDay = sFirstDay;
LastDay = sLastDay;
theday = Case( myrep = FirstDay; 1; myrep - FirstDay + 1);
istoday = today = Date(sMonthNumber; theday; sYear ) ;
formatted = TextSize ( TextStyleAdd ( TextColor ( theday ; RGB ( 218 ; 107 ; 68 ) ) ; Bold ) ; 12 );
myday = Case( istoday; formatted; theday);
PMLastDay=Day(Date ( sMonthNumber ; 0 ; sYear ))




];

Case(myrep >= FirstDay and theday <= LastDay; myday;

Case(

myday ≤ 0; TextStyleRemove (TextColor ( PMLastDay + myday ; RGB ( 136 ; 136 ; 136 ) ); Bold);

TextStyleRemove (TextColor ( myday-LastDay ; RGB ( 136 ; 136 ; 136 ) ); Bold))


))

CF to display calendar numbers in repeating fields.

MODIFIED 9/15/2009 - by request, added dimmed days outside of the select Month/Year. Now uses 42 Reps.

This CF is a optimized CF based on a tip file created by ISO Productions. Thanks guys for the foundation.

Since FMP7 allows you to specify the range of Repeating Field, it makes define a calendar easy.

Basically, you stack the same field displaying the rep ranges as follows:

Reps 1-7
Reps 8-14
Reps 15-21
Reps 22-28
Reps 29-35
Reps 36-42

To get a fuctional example file of this CF and the related scripting (for navigation and selecting a day), browse to our site at http://www.dwdataconcepts.com and select the TIPS button link.

KNOWN ISSUE - unfortunately to get this CF to update there needs to be a REFRESH WINDOW [] step on all navigation scripts (FMP7 bug). If you need the ability to select a Month or Year from a value list, just use the CF calculation in the definitions of the Calendar field itself and change the first two variables to the proper field names (note: our sample files does not demonstrate this).

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

RepCalendar ( SelectedMonth ; SelectedYear )

Comments

Support this website.

Support this website.