Lesson: 09 | Account Number must be numeric and not blank

Create a validation rule for the account object to validate the account number is numeric when it's not blank.

Validation Rule

Field	Value
Description:	Validates that the Account Number is numeric and not blank.
Formula:	`OR(ISBLANK(AccountNumber),NOT(ISNUMBER(AccountNumber)))`
Error Message:	Account Number Must be Numeric and not Blank
Error Location:	Account Number

You need to login to have access to the quizzes. START QUIZ

Mastered by 59 users.

Exercises

A. Administrator | Exercises (62 lessons)

01 | Brand Theme Settings

02 | Account number must be numeric

03 | Account Number must be 7 digits

04 | Account Site must not be blank

05 | Create Formula_Practice Object for Formula Field Practice

06 | Initials of a Contact

07 | Amount must have a value greater than 0

08 | Calculate the Account Score

09 | Account Number must be numeric and not blank

10 | Verify if a Field's Content Includes a Specified String

11 | Link to LinkedIn

12 | This record is not editable.

13 | Account number is required

14 | Date must be in the current year or in the future

15 | Annual Revenue must be between 0 and 100,000

16 | Billing Street, City and Country are Required

17 | Date must be in current year and month

18 | WebSite must have an extension of com or org

19 | A valid two country code is required

20 | Delivery Date: Max 14 Days After Close

21 | Validate Stage Name of the Opportunity Object

22 | Length of State

23 | A new case with an active account must be prioritized

24 | Phone Number Has International Format

25 | Remaining Days

26 | Close Date Must be Weekday

27 | Prevent Open Cases from Being Reset to New

28 | Amount must have a value greater than 0

29 | The End Date must be after the Start Date

30 | Case Origin cannot be edited

31 | Only admins can change account names

32 | Number must be a positive even number

33 | Invalid Billing State

34 | Invalid Teacher Email Address

35 | Future Birthdate Error

36 | Create Image Based on Rating Value

37 | Creating a Dynamic Validation Rule with Metadata Control

38 | Number must be a positive odd number

39 | Summer Business Hours

40 | Open Opportunities by Stage

41 | Monitor Email Field Changes on Contact Object

42 | Close Date Validation for New Opportunities and Date Changes

43 | Email or Phone Required

44 | Start date must be in the current month

45 | Calculating Sales Tax

46 | Website must end with org

47 | Add Global Login IP Range to System Administrator Profile

48 | Day of the Week

49 | Create Labor Day Holiday

50 | Salary Range Check

51 | Birthday Checker

52 | New Contact Welcome Email Template

53 | Formatted Date

54 | Configure Field Dependency for Industry and Product Interest on Account Object

55 | Length of Account Must be 8 Digits

56 | Calculating Age from Birthdate

57 | Invalid Primary Contact Update for Inactive Account

58 | CloseDate 15 days Ahead

59 | Opportunity Stage Name Order Validation

60 | Track Opportunity Close Date History

61 | Display Status Change Date/Time on Task Object

62 | Restrict Account Lookup to Active Accounts

B. Flow Builder | Exercises (79 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (97 lessons)

E. Integration | Exercises (6 lessons)

F. Lightning Web Component (LWC) Exercises (34 lessons)

Lesson: 09 | Account Number must be numeric and not blank

Create a validation rule for the account object to validate the account number is numeric when it's not blank.

Validation Rule

Field

Value

Page Layout View

Video

Exercises

Lesson: 09 | Account Number must be numeric and not blank

Create a validation rule for the account object to validate the account number is numeric when it's not blank.

Validation Rule

Field

Value

Exercises

Login to your account