There's an infinite number of ways to design your doc, but you don't want to use the same tool for every job. That's where designing docs come into play. Explore the basics of schema design in this video series. Lesson 1 - What is a schema? Lesson 2 - Set up your doc Try It! Take a look at the bulleted list and create a table to meet those needs by clicking Explore and choosing Tables What our doc needs: Lesson 3 - Schema 1 - One Big Table Try It! Lesson 4 - Schema 2 - Star Try It! Add a new company to the Companies table Find your new customer in the dropdown list Add a column for priority and set the format to lookup Lesson 5 - Schema 3 - Master/Detail Try It! Update the All Deals table and then see what happens in the Deal Board Add a new salesperson to the deal dashboard Lesson 6 - Schema 4 - Multidimensional Try It! Pick a contact, and then hover to review that contact's company record Create a view that shows all deals greater than $25,000 Lesson 7 - Check your work Try It! Set one of the owners to null Add a column for # of deals for the companies Lesson 8 - Master and individual views Try It! Make a change to the Master View table by assigning to Polly Review Polly's dashboards to see the updates Lesson 9 - Master, individual and team views Try It! Make a change in each of the views and see how it impacts the other locations Lesson 10 - Master and time views Try It! Make a change to the master table Select a new timeframe from the dropdown menu Timeframe - Add your email to the table below Click the button below to email your Designing Docs Diploma
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (