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 »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Database Design
Pages: [1]

Author Topic: Database Design  (Read 1649 times)

blindape

  • Guest
Database Design
June 21, 2009, 11:27:57 pm
Hi,

I'm investigating CiviCRM as a tool for tracking potential carers in an organisation that provides foster care to children in need.  So far it looks very good and they are definitely interested in using it.  One question I do have is to do with setting up the data base and the use of custom fields.  Is CiviCRM able to utilise nested or sub-fields?  For example one field in the data base would ask how a potential carer heard about the organisation. Then depending on the answer there would be a sub filed to add more info.  For example if the entry in the first field was News Paper then a sub-field would be available to provide the name of the news paper.  In the entry in the first field was the organisations website then there would be no need for a sub-field.  Another example of this is asking about a potential carers ethnicity in the first field there would be a selection of general ethnicities. For example, Polynesian, European, Asian then depending on what was chosen in the first field a sub field would be available to enter specific ethnicities.  For example Polynesian was chosen in the first field and then a sub-field would be available which would list specific Polynesian ethnicities such as Samoan, Tongan, Nuiean, Cook Islander.
Is this sort of design  possible with CiviCRM, or is there some sort of effective workaround that could be used?

Regards,

John Curwood

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Database Design
June 22, 2009, 04:59:19 am
No, CiviCRM custom fields do not currently have the ability to define conditional dependencies. You'd need to custom code that type of capability.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

blindape

  • Guest
Re: Database Design
June 22, 2009, 09:52:16 pm
From your reply I have a couple of questions.
1) is there any other sort of work around that could produce a similar effect?
2) with regards to creating custom coded fields, how involved is that as there are only a few instances in the database where such fields are required.

Regards,

John Curwood

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Database Design
June 23, 2009, 10:40:34 am
John - You might be able to do this by customizing the template used for the form(s) - adding Javascript to switch display (i.e. show/hide) properties for various fields based on user actions.

There's some discussion of this in this thread:
http://forum.civicrm.org/index.php/topic,7708.0.html
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Database Design

This forum was archived on 2017-11-26.