{"_id":"57489a1de8c6a420000b7316","project":"5746675a5aa03c0e00fce9bc","__v":0,"version":{"_id":"5746675a5aa03c0e00fce9bf","__v":7,"project":"5746675a5aa03c0e00fce9bc","createdAt":"2016-05-26T03:02:50.849Z","releaseDate":"2016-05-26T03:02:50.849Z","categories":["5746675a5aa03c0e00fce9c0","574899e7e8c6a420000b7314","57489c11d929e919006ed4ae","57489c82d929e919006ed4b1","57489ce91b345d0e004e5231","5748a82e1b345d0e004e5256","59ce5c88e8c105001a4bedd7"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"parentDoc":null,"category":{"_id":"574899e7e8c6a420000b7314","__v":0,"project":"5746675a5aa03c0e00fce9bc","version":"5746675a5aa03c0e00fce9bf","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-27T19:03:03.123Z","from_sync":false,"order":2,"slug":"google-sheets","title":"Google Sheets & Excel"},"user":"5706caf0adbf4d1900caf110","updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-27T19:03:57.892Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":3,"body":"lockspring 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 \nHere is how you add a block to a spreadsheet:\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"1. Open the Blockspring plugin\"\n}\n[/block]\nIn Google Sheets, this is in the top toolbar under \"Add-ons\".  In Excel, this is in the top toolbar under \"Blockspring\". Log-in to Blockspring if needed.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"2. Click the \\\"Add Block\\\" button\"\n}\n[/block]\nThere is a green \"Add Block\" button near the top-right of the Blockspring plugin.  Click this.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"3. Choose a block to add\"\n}\n[/block]\nYou can search or click a company to view their blocks.  When you have found a block to add, click on it and you will see a page with its title, description, a form for filling out its inputs, and an insert button.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"4. Fill out the form for the block's inputs\"\n}\n[/block]\nOn a block's page, there is a form for the block's inputs.  Fill out each input or have the input reference a cell in your spreadsheet.  \n\nWhen an input references a cell, the block will use the data in your spreadsheet as an input.  If the data in the referenced cell changes, then next time the block runs it will use the new data.\n\nChanging a referenced cell will **not** cause the block to run again.  The block will only run again if \"run\" is clicked, or if the block is scheduled to run automatically. \n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"5. Click the \\\"Insert\\\" button\"\n}\n[/block]\nClick the green \"Insert\" button. The block will run and the results will be added to your sheet.\n\nThe results will be inserted in the currently selected cell.","excerpt":"","slug":"adding-a-block","type":"basic","title":"Adding a Block"}
lockspring 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). Here is how you add a block to a spreadsheet: [block:api-header] { "type": "basic", "title": "1. Open the Blockspring plugin" } [/block] In Google Sheets, this is in the top toolbar under "Add-ons". In Excel, this is in the top toolbar under "Blockspring". Log-in to Blockspring if needed. [block:api-header] { "type": "basic", "title": "2. Click the \"Add Block\" button" } [/block] There is a green "Add Block" button near the top-right of the Blockspring plugin. Click this. [block:api-header] { "type": "basic", "title": "3. Choose a block to add" } [/block] You can search or click a company to view their blocks. When you have found a block to add, click on it and you will see a page with its title, description, a form for filling out its inputs, and an insert button. [block:api-header] { "type": "basic", "title": "4. Fill out the form for the block's inputs" } [/block] On a block's page, there is a form for the block's inputs. Fill out each input or have the input reference a cell in your spreadsheet. When an input references a cell, the block will use the data in your spreadsheet as an input. If the data in the referenced cell changes, then next time the block runs it will use the new data. Changing a referenced cell will **not** cause the block to run again. The block will only run again if "run" is clicked, or if the block is scheduled to run automatically. [block:api-header] { "type": "basic", "title": "5. Click the \"Insert\" button" } [/block] Click the green "Insert" button. The block will run and the results will be added to your sheet. The results will be inserted in the currently selected cell.