{"__v":3,"_id":"56330e2a62c48a0d00334dfc","category":{"__v":7,"_id":"5614aa6253a1830d0098e962","pages":["5614aa8653a1830d0098e963","5614aa9dfb2ff50d0026c5d5","563303f57b563e0d00904902","56330c0c10b6040d00879475","56330dbe8c9cda0d0025270b","56330ddf7b563e0d00904906","56330e2a62c48a0d00334dfc"],"project":"5614a5066ebd340d006a1bcc","version":"5614a5076ebd340d006a1bcf","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-10-07T05:15:14.875Z","from_sync":false,"order":0,"slug":"tutorials","title":"Tutorials"},"parentDoc":null,"project":"5614a5066ebd340d006a1bcc","user":"5614a4b8b283fb0d00a487d3","version":{"__v":5,"_id":"5614a5076ebd340d006a1bcf","project":"5614a5066ebd340d006a1bcc","createdAt":"2015-10-07T04:52:23.031Z","releaseDate":"2015-10-07T04:52:23.031Z","categories":["5614a5076ebd340d006a1bd0","5614aa6253a1830d0098e962","5633048649e16d0d00122539","563305b08c9cda0d00252704","563305dc8c9cda0d00252705"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-10-30T06:28:58.455Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":4,"body":"Spreadsheets only give you two dimensions to work with. But your data is often multi-dimensional (or in strict technical geek terminology, “relational”). For instance:\n\n* For a project, you want to track multiple tasks\n* One employee might be assigned to multiple clients, and vice versa\n* One candidate talks to multiple interviewers\n\nThe two-dimensional grid of a spreadsheet doesn't handle this well—but Fieldbook does, using linked sheets. Here's an example of starting with a sheet of Projects and creating a linked sheet of Employees. When done, you can see all an employee's projects on their [detail page](doc:add-detail).\n\n[block:embed]\n{\n  \"html\": \"<video style=\\\"border: 1px solid #ddd; width: 100%;\\\" src=\\\"http://s3-us-west-2.amazonaws.com/fieldbook-demo-videos/linking.mp4\\\" preload loop autoplay></video>\",\n  \"url\": \"http://s3-us-west-2.amazonaws.com/fieldbook-demo-videos/linking.mp4\"\n}\n[/block]\nSee how this works on our [client tracking template](https://fieldbook.com/templates/client-tracking), or [learn more about linked sheets](doc:linking-sheets).\n\n-----\n\nThis is the last tutorial! Now [go check out Fieldbook](https://fieldbook.com).","excerpt":"","slug":"go-beyond-the-grid","type":"basic","title":"Go beyond the grid"}

Go beyond the grid


Spreadsheets only give you two dimensions to work with. But your data is often multi-dimensional (or in strict technical geek terminology, “relational”). For instance: * For a project, you want to track multiple tasks * One employee might be assigned to multiple clients, and vice versa * One candidate talks to multiple interviewers The two-dimensional grid of a spreadsheet doesn't handle this well—but Fieldbook does, using linked sheets. Here's an example of starting with a sheet of Projects and creating a linked sheet of Employees. When done, you can see all an employee's projects on their [detail page](doc:add-detail). [block:embed] { "html": "<video style=\"border: 1px solid #ddd; width: 100%;\" src=\"http://s3-us-west-2.amazonaws.com/fieldbook-demo-videos/linking.mp4\" preload loop autoplay></video>", "url": "http://s3-us-west-2.amazonaws.com/fieldbook-demo-videos/linking.mp4" } [/block] See how this works on our [client tracking template](https://fieldbook.com/templates/client-tracking), or [learn more about linked sheets](doc:linking-sheets). ----- This is the last tutorial! Now [go check out Fieldbook](https://fieldbook.com).