CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • More than one Suffix
Pages: [1]

Author Topic: More than one Suffix  (Read 6477 times)

matt.goodwin

  • Guest
More than one Suffix
February 13, 2009, 01:14:51 pm
Any possibility of having more than one suffix?
I have someone with a name like Dr. Martin Luther King Jr PhD

ctarascio

  • I post frequently
  • ***
  • Posts: 334
  • Karma: 30
    • American Friends Service Committee
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: 5.5.20
  • PHP version: 5.3.13
Re: More than one Suffix
February 13, 2009, 01:22:10 pm
Why not just create a new individual suffix as "Jr Phd"? Then, you can select it from the drop-down list of suffixes. That seems like the easiest way to me to get what you need.

Cynthia

matt.goodwin

  • Guest
Re: More than one Suffix
February 13, 2009, 01:50:17 pm
True, but since our list of potential combinations is pretty high, that might become unmanageable.
ie. Jr, Sr, II, III, PhD, MD, DD, AuD, DPM, RN, ND, DC, DVM, NP, DO, PA, DMD, MBA, BS, BA

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: More than one Suffix
February 13, 2009, 03:34:59 pm

sorry. this is not on our short term or medium term list. not too many folks have those needs. I think have a large list is probably your best bet for now

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: More than one Suffix
February 13, 2009, 08:14:14 pm
PhD isn't actually a Suffix but a qualification - and I expect most of the other examples could be in that category. Maybe easier to drive this off a Custom Data set? - this could certainly be used for mailmerging etc couldn't it?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

matt.goodwin

  • Guest
Re: More than one Suffix
February 16, 2009, 05:25:22 am
Originally, I just wanted to leverage the already existing functionality for suffix, so I wouldn't have to do any hacking to get people's qualifications into the invoices and such.
I'll give it a go with peterd's suggestion.
Thanks everyone for taking the time to post.
-Matt

hhelgesen

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
    • California Jaycees
Re: More than one Suffix
February 17, 2009, 11:13:14 pm
Reminds me of a customer of mine (I do ERP software for a living, CiviCrm is for fun)

He had one, listed as Dr. John Doe, III, MD, PHd, Esq

I told him, anyone that full of them selves need to pick one

choster

  • I’m new here
  • *
  • Posts: 29
  • Karma: 2
    • Lattice Group
  • CiviCRM version: 4.3,4.4,4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.39
  • PHP version: 5.5.15
Re: More than one Suffix
December 22, 2009, 12:34:52 pm
Is there any way at least to remove the constraint on the prefix/suffix— to make it a free-form field?

Unfortunately, this is an impediment to our import, as some contacts write their name "Dr. Jane Doe" while others prefer "Jane Doe, MD," and our legacy system thus dozens of different suffixes over a few tens of thousands of rows. And even if we were to get past the import by create all of them in the database, it's not quite usable to present a drop-down list with 40 or 50 on the edit forms.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: More than one Suffix
December 22, 2009, 09:21:37 pm

in the current schema, suffix_id is a foreign key. you'll need to extend the schema to allow a free form field also. i would go with peterd's recommendation and use a custom field for this

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: More than one Suffix
January 20, 2010, 08:38:33 pm
Another way to handle this complex prefix / suffix requirement is to write custom hooks. I uploaded some code that may be a good starting point at: http://civicrm.org/node/651

What I have found is that how you address someone ( such as Dr. Jane Doe ) will depend as much on the formality of the occasion as much as the prefix and suffix.  For example, for an informal event, such as a movie night the message may start "Dear Jane." For a formal social event, the message may start "Dear Dr. Jane Doe"   For a formal professional event,  you may use "Dear Jane Doe, MD.

If Jane is married to another doctor, then you also have the potential of having to address her and her spouse as a couple. ( such as Dr. and Mr Doe ).
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • More than one Suffix

This forum was archived on 2017-11-26.