Hello everyone,

I need support please! I would like to create a specific field in Books. This missing field should consist of the following parameters:

1. symtax: "PR-"

2. customer number (cf_kdnr)

3. consecutive 3-digit number

I would like to achieve that when a project/cost estimate is created, the following line appears on the quotation: PR-20347_045.

Unfortunately, I can't get any further if I enter a formula in Zoho via the "New specific field - Projects" item, e.g:

CONCATENATE("PR-", customer.custom_field_hash.cf_kdnr_unformatted, "_", (customer.custom_field_hash.cf_kdnr_unformatted + 1))

I have tried different variations, but unfortunately I am not getting anywhere. Does anyone have any idea what I am doing wrong?

Best regards,

Jens