+ Start a Discussion

Max records :2 /day !!


am creating a custom object .it  contain a mission progress report by day per employee.but the problem is that he can work in two missions in one day.

so i need to  avoid the duplicated records.(In max an employee can have 2 records in one day)

thanks for help.


maybe a trigger on before update


query the owner id and created date of your object then validate if results is already equal to two dont allow to insert the current user entry.


let's wait for other if you asking for pseudocode.