{"__v":0,"_id":"57489c4b919ad20e00b6c764","category":{"project":"5746675a5aa03c0e00fce9bc","version":"5746675a5aa03c0e00fce9bf","_id":"57489c11d929e919006ed4ae","__v":0,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-27T19:12:17.975Z","from_sync":false,"order":2,"slug":"blocks","title":"Blocks"},"parentDoc":null,"project":"5746675a5aa03c0e00fce9bc","user":"5706caf0adbf4d1900caf110","version":{"__v":6,"_id":"5746675a5aa03c0e00fce9bf","project":"5746675a5aa03c0e00fce9bc","createdAt":"2016-05-26T03:02:50.849Z","releaseDate":"2016-05-26T03:02:50.849Z","categories":["5746675a5aa03c0e00fce9c0","574899e7e8c6a420000b7314","57489c11d929e919006ed4ae","57489c82d929e919006ed4b1","57489ce91b345d0e004e5231","5748a82e1b345d0e004e5256"],"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":"2016-05-27T19:13:15.816Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":0,"body":"Blockspring makes spreadsheets more powerful by adding \"blocks\" to them. A block can do many things. The typical things a block does is get data, do a calculation, or take an action (e.g. send an email).\n \n## Examples\n\nEach of these examples is 1 minute or less, and shows a block being used in a spreadsheet.\n\n### Get data\n[block:embed]\n{\n  \"html\": \"<iframe class=\\\"embedly-embed\\\" src=\\\"//cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fak1qL1NvytM%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dak1qL1NvytM&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fak1qL1NvytM%2Fhqdefault.jpg&key=02466f963b9b4bb8845a05b53d3235d7&type=text%2Fhtml&schema=youtube\\\" width=\\\"640\\\" height=\\\"480\\\" scrolling=\\\"no\\\" frameborder=\\\"0\\\" allowfullscreen></iframe>\",\n  \"url\": \"https://www.youtube.com/watch?v=ak1qL1NvytM\",\n  \"title\": \"Example - Get data with a block\",\n  \"favicon\": \"https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico\",\n  \"image\": \"https://i.ytimg.com/vi/ak1qL1NvytM/hqdefault.jpg\"\n}\n[/block]\n### Do new calculations\n[block:embed]\n{\n  \"html\": \"<iframe class=\\\"embedly-embed\\\" src=\\\"//cdn.embedly.com/widgets/media.html?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqGO8Xj6jzLU&src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FqGO8Xj6jzLU%3Ffeature%3Doembed&type=text%2Fhtml&key=02466f963b9b4bb8845a05b53d3235d7&schema=youtube\\\" width=\\\"640\\\" height=\\\"480\\\" scrolling=\\\"no\\\" frameborder=\\\"0\\\" allowfullscreen></iframe>\",\n  \"url\": \"https://www.youtube.com/watch?v=qGO8Xj6jzLU\",\n  \"title\": \"Blockspring - Do new spreadsheet calculations\",\n  \"favicon\": \"https://www.youtube.com/favicon.ico\"\n}\n[/block]\n### Take an action (e.g. post to Twitter)\n[block:embed]\n{\n  \"html\": \"<iframe class=\\\"embedly-embed\\\" src=\\\"//cdn.embedly.com/widgets/media.html?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D04Z9B5jn3ZA%26feature%3Dyoutu.be&src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F04Z9B5jn3ZA%3Ffeature%3Doembed&type=text%2Fhtml&key=02466f963b9b4bb8845a05b53d3235d7&schema=youtube\\\" width=\\\"640\\\" height=\\\"480\\\" scrolling=\\\"no\\\" frameborder=\\\"0\\\" allowfullscreen></iframe>\",\n  \"url\": \"https://www.youtube.com/watch?v=04Z9B5jn3ZA&feature=youtu.be\",\n  \"title\": \"Example - Do an action\",\n  \"favicon\": \"https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico\"\n}\n[/block]","excerpt":"","slug":"what-is-a-block","type":"basic","title":"What is a block?"}
Blockspring makes spreadsheets more powerful by adding "blocks" to them. A block can do many things. The typical things a block does is get data, do a calculation, or take an action (e.g. send an email). ## Examples Each of these examples is 1 minute or less, and shows a block being used in a spreadsheet. ### Get data [block:embed] { "html": "<iframe class=\"embedly-embed\" src=\"//cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fak1qL1NvytM%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dak1qL1NvytM&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fak1qL1NvytM%2Fhqdefault.jpg&key=02466f963b9b4bb8845a05b53d3235d7&type=text%2Fhtml&schema=youtube\" width=\"640\" height=\"480\" scrolling=\"no\" frameborder=\"0\" allowfullscreen></iframe>", "url": "https://www.youtube.com/watch?v=ak1qL1NvytM", "title": "Example - Get data with a block", "favicon": "https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico", "image": "https://i.ytimg.com/vi/ak1qL1NvytM/hqdefault.jpg" } [/block] ### Do new calculations [block:embed] { "html": "<iframe class=\"embedly-embed\" src=\"//cdn.embedly.com/widgets/media.html?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqGO8Xj6jzLU&src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FqGO8Xj6jzLU%3Ffeature%3Doembed&type=text%2Fhtml&key=02466f963b9b4bb8845a05b53d3235d7&schema=youtube\" width=\"640\" height=\"480\" scrolling=\"no\" frameborder=\"0\" allowfullscreen></iframe>", "url": "https://www.youtube.com/watch?v=qGO8Xj6jzLU", "title": "Blockspring - Do new spreadsheet calculations", "favicon": "https://www.youtube.com/favicon.ico" } [/block] ### Take an action (e.g. post to Twitter) [block:embed] { "html": "<iframe class=\"embedly-embed\" src=\"//cdn.embedly.com/widgets/media.html?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D04Z9B5jn3ZA%26feature%3Dyoutu.be&src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F04Z9B5jn3ZA%3Ffeature%3Doembed&type=text%2Fhtml&key=02466f963b9b4bb8845a05b53d3235d7&schema=youtube\" width=\"640\" height=\"480\" scrolling=\"no\" frameborder=\"0\" allowfullscreen></iframe>", "url": "https://www.youtube.com/watch?v=04Z9B5jn3ZA&feature=youtu.be", "title": "Example - Do an action", "favicon": "https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico" } [/block]