I want to create requirement to create one record for a day. I want to do this through the E-mail field on my custom object. I have checked for "No Duplicate Value" for the email field but want to retain the older functionality such that the same user can create another record again in the next day. How would I achieve this?
Follow these steps:
- Create a text field with Unique checkbox true
- Create a workflow rule with no criteria and use field update options.
- In field update select the field which you have created (Unique text field) in the first step.
- Use a formula to update that field value with Concatenation of Date, LoggedinUser, Email Id (Formula: TEXT(Today())&""&LoggedinUserId&""&Email__c ) Hope this will solve your issue :)