Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Encounter the error, "Salesforce error validating object.".Rule 1 Employees of type ‘Vendor’ are not allowed to enter information There are two types of validation settings, one at list level and another at column(field) level.After creating the list, go to the list settings page.
In the Insertcolumn we will have all the column list that are eligible for setting the validation.With Excel's data validation tools, you can control how users input data into workbooks and ensure data is entered consistently and accurately.You can control the dates, the times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes.List validation and column validation is one of the notable feature of Share Point 2010.We will see how we can set validation to a list and to a column with formulas without using Share Point designer Taking an example of an Employee Entry list where employees will enter their data in the list; we will see how the validation rules can be set on this list The list schema of Employee Entry list is as follows Title – Single line of text Description – Multiline of text Emp Id – Numeric column Emp Type – Choice [dropdown with values ‘Permanent’, ‘Vendor’] Following are the business rules we are going to implement with the validation settings.(So for example, column validation can ensure that the date in the Date Finished column can’t be earlier than the date in the Date Started column — you can’t finish a project before it’s begun!) To use column validation on your app: You can add column validation to columns created at the app or site level.You can download an example workbook with all of the data validation examples you'll find in this article.You can follow along, or create your own data validation scenarios.When I was finished, it was one of those moments of “wow, that was easy, how come I didn’t look into this earlier?” This can be done quite simply by using List Validation.