Hello everyone,noob in programming and databases there.
I have a question that looks complicated to me.
Situation: I want to do a research on my own parish and research what were main criteria for giving baptising names.
Fact: I enter birth date (year; month_day), sex (male or female); given name; sign if person was baptised after parents, godparents, saint of that day or unknown reasons; if person was "illegitimate" child. So it may sound like: "1788 12_01 m Adam p I (date, male, Adam, named after parents, illegitimate).
Goal: to make something that:
a) takes data from cell "name", then
b) takes data from cell "date" (excluding year, it is unimportant), then
c) compare with entered [newly] parent's names: male with male, female with female; if they are same, mark as, say, "P"; if not, then
d) compare with entered [newly] godfathers' names: male with male, female with female; if they are the same, mark as, say, "G"; if not, then
e) compare with entered list of saints' dates, like "date+given name" comparing to pre-entered "date+name"; if they are same, mark as "S"; if not then mark "X" and end cycle.

How it could work: script takes data "12_01" and "Adam"; script checks names of father - if they are same, marks as "P" and ends; if not, script checks name of godfather - if they are same (i.e. godfather was Adam) script marks as "G" and ends' if not, script checks if "12_01" on pre-entered list has entry "Adam" - if yes, marks with "S", if not - marks with "X" and end cykle.

Question: is it possible to create such thing and...well....where to look for those who could make such thing for me?