Login to your account

Username or Email *

Password *

Remember Me

Forgot your password?
Forgot your username?

Home
Courses
Projects
Challenge
Recap Quiz
Live Courses
Interview

Lesson: 48 | Day of the Week

User Story
Expectation
Code

User Story

Create a formula field which displays the CloseDate of an Opportunity in Words

Expectation

When Close Date is selected as 1/28/2023, a new formula field will display Saturday upon save

Code

Case (WEEKDAY( CloseDate), 1, "Sunday", 2, "Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6, "Friday",  "Saturday")

Prev You need to login to have access to the quizzes. Next

Mastered by 62 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 (69 lessons)

01 | Create a Contact

02 | Account Creation with Contact Addition

03 | Create a Case

04 | Create Account, Contact and Case

05 | Create New User

06 | Screen Flow | Create a New Case

07 | Create a New Account and Task

08 | Clone an Account

09 | Get the Total Number of Active Accounts

10 | Create an Account with multiple Contacts

11 | Update Rating when a Lead is created or updated

12 | Update Close Date to Monday If Saturday or Sunday Selected

13 | Create a Quiz Program

14 | Screen Flow | Email Template

15 | Screen Flow | Other Address as default value from Mailing Address

16 | Schedule Triggered Flow | Send Birthday Message

17 | Screen Flow Simple Addition with Flows

18 | Update the priority of new cases to high

19 | Set Time Base flow for Accounts

20 | Notify contacts of an account when the account is updated

21 | To create an account when a platform event is created

22 | Auto-Create Opportunities for Hot-Rated Accounts

23 | Automatic Task Creation for Missing Contact Information

24 | Account Case Priority Distribution Flow

25 | Email Notification for Deleted Closed Lost Opportunities

26 | Seamlessly Searching and Creating Accounts with Flow Builder

27 | Creating Automated Celebration Emails for National Holidays in Salesforce

28 | Purge COVID 19 Symptoms Survey

29 | User Verification Code for Salesforce Login

30 | Auto-Inactivation of Inactive User Accounts

31 | Update the case owner as the Account Owner

32 | Deactivate inactive Users

33 | Create a Contact Linked to Most Recent Account

34 | Notification Process for Web to Lead Creations

35 | Develop a Job Application Management App

36 | Mass Task Reassignment

37 | Send Follow-Up Email After Opportunity Creation

38 | Automating Case Escalation

39 | Automate Case Owner Update Based on Account Owner Changes

40 | Generate Credit Card Number with Flows using Apex Action

41 | Implement "Mass Delete" Flow for Account Management

42 | Managing Account Contacts with Max Contacts

43 | Automated Flow to Delete Inactive Accounts Older Than 30 Days

44 | Screen Flow to Display Account Details on Home Page

45 | Time-Off Request Flow

46 | Dependent Picklists

47 | Dynamic Record Lookup and Update

48 | File Upload with Notes

49 | Create a Form for License Allocation and User Creation

50 | Automate Opportunity Stage Email Notifications

51 | Automatically Assign Permission Sets to New Users

52 | Create SubFlow to Validate and Shorten String Length

53 | Delete Selected Contacts Button with Screen Flow

54 | Set Sequential Opportunity Close Dates Subflow

55 | Ensure Primary Contact Exists for Accounts

56 | Automate Deletion of Middle Accounts Based on Creation Order

57 | Create a Screen Flow for Filtering Accounts

58 | Create a Screen Flow to Display Accounts by Date Range

59 | Create a Screen Flow for Deleting API Logs

60 | Login Alert for Suspicious Activity

61 | Track Account Owner Changes

62 | Secure Account Cleanup Flow

63 | Auto-Extend Opportunity Close Date Based on Metadata

64 | Assigning and Tracking User Scores

65 | Notify Account Owners Based on Account Rating

66 | Restrict Case Creation for Accounts with Open Cases

67 | Assign Tasks from Inactive Users to Active Users

68 | Account Name Length Validation Flow

69 | Prevent Duplicate Contact Creation Based on Name and Birthdate

C. Apex Beginner | Exercises (78 lessons)

01 | User Login Form

02 | Check if a number is odd or even

03 | Generate Full Name

04 | Add two numbers

05 | Square Root of a Number

06 | Calculate the Area of a Triangle

07 | Generate a Random Number

08 | Convert Kilometers to Miles

09 | Opportunities within a Specific Amount Range

10 | Cube of a number

11 | Case Transformation of Mixed Casing in a String

12 | Accounts with Related Contacts

13 | Days of a Month

14 | Calculate the maximum of three integers.

15 | Sum of the elements of two Lists

16 | Sum of the numbers from 1 to 10

17 | The greatest element of a List

18 | Finding the Maximum Number in a List Using

19 | The average of the elements of a List

20 | Account-Contact Verification

21 | Accounts with Associated Contacts

22 | Accounts with Open Cases and Unclosed Opportunities

23 | Account and Case Connection

24 | Initializing a New Set

25 | Create a Map

26 | Create a List of Colors

27 | Iterate over a List

28 | Maps

29 | Convert a List to a Set

30 | Convert a Set to a List

31 | Days of a specific month and a year in words

32 | Multiplication Table

33 | Voter Eligibility Checker

34 | Which day did you born?

35 | How long have you been living?

36 | How many days are there in the current year?

37 | What is the sum of multiples of 7 between 1 and 1000?

38 | The sum of the Perfect Squares

39 | Check if a List of integers contains only odd numbers?

40 | Sum of all elements in integer array?

41 | Merge two Lists

42 | Is your name palindrome?

43 | Convert all the element to UpperCase

44 | Secure Password

45 | Average Annual Revenue by Account Rating

46 | Accounts with Related Cases

47 | Active Owner and Creator Accounts

48 | Accounts with Two or More Related Contacts

49 | Number Parity Checker

50 | Split Full Name into First and Last Name Variables

51 | Contact Lookup for Account Management

52 | Opportunity Tracking for Sales Forecasting

53 | High Priority Case Management

54 | Lead Conversion Tracking

55 | Account Lookup by Email

56 | High-Value Opportunity Tracking

57 | Sales Lead Tracking

58 | Inactive Account Monitoring

59 | View Comprehensive Information about Accounts and Related Records using SOQL Query

60 | View Cases for Accounts Starting with "Bank"

61 | Advanced Account and Contact Search

62 | Account Health Check

63 | Opportunity Pipeline Report

64 | Upcoming Opportunities

65 | Identify Accounts with Contacts and No Closed Opportunities or Cases

66 | Identifying Even Numbers in a List

67 | Calculating and Displaying Megan's Age

68 | Create Random American Named Contacts in Salesforce

69 | Email Address List Conversion

70 | Bulk Update Account Ratings

72 | Creating a New Automated User

73 | Account and Contact Generation

74 | Month Name to Numeric Representation Conversion Utility

75 | Retrieve Accounts with Related Contacts and Cases

79 | Mass Update of User Roles to Null

Discount Calculator

Grade Converter

Simple Number Checker

D. Apex Intermediate | Exercises (97 lessons)

01 | Sum of the numbers from 1 to 10

02 | Create 100 Accounts

03 | School Grading

04 | Max Integer

05 | Create a Lead Trigger that updates the value of Rating

06 | Create a trigger which updates the description of the related opportunities of an account...

07 | Update Description when an Account is created or updated

08 | Update Account's Billing Country as USA for America or AMERICA values

10 | Automatically Copy Mailing Address to Other Address When "Mailing Address Is Same As Other...

100 | Automatically Adjust Opportunity Close Dates Based on a Custom Range

101 | Scheduled Batch Update for Account Annual Revenue

102 | Update Account Ratings Based on Closed Case Count

103 | Preventing Multiple Open Cases for an Account

11 | Create List With Method and Parameters

12 | Set Lead Source to Web Upon Opportunity Creation or Update

13 | Automatically Set Opportunity Lead Source and Type

14 | Mandatory Type Field for Opportunities

15 | Student Management System

16 | Account Name Validation on Creation

17 | Unique Email

18 | Account Name can not be changed

19 | Concatenate two fields

20 | Update billing country to USA if entered as America

21 | Create a trigger that determines if the account name has changed

22 | Create a contact related to Account if Create Contact Field is Checked

23 | Update the description of the related opportunities of an account

24 | Prevents users to delete Accounts with related opportunities

25 | Create an Opportunity related to Account Object

26 | Update Annual Revenue

27 | Prevents users to change Stage Name of Won and Lost Opportunities

28 | Avoid deletion of the account with a contact

29 | Prevent users to create an opportunity with an existing name

30 | Future Method Example 01

31 | Future Method Example 02

32 | Apex Scheduler Example

33 | Update Contact Description Upon Insertion or Update

34 | Prevent Deletion of Closed Won Opportunities

35 | Create Opportunity On Lead Conversion

36 | Batch Apex | Delete Records

37 | Batch Apex | Update Records

38 | Implementing a Stateful Batch Apex to Aggregate Data

39 | Batch Apex | Inactive Account Deleter

40 | UpdateAccountBillingAddress

41 | Delete Inactive Accounts

42 | Send New Year Message

43 | Debug the number of Deleted Accounts

44 | Update description when the Name of an Account is updated

47 | Update Phone Number of the Contacts when an Account is updated

48 | Prevent Duplicate Contact Creation

49 | Animal Sound Simulator

50 | Prevent Account Deletion

51 | Updating Last Contact Date on Account When Contacts Are Added or Updated in Salesforce

52 | Automatically Set Case Status and Priority for Email-Originated Cases

53 | Automatically Set Lead Rating Based on LeadSource

54 | Automatically Create Associated Contact Record for New Account

55 | Automatically Create Associated Contact Record for New Consulting Account

56 | Automatically Create Multiple Contact Records Based on Number of Contacts Specified on Account...

57 | Update Account with Latest Opportunity Amount

58 | Update Opportunity Stages on Account Deactivation

59 | Prevent Deletion of Active Accounts

60 | Restrict Editing of Closed Opportunities

61 | Validation rule to require Closed Lost Reason on Opportunities

62 | Restrict Account deletion to System Administrators only

63 | Prevent Deletion of Closed Opportunities

65 | Update Contact Owner When Account Owner Changes

66 | Preventing Duplicate Contact Records Trigger

67 | Deleting secondary contacts with a batch apex class

68 | Account Trigger for Updating Related Contacts

69 | Auto-assign Task to Case Owner

70 | Email Alert for High Priority Cases

71 | Notify User on Info Modification

72 | Schedule a daily Apex job to notify users on company holidays

73 | Prevent creation of new Account records outside of business hours

74 | Phone Number Formatting

75 | Vehicle Inventory Management

76 | Expense Tracking Application

77 | Set default value for Opportunity Type field as New Customer when left blank

78 | Constructor Example

79 | Interface Class

80 | Interface Class

81 | Random Stage Name Generator

82 | Deactivate System Administrator after 30 days inactivity

83 | Eliminate Duplicate Integers from a List

84 | Switch | Date Utility - Convert Month Name to Number

85 | Switch | Shipping Cost Calculator

86 | Empowering Account Owners in Salesforce

87 | Update Account Annual Revenue Based on Opportunity Amount Summaries

88 | Update Account Contacts Summary Fields

89 | Automated Phone Number Retrieval and Case Creation for Accounts with Missing Phone Information

90 | Update fields when an Account is created.

91 | Automated Test Data Entry

94 | Create Person Account for Each Contact

95 | Prevent Duplicate Contacts in the System

96 | Convert 24-Hour Time to 12-Hour Format

97 | Account Merge Utility

98 | Create Duplicate Accounts Dynamically Based on Existing Records

99 | Create Apex Method to Validate and Shorten String Length

E. Integration | Exercises (6 lessons)

01 | Retrieve List of Animals from Remote Server using HTTP GET Request

02 | Add a New Animal to Remote Server using HTTP POST Request

03 | Customer Contact Creation

04 | Lead Creation from Customer Information

05 | Create Salesforce Accounts, Contacts, and Cases from External API Data

06 | Create an API to Add Account Data with Related Child Records

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

01 | Hello World

02 | Area of Triangle

03 | Interactive Addition Calculator

04 | Fetch Contacts Via Apex (Filter by Number)

05 | Mortgage Calculation

06 | Registration Form

07 | Event Booking Form

08 | Create an Opportunity

09 | Hotel Booking

10 | Login Form

11 | Fetch Closed Opportunities

12 | Search Account

13 | Search Accounts (2nd Way)

42 | JavaScript Methods

Go to top