Set a maximum record limit per user

[ciucaadrian11]

Hello,
I hope to find support and solution for my need.
I would like to set a a maximum limit for records in entity per user. Exemple: I created a custom entity "Cars" and I would like to set for users to create maximum 100 records and when this limit is reached, users will no longer be able to create records.
Thank you!

[victor]

Requires coding skills: https://forum.espocrm.com/forum/deve...ndler-and-ajax.

[yuri]

HI,

You can utilize an API before-save script.

Whenever a user creates a record, check the count of records created by the user. If it's greater than the limit, throw an exception with a message. I think it will be a few lines of code (right in UI, no writing in source files needed).

https://docs.espocrm.com/administration/api-before-save-script/

[ciucaadrian11]

Thank you!

[lazovic]

Hi ciucaadrian11,

You can use the following formula script in the Administration > Entity Manager > Car > Formula > API Before Save Script:

$currentUserId = env\userAttribute('id');

if (entity\isNew() && record\count('Car', 'createdById=', $currentUserId) >= 100) {
    recordService\throwForbidden("You have exceeded the limit for creating Cars records.");
}

[yuri]

Note that the custom entity is likely named 'CCar' (with the 'C' prefix).

[ciucaadrian11]

Hi,
Thank you very much for your support. It's working.