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.

Help with a field

Featured Replies

  • Newbies

First post here so hopefully someone can help me!

I track machine downtime at my facilty here and Im having trouble getting a calculation to work. I have a field that is for determining what shift a machine went down, either first or second. My boss wants me to make 2 fields that count how many occurances each shift had, (one for first, one for second) on the bottom of my report.

Example :

2/1/2005 We had 20 Occurances between the 2 shifts.

12 of them were first, 8 on second. I want filemaker to sort thru the shift field into 2 seperate boxes typing them automatically.

Ive tried a few scripts/calculations but it wont add up the shifts, it only counts 1 record so my two fields both just say one adding up to two records, instead of the full 20.

First thing I tried was make a total of 4 fields, 2 calculations, 2 number fields. One calc for First shift totals, using the if( command but with no luck.

So once again, I want to look into a field that either has a 1 or a 2 and have filemaker tell me how many 1's there are and how many 2's there are in two diffrent fields.

You could create a subsummary report where the field that has either the 1 or the 2 is the break field. (sort by that field) then use a summary field that summarizes the count of records for each subsection.

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.