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

Counting number of occurrences in a field

enelson493
in Script Workspace and Script Triggers

Featured Replies

The field type is date and it is also Indexed (I don't know if that matters) and repeating.

Eric

Repeating field -- that's the problem. Now you know why we don't use them.

  • Author

I am using FMP 5.5. I have a database with a field that has many different dates entered into it. I want to have a script count the number of occurrences of certain dates within that field. For example, this field has about 30 dates in it from throughout the last year. I want a script that will search the field for dates from say December and then count the number of those occurrences. Is this possible when many values are entered into one field? This appears to be a multivalued attribute. Should I use repeating groups?

Eric

Hi Eric,

I assume that you're talking about multiple dates in one field in one record - is that right?

What kind of field holds the dates - a text field? - a repeating field?

Create an account or sign in to comment

https://fmforums.com/topic/2531-counting-number-of-occurrences-in-a-field/
Go to topic listing

Important Information

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

I accept

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.