Validation before saving

[maxniebieski]

Hello experts,

I need to do a validation before saving, whether the selected value does not exceed the maximum allowed. In my case, the selected value is the number of days but only working days and taking into account exceptions
What is the best way to capture this value before saving the record?

$totalWorkingDays = ext\workingTime\getWorkingDays(
    entity\attribute('dateStartDate'),
    entity\attribute('dateEndDate'),
    entity\attribute('assignedUser.workingTimeCalendarId')

[lazovic]

Hi maxniebieski,

For validation check you should use the API Before-Save script: https://docs.espocrm.com/administrat...re-save-script.

[maxniebieski]

Hi lazovic ,

Yes, i tried, but have a problem.
How to read the calculated number of working days before saving to compare it with the value specified as maximum in another field?

[maxniebieski]

Is this not supposed to work or am I doing something wrong?


Before save custom script

$totalWorkingDays = ext\workingTime\getWorkingDays(
    entity\attribute('dateStartDate'),
    entity\attribute('dateEndDate'),
    entity\attribute('assignedUser.workingTimeCalendarId')
    
);

entity\setAttribute('iloscdni', $totalWorkingDays);

Validation (API before save script)

if (entity\attribute('iloscdni', 0) > entity\attribute('dowykorzystaniaUrlop', 0)) {
    recordService\throwBadRequest("MY ERROR TEXT");
}

Only when i check with duration its works - but duration does not take into account working days and exceptions from the working time calendar

[maxniebieski]

Hi again

yuri as expert - can you give any advice , i know you are so busy but my work has stopped.

I was convinced that I would be able to do it through workflow, later, hook, and now I don't know anything