Author Topic: Adding an Application ID field on the Grant Tab (Read 1419 times)

Jrichardson · September 26, 2009, 01:01:16 pm

Hi --
I need to numerically identify grant applications made. Is there a way to create an autonumber function or display the GrantID number to specifically identify each grant application made?

I have created some other custom fields but am not sure how to do this. Suggestions would be appreciated.

Thanks In Advance !

Donald Lobo · September 27, 2009, 07:48:41 am

You could create a custom field of type view (php code). Once the column has been created, you can alter the sql to make it an autoincrement field. Alternatively you can write a custom field hook to do set the grant id. I think "altering" the column is a bit cleaner and easier

. In either case you will need some sql/php knowledge

lobo

Dave Greenberg · September 28, 2009, 10:59:39 am

If what you need is just to display a unique number for each Grant in CiviGrant - then you can potentially use the civicrm_grant primary key - which is available as a smarty variable - {$id} - in the both View and Edit Grant screens, and as {$row.grant_id} in the Grant tab listing.

(Then you only need to create a custom version of these templates and expose the grant id somewhere in the template.)

CiviCRM Community Forums (archive)

News:

Author Topic: Adding an Application ID field on the Grant Tab (Read 1419 times)

Jrichardson

Adding an Application ID field on the Grant Tab

Donald Lobo

Re: Adding an Application ID field on the Grant Tab

Dave Greenberg

Re: Adding an Application ID field on the Grant Tab