Repeating Calculation Fields

[ryangrg]

How do you produce the results of a repeating calculation fields repetitions by its own internal calculation? Is this possible? For example if you wanted Field[1] to be 1 and Field[2] to be 2 and so and so forth via the fields own internal calculation. Why do I want to do this you ask? Because I want to set a repeating calculation field with 7 repetitions with the current weeks dates - repetition 1 being Monday etc. I can isolate the date range of the current week just wanted to know if I could produce a result in a repeating calculation field via its own internal calculation thus eliminating the need to set the repetitions with a script. I have been playing around but just get questions marks.

[bruceR]

Get(CalculationRepetitionNumber)

http://fmhelp.filemaker.com/fmphelp_11/en/html/func_ref2.32.18.html#1028830

[ryangrg]

Thanks, works now. I was using Get( ActiveRepetitionNumber ). Heres an example of what I did.

Dates.fp7.zip

[comment]

How about something simple?

CurrentWeekR.zip

[ryangrg]

Nice, thanks Consultant. I was coding to get it done cause I couldn't figure out the reduction quite yet. This helps a lot for further use. Thanks again.

[ryangrg]

Maybe I can takes this to the point were repetition fields become a problem. Can a specific repetition number be conditionally formatted? Trying to shade current date now.

[comment]

Can a specific repetition number be conditionally formatted? Trying to shade current date now.

Why would this require conditional formatting of a specific repetition?

[ryangrg]

Wanted to use conditional formatting to shade, highlight, or change fill color of a single repetition ( the repetition with the current date ). Is there another way to change a fields fill color other than conditional formatting. Formatting calculation functions only act on text right?

[comment]

Wanted to use conditional formatting to shade, highlight, or change fill color of a single repetition ( the repetition with the current date ).

Yes, I understand that - but the condition is the same for all repetitions (i.e. for the entire repeating field):

Self = Get (CurrentDate)

[ryangrg]

Got it. Was using Get ( ActiveRepetitionNumber ) in conditional formatting calculation instead of Get ( CalculationRepetitonNumber ) - you'd think I would have learned. Any hoot heres what I have to share from it. This also includes a global that captures data for filtering relationships - events, task and such.

DatesCurrentWeek.fp7.zip

Thanks for the help.

[comment]

I think you are making this more complicated than it needs to be, by working with text instead of directly with dates. Another by-product of this approach is that the selected date changes when you change the week starting day.

[ryangrg]

Ok, fixed that. Text fields are used so full date doesn't flash when selected.

DatesCurrentWeek2.fp7.zip

Ok No more edits.