{"__v":0,"_id":"582df8bd4516e80f009e73d8","category":{"__v":30,"_id":"5434918d0ef9c008001651ff","pages":["5435626c5ff8a51a006e4110","543553953513400800a14736","543555cc3513400800a14752","54355bcc35740020002a1b3b","5434928b0ef9c0080016520e","54347c8e5b10711400c6c30a","54346f750ef9c00800164fa0","543470f45b10711400c6c1e5","543477b70ef9c0080016505b","543478fb5b10711400c6c29f","54347d105b10711400c6c318","54347df00ef9c008001650d2","54347edf5b10711400c6c336","54357a175e1b2020004380dc","543483520ef9c0080016512a","543484820ef9c0080016513a","5434887e5b10711400c6c3cd","543488c05b10711400c6c3d2","54348ac85b10711400c6c401","5434959c0ef9c0080016522d","543497030ef9c00800165244","543498ae5b10711400c6c4f6","54349b7f0ef9c00800165293","54349c070ef9c00800165298","54349dbf0ef9c008001652ad","5434ab8e0ef9c00800165384","5434abbb0ef9c0080016538f","5434ac495b10711400c6c626","5434ada40ef9c008001653a8","5434af0a0ef9c008001653bc","5434af5f0ef9c008001653c8","5434b00a5b10711400c6c66b","5434b0d15b10711400c6c68c","5434b1ee0ef9c00800165406","5434b26d0ef9c0080016541c","5434b3560ef9c00800165427","5434b3b40ef9c0080016545a","5434b49f008ec22200d86ab9","5434b51f008ec22200d86aca","5434b5a80ef9c0080016546f","5434b5f4008ec22200d86ad8","5434b676008ec22200d86add","5434b6e6008ec22200d86ae5"],"project":"543469460ef9c00800164f0e","version":"54346a2a0ef9c00800164f28","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2014-10-08T01:21:17.804Z","from_sync":false,"order":1,"slug":"rest-api","title":"REST API"},"parentDoc":null,"project":"543469460ef9c00800164f0e","user":"543469060ef9c00800164f01","version":{"__v":7,"_id":"54346a2a0ef9c00800164f28","forked_from":"543469460ef9c00800164f11","project":"543469460ef9c00800164f0e","createdAt":"2014-10-07T22:33:14.982Z","releaseDate":"2014-10-07T22:33:14.982Z","categories":["54346a2b0ef9c00800164f29","543473445b10711400c6c21a","543473500ef9c00800164fde","54347c625b10711400c6c301","5434918d0ef9c008001651ff","5434b72c008ec22200d86ae7","5435990c495d5d0800f3a510"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"2.0.0","version":"2.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-11-17T18:36:45.402Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":54,"body":"Our number fields support providing a default value using a calculation. All field endpoints that accept or return data use the `calculation` property. The data passed in the `calculation` property must follow the below format.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Supported Symbols\"\n}\n[/block]\nOur calculations support a limited number of symbols along with numbers. All symbols in our calculations should contain white spaces before and after the symbol with the exception of the field brackets which should not contain spaces between the brackets and the field ID.\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Symbol\",\n    \"h-1\": \"Example\",\n    \"0-0\": \"`+`, `-`, `/`, `*`\",\n    \"0-1\": \"`( [FieldID] + 3 ) - ( [FieldID] / [FieldID] ) * 5.3`\",\n    \"1-0\": \"`(`, `)`\",\n    \"1-1\": \"`( [FieldID] * 10 ) / [FieldID]`\",\n    \"2-0\": \"`[FieldID]`\",\n    \"2-1\": \"`[12345] + [12346]`\"\n  },\n  \"cols\": 2,\n  \"rows\": 3\n}\n[/block]\nWhile we do our best to normalize whitespace in the string you send us to convert it into the format above, it's best to follow the format to avoid an incorrect calculation value being stored based on that normalization.","excerpt":"","slug":"field-calculations","type":"basic","title":"Field Calculations"}

Field Calculations


Our number fields support providing a default value using a calculation. All field endpoints that accept or return data use the `calculation` property. The data passed in the `calculation` property must follow the below format. [block:api-header] { "type": "basic", "title": "Supported Symbols" } [/block] Our calculations support a limited number of symbols along with numbers. All symbols in our calculations should contain white spaces before and after the symbol with the exception of the field brackets which should not contain spaces between the brackets and the field ID. [block:parameters] { "data": { "h-0": "Symbol", "h-1": "Example", "0-0": "`+`, `-`, `/`, `*`", "0-1": "`( [FieldID] + 3 ) - ( [FieldID] / [FieldID] ) * 5.3`", "1-0": "`(`, `)`", "1-1": "`( [FieldID] * 10 ) / [FieldID]`", "2-0": "`[FieldID]`", "2-1": "`[12345] + [12346]`" }, "cols": 2, "rows": 3 } [/block] While we do our best to normalize whitespace in the string you send us to convert it into the format above, it's best to follow the format to avoid an incorrect calculation value being stored based on that normalization.