Jackie asked <snippet> I would like to add a column in the Individual Records window to shown which BMD certificates I have. I know how to create a new column, but need some help composing the data reference. I just need it to display any combination of B M and D in the records window, but I don't want it to show up on the Reports. <snippet> See the FHUG Knowledge Base that has worked examples along those lines: http://www.fhug.org.uk/wiki/doku.php?id=how_to:using_flags_and_icons Just use several =ExistsText() functions instead of one =Exists() function. e.g. =ExistsText( %INDI.BIRT.SOUR>% , "B" ) =ExistsText( %INDI.FAMS>MARR.SOUR% , "M" ) =ExistsText( %INDI.DEAT.SOUR>% , "D" ) All entered on one line in the Expression. These check that a Source citation exists for 1st Birth, or 1st Marriage, or 1st Death event. The FHUG gives examples of how to check the Source Type or Source Title and can be extended to check if a Multimedia image is attached (but you may not always have an image for an otherwise fully Sourced event). They all assume that a Certificated Source would always be the 1st citation. The FHUG also shows how to cope with multiple marriages. Happy New Year, Mike Tate
Correction ... the Expression needs to combine each =ExistsText() within a =Text() function: e.g. =Text(ExistsText(%INDI.BIRT.SOUR>%,"B") . ExistsText(%INDI.FAMS>MARR.SOUR%,"M") . ExistsText(%INDI.DEAT.SOUR>%,"D")) Mike Tate -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Beryl and Mike Tate Sent: 31 December 2013 18:31 To: [email protected] Subject: Re: [FHU] Individual Records window Jackie asked <snippet> I would like to add a column in the Individual Records window to shown which BMD certificates I have. I know how to create a new column, but need some help composing the data reference. I just need it to display any combination of B M and D in the records window, but I don't want it to show up on the Reports. <snippet> See the FHUG Knowledge Base that has worked examples along those lines: http://www.fhug.org.uk/wiki/doku.php?id=how_to:using_flags_and_icons Just use several =ExistsText() functions instead of one =Exists() function. e.g. =ExistsText( %INDI.BIRT.SOUR>% , "B" ) =ExistsText( %INDI.FAMS>MARR.SOUR% , "M" ) =ExistsText( %INDI.DEAT.SOUR>% , "D" ) All entered on one line in the Expression. These check that a Source citation exists for 1st Birth, or 1st Marriage, or 1st Death event. The FHUG gives examples of how to check the Source Type or Source Title and can be extended to check if a Multimedia image is attached (but you may not always have an image for an otherwise fully Sourced event). They all assume that a Certificated Source would always be the 1st citation. The FHUG also shows how to cope with multiple marriages. Happy New Year, Mike Tate ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message