How to Concat Text field and AutoIncrement number

I'm wanting to create a new text field that is the concatenation of an alphabetic code field and an AutoIncrement numeric field. I don't see the AutoIncrement field in the choices when setting the calculation of the text field in Studio:

concat($alpha_code,??????)

How is this done?

Parents

0 Ben Hamilton over 1 year ago

It'll depend on which version and edition of Sugar you're running.

In 12.0 Enterprise, you have an auto-increment field: https://support.sugarcrm.com/Documentation/Sugar_Versions/12.0/Ent/Administration_Guide/Developer_Tools/Studio/Fields/#AutoIncrement_Next_Value

or you can make your own using a logic hook: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_12.3/Cookbook/Creating_an_Auto-Incrementing_Field/

Hope that helps.

Ben Hamilton (more)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Ben Hamilton over 1 year ago

It'll depend on which version and edition of Sugar you're running.

In 12.0 Enterprise, you have an auto-increment field: https://support.sugarcrm.com/Documentation/Sugar_Versions/12.0/Ent/Administration_Guide/Developer_Tools/Studio/Fields/#AutoIncrement_Next_Value

or you can make your own using a logic hook: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_12.3/Cookbook/Creating_an_Auto-Incrementing_Field/

Hope that helps.

Ben Hamilton (more)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data