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.

Working with portals and Sum() functions...help pls

Featured Replies

  • Newbies

Hi,

I'm new to this and I need to have a (calculation?) field which sums a portal on the layout. The trick is: the Sum field needs to evaluate on record creation without evaluating deletion of portal rows. Basically, it should only reflect increases and not decreases (all entries will be positive values). I've looked at auto-entry and lookup approaches but can't seem to make them work.

Thanks

Mike

You could make an invisible field that would lookup the value of the field that you need to sum and your calculation would sum the lookup fields instead of the real field. The drawback is that if you changed the data in the real field it would not reflect in your sum field, even if you typed 33 instead of 32 and hit enter then corrected it, it would not reflect it.

There are much better ways to do what you want then this and this way probably is very bad but I'm new here and this is how I learn things, sorry.

This is probably more of a structural issue. See if this file helps you out.

falseDelete.zip

Create an account or sign in to comment

Important Information

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

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.