{"id":10936,"date":"2020-07-15T16:15:03","date_gmt":"2020-07-15T16:15:03","guid":{"rendered":"https:\/\/fhug.org.uk\/kb\/?post_type=kb_article&p=10936"},"modified":"2024-02-24T15:41:03","modified_gmt":"2024-02-24T15:41:03","slug":"how-to-customise-or-print-records-window-columns","status":"publish","type":"kb_article","link":"https:\/\/www.fhug.org.uk\/kb\/kb-article\/how-to-customise-or-print-records-window-columns\/","title":{"rendered":"How to Customise or Print Records Window or Named List Columns"},"content":{"rendered":"

Introduction<\/h2>\n

The columns in the\u00a0Records Window<\/em> (and Named Lists<\/em>) can be customised to suit the user’s preferences. For example, many researchers find it helpful to include an extra column to show a woman’s married name. It is then possible to do a sort on spouse name which can be particularly helpful for example when sorting out burial records. Some researchers also find it helpful to add extra columns to show date and place of marriage or date and place of death. Many other column values are also possible.<\/p>\n

The Lists > Configure Records Window Columns<\/a> dialogue customises the columns, and offers a Save to Query…<\/em> button, which not only saves the customisation as a Query file that can be restored via Load from Query…<\/em> button, but also allows the Query to be used to printout the Records Window details. Similar features exist in the Configure Columns<\/em> for Named List dialogue. An alternative way of opening those dialogues is to right-click any Column Heading and choose Configure Columns.<\/p>\n

Use Tools > Preferences<\/a> and select the Records Window<\/em> tab to adjust the Record Type Display Options<\/em> and other settings.<\/p>\n

Configure Columns<\/h2>\n

This tutorial is for \u0192h<\/span><\/span> V3 on Windows XP, but despite slightly different layout and colours, the concepts are still valid for later versions.<\/p>\n\n\t

\n \n \"Adding\n <\/a>\n <\/div>\n

Note: The above tutorial shows you how to add a spouse surname as a column in the\u00a0Records Window. If you only want the spouse surname to appear for women, follow the tutorial until the\u00a0Add Column\u00a0window is displayed. It has two fields. Set the\u00a0Heading\u00a0field to\u00a0Husband’s Surname\u00a0(say), and copy and paste the following into the\u00a0Expression\u00a0field:<\/p>\n

=TextIf(%INDI.SEX% = \"Female\",%INDI.~SPOU>NAME:SURNAME%,\"\")<\/code><\/p>\n

or since\u00a0\u0192h\u00a0V6.1.4:<\/p>\n

=Sex(%INDI%,\"\",%INDI.~SPOU>NAME:SURNAME%,\"\")<\/code><\/p>\n

and click the Add <\/i>button<\/p>\n

Another animated tutorial, Using Lists to Mark a Diagram, illustrates a Custom Column in conjunction with other features:<\/p>\n\n\t

\n \n \"Using\n <\/a>\n <\/div>\n

Beware that in \u0192h<\/span><\/span> V6.2.5 the text in the Edit Column Details<\/em> dialogue Heading and Expression must not exceed about 470 characters, otherwise that configuration will NOT be saved when \u0192h<\/span><\/span> is Closed, so the Column vanishes!<\/p>\n

More Example Record Window Column Expressions<\/h2>\n

You can test for the existence of a data item as follows:<\/p>\n