* Census Summary Line

[SimonH]

I have just returned to my Family History now that the 1939 Registration is available.

I may be imagining it, but I am fairly sure that on the Individual Records Window, an unexpanded Census line would include the year, eg "1851 Census in Manchester, Lancashire, England" but now, no year is shown so it just says "Census in Manchester, Lancashire, England".

This is the expanded entry:

Capture.JPG (26.4 KiB) Viewed 7840 times

Any advice please?

[tatewise]

Welcome back to the FHUG Simon.

First a little housekeeping, so we know which FH version you are using.
Please update your Family Historian Version in the Profile to the right of your posting.
Click your username SimonH top right of this web page and choose User Control Panel.
Then on its Profile tab, select your Family Historian Version, and scroll down to click Submit.

You are correct that by default every unexpanded Records Window entry should show fact Name, Date & Place.
In your example it should show the full date not just the year:
[+] Census 30 March 1851 in Manchester, Lancashire, England

Does the problem only affect Census or are any other facts affected?

Is it possible that you have customised the Tools > Fact Types entry for Census via the Edit > Advanced > Use Override Template for Record Window Listings?

[SimonH]

Thanks. Profile updated.

It is only Census and yes, I have made the changes to accommodate the 1939 Registration as detailed at ancestralsources:family_historian_census_event_for_uk_1939_register|> Family Historian Census Event for UK 1939 Register.

Looking at it again, I see that it omits the date.

[tatewise]

Ah yes, it needs to omit the {date} for the Override Template for Facts Tab Listings but it is needed for the Override Template for Record Window Listings.

I have updated the advice to make that adjustment.

[SimonH]

Thanks for the rapid help.

Incidentally, is there a function to derive the year from {date} if I wanted to say "1891 Census" in the record window?

[Jane]

The Record Window Template takes all template codes in the same way as the narrative reports so you can use

Code: Select all

{%FACT.DATE:YEAR%} Census {_place}

Mike I was looking at your routine in the Knowledge base, I wondered if this might be more compact

Code: Select all

=TextIf((Year(%FACT.DATE%) = 1939) ,"1939 Register","Census")
or
=TextIf(%FACT.DATE% = DateAt(1939,9,29),"1939 Register","Census")

[tatewise]

Yes, thanks Jane, that is more compact, and the KB has been updated.

I prefer to test the full date, because other countries may have a Census in 1939.

[SimonH]

Thank you Jane.

Can you please tell me what is wrong with this:

{=TextIf( %FACT.DATE% = DateAt(1939,9,29), "1939 Register",{%FACT.DATE:YEAR%} Census)} {place}

I end up with:

Capture.JPG (15.46 KiB) Viewed 7764 times

[tatewise]

Yes, when you embed codes like that into function parameters it gets a bit trickier.
You have to use the Text(...) function to force integers into text and join text components together.

{=TextIf( %FACT.DATE% = DateAt(1939,9,29), "1939 Register",Text( Text(Year(%FACT.DATE%)) . " Census") )}

It assumes that every Census Event will have a Date with at least the year.

[Jane]

or Try

Code: Select all

=TextIf(%FACT.DATE% = DateAt(1939,9,29),"1939 Register",Text(Text(%FACT.DATE:YEAR%) . " Census"))

(Mike posted while I was working it out).

[tatewise]

Or if you want it completely foolproof and perhaps a bit easier to understand try:

{=TextIf(%FACT.DATE% = DateAt(1939,9,29),"1939 Register",CombineText("",%FACT.DATE:YEAR%," Census","Census"))}
or
{=CombineText( "", %FACT.DATE:YEAR%, TextIf(%FACT.DATE% = DateAt(1939,9,29)," Register"," Census"), "Census")}

where if %FACT.DATE:YEAR% exists it combines with " Register" or " Census" otherwise uses just "Census" to avoid the redundant space.

I have added that to ancestralsources:family_historian_census_event_for_uk_1939_register|> Family Historian Census Event for UK 1939 Register.

[SimonH]

Mike and Jane

Thank you both for your help. It is much appreciated.

[brianlummis]

Mike - I think that an extra closing bracket has crept into the following expression in the KB

{=CombineText("",%FACT.DATE:YEAR%,TextIf(%FACT.DATE% = DateAt(1939,9,29)," Register"," Census"),"Census"))} {place}

I think that it should be
{=CombineText("",%FACT.DATE:YEAR%,TextIf(%FACT.DATE% = DateAt(1939,9,29)," Register"," Census"),"Census")} {place}
although I'm no expert

Brian

[tatewise]

Yes, you are correct Brian, thank you, and now rectified.

Those pesky brackets