I have a database that prints certificates that are proof of academic status.

I have a script that works fine to verify that all the required fields have a value before printing a single certificate. However, if I'm printing multiple certificates at a time, I'd like to still check for empty fields.

Some of my ideas to solve this:

I created a boolean field with the following calculation:

If ( IsEmpty ( BirthDate or Fall_Campus or First_Name or Last_Name or Nationality or Program_Start_Date or Program_End_Date or University) ; 0 ; 1 )

First off, it doesn't work. Is my logic correct? I've purposely deleted data to see if it would show 0, but it always shows 1.

I considered using this boolean field as a constrain found set, so as only to print those with the boolean value of 1. Is this the best way to do this?

Second issue, once I resolve how to verify multiple certificates before printing, I'd like it to continue printing those that are complete, but then show in my list view the ones that were skipped because they had incomplete data.

Any suggestions?

You have to have IsEmpty for each field that you want to check.

You could do something like this.

not (

IsEmpty ( BirthDate ) + IsEmpty ( Fall_Campus ) + IsEmpty ( First_Name ) + IsEmpty ( Last_Name ) + IsEmpty ( Nationality ) + IsEmpty ( Program_Start_Date ) + IsEmpty ( Program_End_Date ) + IsEmpty ( University )

)

Edited August 23, 200718 yr by Guest

Thanks, that calculation works. Now I just have to figure out the print multiple certificates script having it skip those that aren't complete but then come back to them at the end.

Perform a find for those that are flagged as 1 to print the ones that are complete. Then perform a find for the ones that are marked 0 to show the ones that need attending to.