Running external script based on Summary fields?

[bbaliner]

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

[LiveOak]

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

[bbaliner]

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