Determine max numeric value in table

[ecristen]

I have a entity/table with a numeric field in it and depending on the status/stage of that record I want to have the numeric value set to the max of that value in the table +1. Is there a function through which I can achieve this or do I have to do this by writing custom php code? I know how to code, but am not yet a pro in writing custom code in Espo, and where to place it. Any help would be appreciated.

Kind regards,

Emil

[tanya]

EspoCrm has 'number' field type

https://github.com/espocrm/espocrm/blob/master/application/Espo/Core/Utils/FieldManager/Hooks/NumberType.php#L57

You can try to use this logic, because there is nothing other, except sql executing