Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Repeating Field Calc.

Featured Replies

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

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

  • Author

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...

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.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.