Filters and Functions
Expressions are used in Knackly for formulas and logic. The concept of expressions was introduced at the end of the Knackly Bootcamp guide; please refer to ...
Wed, 3 Jan, 2024 at 4:08 PM
Relevance: Relevance is the property of a variable that makes it visible in the Knackly interview – i.e., a relevant variable is one the end-user can see a...
Thu, 19 Mar, 2020 at 8:08 AM
Formulas in Knackly can be thought of as "named expressions": with a formula, you can do anything you can do in an expression, but you can attach...
Thu, 27 Feb, 2020 at 5:11 PM
FilterParametersExampleThis example…Converts…To…Notesupper(none)TextVar | upperFormats TextVar in all upper casetexttextConverts any text value to all upper ...
Thu, 12 Sep, 2019 at 10:13 AM
HotDocs Function Native JavaScript equivalent Knackly Equivalent TEXT + TEXT text + text FIRST( TEXT, NUM ) text.substring(0, num...
Thu, 2 Apr, 2020 at 9:21 AM
mathconstantstype Enumhttps://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Math/E LN2numhttps://developer.mozilla.org/en-US/docs...
Wed, 7 Aug, 2019 at 4:17 PM
Order of Operations: Precedence Operators Examples 1 Parentheses: "( )" (Var1 + Var2) If (NumVar1 + NumVar2) * NumVar3, N...
Thu, 27 Feb, 2020 at 9:31 AM
textinstance propertiestype related documentation lengthnum https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/leng...
Wed, 7 Aug, 2019 at 4:18 PM
Financehelper methodsresult typeparameters PMTnumberrate, nper, pv, fv = 0, type = 0https://exceljet.net/excel-functions/excel-pmt-function PVnumberrate, np...
Wed, 7 Aug, 2019 at 4:20 PM
helper methodsresult typeparameters parsedatetext or number https://date-fns.org/v1.30.1/docs/parsetodaydate https://date-fns.org/v1.30.1/docs/startOfToday...
Wed, 21 Aug, 2019 at 8:47 AM