Filters and Functions

Advanced Operators and Expressions Guide
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
Relevancy Guide
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
Formula Reference
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
Filters
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 to Knackly Functions
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
Math Functions
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 Guide
Order of Operations:    Precedence Operators Examples 1 Parentheses: "( )" (Var1 + Var2)   If (NumVar1 + NumVar2) * NumVar3, N...
Thu, 27 Feb, 2020 at 9:31 AM
Text Functions
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
Finance Functions
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
Date Calculations
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