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.

summary fields based on date

Featured Replies

I have a schedule that has a date popuplist that schedules a piece of equipment. Each job is automatically calculated for time to perform. If all records are listed in a row, is there a way to sort the records by date and have a summary field after date? Maybe this is a script or portal isue... I have no clue...thanks for the help

There is certainly a way to sort records by date. Several ways in fact.

One way is via the sort command, which will place your records in either ascending or descending order by any field value(s) you specify - including dates.

The other way is to display your records within a portal (based on a relationship from the same or another file) and specify a sort order for the relationship on which the protal is based. This feature can be accessed from within the Define Relationships dialog.

It is also possible to create a summary field which summarise date values - however whereas average date, maximum date (latest), minimum date (earliest) and such have an obvious meaning, other options such as the sum of all dates in a given field are not so useful (though FileMaker will calculate them nonetheless if that is what you request).

Create an account or sign in to comment

Important Information

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

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.