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

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()

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)

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)

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)

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)

7

AverageIf

CountIf

Filter

IsFromTable

Lookup

Matches

SumIf

9

IsBlank

IsDate

IsLogical

IsNotBlank

IsNotText

IsNumber

IsText

ToNumber

ToText

9

And

False

If

IfBlank

Not

Or

Switch

SwitchIf

True

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

2

ObjectLink

ParseCSV

1

ParseJSON

4

CreatedBy

IsSignedIn

ModifiedBy

User

3

RowId

Sort

WithName

3

BulletedList

IndentBy

NumberedList

6

ClipCircle

Embed

Hyperlink

HyperlinkCard

Image

Rectangle

2

Distance

Location

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