Set Up Your Trailhead Playground
Get Cloudy Consulting is a Salesforce consulting company that just got a new project from a client of theirs, Books4Everyone, an up-and-coming etailer that is moving their systems to Salesforce for scalability. They sell books, and accept reviews from their customers so they know which books are good to keep stocked. Get Cloudy Consulting previously created a simple application for Books4Everyone that kept track of authors, books and recommendations from their customers. Books4Everyone has decided that they love working in Salesforce and need more functionality on their custom home page. The .NET developer at Books4Everyone gave Get Cloudy Consulting requirements, including snippets of code SQL queries they use to report on the data. Since you already know SQL, they asked you to convert the functionality to SOQL. SOQL, or Salesforce Object Query Language, is a query language similar to SQL. It was developed by Salesforce to retrieve data for its use in Salesforce code. It provides a SELECT method and allows you to identify the fields and objects you want data from. Through this project you will take your SQL knowledge and turn it into SOQL skills!
To get started working on the Books4Everyone home page, you’ll need to make a new Trailhead Playground (TP).You also need to know the username and password for your TP. Follow the steps in this article to find your username and set your password.
Now that you have a brand new Trailhead Playground we need to install our unmanaged package.
- Install this unmanaged package for Books4Everyone. If you’re having trouble installing the package, follow the steps in this Trailhead help article.
- Navigate to the Books4Everyone app and click Data Import, then Initialize Sample Data. This gives us sample data from Books4Everyone.
The current books for everyone app has 4 tabs.
- Home—Where we will be doing most of our work, updating the home page to be more useful
- Books—Information about all the books Books4Everyone has
- Author—Every book has an author, and this tab shows off all of an author’s books
- Recommendations—The reviews left by Books4Everyone readers
Since you will be working with these tabs throughout this project, it’s important to know which objects are represented in
each tab and how they are all related. To see this entity diagram in your org, from Setup enter
Schema Builder in the Quick
Find box and then click
As we continue to build out our new homepage, refer back to this entity diagram as needed.