Filters and Functions

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
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 ...
Thu, 19 Mar, 2020 at 7:50 AM
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