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.

Running external script based on Summary fields?

Featured Replies

Interesting question,

I have a script in File1 that is setting a global field (insert calc result) in File2 based on values in several summary fields in File1.

I am performing this script from File2, and sorting (I know it's important, I'm sorting correct fields in File1). But my global in File2 doesn't get set.

If I run the same script locally in File1, changing it to set the local Global (ha ha) field, it works.

Is it something about the summary fields that doesn't allow to do that across files?

Thank you

I'd use Set Field() instead of Insert Calc Result (). Insert script steps won't work unless a field is visible on the current layout. It's preferable not to have this implied requirement on you script unless you absolutely have to. It's too easy to delete a field from a layout without remembering it is needed for an operation. If you must do an Insert (date ranges in a find, etc.), ALWAYS do a Go To Layout to an "All Field" layout first (AND keep this undated so that it is REALLY all fields).

-bd

  • Author

Oak, I can not use Set Field command, because I am inserting multiple results into this field, and want to avoid using Repeating Fields, (booo).

Set Field will only have the result from the last record at the end. Insert Calculated result worked fine for me in the local file (File1). But if I want to run this script as external from File2, does that mean that I have to drag all those Summary fields from File1 onto File2 layout??

Thanks

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.