4 Replies Latest reply on Aug 31, 2012 8:42 AM by RashinAlizadeh_1

    if merged field is empty



      if merged field is empty



      I have a database that creates labels. Due to the fact that some of the names are long I have created relationships with the main table where the shortforms are listed. This means that I have two fields: one is the long form and the other short form.

      Sometimes the user does not enter/forgets to enter the short form to the list, or its already short and there is no need to have unnecessary repetitive work by assigning a short name in the related table. However this will cause a problem. This means that the reports will come out with blanks if no short form is assigned. Is there a way to tell Filemaker that if one of the merged fields (shot form) on the report layout is empty then to use the long name?