There is another question often asked, concerning how to immediatly avoid duplicated record in the same block. (by immediatly I would say before posting or committing).
The technique used to solve this problem comes from the Kevin D Clarke’s calculated item famous solution.
/https%3A%2F%2Fassets.over-blog.com%2Ft%2Fcedistic%2Fcamera.png)