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.

COUNTING FIELDS

Featured Replies

need some help please, I have 5 fields in db 1-message,2-closed,-3-will call back, 4-on property, 5-patched call. I needs to be able to have a count for each field and a total. I use these numbers for billing, after i have printed the monthy report i will need to 0 out the subtotal and the total to 0 to start a new month. thanks

Try adding some Summary functions that Count those fields. The sumamry field Count.message will be a number that is the number of entries in the message field IN THE CURRENT FOUND SET. So it returns to zero after every time you use it. If you add an auto-enter date field (or perhaps auto-enter just the month), then you can search for that month, and a Count will only count what you find. For some reason (anyone know why?) you can't make a Summary of a Count. But you can make a Calculation field that adds up those Count fields. So create:

Date [auto-enter]

Count.message

Count.closed

etc.

Total [= Count.message + Count.closed+ etc...]

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.