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.

Calculating Number of Related Fields

nutthick
in Calculation Engine (Define Fields)

Featured Replies

I have two tables, Matches and Goals, with a MatchID relating the two. One of the match layouts needs to display the match details (locations, teams etc.) which is easy, but is also required to display the score. The Goals table holds details of the MatchID, TeamID, Player who scored and the time. I'm assuming I can place a calculation field into the Match table to tell me the number of related records from Goals, but I don't know where to start. Also there is the added complication of Teams. The Match table includes the TeamIDs of the two teams playing, so the calculation needs to know which team scored the goal. Can anyone help?

Thanks

Here's a few ideas ...take a look at the attached template!

--sd

Footie.fp7.zip

  • Author

Thanks S

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

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.