access17401
Registered User.
- Local time
- Today, 14:27
- Joined
- Aug 24, 2017
- Messages
- 33
So I have a complicated question (it’s probable not that hard but I am struggling), I have the following fields.
A_Title – Title, data input
A_FirstName – First name, data input
A_MiddleName – Middle name, data input
A_LastName – Last name, data input
Salutation – changes according to above
I am trying to make the salutation field change according to the other fields. So, I have an example.
The fields might contain Mr J J Smith and the salutation would be Mr Smith, but I now have updated information, his first name is John, so now I have Mr John J Smith and the salutation changes to John.
My salutation rules are:
Name Salutation
Mr Smith = Mr Smith – If no first name but title and last name
Mr J Smith = Mr Smith – First name only initial
J Smith = Default (Friend) – No title and first name initial only
Smith = Default (Friend) – No title or first name
John Smith = John – If first name always use
Mr John Smith = John – If first name always use
BUT I also need to be able to override it with a save button so it’s not accidentally done.
For example, John has asked us to send our reply to his wife Anne, so when I bring Johns profile up his fields are still Mr John J Smith but I need to make the salutation = Anne.
I have worked hard on learning code the last few weeks, worked out some cool things but after spending all last night trying to work this out, using ElseIf ect, I’m stumped.
A_Title – Title, data input
A_FirstName – First name, data input
A_MiddleName – Middle name, data input
A_LastName – Last name, data input
Salutation – changes according to above
I am trying to make the salutation field change according to the other fields. So, I have an example.
The fields might contain Mr J J Smith and the salutation would be Mr Smith, but I now have updated information, his first name is John, so now I have Mr John J Smith and the salutation changes to John.
My salutation rules are:
Name Salutation
Mr Smith = Mr Smith – If no first name but title and last name
Mr J Smith = Mr Smith – First name only initial
J Smith = Default (Friend) – No title and first name initial only
Smith = Default (Friend) – No title or first name
John Smith = John – If first name always use
Mr John Smith = John – If first name always use
BUT I also need to be able to override it with a save button so it’s not accidentally done.
For example, John has asked us to send our reply to his wife Anne, so when I bring Johns profile up his fields are still Mr John J Smith but I need to make the salutation = Anne.
I have worked hard on learning code the last few weeks, worked out some cool things but after spending all last night trying to work this out, using ElseIf ect, I’m stumped.