How to update newly added "number" field for existing records?

[helix101]

Hi Espo community,

when I add a new field of type "number" with a prefix and leading zeros (example: 20240001) it is not filled for all already existing records. Can I somehow catch up for the existing records? When changing an existing record the field is not automatically filled. Is there some mechanism in regards to formulas I could use? E.g. if field is empty then create field value with the logic of the number field?

[lazovic]

Hi helix101,

This forum post may be useful: https://forum.espocrm.com/forum/gene...isting-records.

[helix101]

Hi helix101,

This forum post may be useful: https://forum.espocrm.com/forum/gene...isting-records.

Hi @lazovic, thanks for pointing out. So the summary reviewing these workarounds is: I won't be able to do what I want without these workarounds?

[lazovic]

helix101,

As Yuri wrote in the post that I gave you as an instruction, you can also use the following command in the console: https://github.com/espocrm/espocrm/i...ent-1298638754.

At the moment this is the best command to solve your issue.

[helix101]

Thanks for this idea.