AnsweredAssumed Answered

Script Problem when opening File

Question asked by andrewma on Jan 31, 2017
Latest reply on Jan 31, 2017 by philmodjunk

I have a Main database that I am trying to import data to from another one.


Database A  has a button that when pressed is supposed to open Database B.

When Database B is opened(preferrable hidden) I want a script to run.  After the script runs, Database B can close

(the script is one that collects data from an excel sheet)


My problem is I have selected the script on Database B to run based on a script trigger "OnFirstWindowOpen".

And it does not trigger when the file is simply opened.


If I run it manually it works just fine.  It seems there is no way to have a script run when a file is opened, and then closed almost immediately and never actually having its window shown on my screen.


Just to clarify, I do not want to see or even interact normally with  Database B, I simply want it to open, run the import script then close.


That way I can have my field in Database A which is a Lookup of one in Database B show the data I'm looking for properly.