In this lesson, I adjust a previously created formula field to return the Account Phone number on the Project record whenever there is a Phone Number populated, but yet hide any characters from the formula in the field if the account does not have a phone number. This is a good example of a more complex formula.
Here is the final formula that I used:
IF(ISBLANK( Account__r.Phone ), '', "(" & LEFT(Account__r.Phone, 3) & ") " & LEFT(RIGHT(Account__r.Phone, 7), 3) & "-" & RIGHT(Account__r.Phone, 4))
In this lesson, we create a Validation Rule on the Percentage Complete field on the Project object to limit entries by users to 100%, but no higher.
In this lesson, we change the Related List Properties on Related Lists.
In this lesson, we look at the different options for the default Lightning Experience Record Page View - Grouped View or Full View. We change these settings back and forth and note the change of appearance of the Lightning Page record page layout.