Hi,

I have a calculation set up to show the state of a checkbox (True or False) if a container is populated.

Now I need to alter this slightly, I need the checkbox to show False (off) if; has been pasted into the container and True if; C:windowsdatafilesassetsxyzfoto.png has been used instead.

How do I reference these external files correctly?

My current script is;

If (IsEmpty(Foto) ;"F";"T")

...which works as normal.

Thanks!

place "C:windowsdatafiles interfacenopic.png" in a global container field. then schange if statement as like below:

if(photo_field = global_container ; "F";"T")

Hi Osman - many thanks! Saved me hours of trial-&-error (mostly error)

If(Foto = GlobalFoto ; "F";"T") worked perfectly; the checkbox is switched on only when a graphic OTHER than the one in the field is pasted into

Frank.

...Just worked out the correct script;

[color:purple]If(Foto = GlobalFoto or (IsEmpty(Foto));"F";"T")

this still shows checkbox UNCHECKED if field is left empty...

Frank.

Edited February 10, 200718 yr by Guest

I tried same calculation but its works normal

...There are 2 calculations - which did you try, and what is your definition of 'normal'?

[color:purple]Frank

calculation:

If(Foto = GlobalFoto or IsEmpty(Foto);"F";"T")

amd several results are listed below:

- if field is left empty result is F

- if nopic.png image appears result is F

- otherwise result is T

i think these are desired results.

try unchecking "Do not evaluate if the reference fields are empty" option in calculation dialog box.