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.

Counting in Found Set...newbie

Featured Replies

Possible? How?

-or is it possible to count based on a field meeting a specific criteria (containing a specific value, not just any value)?

Howdy! I'm not sure I follow exactly but you may want to look at these and see if these will help solve your problem...

Status (CurrentFoundCount)

-- this gives you the number of records in your found set

summary fields... (count of field x)

-- this gives you the number of records in the found set for which field x has values

PatternCount

-- this counts the number of occurances of a string in a body of text

--ST

  • Author

but what if i want to find how many currently found records have a value of "y" for "field x"...sorry for the poor explanation

Hmm...

I have not use it before, but the GetSummary function may work for you in this situation.

GetSummary Help has as an example...

GetSummary(Total Sales, Country) returns a summary of all records pertaining to the value in the Country field.

Either that, or you can create a calc field y_specific that only has value if y=specific and then use a summary field that counts y_specific instead, I suppose... kinda weak if there's several but it should be okay if it's just that 1 criterion. I'm sure there's better ways of doing this... probably having to do w/relationships and self-joins and what not which are still kind of fuzzy to me.

Ah, well... not really my area of expertise, but I hope this helps.

--ST

  • Author

thanks. ya, i'm not entirely familiar with relationships and summaries, so i've started doing it the long way with calculations and totals. thanks for the help

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.