If I have a file with a script that is set to run an external script in another file, is there any type of IF calc that can be used so that if the other external file is not currently open, the external script wont be run?

Right now, if I run the script with the external call, the other file is opened and the external script in that file is run. I only want it to run if the other file is already opened.

LR

Use

PatternCount (DatabaseNames, "FielName")

so the script coulld look somehow like this

If(PatternCount (DatabaseNames, "FielName"))

Perform Script [External Script]

else

Exit Script

End if

HTH

Dj

PatternCount (DatabaseNames, "FieldName")

Did not work. Am I missing some quoation marks?

PatternCount ("DatabaseNames", "FieldName")

LR

DatabaseNames is the name of the function you'll find in Design Function Section of available functions.

FileName should be the name of the file the presence you want to check.

This could be hardcoded string or it could be passed as an value from the field.

HTH

Dj

When he wrote "FielName", he didn't mistype "FieldName", he mistyped "FileName".

But what he *meant* was for you to put the name of your file in that spot.

DatabaseNames should not be in quotes... its the name of a built-in function.