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.