1 Reply Latest reply on Nov 12, 2016 12:19 AM by Johan Hedman

    Insert a container graphic as a condition of the presence of two other container field graphics:

    pjohnson64

      I am very new to Filemaker and am struggling with this problem. I have some check boxes that indicate if the required signatures are on a document. I used something like the following script, and put it as an exiting script trigger on the pop up that houses the signature field.

       

      if [table::record = ""]

      Set Field [table::field; table::Empty_Check_Box]

      Else

      Set Field [Table:Field; Table::Marked_check Box

      End If

       

      This part seems to be working great; however: because the document needs several signatures and a worker would be dealing with several documents at once, I wanted to create a small icon that shows when all of the signatures are present and another when they are not so the user can see at a glance without previewing the finished documents. I have tried a couple things: I set some fields up with the IsEmpty (field) script which populate great. I then set another field which calculates the values of the "IsEmpty" fields; the math worked and the fields show the right values so I tried a similar script:

      Go to Record [first]

      Loop

      If [table:: calculated field= "0"]

      set field [table::field; table::Green_Light]

      Else

      Set Field [table::field; table::Red_Light]

      End If

      Go To record [next; Exit after last]

      End loop

       

      I also tried the same thing with the values of the check boxes instead of the calculated numbers. I would really appreciate it if anyone has advice on how to proceed. Thank you for your time.