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.

Add portal that sums totals for years

Featured Replies

Hi All. I have a portal with several fields, all based on a year. There can be multiple portal rows for any given year. i would like to add another portal on the same layout that will show the sum of a couple of the fields for every year in the first portal. for instance it would look like this:

portal 1

2005 | 200 | 100

2005 | 100 | 100

2006 | 50 | 100

Portal 2

2005 | 300 | 200

2006 | 50 | 100

Can anyone help? Thanks!!!

Well this is a kind of portalized summary, which hardly is posible without some kind of scripting in order to be reliable....

Since the calculation of the sum is more than a relation away!

Here's my stab at it!

--sd

test.zip

  • Author

wow, you got it to work. im not sure exactly how you accomplished it yet. i will look further into your relationships. Thanks a ton. hopefully i will be able to replicate this!

  • 4 weeks later...
  • Author

i kind of got this to work, except that the summarized portal shows the same values in all records and the relookup script is pretty slow.

is there an easier solution, or am i missing something?

thanks for all the help!!

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.