Manipulation of Data
Calculation Fields
Concatenating Multiple Fields
DATES:
It was clear that I needed separate fields for the three components of a date (Month, Day, Year), because in some instances I had all those fields, but in some cases I only knew the year.
There were other places, however, that I really wanted to combine all of these dates, either to make it more visually appealing, or clearer to read.
Here's how I did that:
Instead of :
July 4 1800
I wanted it to read:
(1800 - 1900)
Here's what the calculation for that looked like:
"(" & birth year & " " & "-" & " " & death year & ")"
This might seem pretty simplistic, but it was my first real experience coding, so it was pretty exciting to figure out!
Here you can see the separately entered dates in the individual record fields, and then the calculation for concatenating that information.
Full Name
Here's the similar process of concatenating the Full Name Calculation, which includes maiden names in parenthesis, as well as birth to death dates (years only):
Above is the drop-down menu for choosing a person, using this calculation field to express their full "identity."