dimension Posted February 10, 2007 Share Posted February 10, 2007 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! Link to comment Share on other sites More sharing options...
Osman Posted February 10, 2007 Share Posted February 10, 2007 place "C:windowsdatafiles interfacenopic.png" in a global container field. then schange if statement as like below: if(photo_field = global_container ; "F";"T") Link to comment Share on other sites More sharing options...
dimension Posted February 10, 2007 Author Share Posted February 10, 2007 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. Link to comment Share on other sites More sharing options...
dimension Posted February 10, 2007 Author Share Posted February 10, 2007 (edited) ...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, 2007 by Guest Link to comment Share on other sites More sharing options...
Osman Posted February 11, 2007 Share Posted February 11, 2007 I tried same calculation but its works normal Link to comment Share on other sites More sharing options...
dimension Posted February 11, 2007 Author Share Posted February 11, 2007 ...There are 2 calculations - which did you try, and what is your definition of 'normal'? [color:purple]Frank Link to comment Share on other sites More sharing options...
Osman Posted February 11, 2007 Share Posted February 11, 2007 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6277 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now