However, Theres one new case I've encountered where this may not work -
I need to prevent duplicate records but only duplicate 'active' records. In my case, 'Active' is a checkbox (Formula) based on dates (Within a date range = active)
So when I pass a concatnated value of name + Active, sometimes the record gets inserted because at the time of creation, the status is inactive based on the date. But as time goes on and the active status changes based on that day's date, the duplicate is inevitably allowed because the records are already 'in' and status becomes active.
Hope this makes sense and wonder if you have a solution for this.
5 件の回答
So I am guessing you just have to modify the Workflow Rule to run on UPDATES too and thus this would be enforced.
