modules

@nishans/notion-formula / Exports

@nishans/notion-formula#

Index#

Interfaces#

Type aliases#

Variables#

Functions#

Type aliases#

AbsFunctionArrayCreateInput#

Ƭ AbsFunctionArrayCreateInput: [abs, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:83

AbsFunctionCreateInput#

Ƭ AbsFunctionCreateInput: IFunctionCreateInput<abs, [TNumberResultType]>

Defined in: types/formula-object.ts:78

AndFunctionArrayCreateInput#

Ƭ AndFunctionArrayCreateInput: [and, Tuple2<TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:58

AndFunctionCreateInput#

Ƭ AndFunctionCreateInput: IFunctionCreateInput<and, Tuple2<TCheckboxResultType>>

Defined in: types/formula-object.ts:58

AnyArrayResultType#

Ƭ AnyArrayResultType: TCheckboxArrayResultType | TTextArrayResultType | TNumberArrayResultType | TDateArrayResultType

Defined in: types/formula-array.ts:4

CbrtFunctionArrayCreateInput#

Ƭ CbrtFunctionArrayCreateInput: [cbrt, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:84

CbrtFunctionCreateInput#

Ƭ CbrtFunctionCreateInput: IFunctionCreateInput<cbrt, [TNumberResultType]>

Defined in: types/formula-object.ts:79

CeilFunctionArrayCreateInput#

Ƭ CeilFunctionArrayCreateInput: [ceil, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:85

CeilFunctionCreateInput#

Ƭ CeilFunctionCreateInput: IFunctionCreateInput<ceil, [TNumberResultType]>

Defined in: types/formula-object.ts:80

CheckboxIfFunctionArrayCreateInput#

Ƭ CheckboxIfFunctionArrayCreateInput: [if, Tuple12<TCheckboxArrayResultType, TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:26

CheckboxIfFunctionCreateInput#

Ƭ CheckboxIfFunctionCreateInput: IFunctionCreateInput<if, Tuple12<TCheckboxResultType, TCheckboxResultType>>

Defined in: types/formula-object.ts:30

ConcatFunctionArrayCreateInput#

Ƭ ConcatFunctionArrayCreateInput: [concat, TTextArrayResultType[]]

Defined in: types/formula-array.ts:48

ConcatFunctionCreateInput#

Ƭ ConcatFunctionCreateInput: IFunctionCreateInput<concat, TTextResultType[]>

Defined in: types/formula-object.ts:51

ContainsFunctionArrayCreateInput#

Ƭ ContainsFunctionArrayCreateInput: [contains, Tuple2<TTextArrayResultType>]

Defined in: types/formula-array.ts:72

ContainsFunctionCreateInput#

Ƭ ContainsFunctionCreateInput: IFunctionCreateInput<contains, Tuple2<TTextResultType>>

Defined in: types/formula-object.ts:72

DateAddFunctionArrayCreateInput#

Ƭ DateAddFunctionArrayCreateInput: [dateAdd, [TDateArrayResultType, TNumberArrayResultType, TDateConstantValueType]]

Defined in: types/formula-array.ts:98

DateAddFunctionCreateInput#

Ƭ DateAddFunctionCreateInput: IFunctionCreateInput<dateAdd, [TDateResultType, TNumberResultType, TDateConstantValueType]>

Defined in: types/formula-object.ts:93

DateBetweenFunctionArrayCreateInput#

Ƭ DateBetweenFunctionArrayCreateInput: [dateBetween, Tuple12<TDateArrayResultType, TDateConstantValueType>]

Defined in: types/formula-array.ts:106

DateBetweenFunctionCreateInput#

Ƭ DateBetweenFunctionCreateInput: IFunctionCreateInput<dateBetween, Tuple12<TDateResultType, TDateConstantValueType>>

Defined in: types/formula-object.ts:101

DateFunctionArrayCreateInput#

Ƭ DateFunctionArrayCreateInput: [date, [TDateArrayResultType]]

Defined in: types/formula-array.ts:117

DateFunctionCreateInput#

Ƭ DateFunctionCreateInput: IFunctionCreateInput<date, [TDateResultType]>

Defined in: types/formula-object.ts:111

DateIfFunctionArrayCreateInput#

Ƭ DateIfFunctionArrayCreateInput: [if, Tuple12<TCheckboxArrayResultType, TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:27

DateIfFunctionCreateInput#

Ƭ DateIfFunctionCreateInput: IFunctionCreateInput<if, Tuple12<TCheckboxResultType, TDateResultType>>

Defined in: types/formula-object.ts:34

DateSubtractFunctionArrayCreateInput#

Ƭ DateSubtractFunctionArrayCreateInput: [dateSubtract, [TDateArrayResultType, TNumberArrayResultType, TDateConstantValueType]]

Defined in: types/formula-array.ts:102

DateSubtractFunctionCreateInput#

Ƭ DateSubtractFunctionCreateInput: IFunctionCreateInput<dateSubtract, [TDateResultType, TNumberResultType, TDateConstantValueType]>

Defined in: types/formula-object.ts:97

DayFunctionArrayCreateInput#

Ƭ DayFunctionArrayCreateInput: [day, [TDateArrayResultType]]

Defined in: types/formula-array.ts:116

DayFunctionCreateInput#

Ƭ DayFunctionCreateInput: IFunctionCreateInput<day, [TDateResultType]>

Defined in: types/formula-object.ts:110

DivideFunctionArrayCreateInput#

Ƭ DivideFunctionArrayCreateInput: [divide, Tuple2<TNumberArrayResultType>]

Defined in: types/formula-array.ts:66

DivideFunctionCreateInput#

Ƭ DivideFunctionCreateInput: IFunctionCreateInput<divide, Tuple2<TNumberResultType>>

Defined in: types/formula-object.ts:66

EmptyFunctionArrayCreateInput#

Ƭ EmptyFunctionArrayCreateInput: [empty, [AnyArrayResultType]]

Defined in: types/formula-array.ts:82

EmptyFunctionCreateInput#

Ƭ EmptyFunctionCreateInput: IFunctionCreateInput<empty, [TResultType]>

Defined in: types/formula-object.ts:77

EndFunctionArrayCreateInput#

Ƭ EndFunctionArrayCreateInput: [end, [TDateArrayResultType]]

Defined in: types/formula-array.ts:97

EndFunctionCreateInput#

Ƭ EndFunctionCreateInput: IFunctionCreateInput<end, [TDateResultType]>

Defined in: types/formula-object.ts:92

EqualFunctionArrayCreateInput#

Ƭ EqualFunctionArrayCreateInput: [equal, Tuple2AnyArrayResultType]

Defined in: types/formula-array.ts:28

EqualFunctionCreateInput#

Ƭ EqualFunctionCreateInput: IFunctionCreateInput<equal, Tuple2AnyResultType>

Defined in: types/formula-object.ts:35

ExpFunctionArrayCreateInput#

Ƭ ExpFunctionArrayCreateInput: [exp, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:86

ExpFunctionCreateInput#

Ƭ ExpFunctionCreateInput: IFunctionCreateInput<exp, [TNumberResultType]>

Defined in: types/formula-object.ts:81

FloorFunctionArrayCreateInput#

Ƭ FloorFunctionArrayCreateInput: [floor, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:87

FloorFunctionCreateInput#

Ƭ FloorFunctionCreateInput: IFunctionCreateInput<floor, [TNumberResultType]>

Defined in: types/formula-object.ts:82

FormatDateFunctionArrayCreateInput#

Ƭ FormatDateFunctionArrayCreateInput: [formatDate, [TDateArrayResultType, TTextArrayResultType]]

Defined in: types/formula-array.ts:110

FormatDateFunctionCreateInput#

Ƭ FormatDateFunctionCreateInput: IFunctionCreateInput<formatDate, [TDateResultType, TTextResultType]>

Defined in: types/formula-object.ts:105

FormatFunctionArrayCreateInput#

Ƭ FormatFunctionArrayCreateInput: [format, [AnyArrayResultType]]

Defined in: types/formula-array.ts:57

FormatFunctionCreateInput#

Ƭ FormatFunctionCreateInput: IFunctionCreateInput<format, [TResultType]>

Defined in: types/formula-object.ts:57

FormulaArraySchemaUnitInput#

Ƭ FormulaArraySchemaUnitInput: { formula: TFormulaArrayCreateInput ; name: string ; type: formula }

Type declaration:#

NameType
formulaTFormulaArrayCreateInput
namestring
typeformula

Defined in: types/formula-array.ts:200

FormulaSchemaUnitInput#

Ƭ FormulaSchemaUnitInput: { formula: TFormulaCreateInput ; name: string ; type: formula }

Type declaration:#

NameType
formulaTFormulaCreateInput
namestring
typeformula

Defined in: types/formula-object.ts:197

FromTimestampFunctionArrayCreateInput#

Ƭ FromTimestampFunctionArrayCreateInput: [fromTimestamp, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:113

FromTimestampFunctionCreateInput#

Ƭ FromTimestampFunctionCreateInput: IFunctionCreateInput<fromTimestamp, [TNumberResultType]>

Defined in: types/formula-object.ts:107

HourFunctionArrayCreateInput#

Ƭ HourFunctionArrayCreateInput: [hour, [TDateArrayResultType]]

Defined in: types/formula-array.ts:115

HourFunctionCreateInput#

Ƭ HourFunctionCreateInput: IFunctionCreateInput<hour, [TDateResultType]>

Defined in: types/formula-object.ts:109

IFunctionForumlaSignature#

Ƭ IFunctionForumlaSignature: { arity?: TFormulaResultType[] ; result_type: TFormulaResultType ; variadic?: TFormulaResultType }

Type declaration:#

NameType
arity?TFormulaResultType[]
result_typeTFormulaResultType
variadic?TFormulaResultType

Defined in: utils/functionFormulaInfo.ts:3

ISchemaMap#

Ƭ ISchemaMap: Map<string, ISchemaMapValue>

Defined in: types/formula-object.ts:4

ISchemaMapValue#

Ƭ ISchemaMapValue: { schema_id: string } & TSchemaUnit

Defined in: types/formula-object.ts:3

JoinFunctionArrayCreateInput#

Ƭ JoinFunctionArrayCreateInput: [join, TTextArrayResultType[]]

Defined in: types/formula-array.ts:49

JoinFunctionCreateInput#

Ƭ JoinFunctionCreateInput: IFunctionCreateInput<join, TTextResultType[]>

Defined in: types/formula-object.ts:52

LargerEqFunctionArrayCreateInput#

Ƭ LargerEqFunctionArrayCreateInput: [largerEq, Tuple2<TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:61

LargerEqFunctionCreateInput#

Ƭ LargerEqFunctionCreateInput: IFunctionCreateInput<largerEq, Tuple2<TCheckboxResultType>>

Defined in: types/formula-object.ts:61

LargerFunctionArrayCreateInput#

Ƭ LargerFunctionArrayCreateInput: [larger, Tuple2<TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:60

LargerFunctionCreateInput#

Ƭ LargerFunctionCreateInput: IFunctionCreateInput<larger, Tuple2<TCheckboxResultType>>

Defined in: types/formula-object.ts:60

LengthFunctionArrayCreateInput#

Ƭ LengthFunctionArrayCreateInput: [length, [TTextArrayResultType]]

Defined in: types/formula-array.ts:120

LengthFunctionCreateInput#

Ƭ LengthFunctionCreateInput: IFunctionCreateInput<length, [TTextResultType]>

Defined in: types/formula-object.ts:114

LnFunctionArrayCreateInput#

Ƭ LnFunctionArrayCreateInput: [ln, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:88

LnFunctionCreateInput#

Ƭ LnFunctionCreateInput: IFunctionCreateInput<ln, [TNumberResultType]>

Defined in: types/formula-object.ts:83

Log10FunctionArrayCreateInput#

Ƭ Log10FunctionArrayCreateInput: [log10, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:89

Log10FunctionCreateInput#

Ƭ Log10FunctionCreateInput: IFunctionCreateInput<log10, [TNumberResultType]>

Defined in: types/formula-object.ts:84

Log2FunctionArrayCreateInput#

Ƭ Log2FunctionArrayCreateInput: [log2, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:90

Log2FunctionCreateInput#

Ƭ Log2FunctionCreateInput: IFunctionCreateInput<log2, [TNumberResultType]>

Defined in: types/formula-object.ts:85

MaxFunctionArrayCreateInput#

Ƭ MaxFunctionArrayCreateInput: [max, TNumberArrayResultType[]]

Defined in: types/formula-array.ts:91

MaxFunctionCreateInput#

Ƭ MaxFunctionCreateInput: IFunctionCreateInput<max, TNumberResultType[]>

Defined in: types/formula-object.ts:86

MinFunctionArrayCreateInput#

Ƭ MinFunctionArrayCreateInput: [min, TNumberArrayResultType[]]

Defined in: types/formula-array.ts:92

MinFunctionCreateInput#

Ƭ MinFunctionCreateInput: IFunctionCreateInput<min, TNumberResultType[]>

Defined in: types/formula-object.ts:87

MinuteFunctionArrayCreateInput#

Ƭ MinuteFunctionArrayCreateInput: [minute, [TDateArrayResultType]]

Defined in: types/formula-array.ts:114

MinuteFunctionCreateInput#

Ƭ MinuteFunctionCreateInput: IFunctionCreateInput<minute, [TDateResultType]>

Defined in: types/formula-object.ts:108

ModFunctionArrayCreateInput#

Ƭ ModFunctionArrayCreateInput: [mod, Tuple2<TNumberArrayResultType>]

Defined in: types/formula-array.ts:69

ModFunctionCreateInput#

Ƭ ModFunctionCreateInput: IFunctionCreateInput<mod, Tuple2<TNumberResultType>>

Defined in: types/formula-object.ts:69

MonthFunctionArrayCreateInput#

Ƭ MonthFunctionArrayCreateInput: [month, [TDateArrayResultType]]

Defined in: types/formula-array.ts:118

MonthFunctionCreateInput#

Ƭ MonthFunctionCreateInput: IFunctionCreateInput<month, [TDateResultType]>

Defined in: types/formula-object.ts:112

MultiplyFunctionArrayCreateInput#

Ƭ MultiplyFunctionArrayCreateInput: [multiply, Tuple2<TNumberArrayResultType>]

Defined in: types/formula-array.ts:67

MultiplyFunctionCreateInput#

Ƭ MultiplyFunctionCreateInput: IFunctionCreateInput<multiply, Tuple2<TNumberResultType>>

Defined in: types/formula-object.ts:67

NotFunctionArrayCreateInput#

Ƭ NotFunctionArrayCreateInput: [not, TCheckboxArrayResultType]

Defined in: types/formula-array.ts:64

NotFunctionCreateInput#

Ƭ NotFunctionCreateInput: IFunctionCreateInput<not, [TCheckboxResultType]>

Defined in: types/formula-object.ts:64

NowFunctionArrayCreateInput#

Ƭ NowFunctionArrayCreateInput: [now]

Defined in: types/formula-array.ts:122

NowFunctionCreateInput#

Ƭ NowFunctionCreateInput: { args?: [] ; function: now }

Type declaration:#

NameType
args?[]
functionnow

Defined in: types/formula-object.ts:116

NumberAddFunctionArrayCreateInput#

Ƭ NumberAddFunctionArrayCreateInput: [add, Tuple2<TNumberArrayResultType>]

Defined in: types/formula-array.ts:31

NumberAddFunctionCreateInput#

Ƭ NumberAddFunctionCreateInput: IFunctionCreateInput<add, Tuple2<TNumberResultType>>

Defined in: types/formula-object.ts:38

NumberIfFunctionArrayCreateInput#

Ƭ NumberIfFunctionArrayCreateInput: [if, Tuple12<TCheckboxArrayResultType, TNumberArrayResultType>]

Defined in: types/formula-array.ts:24

NumberIfFunctionCreateInput#

Ƭ NumberIfFunctionCreateInput: IFunctionCreateInput<if, Tuple12<TCheckboxResultType, TNumberResultType>>

Defined in: types/formula-object.ts:28

OrFunctionArrayCreateInput#

Ƭ OrFunctionArrayCreateInput: [or, Tuple2<TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:59

OrFunctionCreateInput#

Ƭ OrFunctionCreateInput: IFunctionCreateInput<or, Tuple2<TCheckboxResultType>>

Defined in: types/formula-object.ts:59

PowFunctionArrayCreateInput#

Ƭ PowFunctionArrayCreateInput: [pow, Tuple2<TNumberArrayResultType>]

Defined in: types/formula-array.ts:68

PowFunctionCreateInput#

Ƭ PowFunctionCreateInput: IFunctionCreateInput<pow, Tuple2<TNumberResultType>>

Defined in: types/formula-object.ts:68

ReplaceAllFunctionArrayCreateInput#

Ƭ ReplaceAllFunctionArrayCreateInput: [replaceAll, Tuple12<TNumberArrayResultType, TTextArrayResultType> | Tuple12<TTextArrayResultType, TTextArrayResultType> | Tuple12<TCheckboxArrayResultType, TTextArrayResultType>]

Defined in: types/formula-array.ts:32

ReplaceAllFunctionCreateInput#

Ƭ ReplaceAllFunctionCreateInput: IFunctionCreateInput<replaceAll, Tuple12<TNumberResultType, TTextResultType> | Tuple12<TTextResultType, TTextResultType> | Tuple12<TCheckboxResultType, TTextResultType>>

Defined in: types/formula-object.ts:39

ReplaceFunctionArrayCreateInput#

Ƭ ReplaceFunctionArrayCreateInput: [replace, Tuple12<TNumberArrayResultType, TTextArrayResultType> | Tuple12<TTextArrayResultType, TTextArrayResultType> | Tuple12<TCheckboxArrayResultType, TTextArrayResultType>]

Defined in: types/formula-array.ts:40

ReplaceFunctionCreateInput#

Ƭ ReplaceFunctionCreateInput: IFunctionCreateInput<replace, Tuple12<TNumberResultType, TTextResultType> | Tuple12<TTextResultType, TTextResultType> | Tuple12<TCheckboxResultType, TTextResultType>>

Defined in: types/formula-object.ts:45

RoundFunctionArrayCreateInput#

Ƭ RoundFunctionArrayCreateInput: [round, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:93

RoundFunctionCreateInput#

Ƭ RoundFunctionCreateInput: IFunctionCreateInput<round, [TNumberResultType]>

Defined in: types/formula-object.ts:88

SignFunctionArrayCreateInput#

Ƭ SignFunctionArrayCreateInput: [sign, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:94

SignFunctionCreateInput#

Ƭ SignFunctionCreateInput: IFunctionCreateInput<sign, [TNumberResultType]>

Defined in: types/formula-object.ts:89

SliceFunctionArrayCreateInput#

Ƭ SliceFunctionArrayCreateInput: [slice, [TTextArrayResultType, TNumberArrayResultType, TNumberArrayResultType] | [TTextArrayResultType, TNumberArrayResultType]]

Defined in: types/formula-array.ts:50

SliceFunctionCreateInput#

Ƭ SliceFunctionCreateInput: IFunctionCreateInput<slice, [TTextResultType, TNumberResultType, TNumberResultType] | [TTextResultType, TNumberResultType]>

Defined in: types/formula-object.ts:53

SmallerEqFunctionArrayCreateInput#

Ƭ SmallerEqFunctionArrayCreateInput: [smallerEq, Tuple2<TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:63

SmallerEqFunctionCreateInput#

Ƭ SmallerEqFunctionCreateInput: IFunctionCreateInput<smallerEq, Tuple2<TCheckboxResultType>>

Defined in: types/formula-object.ts:63

SmallerFunctionArrayCreateInput#

Ƭ SmallerFunctionArrayCreateInput: [smaller, Tuple2<TCheckboxArrayResultType>]

Defined in: types/formula-array.ts:62

SmallerFunctionCreateInput#

Ƭ SmallerFunctionCreateInput: IFunctionCreateInput<smaller, Tuple2<TCheckboxResultType>>

Defined in: types/formula-object.ts:62

SqrtFunctionArrayCreateInput#

Ƭ SqrtFunctionArrayCreateInput: [sqrt, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:95

SqrtFunctionCreateInput#

Ƭ SqrtFunctionCreateInput: IFunctionCreateInput<sqrt, [TNumberResultType]>

Defined in: types/formula-object.ts:90

StartFunctionArrayCreateInput#

Ƭ StartFunctionArrayCreateInput: [start, [TDateArrayResultType]]

Defined in: types/formula-array.ts:96

StartFunctionCreateInput#

Ƭ StartFunctionCreateInput: IFunctionCreateInput<start, [TDateResultType]>

Defined in: types/formula-object.ts:91

SubtractFunctionArrayCreateInput#

Ƭ SubtractFunctionArrayCreateInput: [subtract, Tuple2<TNumberArrayResultType>]

Defined in: types/formula-array.ts:65

SubtractFunctionCreateInput#

Ƭ SubtractFunctionCreateInput: IFunctionCreateInput<subtract, Tuple2<TNumberResultType>>

Defined in: types/formula-object.ts:65

TCheckboxArrayResultType#

Ƭ TCheckboxArrayResultType: boolean | TCheckboxFunctionArrayCreateInput | { property: string }

Defined in: types/formula-array.ts:19

TCheckboxFunctionArrayCreateInput#

Ƭ TCheckboxFunctionArrayCreateInput: CheckboxIfFunctionArrayCreateInput | EqualFunctionArrayCreateInput | UnequalFunctionArrayCreateInput | AndFunctionArrayCreateInput | OrFunctionArrayCreateInput | LargerFunctionArrayCreateInput | LargerEqFunctionArrayCreateInput | SmallerFunctionArrayCreateInput | SmallerEqFunctionArrayCreateInput | NotFunctionArrayCreateInput | EmptyFunctionArrayCreateInput | TestFunctionArrayCreateInput | ContainsFunctionArrayCreateInput

Defined in: types/formula-array.ts:134

TCheckboxFunctionCreateInput#

Ƭ TCheckboxFunctionCreateInput: CheckboxIfFunctionCreateInput | EqualFunctionCreateInput | UnequalFunctionCreateInput | AndFunctionCreateInput | OrFunctionCreateInput | LargerFunctionCreateInput | LargerEqFunctionCreateInput | SmallerFunctionCreateInput | SmallerEqFunctionCreateInput | NotFunctionCreateInput | EmptyFunctionCreateInput | TestFunctionCreateInput | ContainsFunctionCreateInput

Defined in: types/formula-object.ts:131

TCheckboxResultType#

Ƭ TCheckboxResultType: boolean | TCheckboxFunctionCreateInput | { property: string }

Defined in: types/formula-object.ts:18

TDateArrayResultType#

Ƭ TDateArrayResultType: TDateFunctionArrayCreateInput | { property: string }

Defined in: types/formula-array.ts:21

TDateFunctionArrayCreateInput#

Ƭ TDateFunctionArrayCreateInput: DateIfFunctionArrayCreateInput | FormatDateFunctionArrayCreateInput | DateSubtractFunctionArrayCreateInput | DateAddFunctionArrayCreateInput | NowFunctionArrayCreateInput | StartFunctionArrayCreateInput | EndFunctionArrayCreateInput | TimestampFunctionArrayCreateInput | FromTimestampFunctionArrayCreateInput | MinuteFunctionArrayCreateInput | HourFunctionArrayCreateInput | DayFunctionArrayCreateInput | DateFunctionArrayCreateInput | MonthFunctionArrayCreateInput | YearFunctionArrayCreateInput

Defined in: types/formula-array.ts:177

TDateFunctionCreateInput#

Ƭ TDateFunctionCreateInput: DateIfFunctionCreateInput | FormatDateFunctionCreateInput | DateSubtractFunctionCreateInput | DateAddFunctionCreateInput | NowFunctionCreateInput | StartFunctionCreateInput | EndFunctionCreateInput | TimestampFunctionCreateInput | FromTimestampFunctionCreateInput | MinuteFunctionCreateInput | HourFunctionCreateInput | DayFunctionCreateInput | DateFunctionCreateInput | MonthFunctionCreateInput | YearFunctionCreateInput

Defined in: types/formula-object.ts:174

TDateResultType#

Ƭ TDateResultType: TDateFunctionCreateInput | { property: string }

Defined in: types/formula-object.ts:20

TFormulaArrayCreateInput#

Ƭ TFormulaArrayCreateInput: TDateFunctionArrayCreateInput | TTextFunctionArrayCreateInput | TNumberFunctionArrayCreateInput | TCheckboxFunctionArrayCreateInput

Defined in: types/formula-array.ts:194

TFormulaCreateInput#

Ƭ TFormulaCreateInput: TDateFunctionCreateInput | TTextFunctionCreateInput | TNumberFunctionCreateInput | TCheckboxFunctionCreateInput

Defined in: types/formula-object.ts:191

TNumberArrayResultType#

Ƭ TNumberArrayResultType: e | pi | number | TNumberFunctionArrayCreateInput | { property: string }

Defined in: types/formula-array.ts:20

TNumberFunctionArrayCreateInput#

Ƭ TNumberFunctionArrayCreateInput: NumberAddFunctionArrayCreateInput | SubtractFunctionArrayCreateInput | DivideFunctionArrayCreateInput | MultiplyFunctionArrayCreateInput | PowFunctionArrayCreateInput | ModFunctionArrayCreateInput | UnaryMinusFunctionArrayCreateInput | UnaryPlusFunctionArrayCreateInput | NumberIfFunctionArrayCreateInput | DateBetweenFunctionArrayCreateInput | TimestampFunctionArrayCreateInput | SqrtFunctionArrayCreateInput | SignFunctionArrayCreateInput | RoundFunctionArrayCreateInput | MinFunctionArrayCreateInput | MaxFunctionArrayCreateInput | Log2FunctionArrayCreateInput | Log10FunctionArrayCreateInput | LnFunctionArrayCreateInput | FloorFunctionArrayCreateInput | ExpFunctionArrayCreateInput | CeilFunctionArrayCreateInput | CbrtFunctionArrayCreateInput | AbsFunctionArrayCreateInput | ToNumberFunctionArrayCreateInput | LengthFunctionArrayCreateInput

Defined in: types/formula-array.ts:149

TNumberFunctionCreateInput#

Ƭ TNumberFunctionCreateInput: NumberAddFunctionCreateInput | SubtractFunctionCreateInput | DivideFunctionCreateInput | MultiplyFunctionCreateInput | PowFunctionCreateInput | ModFunctionCreateInput | UnaryMinusFunctionCreateInput | UnaryPlusFunctionCreateInput | NumberIfFunctionCreateInput | DateBetweenFunctionCreateInput | TimestampFunctionCreateInput | SqrtFunctionCreateInput | SignFunctionCreateInput | RoundFunctionCreateInput | MinFunctionCreateInput | MaxFunctionCreateInput | Log2FunctionCreateInput | Log10FunctionCreateInput | LnFunctionCreateInput | FloorFunctionCreateInput | ExpFunctionCreateInput | CeilFunctionCreateInput | CbrtFunctionCreateInput | AbsFunctionCreateInput | ToNumberFunctionCreateInput | LengthFunctionCreateInput

Defined in: types/formula-object.ts:146

TNumberResultType#

Ƭ TNumberResultType: pi | e | number | TNumberFunctionCreateInput | { property: string }

Defined in: types/formula-object.ts:19

TResultType#

Ƭ TResultType: TCheckboxResultType | TTextResultType | TNumberResultType | TDateResultType

Defined in: types/formula-object.ts:7

TTextArrayResultType#

Ƭ TTextArrayResultType: string | TTextFunctionArrayCreateInput | { property: string }

Defined in: types/formula-array.ts:22

TTextFunctionArrayCreateInput#

Ƭ TTextFunctionArrayCreateInput: TextIfFunctionArrayCreateInput | TextAddFunctionArrayCreateInput | ReplaceAllFunctionArrayCreateInput | ReplaceFunctionArrayCreateInput | ConcatFunctionArrayCreateInput | JoinFunctionArrayCreateInput | SliceFunctionArrayCreateInput | FormatFunctionArrayCreateInput

Defined in: types/formula-array.ts:124

TTextFunctionCreateInput#

Ƭ TTextFunctionCreateInput: TextIfFunctionCreateInput | TextAddFunctionCreateInput | ReplaceAllFunctionCreateInput | ReplaceFunctionCreateInput | ConcatFunctionCreateInput | JoinFunctionCreateInput | SliceFunctionCreateInput | FormatFunctionCreateInput

Defined in: types/formula-object.ts:121

TTextResultType#

Ƭ TTextResultType: string | TTextFunctionCreateInput | { property: string }

Defined in: types/formula-object.ts:21

TestFunctionArrayCreateInput#

Ƭ TestFunctionArrayCreateInput: [test, [TNumberArrayResultType, TTextArrayResultType] | [TTextArrayResultType, TTextArrayResultType] | [TCheckboxArrayResultType, TTextArrayResultType]]

Defined in: types/formula-array.ts:73

TestFunctionCreateInput#

Ƭ TestFunctionCreateInput: IFunctionCreateInput<test, [TNumberResultType, TTextResultType] | [TTextResultType, TTextResultType] | [TCheckboxResultType, TTextResultType]>

Defined in: types/formula-object.ts:73

TextAddFunctionArrayCreateInput#

Ƭ TextAddFunctionArrayCreateInput: [add, Tuple2<TTextArrayResultType>]

Defined in: types/formula-array.ts:30

TextAddFunctionCreateInput#

Ƭ TextAddFunctionCreateInput: IFunctionCreateInput<add, Tuple2<TTextResultType>>

Defined in: types/formula-object.ts:37

TextIfFunctionArrayCreateInput#

Ƭ TextIfFunctionArrayCreateInput: [if, Tuple12<TCheckboxArrayResultType, TTextArrayResultType>]

Defined in: types/formula-array.ts:25

TextIfFunctionCreateInput#

Ƭ TextIfFunctionCreateInput: IFunctionCreateInput<if, Tuple12<TCheckboxResultType, TTextResultType>>

Defined in: types/formula-object.ts:29

TimestampFunctionArrayCreateInput#

Ƭ TimestampFunctionArrayCreateInput: [timestamp, [TDateArrayResultType]]

Defined in: types/formula-array.ts:112

TimestampFunctionCreateInput#

Ƭ TimestampFunctionCreateInput: IFunctionCreateInput<timestamp, [TDateResultType]>

Defined in: types/formula-object.ts:106

ToNumberFunctionArrayCreateInput#

Ƭ ToNumberFunctionArrayCreateInput: [toNumber, [AnyArrayResultType]]

Defined in: types/formula-array.ts:121

ToNumberFunctionCreateInput#

Ƭ ToNumberFunctionCreateInput: IFunctionCreateInput<toNumber, [TResultType]>

Defined in: types/formula-object.ts:115

UnaryMinusFunctionArrayCreateInput#

Ƭ UnaryMinusFunctionArrayCreateInput: [unaryMinus, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:70

UnaryMinusFunctionCreateInput#

Ƭ UnaryMinusFunctionCreateInput: IFunctionCreateInput<unaryMinus, [TNumberResultType]>

Defined in: types/formula-object.ts:70

UnaryPlusFunctionArrayCreateInput#

Ƭ UnaryPlusFunctionArrayCreateInput: [unaryPlus, [TNumberArrayResultType]]

Defined in: types/formula-array.ts:71

UnaryPlusFunctionCreateInput#

Ƭ UnaryPlusFunctionCreateInput: IFunctionCreateInput<unaryPlus, [TNumberResultType]>

Defined in: types/formula-object.ts:71

UnequalFunctionArrayCreateInput#

Ƭ UnequalFunctionArrayCreateInput: [unequal, Tuple2AnyArrayResultType]

Defined in: types/formula-array.ts:29

UnequalFunctionCreateInput#

Ƭ UnequalFunctionCreateInput: IFunctionCreateInput<unequal, Tuple2AnyResultType>

Defined in: types/formula-object.ts:36

YearFunctionArrayCreateInput#

Ƭ YearFunctionArrayCreateInput: [year, [TDateArrayResultType]]

Defined in: types/formula-array.ts:119

YearFunctionCreateInput#

Ƭ YearFunctionCreateInput: IFunctionCreateInput<year, [TDateResultType]>

Defined in: types/formula-object.ts:113

Variables#

function_formula_info_arr#

• Const function_formula_info_arr: IFunctionFormulaInfo[]

An array that contains the result_type and the variations of arguments (number and types) supported by all the notion formulas

Defined in: utils/functionFormulaInfo.ts:32

function_formula_info_map#

• Const function_formula_info_map: Map<TFunctionName, IFunctionFormulaInfo>

Defined in: utils/functionFormulaInfo.ts:327

Functions#

formulateResultTypeFromSchemaType#

â–¸ formulateResultTypeFromSchemaType(type: TSchemaUnitType): TFormulaResultType

Get the appropriate formula result_type from the passed schema_unit type

Parameters:#

NameTypeDescription
typeTSchemaUnitTypeThe schema_unit type

Returns: TFormulaResultType

The appropriate formula result_type

Defined in: utils/formulateResultTypeFromSchemaType.ts:8

generateFormulaASTFromArray#

â–¸ generateFormulaASTFromArray(formula: string | number | boolean | DateIfFunctionArrayCreateInput | FormatDateFunctionArrayCreateInput | DateSubtractFunctionArrayCreateInput | DateAddFunctionArrayCreateInput | NowFunctionArrayCreateInput | StartFunctionArrayCreateInput | EndFunctionArrayCreateInput | TimestampFunctionArrayCreateInput | FromTimestampFunctionArrayCreateInput | MinuteFunctionArrayCreateInput | HourFunctionArrayCreateInput | DayFunctionArrayCreateInput | DateFunctionArrayCreateInput | MonthFunctionArrayCreateInput | YearFunctionArrayCreateInput | TextIfFunctionArrayCreateInput | TextAddFunctionArrayCreateInput | ReplaceAllFunctionArrayCreateInput | ReplaceFunctionArrayCreateInput | ConcatFunctionArrayCreateInput | JoinFunctionArrayCreateInput | SliceFunctionArrayCreateInput | FormatFunctionArrayCreateInput | NumberAddFunctionArrayCreateInput | SubtractFunctionArrayCreateInput | DivideFunctionArrayCreateInput | MultiplyFunctionArrayCreateInput | PowFunctionArrayCreateInput | ModFunctionArrayCreateInput | UnaryMinusFunctionArrayCreateInput | UnaryPlusFunctionArrayCreateInput | NumberIfFunctionArrayCreateInput | DateBetweenFunctionArrayCreateInput | SqrtFunctionArrayCreateInput | SignFunctionArrayCreateInput | RoundFunctionArrayCreateInput | MinFunctionArrayCreateInput | MaxFunctionArrayCreateInput | Log2FunctionArrayCreateInput | Log10FunctionArrayCreateInput | LnFunctionArrayCreateInput | FloorFunctionArrayCreateInput | ExpFunctionArrayCreateInput | CeilFunctionArrayCreateInput | CbrtFunctionArrayCreateInput | AbsFunctionArrayCreateInput | ToNumberFunctionArrayCreateInput | LengthFunctionArrayCreateInput | CheckboxIfFunctionArrayCreateInput | EqualFunctionArrayCreateInput | UnequalFunctionArrayCreateInput | AndFunctionArrayCreateInput | OrFunctionArrayCreateInput | LargerFunctionArrayCreateInput | LargerEqFunctionArrayCreateInput | SmallerFunctionArrayCreateInput | SmallerEqFunctionArrayCreateInput | NotFunctionArrayCreateInput | EmptyFunctionArrayCreateInput | TestFunctionArrayCreateInput | ContainsFunctionArrayCreateInput | { property: string }, schema_map?: ISchemaMap): TFormula

Generates a notion client compatible formula object using an easier object based representation

Parameters:#

NameTypeDescription
formulastring | number | boolean | DateIfFunctionArrayCreateInput | FormatDateFunctionArrayCreateInput | DateSubtractFunctionArrayCreateInput | DateAddFunctionArrayCreateInput | NowFunctionArrayCreateInput | StartFunctionArrayCreateInput | EndFunctionArrayCreateInput | TimestampFunctionArrayCreateInput | FromTimestampFunctionArrayCreateInput | MinuteFunctionArrayCreateInput | HourFunctionArrayCreateInput | DayFunctionArrayCreateInput | DateFunctionArrayCreateInput | MonthFunctionArrayCreateInput | YearFunctionArrayCreateInput | TextIfFunctionArrayCreateInput | TextAddFunctionArrayCreateInput | ReplaceAllFunctionArrayCreateInput | ReplaceFunctionArrayCreateInput | ConcatFunctionArrayCreateInput | JoinFunctionArrayCreateInput | SliceFunctionArrayCreateInput | FormatFunctionArrayCreateInput | NumberAddFunctionArrayCreateInput | SubtractFunctionArrayCreateInput | DivideFunctionArrayCreateInput | MultiplyFunctionArrayCreateInput | PowFunctionArrayCreateInput | ModFunctionArrayCreateInput | UnaryMinusFunctionArrayCreateInput | UnaryPlusFunctionArrayCreateInput | NumberIfFunctionArrayCreateInput | DateBetweenFunctionArrayCreateInput | SqrtFunctionArrayCreateInput | SignFunctionArrayCreateInput | RoundFunctionArrayCreateInput | MinFunctionArrayCreateInput | MaxFunctionArrayCreateInput | Log2FunctionArrayCreateInput | Log10FunctionArrayCreateInput | LnFunctionArrayCreateInput | FloorFunctionArrayCreateInput | ExpFunctionArrayCreateInput | CeilFunctionArrayCreateInput | CbrtFunctionArrayCreateInput | AbsFunctionArrayCreateInput | ToNumberFunctionArrayCreateInput | LengthFunctionArrayCreateInput | CheckboxIfFunctionArrayCreateInput | EqualFunctionArrayCreateInput | UnequalFunctionArrayCreateInput | AndFunctionArrayCreateInput | OrFunctionArrayCreateInput | LargerFunctionArrayCreateInput | LargerEqFunctionArrayCreateInput | SmallerFunctionArrayCreateInput | SmallerEqFunctionArrayCreateInput | NotFunctionArrayCreateInput | EmptyFunctionArrayCreateInput | TestFunctionArrayCreateInput | ContainsFunctionArrayCreateInput | { property: string }The simple array representation of the formula
schema_map?ISchemaMapA specific schema map of the collection used to reference properties used inside the formula

Returns: TFormula

The generated formula ast

Defined in: src/generateFormulaAST.ts:107

generateFormulaASTFromObject#

â–¸ generateFormulaASTFromObject(formula: string | number | boolean | DateIfFunctionCreateInput | FormatDateFunctionCreateInput | DateSubtractFunctionCreateInput | DateAddFunctionCreateInput | NowFunctionCreateInput | StartFunctionCreateInput | EndFunctionCreateInput | TimestampFunctionCreateInput | FromTimestampFunctionCreateInput | MinuteFunctionCreateInput | HourFunctionCreateInput | DayFunctionCreateInput | DateFunctionCreateInput | MonthFunctionCreateInput | YearFunctionCreateInput | TextIfFunctionCreateInput | TextAddFunctionCreateInput | ReplaceAllFunctionCreateInput | ReplaceFunctionCreateInput | ConcatFunctionCreateInput | JoinFunctionCreateInput | SliceFunctionCreateInput | FormatFunctionCreateInput | NumberAddFunctionCreateInput | SubtractFunctionCreateInput | DivideFunctionCreateInput | MultiplyFunctionCreateInput | PowFunctionCreateInput | ModFunctionCreateInput | UnaryMinusFunctionCreateInput | UnaryPlusFunctionCreateInput | NumberIfFunctionCreateInput | DateBetweenFunctionCreateInput | SqrtFunctionCreateInput | SignFunctionCreateInput | RoundFunctionCreateInput | MinFunctionCreateInput | MaxFunctionCreateInput | Log2FunctionCreateInput | Log10FunctionCreateInput | LnFunctionCreateInput | FloorFunctionCreateInput | ExpFunctionCreateInput | CeilFunctionCreateInput | CbrtFunctionCreateInput | AbsFunctionCreateInput | ToNumberFunctionCreateInput | LengthFunctionCreateInput | CheckboxIfFunctionCreateInput | EqualFunctionCreateInput | UnequalFunctionCreateInput | AndFunctionCreateInput | OrFunctionCreateInput | LargerFunctionCreateInput | LargerEqFunctionCreateInput | SmallerFunctionCreateInput | SmallerEqFunctionCreateInput | NotFunctionCreateInput | EmptyFunctionCreateInput | TestFunctionCreateInput | ContainsFunctionCreateInput | { property: string }, schema_map?: ISchemaMap): TFormula

Generates a notion client compatible formula object using an easier object based representation

Parameters:#

NameTypeDescription
formulastring | number | boolean | DateIfFunctionCreateInput | FormatDateFunctionCreateInput | DateSubtractFunctionCreateInput | DateAddFunctionCreateInput | NowFunctionCreateInput | StartFunctionCreateInput | EndFunctionCreateInput | TimestampFunctionCreateInput | FromTimestampFunctionCreateInput | MinuteFunctionCreateInput | HourFunctionCreateInput | DayFunctionCreateInput | DateFunctionCreateInput | MonthFunctionCreateInput | YearFunctionCreateInput | TextIfFunctionCreateInput | TextAddFunctionCreateInput | ReplaceAllFunctionCreateInput | ReplaceFunctionCreateInput | ConcatFunctionCreateInput | JoinFunctionCreateInput | SliceFunctionCreateInput | FormatFunctionCreateInput | NumberAddFunctionCreateInput | SubtractFunctionCreateInput | DivideFunctionCreateInput | MultiplyFunctionCreateInput | PowFunctionCreateInput | ModFunctionCreateInput | UnaryMinusFunctionCreateInput | UnaryPlusFunctionCreateInput | NumberIfFunctionCreateInput | DateBetweenFunctionCreateInput | SqrtFunctionCreateInput | SignFunctionCreateInput | RoundFunctionCreateInput | MinFunctionCreateInput | MaxFunctionCreateInput | Log2FunctionCreateInput | Log10FunctionCreateInput | LnFunctionCreateInput | FloorFunctionCreateInput | ExpFunctionCreateInput | CeilFunctionCreateInput | CbrtFunctionCreateInput | AbsFunctionCreateInput | ToNumberFunctionCreateInput | LengthFunctionCreateInput | CheckboxIfFunctionCreateInput | EqualFunctionCreateInput | UnequalFunctionCreateInput | AndFunctionCreateInput | OrFunctionCreateInput | LargerFunctionCreateInput | LargerEqFunctionCreateInput | SmallerFunctionCreateInput | SmallerEqFunctionCreateInput | NotFunctionCreateInput | EmptyFunctionCreateInput | TestFunctionCreateInput | ContainsFunctionCreateInput | { property: string }The simple object representation of the formula
schema_map?ISchemaMapA specific schema map of the collection used to reference properties used inside the formula

Returns: TFormula

The generated formula ast

Defined in: src/generateFormulaAST.ts:97

generateFormulaASTFromString#

â–¸ generateFormulaASTFromString(formula: string, schema_map?: ISchemaMap): TFormula

Generate notion client compatible formula ast from string

Parameters:#

NameTypeDescription
formulastringThe formula string required to be parsed
schema_map?ISchemaMapThe schema_map used to resolve property reference

Returns: TFormula

Notion compatible formula ast

Defined in: src/generateFormulaASTFromString.ts:11

generateFormulaArgFromProperty#

â–¸ generateFormulaArgFromProperty(arg: { property: string }, schema_map: ISchemaMap): TPropertyFormula

Generate function formula argument using information from the passed schema_map

Parameters:#

NameTypeDescription
arg{ property: string }A object with the key property and value matching the name of the property referencing
schema_mapISchemaMapThe schema map used to deduce information for the function formula argument chunk

Returns: TPropertyFormula

The appropriate property based function formula argument chunk

Defined in: utils/generateFormulaArgs.ts:52

generateFormulaArgsFromLiterals#

â–¸ generateFormulaArgsFromLiterals(value: string | number | boolean): INumberConstantFormula<string> | ITextConstantFormula<string> | ISymbolFormula<e, number> | ISymbolFormula<pi, number> | ISymbolFormula<true, checkbox> | ISymbolFormula<false, checkbox>

Generate function formula arg based on certain criterias

Parameters:#

NameTypeDescription
valuestring | number | booleanThe value to check

Returns: INumberConstantFormula<string> | ITextConstantFormula<string> | ISymbolFormula<e, number> | ISymbolFormula<pi, number> | ISymbolFormula<true, checkbox> | ISymbolFormula<false, checkbox>

The appropriate function formula argument chunk

Defined in: utils/generateFormulaArgs.ts:10

Edit this page