{"_id":"5633024010b6040d0087946d","user":"5614a4b8b283fb0d00a487d3","parentDoc":null,"category":{"_id":"5614a5076ebd340d006a1bd0","pages":["5614a5086ebd340d006a1bd2","5614a68fb283fb0d00a487d5","5614aab0163a7d2100ab5f02","563301637b563e0d00904900","56330184b904a10d0032f797","563302048c9cda0d002526ff","5633020e62c48a0d00334df3","5633022c10b6040d0087946b","5633024010b6040d0087946d","5633026fb904a10d0032f799","5633034538f8aa0d00d31002","5633035062c48a0d00334df5","5633036949e16d0d00122537","5633037b38f8aa0d00d31005","5633038d38f8aa0d00d31007","5633039bb904a10d0032f79b","56330b63b904a10d0032f7a6","56330e587b563e0d00904908","56370adb0704070d00f06c0c","563bc913dfa1282b000dd33e","56ad51b279011b0d00c32aba"],"version":"5614a5076ebd340d006a1bcf","__v":21,"project":"5614a5066ebd340d006a1bcc","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-10-07T04:52:23.567Z","from_sync":false,"order":1,"slug":"reference","title":"Reference"},"__v":11,"project":"5614a5066ebd340d006a1bcc","version":{"_id":"5614a5076ebd340d006a1bcf","project":"5614a5066ebd340d006a1bcc","__v":5,"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":["585f176f72d7872300c19888","585f1789d0bbbc2f003a3097"],"next":{"pages":[],"description":""},"createdAt":"2015-10-30T05:38:08.827Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":1,"body":"Typing info into Fieldbook is as easy and flexible as a spreadsheet.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Multi-line cells\"\n}\n[/block]\nWant to enter multiple lines or paragraphs in a single cell? Normally, typing Enter closes the input box, like in a spreadsheet. To input a line break instead, hold down Control, Alt or Option while pressing Enter.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/hP52l4qCTdK7Ef2i3Sqe_Screen%20Shot%202015-11-01%20at%208.57.41%20PM.png\",\n        \"Screen Shot 2015-11-01 at 8.57.41 PM.png\",\n        \"513\",\n        \"145\",\n        \"#64b86c\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Digit grouping (thousands separator)\"\n}\n[/block]\nTo format numeric values in a column with commas (or dots, depending on your [locale settings](doc:locale-settings)), just choose this option from the column menu:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/dfqQSiGKTK6fU1Fu2OiU_Screen%20Shot%202016-05-17%20at%206.42.02%20PM.png\",\n        \"Screen Shot 2016-05-17 at 6.42.02 PM.png\",\n        \"374\",\n        \"349\",\n        \"#35a24a\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Wrap text\"\n}\n[/block]\nText is always wrapped on the detail page. It is not wrapped by default on the sheet view, but you can turn this on with a column setting:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/6a458a1-Screen_Shot_2017-01-24_at_4.12.05_PM.png\",\n        \"Screen Shot 2017-01-24 at 4.12.05 PM.png\",\n        501,\n        334,\n        \"#397952\"\n      ],\n      \"border\": true\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Input types\"\n}\n[/block]\nIf desired, you can set the input type on any column, such as text, number, date, currency, etc. More about types: [Data types](doc:data-types) \n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/f7mLYOCsSiiBmxpDE62M_Screen%20Shot%202015-11-01%20at%208.43.24%20PM.png\",\n        \"Screen Shot 2015-11-01 at 8.43.24 PM.png\",\n        \"413\",\n        \"242\",\n        \"#319f38\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Required fields\"\n}\n[/block]\nIf a field is marked as required, then having an empty value will be an error, and missing values will be highlighted in red. Find this option under the column menu:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/Qzp4MSMsS9SGH5z4as8v_Screen%20Shot%202015-11-01%20at%208.55.29%20PM.png\",\n        \"Screen Shot 2015-11-01 at 8.55.29 PM.png\",\n        \"418\",\n        \"272\",\n        \"#329c38\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Options coming in the future\"\n}\n[/block]\nOther formatting options coming in the future include:\n\n* Highlight color and text color\n* Bold and italic\n* Conditional formatting\n\nPro tip: If you want conditional formatting in order to see the status of items in a workflow or pipeline, try grouping on the status column as an alternative.","excerpt":"","slug":"input-and-formatting","type":"basic","title":"Input & formatting"}

Input & formatting


Typing info into Fieldbook is as easy and flexible as a spreadsheet. [block:api-header] { "type": "basic", "title": "Multi-line cells" } [/block] Want to enter multiple lines or paragraphs in a single cell? Normally, typing Enter closes the input box, like in a spreadsheet. To input a line break instead, hold down Control, Alt or Option while pressing Enter. [block:image] { "images": [ { "image": [ "https://files.readme.io/hP52l4qCTdK7Ef2i3Sqe_Screen%20Shot%202015-11-01%20at%208.57.41%20PM.png", "Screen Shot 2015-11-01 at 8.57.41 PM.png", "513", "145", "#64b86c", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Digit grouping (thousands separator)" } [/block] To format numeric values in a column with commas (or dots, depending on your [locale settings](doc:locale-settings)), just choose this option from the column menu: [block:image] { "images": [ { "image": [ "https://files.readme.io/dfqQSiGKTK6fU1Fu2OiU_Screen%20Shot%202016-05-17%20at%206.42.02%20PM.png", "Screen Shot 2016-05-17 at 6.42.02 PM.png", "374", "349", "#35a24a", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Wrap text" } [/block] Text is always wrapped on the detail page. It is not wrapped by default on the sheet view, but you can turn this on with a column setting: [block:image] { "images": [ { "image": [ "https://files.readme.io/6a458a1-Screen_Shot_2017-01-24_at_4.12.05_PM.png", "Screen Shot 2017-01-24 at 4.12.05 PM.png", 501, 334, "#397952" ], "border": true } ] } [/block] [block:api-header] { "type": "basic", "title": "Input types" } [/block] If desired, you can set the input type on any column, such as text, number, date, currency, etc. More about types: [Data types](doc:data-types) [block:image] { "images": [ { "image": [ "https://files.readme.io/f7mLYOCsSiiBmxpDE62M_Screen%20Shot%202015-11-01%20at%208.43.24%20PM.png", "Screen Shot 2015-11-01 at 8.43.24 PM.png", "413", "242", "#319f38", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Required fields" } [/block] If a field is marked as required, then having an empty value will be an error, and missing values will be highlighted in red. Find this option under the column menu: [block:image] { "images": [ { "image": [ "https://files.readme.io/Qzp4MSMsS9SGH5z4as8v_Screen%20Shot%202015-11-01%20at%208.55.29%20PM.png", "Screen Shot 2015-11-01 at 8.55.29 PM.png", "418", "272", "#329c38", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Options coming in the future" } [/block] Other formatting options coming in the future include: * Highlight color and text color * Bold and italic * Conditional formatting Pro tip: If you want conditional formatting in order to see the status of items in a workflow or pipeline, try grouping on the status column as an alternative.