Create Auto generated field for your Custom Entity

By | April 24, 2009

Are looking to create an auto generated field which will work same as case Reference number?

Yes it’s possible, we can create auto generated field for custom entity or any standard entity. What you need to do is:

1. Create your fields as stored procedure type within CRM.

2. Add a new entry into the “custom_sysparams” table as per the Sage CRM standard.
For example, Param Name = ‘CustomEntityNameCuEn_referenceid’ and Param Value= ‘1000’ // here 1000 is the initial value for this auto generated number field

3. We need add few scripts to auto increase the number for your custom field in the stored procedure named “eware_default_value”.

4. You can use this field on any screen.