Repeating Field Calc.

[Himitsu]

I know not many people like repeating fields but I use one on my system that hold dates for a day. Say, Monday, and stores the dates for all the mondays we have in our school. We run on a 46 week year and I had to put 48 repetitions (12 per quarter) and two of the fields are empty depending on that day's holidays. I wanted to know if there is a calculation that would get only values and not empty values... so the blank field would just bring over the next value.

I can kind of see it, but can't think if it should be a case() or evaluation...

any help would be super. Thanks

[Søren Dyhr]

Indeed it looks ugly, well knowing that your version isn't 7DEV so custom functions is out of your reach ...but I tend to solve it this way instead of the repeating fields. This upload contains the custom function i use produces a <return> delimited list of the day numbers in a range between two dates.

DateRange(StartDate; EndDate; WeekDays)

The custom function contains this:

Case (StartDate = EndDate; Case(DayOfWeek(StartDate) = 1; StartDate); 

Let ( CurrStart = Case(StartDate + 1 = EndDate; EndDate; StartDate + 1);

Case(PatternCount ( WeekDays;DayOfWeek(StartDate) ); StartDate & "

RangeNCheck.zip

[Himitsu]

Well, the thing is I already have the dates in, and a calender solution that I just click on the dates and it adds it to the fields repetition... I just wanted to know if there was a way to kind of move the dates to fit. I have date[1] to date[6] with dates but date[7] is empty because that quarter only has 11 weeks. but date[13] to date[24] has all the fields entered. So, I need it to do a kind of slide printing but with the data moving. So date[8] would end up in date[7] rep. I thought about a calc that would get next repetition and using a IsEmpty with it. But I just can't get the syntax right...

[Ugo DI LUCA]

Hi, you can make a repeating field slide with a calc for sure.

Check some examples in this file.

RelTipsFor7

Be aware that the last feature suggested in this file is not working as the v3 upgrade did broke the ability to split repeating field on import.