3 Replies Latest reply on Oct 3, 2013 10:33 AM by philmodjunk

    help with a calculation in an email

    CampAdmin

      Title

      help with a calculation in an email

      Post

           I'm trying to send an email to have registrants confirm information they have given us and show what we are missing.

           If there is data in the field I want it to show the data and if the field is empty I want it to have a line (________), so they know to fill it in and send it back.

           I tried using the following calculation, but I get the line if it's empty or a ? if there is data in the field. Someone please tell me what I'm doing wrong and how to fix it.

            "Date of Birth: " & If ( IsEmpty ( CDR CAMPER DATABASE new layouts::DOB ) ; "_____" ; GetField ( CDR CAMPER DATABASE new layouts::DOB ) ) & ¶ &