Is it possible customize quote number adding a prefix?

Goodmorning,
is there the possibility to customize the quote number (autoincrement) field?
In my case, I need to add a prefix and the numeric part must be 6 characters long (padding left 0 to reach length 6).

An example of the desirable result is the following: QUO-000001, QUO-000002 … I would like to have this result not only when I show the record, but the whole value must be saved into db.

Someone can help me?
Thankyou so much,
B.

You can use calculated fields from Workflow (Done from Within SuiteCRM interface ) or use before_save LogicHook ( Don by adding code to the back end) for that.

Calculated fields:
https://docs.suitecrm.com/user/advanced-modules/workflow-calculated-fields/

LogicHooks
https://docs.suitecrm.com/developer/logic-hooks/

1 Like

thank you very much. I opted for workflow.

B.

1 Like

Could you please help me with the formula?

1 Like