{"__v":8,"_id":"56370adb0704070d00f06c0c","category":{"__v":21,"_id":"5614a5076ebd340d006a1bd0","pages":["5614a5086ebd340d006a1bd2","5614a68fb283fb0d00a487d5","5614aab0163a7d2100ab5f02","563301637b563e0d00904900","56330184b904a10d0032f797","563302048c9cda0d002526ff","5633020e62c48a0d00334df3","5633022c10b6040d0087946b","5633024010b6040d0087946d","5633026fb904a10d0032f799","5633034538f8aa0d00d31002","5633035062c48a0d00334df5","5633036949e16d0d00122537","5633037b38f8aa0d00d31005","5633038d38f8aa0d00d31007","5633039bb904a10d0032f79b","56330b63b904a10d0032f7a6","56330e587b563e0d00904908","56370adb0704070d00f06c0c","563bc913dfa1282b000dd33e","56ad51b279011b0d00c32aba"],"project":"5614a5066ebd340d006a1bcc","version":"5614a5076ebd340d006a1bcf","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-10-07T04:52:23.567Z","from_sync":false,"order":1,"slug":"reference","title":"Reference"},"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-11-02T07:03:55.867Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":5,"body":"[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"What is special about the first column?\"\n}\n[/block]\nThe first column is reserved for a name or identifier. Some examples:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Type of sheet\",\n    \"h-1\": \"What should be in the first column\",\n    \"0-0\": \"Contacts or Employees\",\n    \"0-1\": \"Person's (full) name\",\n    \"1-0\": \"Companies or Clients\",\n    \"1-1\": \"Business name\",\n    \"2-0\": \"Books or Movies\",\n    \"2-1\": \"Title\",\n    \"3-0\": \"Orders\",\n    \"3-1\": \"Order ID number (see below regarding numeric IDs)\",\n    \"4-0\": \"Meetings\",\n    \"4-1\": \"Company name + Date (see below regarding multi-field names)\"\n  },\n  \"cols\": 2,\n  \"rows\": 5\n}\n[/block]\nFor short, we call the first column “the name column”.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Why is this needed?\"\n}\n[/block]\nWhen you link sheets (see [Linking sheets](doc:linking-sheets)), anything you type in a linked column will be matched against the name column of the linked sheet. For instance, if a Contacts sheet has a Company column that links to a Companies sheet, then anything you type in the Company column will match against the company names in the first column of the Companies sheet:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/iSSFN55eQ6u2LLqkZkGV_Screen%20Shot%202015-11-01%20at%2011.17.50%20PM.png\",\n        \"Screen Shot 2015-11-01 at 11.17.50 PM.png\",\n        \"462\",\n        \"274\",\n        \"#30a738\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/gtrxyIoyQLWzPZC7kUxQ_Screen%20Shot%202015-11-01%20at%2011.18.04%20PM.png\",\n        \"Screen Shot 2015-11-01 at 11.18.04 PM.png\",\n        \"543\",\n        \"274\",\n        \"#66b569\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"How to change the name column\"\n}\n[/block]\nYou can't move or delete the name column. If you want to pick a different column as the name column, choose “Configure this column…”\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/lVdn4Nr7TK474eXrPUJ1_Screen%20Shot%202015-11-01%20at%2011.19.26%20PM.png\",\n        \"Screen Shot 2015-11-01 at 11.19.26 PM.png\",\n        \"450\",\n        \"297\",\n        \"#319f37\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Multi-field names\"\n}\n[/block]\nYou can configure a name column based on a combination of other columns. For instance, combine first-name and last-name columns into a full-name column:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/pKwTTaJLQTO9NftZ6n5Z_Screen%20Shot%202015-11-01%20at%2011.20.38%20PM.png\",\n        \"Screen Shot 2015-11-01 at 11.20.38 PM.png\",\n        \"723\",\n        \"369\",\n        \"#28872e\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Numeric ID names\"\n}\n[/block]\nSome things just don't have names or titles—such as orders, meetings, submissions, assignments, interviews, or other process-oriented things like that. If there's no good name, just configure a numeric ID instead:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/fILrvRzuQGCkxVQpbAxf_Screen%20Shot%202015-11-01%20at%2011.23.36%20PM.png\",\n        \"Screen Shot 2015-11-01 at 11.23.36 PM.png\",\n        \"726\",\n        \"367\",\n        \"#2b8931\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]","excerpt":"","slug":"the-name-column","type":"basic","title":"The name column"}
[block:api-header] { "type": "basic", "title": "What is special about the first column?" } [/block] The first column is reserved for a name or identifier. Some examples: [block:parameters] { "data": { "h-0": "Type of sheet", "h-1": "What should be in the first column", "0-0": "Contacts or Employees", "0-1": "Person's (full) name", "1-0": "Companies or Clients", "1-1": "Business name", "2-0": "Books or Movies", "2-1": "Title", "3-0": "Orders", "3-1": "Order ID number (see below regarding numeric IDs)", "4-0": "Meetings", "4-1": "Company name + Date (see below regarding multi-field names)" }, "cols": 2, "rows": 5 } [/block] For short, we call the first column “the name column”. [block:api-header] { "type": "basic", "title": "Why is this needed?" } [/block] When you link sheets (see [Linking sheets](doc:linking-sheets)), anything you type in a linked column will be matched against the name column of the linked sheet. For instance, if a Contacts sheet has a Company column that links to a Companies sheet, then anything you type in the Company column will match against the company names in the first column of the Companies sheet: [block:image] { "images": [ { "image": [ "https://files.readme.io/iSSFN55eQ6u2LLqkZkGV_Screen%20Shot%202015-11-01%20at%2011.17.50%20PM.png", "Screen Shot 2015-11-01 at 11.17.50 PM.png", "462", "274", "#30a738", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/gtrxyIoyQLWzPZC7kUxQ_Screen%20Shot%202015-11-01%20at%2011.18.04%20PM.png", "Screen Shot 2015-11-01 at 11.18.04 PM.png", "543", "274", "#66b569", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "How to change the name column" } [/block] You can't move or delete the name column. If you want to pick a different column as the name column, choose “Configure this column…” [block:image] { "images": [ { "image": [ "https://files.readme.io/lVdn4Nr7TK474eXrPUJ1_Screen%20Shot%202015-11-01%20at%2011.19.26%20PM.png", "Screen Shot 2015-11-01 at 11.19.26 PM.png", "450", "297", "#319f37", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Multi-field names" } [/block] You can configure a name column based on a combination of other columns. For instance, combine first-name and last-name columns into a full-name column: [block:image] { "images": [ { "image": [ "https://files.readme.io/pKwTTaJLQTO9NftZ6n5Z_Screen%20Shot%202015-11-01%20at%2011.20.38%20PM.png", "Screen Shot 2015-11-01 at 11.20.38 PM.png", "723", "369", "#28872e", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Numeric ID names" } [/block] Some things just don't have names or titles—such as orders, meetings, submissions, assignments, interviews, or other process-oriented things like that. If there's no good name, just configure a numeric ID instead: [block:image] { "images": [ { "image": [ "https://files.readme.io/fILrvRzuQGCkxVQpbAxf_Screen%20Shot%202015-11-01%20at%2011.23.36%20PM.png", "Screen Shot 2015-11-01 at 11.23.36 PM.png", "726", "367", "#2b8931", "" ] } ] } [/block]