* Expression =FactOwner(%FACT%,1,MALES_FIRST)
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Expression =FactOwner(%FACT%,1,MALES_FIRST)
When using the expression =FactOwner(%FACT%,1,MALES_FIRST) this returns name with surname last. I would like to return Surname first. Can I add a qualifier to accomplish this?
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15
- Jane
- Site Admin
- Posts: 8503
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Expression =FactOwner(%FACT%,1,MALES_FIRST)
It actually returns a Record which will sort by surname, if you want a column with just the surname use
=GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:SURNAME%")
You could of course combine this with
=GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:GIVEN_ALL%")
So
=Text(GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:SURNAME%") . ", " . GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:GIVEN_ALL%"))
but note this will not be a record link so you won't be able to click on it to open the person.
=GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:SURNAME%")
You could of course combine this with
=GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:GIVEN_ALL%")
So
=Text(GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:SURNAME%") . ", " . GetFieldText(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.NAME:GIVEN_ALL%"))
but note this will not be a record link so you won't be able to click on it to open the person.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
- tatewise
- Megastar
- Posts: 28272
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Expression =FactOwner(%FACT%,1,MALES_FIRST)
This crops up so often that I wrote advice on it three years ago.
See how_to:sort_fact_query_on_owner_surname|> Sort Fact Query on Owner Surname that gives all the options including having a single column that both sorts in Surname order and actively links to the record.
See how_to:sort_fact_query_on_owner_surname|> Sort Fact Query on Owner Surname that gives all the options including having a single column that both sorts in Surname order and actively links to the record.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Re: Expression =FactOwner(%FACT%,1,MALES_FIRST)
Thanks to Jane and Mike. Using the expressions you suggested met my requirement. Leaving the original expression in place then gave me a way to look at the original record. Will experiment with Mike's suggestions in Knowledge Base.
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15