autofill container

[Database Administrator]

I have a group of fields that are filled in automatically by lookup from
a related table, based on what's entered in a field above them. But one
of the fields I want to fill in is a container field with an image. The
filename of the image is one of the things that gets imported from the
related table.

I can write a script that inserts the image in the field and add a
button to click to run it, but I'd like the image to appear
automatically along with everything else. I first thought of using
validation for one of the other fields that gets filled in, but
validation only allows calculations, not scripts. And you can run a
script automatically on opening the database, but that's no help.

Is there some sneaky way to get a script to run automatically without
clicking anything?

[Database Administrator]

I see two ways.

Don't import, but use a referenced calculation. If ever the image changes
you don't have to re-import it. The image stays outside filemaker (where in
my ipinion it should stay). create a calculation, result as container. The
calculation holds the complete path and fieldname and will display the
image.
cImage < calculation, image, "image://FullPath/FileName" >

Or use a plug-in that triggers the script. like s4Hu-eventscript plugin or
callscript


"Bill Steele" schreef in bericht
news:ws21-2CC198.18400411112008@newsstand.cit.cornell.edu...
>I have a group of fields that are filled in automatically by lookup from
> a related table, based on what's entered in a field above them. But one
> of the fields I want to fill in is a container field with an image. The
> filename of the image is one of the things that gets imported from the
> related table.
>
> I can write a script that inserts the image in the field and add a
> button to click to run it, but I'd like the image to appear
> automatically along with everything else. I first thought of using
> validation for one of the other fields that gets filled in, but
> validation only allows calculations, not scripts. And you can run a
> script automatically on opening the database, but that's no help.
>
> Is there some sneaky way to get a script to run automatically without
> clicking anything?