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.

summary over one field of selected

Featured Replies

I have one field with [ kilometers ].

Sometimes I make a selection of records. With a scriptbutton, I want to calculate the summery of field "kilometer" from the selected records, the result should be shown in a seperate field.

I know this must be done with a calculation :)-)), but with which one, this is the question for me as beginner...

Since you're doing this as a script, try something like this:

Go to record[First]

Loop

Set variable[$total; $total + kilometer]

Go to record[Next;exit after last]

End Loop

Set field[myTotal;$total]

Note that the field is only set on the last record. I'm not sure exactly what you're proposing here though, so let us know if you need more help.

Why not simply use a summary field = Total of kilometers?

  • Author

Why not simply use a summary field = Total of kilometers?

yes it looks simple. but how to use a summery field only for selected records?

Not sure what you mean by "selected records". Summary fields summarize the found set of records.

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.