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.

Calculate checkboxes

Featured Replies

[color:blue]I have a field called "rfi_category" that is formatted as a checkbox with 8 values. "CC", "CI", "CL" "CODE", "DI", "IR", VI", "WM" are the values.

I have created calculation fields for each that state: If (rfi_category = "CC"; 1;0)

[color:blue]I have also created summary fields for each that state: Total of "count_cc" (running)

The summary fields are the ones that I have placed on my layout, however all of the fields show "0" even if all of the check boxes are checked.

Am I missing something?

  • Author

Well I have figured it out myself.

For any others that may need the answer:

[color:red]count_cl=

PatternCount (rfi_category; "CL")

//will return number of boxes checked for this value throughout found record set//

Then you will need to create a Summary field that will state: [color:red]Total of count_cl (running).

"If (rfi_category = "CC"; 1;0)"

This can be simplified to

rfi_category = "CC"

since it will evaluate to 1 if true, and 0 if false.

" count_cl=PatternCount (rfi_category; "CL") "

This will also count entrie such as "HCL" as true. To avoid this, check paragraph-delimited values...

PatternCount ("P" & rfi_category & "P"; "P" & "CL" & "P")

... where "P" is really the paragraph pilcrow symbol.

The paragraphs don't have to be explicitly expressed as I have them above, but it makes it a bit clearer to explain what's going on if there are IMHO.

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.