3 Replies Latest reply on May 8, 2014 11:24 AM by philmodjunk

    Conditional field value based on whether a container field has been populated with a signature or...

    CalebTurner

      Title

      Conditional field value based on whether a container field has been populated with a signature or not.

      Post

           Hi,

           I've been working on a simple safety audit database and the list view to see a list of audits performed. 

           One of the fields in list view is name Status and is used to see if an audit has been reviewed or not. I have a signature container field named: Safety Department Signature. The status field should say "Unreviewed if the container field is empty, and say "Reviewed" if the container field has been populated. I used an if statement to try and accomplish this: If (IsEmpty ( Safety Department Signature ) ; Status="Unreviewed" ; Status="Reviewed"), which does not work as all it shows is a 1 or 0 in the status field. Any ideas where I went wrong, I know this should be very simple...

      Screen_Shot_2014-05-08_at_12.54.03_PM.png