AnsweredAssumed Answered

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

Question asked by PeterPitt on Jul 4, 2013
Latest reply on Jul 8, 2013 by 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

Outcomes