3 Replies Latest reply on Jul 8, 2013 8:32 AM by PeterPitt

    Display a record from a default field or an alternative field if the default is blank

    PeterPitt

      Title

      Display a record from a default field or an alternative field if the default is blank

      Post

           Hi

           I think a similar question has been asked on here before but I've not seen an answer for it as yet.  I have a layout for royalty information that summarises the records in a simpler format, however I have a field called 'Royalty Rate' which I need to display either a default field (JeromeRoyaltyrate) or an alternative (electroyaltyterms) if the default is blank.  It there anyway to display results from one specific field or an alternative if the original is blank?

           Thanks

      Royalty_fields.jpg