Brian Dunning's FileMaker Custom Functions

RepCalendar ( SelectedMonth ; SelectedYear )

CF to display calendar numbers in repeating fields.

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

Don Wieland   Don Wieland
DW Data Concepts
http://www.dwdataconcepts.com

Share on Facebook Share on Twitter

  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)

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

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: