Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Running external script based on Summary fields?


This topic is 8190 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8190 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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