Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By craigdurling on
I would like to set up a node that has fields for storing historical data.
I plan to set up a node type for keeping track of people and their level of certification within the organization. The node would contain fields to identify the person (name, id#, contact information, etc). I would also like to establish a field that indicates what the person's current certification level is and another field that is associated to it to indicate the date of each level of certification. If a person re-certifies or upgrades their certification I would like to use this same field to add a new record entry for the node.
For example, a node would display like this:
NAME
John Smith
CERTIFICATION / DATE ACHIEVED
Level 3 / Jan 2, 2008
Level 2 / Mar 3, 2005
Level 1 / Dec 1, 1999
If I were building this from scratch in the database I would create a separate table for the certification data that stores history for all members including the certification level, certification dates, and the corresponding NID for the person. To a user the records in the certification table would be joined with the node table by NID to show a user's full history.
I've been trying to find modules or cck fields that will allow me to do this but I'm having a hard time. Can anyone point me in the right direction?
Craig
