Found this question on sfdc99.com as an example of possible Salesforce developer interview questions. Does anyone know how this can be done? Of course, without coding.


You could create a text field on Opportunity that is marked as "unique" and doesn't allow duplicate values. Then use a Workflow Rule and Field Update to update the field with the account/date combination eg:

AccountId & "-" & YEAR(CreatedDate) & "-" & MONTH(CreatedDate) & "-" & DAY(CreatedDate)

The workflow criteria would be true so that it fired all the time.

|improve this answer|||||

One way would be to rollup the max opportunity date to the account, then have a validation rule check if the newly created opportunity date is equal to the custom rollup field on the account.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.