Author Topic: How to add auto increment value to a field? (Read 1294 times)

jahnabi · June 17, 2008, 12:38:39 am

Hi,

Though civicrm 1.9 is not supported nowadays yet we have to use and are hence using civicrm 1.9, drupal 4.7, PHP 5.2 and mysql 5.0.
I have a customised profile that contains several fields. Now, what i want is to add auto increment value to one of these fields. I dont have mysql command prompt access however i can access phpMyAdmin. I have civicrm and drupal on same database. Here id is set as the primary key and is auto incremented.
Now, when i search my field i.e application ID (to add auto increment field) then i see only edit and drop options (no primary key, unique and index options). Moreover, when i go to edit there is no option as extra to add auto increment to it.
The whole thing works good when i use civicrm 2. Any suggestion how to proceed will be highly appreciated.

Kurund Jalmi · June 18, 2008, 12:59:59 am

This is not possible in CiviCRM v1.9. For you best solution will be creating custom data, and writing / hacking code to add this functionality.

You might want to read http://civicrm.org/node/356. But this will be part of CiviCRM v2.1.

HTH

kurund

CiviCRM Community Forums (archive)

News:

Author Topic: How to add auto increment value to a field? (Read 1294 times)

jahnabi

How to add auto increment value to a field?

Kurund Jalmi

Re: How to add auto increment value to a field?