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.

Summary from one table to another

Featured Replies

How do I take the value from a summary in table 1, and show it in table 2? Portals don't work, creating a field that links to the summary doesn't work.

Are you using a calculated summary field (using GetSummary)?

  • Author

No, I am using a summary field, not a calculation field.

Just take the summary field from table 1 and place in on a layout for table 2. If the two tables are properly linked (check your Relationships Graph) you will see the appropriate summary displayed.

  • Author

My problem is in the relationship graph my summary fields are greyed out. I also already have a join file in between table 1 and 2.

Summary fields are context sensitive in the sense that the value they return is dependent upon the found set for summmary fields in a trailing grand summary part and upon found set and sort order in a subsummary part. I'd try defining a calculation field using the GetSummary() function and using this field in the related table. As an alternative, you can define a calculation field using the Sum(relationship::field) function in the related table. The relationship will determine the set of records aggregated.

-bd

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.