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.

sort by date with summary

Featured Replies

Alright, I have to word this correctly....

I have a list of equipment with days it is supposed to run and hours for each job that will run that day... again only as a group of unsorted records. Is there a good way to sort the list so that each day is separated and that at the end of the list for each day I can insert a summary field that would show the total hours for the jobs for each day?

thanks again.. sorry for my unclear posts!!

Sounds like what you need is a simple sub summary report based on the date field.

Create a new sub sammary report when sorted by date, with the date field being placed in the sub summary area. All else placed in the body area. Sort the data by date then change to preview mode to view or print.

As for the summary, create a summary field which totals the hours field, and place it in the sub summary area of the report as well.

  • Author

Yep, that's what I need... but, I don't know how set the script correctly so that when a list has been created with various dates that these can be sorted and SEPARATED by a summary field... i.e. 50 records with due dates on various pieces of equipment are broken down by pieces of equipment and sorted by date (this I can do)... then ... how do I create a schedule for that piece of equipment for a week , for example, so that it adds a summary field for hours at after each day...

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.