Salesforce Platform Developer I Certification Guide

Exercise

To complete the following exercise, you create a new custom field on the object Person:

• Type Field: Text
• Properties:
  • Label: External Id
  • Length: 20
  • Unique: true, Treat "ABC" and "abc" as duplicate values (case insensitive)
  • External Id: true

Don't fill the field in with information yet; we will do that later, during the exercise.

The exercise will use everything you have learned up until now, and it contains the following requirements.

• Update all the existing person records with a unique external ID (from one until the end of your Person table).
• Write the logic to update the external ID with the unique reference (a counter from one until the end of your table; convert this integer to a string).
• Upsert the following list into ...