Salesforce Validation Rule Only Create 1 Record a day

Question

Any idea how to write a Validation Rule, that prevents the user from creating more than one record a day.

I have one Object called (Stundenkonto__c) it shows a Month in Timetracking. I have a Object called (Zeiteintrag__c) it is the Master Detail of (Stundenkonto__c) So the User should only be able to create only one (Zeiteintrag__c) Record a day.

Answer 1

You can do that with trigger. In your before insert trigger do something

trigger accTrigger on Zeiteintrag__c(before insert) {
   List<Zeiteintrag__c> zeiList = [SELECT Id FROM Account WHERE Zeiteintrag__c = TODAY]
  if(zeiList.size() > 0)
      trigger.new[0].addError('One record is already created');
}

With this small piece of code you can do this.

Answer 2

Now that you've clarified your requirements, it appears to me that you have several options available to you for doing this validation.

Personally, I'm not fond of the beforeInsert trigger solution. Since this is only on one object, you could add a field to the user object that keeps track of the LastCreatedDateZeiteintrag__c which could be used in a validation rule. Most fields on the user object can't be updated using a trigger, but they can be updated using workflow. Triggers also require periodic maintenance of code where workflow does not.

What I would recommend is comparing System.Now(), Today() or the TODAY value of the new CreatedDate (a date-time value) with the LastCreatedDateZeiteintrag__c on the User to create your validation rule. If the record passes, you'll then want to use workflow to update the LastCreatedDateZeiteintrag__c (either as a Date-time or Date, depending on your requirements) for that user with the new CreatedDate for the record. This method doesn't require you to maintain any code and equally important, gives you an error message that will appear where ever you want it to be located on your page.

Another option you'd have would be to create a controller extension that queries the user Zeiteintrag__c record along with user for the last record that user created and compares that with either Now() or Today(). If the number is less than one day, a page message error is generated, preventing the record from being saved.

Answer 3

I found another solution.

1. created a Tick box on Stundenkonto__c
2. I created a Process builder, everytime a Zeiteintrag__c is created tick the box on Stundenkonto__c. After 13hours make the Tick box empty again.
3. I created a Validation Rule Tickbox = TRUE && ISNEW()

So it is working in a very easy way