Formula functions ver 2.0
๐
Formula functions ver 2.0ๅๅ
่ชฌๆ
ๆณจ่จ (ๅคๆด็น)
้ขๆฐๅฝขๅผใฎๆๆณ(ๆผ็ฎๅญใๅซใ)
ใกใฝใใๅฝขๅผใฎๆๆณ
ๆผ็ฎๅญๅฝขๅผใฎๆๆณ
ๅ
ฅๅใฎๅ
่ฟใๅคใฎๅ
Formula 2.0
้ๅผใ Formula ๅฉ็จไพ
(-) 2ใคใฎๆฐๅคใๆธ็ฎใใพใใ
(subtract) 2ใคใฎๆฐๅคใฎๅทฎใ่ฟใใพใใ
Formula 1.0 ใฎ subtract ใฏ่ชๅ็ใซ - ใซๅคๆใใใพใ(subtract ใๆฎใฃใฆใใพใ)ใ
subtract(arg1, arg2)
arg1.subtract(arg2)
arg1 - arg2
Number
Number
Formula 2.0
ใใงใใฏใใใฏในใฎๅคใฎๅๅฏพใ่ฟใใพใใ
Formula 1.0 ใฎ้ขๆฐใฏ ! ใซๅคๆใใใพใ(not ใๆฎใฃใฆใใพใ)ใ
! arg1 ใพใใฏ not arg1
String
Number
Date
Checkbox
List
Checkbox
Checkbox
Formula 2.0
(!=) 2ใคใฎๅคใ็ญใใใชใใใฉใใใ็ขบ่ชใใพใใ
(unequal) ไธกๆนใฎๅคใ็ญใใๅ ดๅใฏfalseใ่ฟใใใใใงใชใๅ ดๅใฏtrueใ่ฟใใพใใ
Formula 1.0 ใฎ้ขๆฐใฏ != ใซๅคๆใใใพใ(unequal ใๆฎใฃใฆใใพใ)ใ
unequal(arg1, arg2)
arg1.unequal(arg2)
arg1 != arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ๆกไปถใtrueใฎๅ ดๅใฏๆๅใฎๅคใ่ฟใใพใใใใใงใชใๅ ดๅใฏ2็ช็ฎใฎๅคใ่ฟใใพใใ
if(condition, value_when_true, value_when_false)
condition.if(value_when_true, value_when_false)
condition ? value_when_true : value_when_false
Condition
Number
String
Date
Checkbox
List
Number
String
Date
Checkbox
List
(*) 2ใคใฎๆฐๅคใไน็ฎใใพใใ
(multiply) 2ใคใฎๆฐๅคใฎ็ฉใ่ฟใใพใใ
Formula 1.0 ใฎ multiply ใฏ่ชๅ็ใซ * ใซๅคๆใใใพใ(multiply ใๆฎใฃใฆใใพใ)ใ
multiply(arg1, arg2)
arg1.multiply(arg2)
arg1 * arg2
Number
Number
Formula 2.0
(/) 2ใคใฎๆฐๅคใ้ค็ฎใใพใใ
(divide) 2 ใคใฎๆฐๅคใฎๅใ่ฟใใพใใ
Formula 1.0 ใฎ divide ใฏ่ชๅ็ใซ / ใซๅคๆใใใพใ(divide ใๆฎใฃใฆใใพใ)ใ
divide(arg1, arg2)
arg1.divide(arg2)
arg1 / arg2
Number
Number
Formula 2.0
ใใงใใฏใใใฏในๆผ็ฎๅญใใใณใ
Formula 1.0 ใฎ and้ขๆฐใฏ and ๆผ็ฎๅญใซๅคๆใใใพใ(and ้ขๆฐใไบๆๆงใฎใใใซๆฎใใใพใใ)
and(cond1, cond2)
cond1.and(cond2)
cond1 and cond2 ใพใใฏ cond1 && cond2
Checkbox
Checkbox
Formula 2.0
ๆๅใฎๆฐๅคใ2็ช็ฎใฎๆฐๅคใงๅฒใฃใไฝใใ่ฟใใพใใ
Formula 1.0 ใฎ mod ใฏ่ชๅ็ใซ % ใซๅคๆใใใพใ(mod ใไบๆๆงใฎใใใซ)ใ
mod(arg1, arg2)
arg1.mod(arg2)
arg1 % arg2
Number
Number
ๅบๆฐใฎในใไนใฎ็ตๆใ่ฟใใพใใ
Formula 1.0 ใฎpow ใฏ่ชๅ็ใซ ^ ใซๅคๆใใใพใ(pow ใๆฎใฃใฆใใพใ)ใ
pow(arg1, arg2)
arg1.pow(arg2)
arg1 ^ arg2
Number
Number
(+) 2 ใคใฎๅคใๅ ็ฎใใพใใ
(add) 2ใคใฎๆฐๅคใๅ ็ฎใใฆใๅ่จใ่ฟใใพใใ
Formula 1.0 ใฎ้ขๆฐใฏ + ใซๅคๆใใใพใใๆๅญๅใฎaddใฏใชใใชใใพใใใ+ ใไฝฟใฃใฆใใ ใใ(ๆฐๅคใซๅฏพใใ add ใฎใฟๆฎใฃใฆใใพใ)ใ
add(arg1, arg2)
arg1.add(arg2)
Number
Number
Formula 2.0
ๆๅใฎๅคใ2็ช็ฎใฎๅคใใๅฐใใใใฉใใใ็ขบ่ชใใพใใ
Formula 1.0 ใฎ smaller ใฏ่ชๅ็ใซ < ใซๅคๆใใใพใใ
arg1 < arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ๆๅใฎๅคใ2็ช็ฎใฎๅคไปฅไธใใฉใใใ็ขบ่ชใใพใใ
Formula 1.0 ใฎ smallerEq ใฏ่ชๅ็ใซ <= ใซๅคๆใใใพใใ
arg1 < arg2
Number
String
Date
Checkbox
Checkbox
Checkbox
Formula 2.0
(==) 2ใคใฎๅคใ็ญใใใใฉใใใ็ขบ่ชใใพใใ
(equal) ไธกๆนใฎๅคใ็ญใใๅ ดๅใฏtrueใ่ฟใใใใใงใชใๅ ดๅใฏfalseใ่ฟใใพใใ
Formula 1.0 ใฎ equal ใฏ่ชๅ็ใซ == ใซๅคๆใใใพใ(equal ใๆฎใฃใฆใใพใ)ใ
equal(arg1, arg2)
arg1.equal(arg2)
arg1 == arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ๆๅใฎๅคใ2็ช็ฎใฎๅคใใๅคงใใใใฉใใใ็ขบ่ชใใพใใ
Formula 1.0 ใฎ larger ใฏ่ชๅ็ใซ > ใซๅคๆใใใพใใ
arg1 > arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ๆๅใฎๅคใ2็ช็ฎใฎๅคไปฅไธใใฉใใใ็ขบ่ชใใพใใ
Formula 1.0 ใฎ largerEq ใฏ่ชๅ็ใซ >= ใซๅคๆใใใพใใ
arg1 >= arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ใใงใใฏใใใฏในๆผ็ฎๅญใพใใฏใ
Formula 1.0 ใฎ or ้ขๆฐใฏ or ๆผ็ฎๅญใซๅคๆใใใพใ(or ้ขๆฐใไบๆๆงใฎใใใซๆฎใใใพใใ)
cond1 or cond2 ใพใใฏ cond1 || cond2
Checkbox
Checkbox
Formula 2.0
(+) 2 ใคใฎๅคใๅ ็ฎใใพใใ
(add) 2ใคใฎๆฐๅคใๅ ็ฎใใฆใๅ่จใ่ฟใใพใใ
Formula 1.0 ใฎ้ขๆฐใฏ + ใซๅคๆใใใพใใๆๅญๅใฎaddใฏใชใใชใใพใใใ+ ใไฝฟใฃใฆใใ ใใ(ๆฐๅคใซๅฏพใใ add ใฎใฟๆฎใฃใฆใใพใ)ใ
add(arg1, arg2)
arg1.add(arg2)
arg1 + arg2
Number
String
Number
String
Formula 2.0
ใใงใใฏใใใฏในๆผ็ฎๅญใใใณใ
and ใฏ้ขๆฐใงใฏใชใๆผ็ฎๅญใซใชใใพใใใ
cond1 and cond2 ใพใใฏ cond1 && cond2
Checkbox
Checkbox
Formula 2.0
ใชในใๅ
ใฎๆๅฎใใใใคใณใใใฏในใฎๅคใ่ฟใใพใใ
at(list, index)
list.at(index)
List
Number
Number
Date
String
Checkbox
Formula 2.0
2ใคใฎใชในใใ้ฃ็ตใใใชในใใ่ฟใใพใใ
ใใฎ้ขๆฐใฏใชในใใๅผๆฐใซๅใๅใใใใซใชใใพใใใFormula 1.0 ใฎ้ขๆฐใฏ + ใจ format ใฎ็ตใฟๅใใใซๅคๆใใใพใใ
concat(list1, list2)
list1.concat(list2)
List
List
Formula 2.0
ๆค็ดขๆๅญๅใๅคใซๅญๅจใใๅ ดๅใฏtrueใ่ฟใใพใใ
ใใใใฏใชในใใฎไธญใซๅคใๅซใพใใๅ ดๅใซใ true ใ่ฟใใพใใ
contains(string, sub)
contains(list, value)
string.contains(sub)
list.contains(value)
String
List
String
Date
Number
Checkbox
Formula 2.0
ๆฅไป๏ผ1๏ฝ31๏ผใใๆใฎๆฅไปใ่ฟใใพใใ
(็ฟป่จณใใน) ๆฅไปใใๆใฎๆฅไป๏ผ1๏ฝ31๏ผใ่ฟใใพใใ
date(arg)
arg.date()
Date
Number
ๆฅไปใซๆ้ใ่ฟฝๅ ใใพใใๆๅพใฎๅผๆฐใฏใ"years"ใ"quarters"ใ"months"ใ"weeks"ใ"days"ใ"hours"ใ"minutes" ใฎใใใใใฎๅไฝใๆๅฎใใพใใ
dateAdd(date, value, unit)
date.dateAdd(value, unit)
Date
Number
String
Date
2ใคใฎๆฅไปใฎๅทฎใใใช็งๅไฝใง่จ็ฎใใพใใๆๅพใฎๅผๆฐใฏใ"years"ใ"quarters"ใ"months"ใ"weeks"ใ"days"ใ"hours"ใ"minutes" ใฎใใใใใฎๅไฝใๆๅฎใใพใใ
dateBetween(date1, date2, unit)
date1.dateBetween(date2, unit)
Date
String
Number
ๆฅไป็ฏๅฒใฎ็ตใใใ่ฟใใพใใ
Formula 1.0 ใงใฏ end() ใงใใใend้ขๆฐใ่จ่ฟฐใใใจใใendใๅฎ็พฉใใใฆใใพใใใ[0,3]้ขๆฐใend()ใใฏใdateEnd()ใใซๅๅใๅคๆดใใใพใใใใใจ่กจ็คบใใใพใใ
dateEnd(date)
date.dateEnd()
Date
Date
Formula 2.0
้ๅงๆฅใจ็ตไบๆฅใใๆง็ฏใใใๆฅไป็ฏๅฒใ่ฟใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
dateRange(arg1, arg2)
arg1.dateRange(arg2)
Date
Date
Formula 2.0
ๆฅไป็ฏๅฒใฎๅงใใ่ฟใใพใใ
Formula 1.0 ใงใฏ start() ใงใใใstart้ขๆฐใ่จ่ฟฐใใใจใใstartใๅฎ็พฉใใใฆใใพใใใ[0,5]้ขๆฐใstart()ใใฏใdateStart()ใใซๅๅใๅคๆดใใใพใใใใใจ่กจ็คบใใใพใใ
dateStart(date)
date.dateStart()
Date
Date
Formula 2.0
ๆฅไปใใๆ้ใๅผใใพใใๆๅพใฎๅผๆฐใฏใ"years"ใ"quarters"ใ"months"ใ"weeks"ใ"days"ใ"hours"ใ"minutes" ใฎใใใใใฎๅไฝใๆๅฎใใพใใ
dateSubtract(date1, date2, unit)
date1.dateSubtract(date2, unit)
Date
Number
String
Date
ๆฅไปใฎๆๆฅใ1๏ผๆๆๆฅ๏ผใใ7๏ผๆฅๆๆฅ๏ผใพใงใฎๆฐๅคใง่ฟใใพใใ
Formula 1.0 ใงใฏๆฅๆๆฅใฏ 0 ใงใใใFormula 1.0 ใใๅคๆใใใจ % 7 ใฎๅฆ็ใ่ฟฝๅ ใใใพใใ
day(date)
date.day()
Date
Number
(/) 2ใคใฎๆฐๅคใ้ค็ฎใใพใใ
(divide) 2 ใคใฎๆฐๅคใฎๅใ่ฟใใพใใ
Formula 1.0 ใฎ divide ใฏ่ชๅ็ใซ / ใซๅคๆใใใพใ(divide ใๆฎใฃใฆใใพใ)ใ
divide(arg1, arg2)
arg1.divide(arg2)
arg1 / arg2
Number
Number
Formula 2.0
่ช็ถๅฏพๆฐใฎๅบใ่ฟใใพใใ
eใฏๅฎๆฐใงใฏใชใ้ขๆฐใซใชใใพใใใe ใฎใฟใ่จ่ฟฐใใใจใ้ขๆฐe()ใฎๅผใณๅบใใๅฟ
่ฆใงใใ[0,1]ใใจ่กจ็คบใใใพใใ
e()
ใชใ
Number
Formula 2.0
ๅคใ็ฉบใฎๅ ดๅใฏtrueใ่ฟใใพใใ0ใโโใ[]ใฏ็ฉบใจใฟใชใใใพใใ
Formula 2.0 ใงใฏใชในใใๅใๅใใใใซใชใใพใใใ
empty(value)
value.empty()
Number
String
Date
Checkbox
List
Checkbox
Formula 2.0
(==) 2ใคใฎๅคใ็ญใใใใฉใใใ็ขบ่ชใใพใใ
(equal) ไธกๆนใฎๅคใ็ญใใๅ ดๅใฏtrueใ่ฟใใใใใงใชใๅ ดๅใฏfalseใ่ฟใใพใใ
Formula 1.0 ใฎ equal ใฏ่ชๅ็ใซ == ใซๅคๆใใใพใ(equal ใๆฎใฃใฆใใพใ)ใ
equal(arg1, arg2)
arg1.equal(arg2)
arg1 == arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ใชในใๅ
ใฎใในใฆใฎ้
็ฎใๆๅฎใใใๆกไปถใๆบใใๅ ดๅใฏtrueใ่ฟใใใใใงใชใๅ ดๅใฏfalseใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
every(list, currentValue = value)
list.every(currentValue = value)
List
Condition
Checkbox
Formula 2.0
e^xใ่ฟใใพใใxใฏๅผๆฐใeใฏ่ช็ถๅฏพๆฐใฎๅบใงใใใชใคใฉใผๆฐ๏ผ2.718โฆ๏ผใงใใ
exp(value)
value.exp()
Number
Number
ๆกไปถใtrueใงใใใชในใๅ
ใฎๅคใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
filter(list, currentValue = value)
list.filter(currentValue = value)
List
Condition
List
Formula 2.0
ๆกไปถใtrueใ่ฟใใชในใๅ
ใฎๆๅใฎ่ฆ็ด ใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
find(list, current = value)
lst.find(current = value)
List
Condition
Number
String
Date
Checkbox
Formula 2.0
ๆกไปถใtrueใงใใใชในใๅ
ใฎๆๅใฎ้
็ฎใฎใคใณใใใฏในใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ่ฆ็ด ใๅญๅจใใชใๆใซใฏ -1 ใ่ฟใใพใใ
findIndex(list, current == value)
list.findIndex(current == value)
List
Condition
Number
Formula 2.0
ใชในใๅ
ใฎๆๅใฎ่ฆ็ด ใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
first(list)
list.first()
List
Number
String
Date
Checkbox
Formula 2.0
ใชในใใฎใชในใใๅไธใฎใชในใใซๅนณๅฆๅใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
flat(list)
list.flat()
List
List
Formula 2.0
ๆๅญๅใจใใฆใใฉใผใใใใใใๅคใ่ฟใใพใใ
format(value)
value.format()
Number
String
Date
Checkbox
List
String
ใซในใฟใ ๆธๅผ่จญๅฎๆๅญๅใไฝฟ็จใใฆๆฅไปใฎๆธๅผใ่จญๅฎใใใพใใๆธๅผ่จญๅฎๆๅญๅใซใฏใๆฅไปใฎไธ้จใ่กจใๆฌกใฎใใญในใใๅซใใใใจใใงใใพใใ"yyyy" ใฏๅนดใ"MM" ใฏๆใ"dd" ใฏๆฅใ"HH" ใฏๆใ"mm" ใฏๅใ"ss" ใฏ็งใ"SSS" ใฏใใช็งใงใใ
formatDate(date, โformatโ, timezone?)
date.formatDate(โformatโ, timezone?)
Date
String
String
ๆๅฎใใใUnixใฟใคใ ในใฟใณใใใๆฅไปใ่ฟใใพใใใฟใคใ ในใฟใณใใฏใ1970ๅนด1 ๆ1ๆฅใใ็ต้ใใใใช็งๆฐใ่กจใใพใใ
fromTimestamp(value)
value.fromTimestamp()
Number
Date
็พๅจใฎใใผใธใฎIDใ่ฟใใพใ
id(), id(block), id(person)
block.id(), person.id()
String
ๆกไปถใtrueใฎๅ ดๅใฏๆๅใฎๅคใ่ฟใใพใใใใใงใชใๅ ดๅใฏ2็ช็ฎใฎๅคใ่ฟใใพใใ
if(condition, value_when_true, value_when_false)
condition.if(value_when_true, value_when_false)
condition ? value_when_true : value_when_false
Condition
Number
String
Date
Checkbox
List
Number
String
Date
Checkbox
List
ๆๅใฎtrueๆกไปถใซๅฏพๅฟใใๅคใ่ฟใใพใใใใใฏใ่คๆฐใฎใในใใใใif()ในใใผใใกใณใใฎไปฃใใใจใใฆไฝฟ็จใงใใพใใ
ๆฐ่ฆ้ขๆฐใงใใๆๅพใฎๅผๆฐใฏใในใฆใฎๆกไปถใซๆบ่ถณใใชใใฃใใจใใฎๅคใงใใ
ifs(condition1, โvalue1โ, condition2, โvalue2โ, โฆ, condition_n, โvalue_nโ, โelseโ)
condition1.ifs(โvalue1โ, condition2, โvalue2โ, โฆ, condition_n, โvalue_nโ, โelseโ)
Condition
Number
String
Date
Checkbox
List
Number
String
Date
Checkbox
List
Formula 2.0
ใชในใใซๆๅฎใใใๅคใๅซใพใใฆใใๅ ดๅใฏtrueใ่ฟใใใใใงใชใๅ ดๅใฏfalseใ่ฟใใพใใ
includes(list, value)
list.includes(value)
List
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ๅๅคใฎ้ใซ็ตๅๅญใ้
็ฝฎใใใชในใใฎๅคใ่ฟใใพใใ
Formula 2.0 ใใใฏใชในใใๅใๅใใใใซๅคๆดใใใพใใใFormula 1.0 ใฎใใฎใฏ่ชๅ็ใซใชในใใไฝฟใฃใใใฎใซ็ฝฎใๆใใใใพใใใพใใๅผๆฐใฎ้ ๅบใๅคใใฃใฆใใใฎใงๆณจๆใใฆใใ ใใใ
join(list, delimiter)
list.join(delimiter)
List
String
String
Formula 2.0
ใชในใๅ
ใฎๆๅพใฎ่ฆ็ด ใ่ฟใใพใใ
last(list)
list.last()
List
Number
String
Date
Checkbox
Formula 2.0
ๆๅญๅใๆธกใใๅ ดๅใๆๅญๆฐใ่ฟใใพใใใชในใใๆธกใใๅ ดๅใซใฏใชในใใฎ้ทใใ่ฟใใพใใ
length(string)
length(list)
string.length()
list.length()
String
List
Number
Formula 2.0
ๅคๆฐใซๅคใไปฃๅ
ฅใใใใฎๅคๆฐใไฝฟ็จใใฆๅผใ่ฉไพกใใพใใ
let(variable_name, variable_value, expression)
Number
String
Date
Checkbox
List
Number
String
Date
Checkbox
List
Formula 2.0
่คๆฐใฎๅคๆฐใซๅคใๅฒใๅฝใฆใใใใใฎๅคๆฐใไฝฟ็จใใฆๅผใ่ฉไพกใใพใใ
lets(variable_name1, variable_value1, variable_name2, variable_value2, โฆ, expression)
Number
String
Date
Checkbox
List
Number
String
Date
Checkbox
List
Formula 2.0
ใฉใใซใฎใใญในใใจURLใใใใคใใผใชใณใฏใไฝๆใใพใใ
link(arg1, arg2)
arg1.link(arg2)
String
String
Formula 2.0
ใใญในใใๅฐๆๅญใซๅคๆใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
lower(arg1)
arg1.lower()
String
String
Formula 2.0
ๅ
ฅๅใชในใๅ
ใฎใในใฆใฎ้
็ฎใซๅฏพใใฆๅผใๅผใณๅบใใ็ตๆใๅ
ฅๅใใใใชในใใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใcurrent ไธๆๅคๆฐใงใชในใใฎ่ฆ็ด ใฎๅคใindex ไธๆๅคๆฐใงใชในใใฎ่ฆ็ด ใฎ็ชๅทใๅ็
งใงใใพใใ
map(list, current.method())
list.map(current.method())
List
List
Formula 2.0
ๆญฃ่ฆ่กจ็พใซไธ่ดใใใใฎใในใฆใใชในใใจใใฆ่ฟใใพใใ
match(arg1, arg2)
arg1.match(arg2)
String
List
Formula 2.0
ๅผๆฐใฎๆๅคงใฎๅคใ่ฟใใพใใๆ่ฟใๆฅไปใฎใชในใใๅฏพๅฟใใพใใใ
Formula 2.0 ใใใฏใชในใใๅใๅใใพใใ
max(value1, value2, value3, โฆ)
max(list)
value1.max(value2, value3, โฆ)
list.max()
Number
List
Number
Formula 2.0
ๅผๆฐใฎ็ฎ่กๅนณๅใ่ฟใใพใใ
mean(value1, value2, value3, โฆ)
mean(list)
value1.mean(value2, value3, โฆ)
list.mean()
Number
List
Number
Formula 2.0
ๅผๆฐใฎไธญๅคฎๅคใ่ฟใใพใใ
่ฆ็ด ใฎๆฐใๅถๆฐใฎใจใใฏไธญๅคฎใใชใใฎใงใไธญๅคฎไบใคใฎๅนณๅๅคใซใชใใพใใใใฎใใใไพใงใฏๅฐๆฐ็นใฎๅคใๅบใฆใใพใใ
median(value1, value2, value3, โฆ)
median(list)
value1.median(value2, value3, โฆ)
list.median()
Number
List
Number
Formula 2.0
ๅผๆฐใฎๆๅฐใฎๆฐๅคใ่ฟใใพใใๆ่ฟใๆฅไปใฎใชในใใๅฏพๅฟใใพใใใ
Formula 2.0 ใใใฏใชในใใๅใๅใใพใใ
min(value1, value2, value3, โฆ)
min(list)
value1.min(value2, value3, โฆ)
list.min()
Number
List
Number
Formula 2.0
ๆๅใฎๆฐๅคใ2็ช็ฎใฎๆฐๅคใงๅฒใฃใไฝใใ่ฟใใพใใ
Formula 1.0 ใฎ mod ใฏ่ชๅ็ใซ % ใซๅคๆใใใพใ(mod ใๆฎใฃใฆใใพใ)ใ
mod(arg1, arg2)
arg1.mod(arg2)
arg1 % arg2
Number
Number
ๆฅไปใฎๆ๏ผ1๏ฝ12๏ผใ่ฟใใพใใ
Formula 1.0 ใงใฏ 0ใ11 ใ่ฟใใฆใใใฎใงใ้ๅปใฎใใฎใฏ่ชๅ็ใซ -1 ใใใๅคๆใใใใใพใใ
month(date)
date.month()
Date
Number
(*) 2ใคใฎๆฐๅคใไน็ฎใใพใใ
(multiply) 2ใคใฎๆฐๅคใฎ็ฉใ่ฟใใพใใ
Formula 1.0 ใฎ multiply ใฏ่ชๅ็ใซ * ใซๅคๆใใใพใ(multiply ใๆฎใฃใฆใใพใ)ใ
multiply(arg1, arg2)
arg1.multiply(arg2)
arg1 * arg2
Number
Number
Formula 2.0
ใใงใใฏใใใฏในใฎๅคใฎๅๅฏพใ่ฟใใพใใ
Formula 1.0 ใฎ้ขๆฐใฏ ! ใซๅคๆใใใพใ(not ใๆฎใฃใฆใใพใ)ใ
! arg1 ใพใใฏ not arg1
String
Number
Date
Checkbox
List
Number
Formula 2.0
ใใงใใฏใใใฏในๆผ็ฎๅญใพใใฏใ
Formula 1.0 ใฎ or ้ขๆฐใฏ or ๆผ็ฎๅญใซๅคๆใใใพใ(or ้ขๆฐใไบๆๆงใฎใใใซๆฎใใใพใใ)
or(cond1, cond2)
cond1.or(cond2)
cond1 or cond2 ใพใใฏ cond1 || cond2
Checkbox
Checkbox
Formula 2.0
Returns the text padded with the provided padding string at the end until the target length is reached.
padEnd(orgStr, length) ใพใใฏ padEnd(orgStr, length, padString)
orgStr.padEnd(length) ใพใใฏ orgStr.padEnd(length, padString)
String
Number
String
Formula 2.0
Returns the text padded with the provided padding string at the start until the target length is reached.
padStart(orgStr, length, padString)
orgStr.padEnd(length, padString)
String
Number
String
Formula 2.0
ISO8601ๆจๆบใซๅพใฃใฆ่งฃๆใใใๆฅไปใ่ฟใใพใใ
ๆฅไปใซ้ขใใๆฐ่ฆ้ขๆฐใงใใISO8601ใฎๅบๆฌ่กจ่จใงใใใฐๆฅไปใพใงใฎๆ
ๅ ฑใงใใใฐๆฐๅคใใๆฅไปใไฝๆใใใใจใๅฏ่ฝใงใใ
parseDate(date_str)
date_str.parseDate()
String
Number
Date
Formula 2.0
ๅใฎๅๅจใจใใฎ็ดๅพใฎๆฏ็ใFormula 2.0 ใใๅฎๆฐใงใฏใชใ้ขๆฐใซใชใใพใใใ
piใฏๅฎๆฐใงใฏใชใ้ขๆฐใซใชใใพใใใpi ใฎใฟใ่จ่ฟฐใใใจใ้ขๆฐpi()ใฎๅผใณๅบใใๅฟ
่ฆใงใใใใจ่กจ็คบใใใพใใ
pi()
Number
ๅบๆฐใฎในใไนใฎ็ตๆใ่ฟใใพใใ
Formula 1.0 ใฎpow ใฏ่ชๅ็ใซ ^ ใซๅคๆใใใพใ(pow ใๆฎใฃใฆใใพใ)ใ
pow(arg1, arg2)
arg1.pow(arg2)
arg1 ^ arg2
Number
Number
ใใญในใใๆๅฎใใใๅๆฐ็นฐใ่ฟใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
repeat(arg1, arg2)
arg1.repeat(arg2)
String
Number
String
Formula 2.0
ๆญฃ่ฆ่กจ็พใฎๆๅใฎไธ่ดใ็ฝฎๆๅคใซ็ฝฎใๆใใพใใ
replace(str, regular_expression, change_text)
str.replace(regular_expression, change_text)
String
String
ๆญฃ่ฆ่กจ็พใฎใในใฆใฎไธ่ดใ็ฝฎๆๅคใซ็ฝฎใๆใใพใใ
replaceAll(str, regular_expression, change_text)
str.replaceAll(regular_expression, change_text)
String
String
ๆใ่ฟใๆดๆฐใซไธธใใใใๆฐๅคใ่ฟใใพใใ
round(arg)
arg.round()
Number
Number
ๆฐๅคใๆญฃใฎๅ ดๅใฏ1ใ่ฒ ใฎๅ ดๅใฏ-1ใใผใญใฎๅ ดๅใฏ0ใ่ฟใใพใใ
sign(arg)
arg.sign()
Number
Number
ๆๅฎใใใ้ๅงใคใณใใใฏใน๏ผๅซใ๏ผใใ็ตไบใคใณใใใฏใน๏ผ็็ฅๅฏ่ฝใๅซใพใชใ๏ผใพใงใๅ
ฅๅใชในใใฎใตใใปใใใ่ฟใใพใใ
็ตไบใคใณใใใฏในใซ่ฒ ใฎๅคใ่จญๅฎใใใจๅณๅดใใใฎใคใณใใใฏในใซใชใใพใใFormula 1.0 ใงใฏๆๅญๅใฎๅใๅบใ้ขๆฐใงใใใใใใใฏ substring ใจใใๅๅใซๅคใใใพใใใFormula 1.0 ใฎ slice ใฏ substring ใซๅคๆใใใพใใ
slice(list, start, end)
slice(list, start)
list.slice(start, end)
list.slice(start)
List
Number
List
Formula 2.0
ใชในใๅ
ใฎใใใใใฎ้
็ฎใๆๅฎใใใๆกไปถใๆบใใๅ ดๅใฏtrueใ่ฟใใใใใงใชใๅ ดๅใฏfalseใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
some(list, condition)
list.some(condition)
List
Condition
Checkbox
Formula 2.0
ๅ
ฅๅใชในใใฎไธฆในๆฟใใใใใใผใธใงใณใ่ฟใใพใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
sort(list)
list.sort()
List
List
Formula 2.0
ๅ
ฅๅใๅบๅใๆๅญใงๅๅฒใใฆไฝๆใใใๅคใฎใชในใใ่ฟใใพใใ
ใชในใใไฝๆใใๆฐ่ฆ้ขๆฐใงใใ
split(arg1, arg2)
arg1.split(arg2)
String
List
Formula 2.0
็นๅฎใฎๅ
ฅๅใซๆธๅผ่จญๅฎในใฟใคใซใ่ฟฝๅ ใใพใใไฝฟ็จๅฏ่ฝใชในใฟใคใซใซใฏใ"b"๏ผๅคชๅญ๏ผใ"u"๏ผไธ็ท๏ผใ"i"๏ผๆไฝ๏ผใ"c"๏ผใณใผใ๏ผใ"s"๏ผๅใๆถใ็ท๏ผใใใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
style(text, style1, style2, โฆ) ใพใใฏ style(text, list)
text.style(style1, style2, โฆ) ใพใใฏ text.style(list)
String
String
Formula 2.0
้ๅงใคใณใใใฏใน๏ผๅซใ๏ผใใ็ตไบใคใณใใใฏใน๏ผ็็ฅๅฏ่ฝใๅซใพใชใ๏ผใพใงใฎใใญในใใฎใตใๆๅญๅใ่ฟใใพใใ
็ตไบใคใณใใใฏในใซ่ฒ ใฎๅคใ่จญๅฎใใใจๅณๅดใใใฎใคใณใใใฏในใซใชใใพใใFormula 1.0 ใงใฏๆๅญๅใฎๅใๅบใ้ขๆฐใงใใใใใใใฏ substring ใจใใๅๅใซๅคใใใพใใใFormula 1.0 ใฎ slice ใฏ substring ใซๅคๆใใใพใใ
substring(str, start, end)
substring(str, start)
str.substring(start, end)
str.substring(start)
String
String
Formula 2.0
(-) 2ใคใฎๆฐๅคใๆธ็ฎใใพใใ
(subtract) 2ใคใฎๆฐๅคใฎๅทฎใ่ฟใใพใใ
Formula 1.0 ใฎ subtract ใฏ่ชๅ็ใซ - ใซๅคๆใใใพใ(subtract ใๆฎใฃใฆใใพใ)ใ
subtract(arg1, arg2)
arg1.subtract(arg2)
arg1 - arg2
Number
Number
Formula 2.0
ๅผๆฐใฎๅ่จใ่ฟใใพใใ
ใชในใใซๅฏพใใๆฐ่ฆ้ขๆฐใงใใ
sum(list)
list.sum()
List
Number
Formula 2.0
ๅคใๆญฃ่ฆ่กจ็พใซไธ่ดใใๅ ดๅใฏtrueใ่ฟใใใใใงใชใๅ ดๅใฏfalseใ่ฟใใพใใ
test(str, regular_expression)
str.test(regular_expression)
String
Checkbox
1970ๅนด1ๆ1ๆฅใใ็ต้ใใใใช็งๆฐใ่กจใใ็พๅจใฎUnixใฟใคใ ในใฟใณใใ่ฟใใพใใ
timestamp(date)
date.timestamp()
Date
Number
ใใญในใใใๆฐๅคใ่งฃๆใใพใใ
toNumber(value)
value.toNumber()
String
Date
Checkbox
Number
(!=) 2ใคใฎๅคใ็ญใใใชใใใฉใใใ็ขบ่ชใใพใใ
(unequal) ไธกๆนใฎๅคใ็ญใใๅ ดๅใฏfalseใ่ฟใใใใใงใชใๅ ดๅใฏtrueใ่ฟใใพใใ
Formula 1.0 ใฎ้ขๆฐใฏ != ใซๅคๆใใใพใ(unequal ใๆฎใฃใฆใใพใ)ใ
unequal(arg1, arg2)
arg1.unequal(arg2)
arg1 != arg2
Number
String
Date
Checkbox
Checkbox
Formula 2.0
ๅ
ฅๅใชในใๅ
ใฎไธๆใฎๅคใฎใชในใใ่ฟใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
unique(list)
list.unique()
List
List
Formula 2.0
็นๅฎใฎๅ
ฅๅใใๆธๅผ่จญๅฎในใฟใคใซใๅ้คใใพใใในใฟใคใซใๆๅฎใใใฆใใชใๅ ดๅใฏใใในใฆใฎในใฟใคใซใๅ้คใใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
unstyle(text, style)
text.unstyle(style)
String
String
ใใญในใใๅคงๆๅญใซๅคๆใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใ
upper(arg1)
arg1.upper()
String
String
Formula 2.0
ๆฅไปใฎๅนดใฎISO้ฑ๏ผ1๏ฝ53๏ผใ่ฟใใพใใ
Formula 2.0 ใฎๆฐ่ฆ้ขๆฐใงใใใใใพใงใฏ formatDate (W) ใจ toNumber ใงไฝๆใใฆใใพใใใISO ใชใฎใงใใฎ้ฑใฎๆๆๆฅใฎๆๆฅ็ชๅทใ่ฟใใพใใ
week(arg1)
arg1.week()
Date
Number
Formula 2.0