Formulas · Wiki Collaboratif de la Communauté Coda en Français

Actions

16

Activate

(object)

Activate(object)

AddOrModifyRows

(table, expression, column, columnValue)

AddOrModifyRows(table, expression, column, columnValue)

AddRow

(table, column, columnValue)

AddRow(table, column, columnValue)

CopyDoc

(title)

CopyDoc(title)

CopyPageToDoc

()

CopyPageToDoc()

CopyToClipboard

(content)

CopyToClipboard(content)

DeleteRows

(rows)

DeleteRows(rows)

DuplicatePage

(page, name, parentPage, copySubpages, duplicateOptions, rowOptions)

DuplicatePage(page, name, parentPage, copySubpages, duplicateOptions, rowOptions)

ModifyRows

(rows, column, columnValue)

ModifyRows(rows, column, columnValue)

Notify

(people, message)

Notify(people, message)

OpenRow

(row, viewOrLayout, viewMode)

OpenRow(row, viewOrLayout, viewMode)

OpenWindow

(url)

OpenWindow(url)

Refresh

(column)

Refresh(column)

RunActions

(action)

RunActions(action)

SetControlValue

(control, value)

SetControlValue(control, value)

SignUpForCoda

()

SignUpForCoda()

Arrays

16

Contains

(value, search)

Contains(value, search)

ContainsAll

(value, search)

ContainsAll(value, search)

ContainsOnly

(value, search)

ContainsOnly(value, search)

Duplicates

(value)

Duplicates(value)

First

(list)

First(list)

FormulaMap

(list, formula)

FormulaMap(list, formula)

In

(search, value)

In(search, value)

Last

(list)

Last(list)

List

(value)

List(value)

ListCombine

(value)

ListCombine(value)

Nth

(list, position)

Nth(list, position)

RandomItem

(list, updateContinuously)

RandomItem(list, updateContinuously)

RandomSample

(list, count, withReplacement, updateContinuously)

RandomSample(list, count, withReplacement, updateContinuously)

ReverseList

(list)

ReverseList(list)

Sequence

(start, end, by)

Sequence(start, end, by)

Unique

(value)

Unique(value)

Collections

5

Count

(list)

Count(list)

CountUnique

(value)

CountUnique(value)

Find

(needle, haystack, startAt, ignoreCase, ignoreAccents)

Find(needle, haystack, startAt, ignoreCase, ignoreAccents)

Slice

(value, start, end)

Slice(value, start, end)

Splice

(value, start, deleteCount, insertValue)

Splice(value, start, deleteCount, insertValue)

Dates

31

Created

(object)

Created(object)

CurrentTimezone

()

CurrentTimezone()

Date

(year, month, day)

Date(year, month, day)

DateTimeTruncate

(dateTime, unit)

DateTimeTruncate(dateTime, unit)

DateEpoch

(date)

DateEpoch(date)

Day

(dateTime)

Day(dateTime)

DocumentTimezone

()

DocumentTimezone()

EndOfMonth

(dateTime, monthOffset)

EndOfMonth(dateTime, monthOffset)

EpochToDate

(epochTime)

EpochToDate(epochTime)

Hour

(dateTime)

Hour(dateTime)

IsoWeekNumber

(dateTime)

IsoWeekNumber(dateTime)

IsoWeekDay

(dateTime)

IsoWeekDay(dateTime)

Minute

(dateTime)

Minute(dateTime)

Modified

(object)

Modified(object)

Month

(dateTime)

Month(dateTime)

MonthName

(dateTime, format)

MonthName(dateTime, format)

NetWorkingDays

(startDate, endDate, holidays)

NetWorkingDays(startDate, endDate, holidays)

Now

(precision)

Now(precision)

RelativeDate

(dateTime, months)

RelativeDate(dateTime, months)

Second

(dateTime)

Second(dateTime)

Time

(hour, minute, second)

Time(hour, minute, second)

TimeValue

(time)

TimeValue(time)

ToDate

(text)

ToDate(text)

ToDateTime

(datetime)

ToDateTime(datetime)

ToTime

(value)

ToTime(value)

Today

()

Today()

WeekNumber

(dateTime, returnType)

WeekNumber(dateTime, returnType)

WeekDay

(dateTime, returnType)

WeekDay(dateTime, returnType)

WeekDayName

(dateTime)

WeekDayName(dateTime)

WorkDay

(startDate, numWorkingDays, holidays)

WorkDay(startDate, numWorkingDays, holidays)

Year

(dateTime)

Year(dateTime)

Durations

9

Days

(days)

Days(days)

Duration

(days, hours, minutes, seconds)

Duration(days, hours, minutes, seconds)

Hours

(hours)

Hours(hours)

Minutes

(minutes)

Minutes(minutes)

Seconds

(seconds)

Seconds(seconds)

ToDays

(duration)

ToDays(duration)

ToHours

(duration)

ToHours(duration)

ToMinutes

(duration)

ToMinutes(duration)

ToSeconds

(duration)

ToSeconds(duration)

Filters

7

AverageIf

CountIf

Filter

IsFromTable

Lookup

Matches

SumIf

Info

9

IsBlank

IsDate

IsLogical

IsNotBlank

IsNotText

IsNumber

IsText

ToNumber

ToText

Logical

9

And

False

If

IfBlank

Not

Or

Switch

SwitchIf

True

Math

39

AbsoluteValue

Average

BinomialCoefficient

Ceiling

Even

Exponent

Factorial

Floor

IsEven

IsOdd

Ln

Log

Log10

Max

Median

Min

Mode

Odd

Percentile

PercentileRank

Pi

Power

Product

Quotient

Random

RandomInteger

Rank

Remainder

Round

RoundDown

RoundTo

RoundUp

Sign

SquareRoot

StandardDeviation

StandardDeviationPopulation

Sum

SumProduct

Truncate

Misc

2

ObjectLink

ParseCSV

Object

1

ParseJSON

People

4

CreatedBy

IsSignedIn

ModifiedBy

User

Relational

3

RowId

Sort

WithName

Rich Text

3

BulletedList

IndentBy

NumberedList

Shape

6

ClipCircle

Embed

Hyperlink

HyperlinkCard

Image

Rectangle

Spatial

2

Distance

Location

String

28

Character

Concatenate

ContainsText

DecodeFromBase64

EncodeAsBase64

EncodeForUrl

EndsWith

Format

Join

Left

LeftPad

Length

LineBreak

Lower

Middle

RegexMatch

RegexReplace

Repeat

Replace

Right

RightPad

Split

StartsWith

Substitute

ToByteSize

ToHexadecimal

Trim

Upper