We are working with clients in 70 countries including Germany, Austria and Switzerland which adds a level of complexity since we do not only have to identify the right gender but also need to select if a last name is German thus using Herr / Frau (English: Mr./Ms.). The forms we use do not ask for salutation and we wouldn’t want to add yet another mandatory field that contacts have to fill. What I have created is a set of name lists: - German female first names - German male first names - International female first names - International male first names Also, I have created a list with the top3000 German last names. My plan is to check the following: - first name is in one of the female/male lists IF not found, don’t set a salutation. A) IF only in International male/female first name then everything should be clear and we add the respective Ms. or Mr. B) IF the first name is in both lists (e.g. Diana) THEN check the German last names (Schmidt) for a match. E.g. Diana Schmidt is female AND most probably German speaking thus set Salutation to „Frau“ If her last name is not on the German last names list, we would either not fill the field or set it to Ms. I have all those nice and extensive lists with thousands of names. I have imported them into custom properties using radio select field type and try to actually build the workflow. What I am struggling with is the combination of check first name, compare with list A, B, C and the German last names. Anyone with a similar challenge and a solution? If not, adding such first name, last name list for recommendations on gender and language dependent salutations would be a great functionality to add to HubSpot. Alternatively, the freedom to make such checks across multiple list in an easy way would be great.
... Mehr anzeigen