Coda

Formulas

Arrays

Contains(search, value)

Copy link

Returns true if any item in the first list is found in the subsequent items.

Contains("Dog", "Cat", "Mouse")
False
Contains("Dog", "Cat", "Mouse", "Dog")
True
Contains(List("Dog", "Giraffe"), "Cat", "Mouse", "Dog")
True

First(list)

Copy link

Returns the first item from a list or table.

Inputs

list
A table, column, or list of values.
List(1, 3, 5, 7, 11, 13).First()
1

FormulaMap(list, expression)

Copy link

Provided a list and a formula, returns a list where each item is passed through the formula.

Inputs

list
A table, column, or list of values.
expression
The formula to transform every value in `list`. Use currentValue to reference the current item being evaluated. For example, an expression of "currentValue * 2" will double every item in the list.
List("Dog", "Cat").FormulaMap(Upper(CurrentValue))
[DOG, CAT]

In(search, value)

Copy link

Returns true if the first item is found in the subsequent items.

In("Dog", "Cat", "Mouse")
False
In("Dog", "Cat", "Mouse", "Dog")
True

Last(list)

Copy link

Returns the last item from a list or table.

Inputs

list
A table, column, or list of values.
List(1, 3, 5, 7, 11, 13).Last()
13

List(item)

Copy link

Creates a list from the provided items.

Inputs

item
The items that make up the list. Specify items in the list, separated by a comma. If empty, the formula will return an empty list.
List(1, 3, 5, 7, 11, 13)
[1,3,5,7,11,13]
List("Dog", "Cat", "Mouse").NTH(2)
"Cat"

ListCombine(value)

Copy link

Combine and flatten multiple items into a list.

ListCombine(List(1, 2, 3), 4, 5, 6)
[1,2,3,4,5,6]
ListCombine(List(1, 2, 3), List(4, 5), 6)
[1,2,3,4,5,6]

Nth(list, index)

Copy link

Returns the nth item in a list from the number provided.

Inputs

list
A table, column, or list of values.
index
The position of the item requested. The first item in the list has index 1.
List(1,3,5,7,11).Nth(1)
1
List("Dog", "Cat", "Mouse").Nth(3)
"Mouse"

Sequence(from, to, by)

Copy link

Returns a list of numbers between the provided from and to parameters.

Inputs

from
The number to start from.
to
The number to end at.
by
Optional. The increment or step between numbers in the sequence. Defaults to 1 or -1 depending on from and to.
Sequence(1, 10)
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
Sequence(0, 50, 10)
[0, 10, 20, 30, 40, 50]

Unique(value)

Copy link

Returns the unique set of rows from a table or items in a list.

List("Dog", "Dog", "Cat", "Mouse").Unique()
[Dog, Cat, Mouse]

Collections

Count(value)

Copy link

Counts the number of rows in table or items in a list, ignoring blank items.

Senators.Count()
100
Senators.Filter(State = "Kansas").Count()
2

CountUnique(value)

Copy link

Counts the number of unique rows in a table or items in a list.

CountUnique(1, 2, 3, 3, 3, 4)
4

Find(needle, haystack, startAt)

Copy link

Returns the numerical value of the position at which the item is first found in the provided text.

Inputs

needle
Value to look for
haystack
String or collection to search
startAt
Optional. Index at which to start looking
Find("world", "hello world")
7

Slice(value, begin, end)

Copy link

Returns a part of the provided text or list based on the numerical position.

Slice("Hello world", 5, 9)
o wor
List("Cat", "Dog", "Mouse").Slice(2, 3)
[Dog, Mouse]

Splice(values, start, deleteCount, items)

Copy link

Returns the provided list with a set of items inserted at a position over an existing set.

Inputs

values
Values to be spliced
start
Index at which splice should happen
deleteCount
Number of values to delete
items
Items to be spliced in
Splice(List(1, 2, 3, 4, 5), 2, 3, List("Dog", "Cat"))
[1, Dog, Cat, 5]

Dates

Created(object)

Copy link

Returns the datetime for when the provided item was created.

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.
ExampleTable.Created()
3/8/2017 9:23:18 AM

CurrentTimezone()

Copy link

Returns timezone information about the connected user's timeone.

CurrentTimezone()
{timezone: "Pacific/Honolulu", offset: -10}

Date(year, month, day)

Copy link

Returns a date for the provided year, month, and day.

Date(1985, 1, 4)
1/4/1985
Date(1776, 7, 4)
7/4/1776

DateTimeTruncate(date, interval)

Copy link

Truncates the provided datetime by the specified interval (year, quarter, month, day, hour, minute or second).

Inputs

date
A Date, Time, or DateTime value.
interval
Time(1, 30, 45).DateTimeTruncate("minute")
1:30 AM
Time(1, 30, 45).DateTimeTruncate("hour")
1:00 AM

Day(date)

Copy link

Returns the day of the given date.

Inputs

date
A Date, Time, or DateTime value.
Day(Date(2013, 4, 18))
18

DocumentTimezone()

Copy link

Returns timezone information about the current document state.

DocumentTimezone()
{timezone: "America/Los_Angeles", offset: -7}

EndOfMonth(date, months)

Copy link

Returns the date for the last day of the month of a date plus the given number of months before or after.

Inputs

date
A Date, Time, or DateTime value.
months
EndOfMonth(Today(), 3)
6/30/2017
EndOfMonth(Date(2017, 03, 20), 1)
4/30/2017

EpochToDate(timestamp)

Copy link

Converts the provided epoch value to a datetime.

EpochToDate(1489187664)
3/10/2017 3:14:24 PM

Hour(date)

Copy link

Returns the hour of the given datetime.

Inputs

date
A Date, Time, or DateTime value.
Hour(Time(1, 30, 45))
1

Minute(date)

Copy link

Returns the minute of the given datetime.

Inputs

date
A Date, Time, or DateTime value.
Minute(Time(1, 30, 45)
30

Modified(object)

Copy link

Returns the datetime representing the last time the given item was updated.

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.
Table.Modified()
3/10/2017 8:56:23 AM

Month(date)

Copy link

Returns the month of the given date.

Inputs

date
A Date, Time, or DateTime value.
Month(Date(2013, 4, 18))
4

MonthName(date, format)

Copy link

Returns the name of the month for the given date.

Inputs

date
A Date, Time, or DateTime value.
format
Optional. "MMM" or "MMMM".
MonthName(Date(2013, 4, 18))
April

NetWorkingDays(startdate, enddate, holidays)

Copy link

Returns the number of net working days (M-F) between two provided dates.

Inputs

startdate
The start date to calculate the number of net working days.
enddate
The end date to calculate the number of net working days.
holidays
Optional. A list of dates to exclude as working days (e.g. holidays).
NetWorkingDays(Date(2016, 2, 1), Date(2016, 2, 3))
3

Returns the current date and time.

Now()
3/10/2017 8:56:23 AM

RelativeDate(date, months)

Copy link

Returns a date a specified number of months before or after another date.

Inputs

date
A Date, Time, or DateTime value.
months
RelativeDate(Date(2016, 1, 1), 2)
3/1/2016

Second(date)

Copy link

Returns the seconds of the given datetime.

Inputs

date
A Date, Time, or DateTime value.
Second(Time(1, 30, 45))
45

Time(hour, minute, second)

Copy link

Returns a time for the provided hour, minute, and second.

Time(1, 30, 45)
1:30:45 AM
Time(17, 0, 0)
5:00 PM

TimeValue(time)

Copy link

Returns the decimal number of the time represented by the provided text string.

TimeValue("5:30:18 PM")
0.729375

ToDate(date)

Copy link

Converts the provided text into a date.

ToDate("2013-03-14")
3/14/2013

ToDateTime(datetime)

Copy link

Converts the provided text into a datetime.

ToDateTime("2013-03-14 18:13:23")
3/14/2013 6:13:23 PM

Today()

Copy link

Returns the current date.

Today()
3/8/2017
Today() + Days(14)
3/22/2017

WeekNumber(date, returnType)

Copy link

Returns the week number in the year for the given date.

Inputs

date
A Date, Time, or DateTime value.
returnType
Optional.
WeekNumber(Date(1776, 7, 4))
27

Weekday(date, returnType)

Copy link

Returns the day of week for the given date.

Inputs

date
A Date, Time, or DateTime value.
returnType
Optional.
Weekday(Date(1776, 7, 4))
5

WeekdayName(date)

Copy link

Returns the name of the day for the given date.

Inputs

date
A Date, Time, or DateTime value.
WeekdayName(Date(1776, 7, 4))
Thursday

Workday(startdate, numDays, holidays)

Copy link

Returns the date after a specified number of working days (M-F) after the start date.

Inputs

startdate
The date from which to begin counting.
numDays
The number of working days to advance from start_date. If negative, counts backwards.
holidays
Optional. A range or array constant containing the dates to consider holidays.
Workday(Date(2016, 2, 1), 5)
2/8/2016

Year(date)

Copy link

Returns the year component of the given date.

Inputs

date
A Date, Time, or DateTime value.
Year(Date(1776, 7, 4))
1776

Duration

Days(days)

Copy link

Returns a duration for the given number of days.

Inputs

days
The number of days
Days(14)
14 days
Date(1776, 7, 4) + Days(7)
7/11/1776

Duration(days, hours, minutes, seconds)

Copy link

Returns a duration for the provided days, hours, minutes, and seconds.

Inputs

days
Optional. The number of days
hours
Optional. The number of hours
minutes
Optional. The number of minutes
seconds
Optional. The number of seconds
Duration(4, 3, 2, 1)
4 days 3 hrs 2 mins 1 sec

Hours(hours)

Copy link

Returns the duration for the given number of hours.

Inputs

hours
The number of hours
Hours(12)
12 hrs
Hours(36)
1 day 12 hours

Minutes(minutes)

Copy link

Returns a duration for the given number of minutes.

Inputs

minutes
The number of minutes
Minutes(3)
3 min
Minutes(84)
1 hour 24 mins

Seconds(seconds)

Copy link

Returns a duration for the given number of seconds.

Inputs

seconds
The number of seconds
Seconds(38)
38 seconds
Seconds(80)
1 min 20 seconds

ToDays(duration)

Copy link

Returns the number of days of the given duration.

Inputs

duration
The duration to get days for.
ToDays(Hours(12))
0.5
ToDays(Duration(days: 1, hours: 6))
1.25

ToHours(duration)

Copy link

Returns the number of hours of the given duration.

Inputs

duration
The duration to get hours for.
ToHours(Minutes(120))
2
ToHours(Duration(days: 1, hours: 6))
30

ToMinutes(duration)

Copy link

Returns the number of minutes of the given duration.

Inputs

duration
The duration to get minutes for.
ToMinutes(Seconds(120))
2
ToMinutes(Duration(days: 1, hours: 6))
1800

ToSeconds(duration)

Copy link

Returns the number of seconds of the given duration.

Inputs

duration
The duration to get seconds for.
ToSeconds(Minutes(120))
120
ToSeconds(Duration(days: 1, hours: 6))
108000

Filters

AverageIf(data, expression)

Copy link

Returns the average for a list of items that match a condition ignoring blank values.

Inputs

data
A column or list of numeric values, including currencies.
expression
A formula returning a boolean value (true or false). If list is a table, use "thisRow" to reference the current row being evaluated. Otherwise, use "currentValue" to reference the current item being evaluated.
List(1,2,3,4).AverageIf(CurrentValue > 2)
3.5

CountIf(list, expression)

Copy link

Counts the number of rows in a table that match the specified condition, ignoring blank items.

Inputs

list
A table, column, or list of values.
expression
A formula returning a boolean value (true or false). If list is a table, use "thisRow" to reference the current row being evaluated. Otherwise, use "currentValue" to reference the current item being evaluated.
States.CountIf(Population < 1000000)
7
CountIf(List(1,2,3,4), CurrentValue > 2)
2

Filter(list, expression)

Copy link

Returns the rows from a table or items in a list that match the specified condition.

Inputs

list
A table, column, or list of values.
expression
A formula returning a boolean value (true or false). If list is a table, use "thisRow" to reference the current row being evaluated. Otherwise, use "currentValue" to reference the current item being evaluated.
Fruits.Filter(Color = "Green")
[@Lime, @Kiwi, @Honeydew]
List(1,2,3,4).Filter(CurrentValue > 2)
[3, 4]

IsFromTable(source reference, target table)

Copy link

Returns true if the given reference resolves to a row in the provided table.

IsFromTable(@Bill Clinton, [Presidents])
true

Lookup(table, column, match value)

Copy link

Returns the rows from a table where the provided column matches the value.

Inputs

table
The "source" table to get rows from.
column
The column to search in the "source" table.
match value
The value to look for in the search column.
Lookup(Tasks, Project, thisRow)
[@Get estimate, @Schedule work, @Get permit]
Lookup(Tasks, Status, "Not Started")
[@Schedule work, @Get permit]

Matches(value, target control)

Copy link

Returns true if the given item contains the value of the provided control.

Inputs

value
The value that the control should match.
target control
The control to check that it's current state matches the value.
[Color Column].Matches([Color Select Control])
true

SumIf(data, expression)

Copy link

Returns the sum of a list of items that match the provided condition.

Inputs

data
A column or list of numeric values, including currencies.
expression
A formula returning a boolean value (true or false). If list is a table, use "thisRow" to reference the current row being evaluated. Otherwise, use "currentValue" to reference the current item being evaluated.
List(1,2,3,4).SumIf(CurrentValue > 2)
7

Info

IsBlank(value)

Copy link

Returns true if the provided value is empty, otherwise false.

IsBlank("")
true
IsBlank("Hello world")
false

IsDate(value)

Copy link

Returns true if the provided value is a valid date, otherwise false.

IsDate("2014-01-1")
true
IsDate("Hello world")
false

IsLogical(value)

Copy link

Returns true if the provided value is either true or false, otherwise false.

IsLogical(True)
true
IsLogical("Hello world")
false

IsNotBlank(value)

Copy link

Returns true if the provided value is not empty, otherwise false.

IsNotBlank("")
false
IsNotBlank("Hello world")
true

IsNotText(value)

Copy link

Returns true if the provided value is not text, otherwise true.

IsNotText(14)
true
IsNotText("Hello world")
false

IsNumber(value)

Copy link

Returns true if the provided value is a number, otherwise false.

IsNumber(14)
true
IsNumber("Hello world")
false

IsText(value)

Copy link

Returns true if the provided value is a text string, otherwise false.

IsText("Hello world")
true
IsText(14)
false

ToNumber(value, base)

Copy link

Returns the provided value as a number.

ToNumber("134")
134
ToNumber("FF", 16)
255

ToText(value)

Copy link

Converts the given value to a string.

ToText(11431)
"11431"

Logical

And(arg)

Copy link

Returns true if all the items are true, otherwise false.

And(Today() > Date(2015, 4, 23), Bugs.Count() < 5)
true
And(True(), False())
false

False()

Copy link

Returns false.

False()
false

If(condition, trueBranch, falseBranch)

Copy link

The IF function is used to return one value if a specified condition is true and another value if the specified condition false.

If(Today() > Date(2015, 4, 23), "Hello world", "Not true")
Hello world
If(Today() < Date(2015, 4, 23), "Hello world", "Not true")
Not true

IfBlank(value, valueIfBlank)

Copy link

Returns the second item if the first item is blank, otherwise returns the first item.

IfBlank("Hello world", "Alternate text")
Hello world
IfBlank("", "Alternate text")
Alternate text

Not(value)

Copy link

Returns true if the provided value is false, and false if the provided value is true.

True().Not()
false
Not(False())
true

Or(arg)

Copy link

Returns true if any of the items are true, otherwise false.

Or(Today() > Date(2015, 4, 23), Bugs.Count() < 5)
true
Or(True(), False())
true

Switch(expr, value1, result1, arg)

Copy link

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.

Inputs

expr
value1
result1
arg
any number of value and result pairs followed by optional default value
Switch(Year(Today()), 2018, "The past", 2019, "The now", 2020, "The future")
The now
Switch("In progress", "Done", 10, "Open", 1, 5)
5

SwitchIf(expr1, value1, arg)

Copy link

Evaluates a list of expressions returning the corresponding value for the first expression that evaluates TRUE. If there is no match, an optional default value may be returned.

Inputs

expr1
value1
arg
any number of value and result pairs followed by optional default value
SwitchIf(Today() > Date(2019, 01, 20), "Hello future!", Year(Today()) = 2017, "Hello present!", Today() < Date(2017, 03, 04), "Hello past!")
Hello present!

True()

Copy link

Returns true.

True()
true

Math

AbsoluteValue(value)

Copy link

Returns the absolute value of a number.

AbsoluteValue(-14)
14
AbsoluteValue(123)
123

Average(value)

Copy link

Averages a list of numbers ignoring any blank values.

States.Population.Average()
6,377,141
Average(1, 3, 5, 7)
4

BinomialCoefficient(n, k)

Copy link

Returns the number of ways of to choose k items out of n possibilities. In math, the symbols nCk and (n k) can denote a binomial coefficient, and are sometimes read as "n choose k".

Inputs

n
The number of possibilities to choose from. Any non-negative integer.
k
The number of items to choose. Any non-negative integer less than or equal to n.
BinomialCoefficient(6, 2)
15

Ceiling(value, factor)

Copy link

Rounds a number up to the nearest integer multiple of specified significance.

Ceiling(3.14, 0.1)
3.2
Ceiling(7, 3)
9

Even(value)

Copy link

Rounds a number up to the nearest even number.

Even(3)
4
Even(2.33)
4

Exponent(value)

Copy link

Returns Euler's number e (~2.718) raised to a power.

Exponent(2)
7.389056099

Factorial(value)

Copy link

Returns the product of an integer and all the integers below it. Note: inputs greater than 19 may cause precision errors.

Factorial(4)
24

Floor(value, factor)

Copy link

Rounds a number down to the nearest integer multiple of the specified significance.

Floor(3.14, 0.1)
3.1
Floor(7, 3)
6

IsEven(value)

Copy link

Returns true if the number is even, otherwise false.

IsEven(17)
false
IsEven(6)
true

IsOdd(value)

Copy link

Returns true if the number is odd, otherwise false.

IsOdd(17)
true
IsOdd(6)
false

Ln(value)

Copy link

Returns the logarithm of a number, base e (Euler's number).

Ln(100)
4.605170186

Log(value, base)

Copy link

Returns the logarithm of a number in the given base.

Log(128, 2)
7

Log10(value)

Copy link

Returns the logarithm of a number in base 10.

Log10(100)
2

Max(value)

Copy link

Returns the maximum number from a list ignoring blanks.

Max(1, 3, 5, 7, 11)
11

Median(value)

Copy link

Returns the median number from a list ignoring blanks.

Median(1, 3, 5, 7, 11)
5

Min(value)

Copy link

Returns the minimum value in a numeric dataset.

Min(1, 3, 5, 7, 11)
1

Mode(value)

Copy link

Returns the mode (most commonly occuring number) from a list ignoring blanks.

Mode(1, 3, 3, 3, 5, 7)
3

Odd(value)

Copy link

Rounds a number up to the nearest odd number.

Odd(2)
3
Odd(1.23)
3

Percentile(data, percentile)

Copy link

Returns the value or interpolation between two values at the given percentile within the provided dataset.

Percentile(List(10, 22, 7, 2, 5), 0.5)
7
Percentile(List(4, 2, 10, 6, 8, 12), 0.1)
3

PercentileRank(data, value)

Copy link

Returns the percentile rank of a given value within the provided dataset.

PercentileRank(List(10, 22, 7, 2, 5), 7)
0.5
PercentileRank(List(4, 2, 10, 6, 8, 12), 12)
1

Returns the value of the mathematical π (pi) constant.

Pi()
3.141592654

Power(base, exponent)

Copy link

Returns a number raised to a power.

Power(2, 3)
8
Power(10, 2)
100

Product(value)

Copy link

Multiplies a list of numbers together.

Product(3, 5, 2)
30

Quotient(dividend, divisor)

Copy link

Returns the result of dividing one number by another.

Quotient(10, 5)
2

Random(updateContinuously)

Copy link

Returns a random number between 0 inclusive and 1 exclusive.

Inputs

updateContinuously
Optional. True if the random number should update on every edit. False if the random number should be fixed after calculation.
Random()
0.423029953691942

Rank(value, values, ascending)

Copy link

Returns the numeric rank of the provided item within a list of items when sorted.

Rank(12, List(10, 15, 12, 3, 5, 1))
2

Remainder(value, divisor)

Copy link

Returns the remainder from the modulo operator.

Remainder(7, 3)
1
Remainder(17, 5)
2

Round(value, places)

Copy link

Rounds a provided number to the specified number of decimal places.

Round(3.14159, 2)
3.14
Round(48.111, 0)
48

RoundDown(value, places)

Copy link

Rounds the provided number with the specified number of decimal places down to the next increment.

RoundDown(3.14159, 3)
3.141
RoundDown($48.999, 0)
$48.00

RoundTo(value, factor)

Copy link

Rounds one number to the nearest integer multiple of another.

RoundTo(22, 14)
28
RoundTo(8, 5)
10

RoundUp(value, places)

Copy link

Rounds the provided number with the specified number of decimal places up to the next increment.

RoundUp(3.14159, 2)
3.15
RoundUp($48.01, 0)
$49.00

Sign(value)

Copy link

For a given number returns -1 if it's negative, 0 if it's zero, and 1 if it's positive.

Sign(13)
1
Sign(-4)
-1

SquareRoot(value)

Copy link

Returns the square root of the provided number.

SquareRoot(64)
8

Sum(value)

Copy link

Returns the sum or aggregation of a provided list of numbers.

Sum(1, 2, 3, 4)
10

SumProduct(list1, list2)

Copy link

Calculates the sum of the products of entries in two equally sized arrays.

SumProduct(List(1, 2), List(3, 4))
11

Misc

ParseCSV(csvString, delimiter)

Copy link

Returns a list of items by parsing a CSV string. This formula can be configured to parse others formats like TSV.

Inputs

csvString
A delimited string value.
delimiter
Optional. The delimiter to use. Defaults to: ','
ParseCSV("Hello,World,!", ",")
["Hello", "World", "!"]
ParseCSV("I'm a TSV", Character(9))
["I'm", "a", "TSV"]

Object

ParseJSON(jsonString, path)

Copy link

Returns a list of matching items from a JSON string from the specified path.

Inputs

jsonString
A JSON string. For example: '{"name": "Bob", "age": 42}'
path
Optional. A path within the JSON; for example, "#/pull_request/state"
ParseJSON('{"name": "Mike", "location": "New York"}', "#/name")
[Mike]

People

CreatedBy(object)

Copy link

Returns the user who created the previous item.

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.
thisRow.CreatedBy()

ModifiedBy(object)

Copy link

Returns the user who modified the previous item.

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.
thisRow.ModifiedBy()

User()

Copy link

Returns the current logged in user (will be different for every user).

User()

Ranges

BulletedList(value)

Copy link

Renders a bulleted list from the provided list or array.

BulletedList("Dog", "Cat", "Mouse")
• Dog • Cat • Mouse

NumberedList(value)

Copy link

Renders a numbered list from the provided list.

NumberedList("Dog", "Cat", "Mouse")
1. Dog 2. Cat 3. Mouse

Relational

RowId(ref)

Copy link

Returns the unique ID for the given row based on when it was created.

thisRow.RowId()
14

Sort(data, ascending, column)

Copy link

Sorts a list of values or table by a specified column.

Inputs

data
Values to be sorted
ascending
Optional. Ascending sort order
column
Optional. Column reference in the case of a table
List(1, 5, 3, 4, 2).Sort()
[1, 2, 3, 4, 5]
States.Sort(true, Population)
[California, Texas, New York...]

Shape

ClipCircle(image)

Copy link

Crops an image to the shape of a circle or oval at the specified width and height.

ClipCircle(Image("https://pbs.twimg.com/profile_images/671865418701606912/HECw8AzK.jpg"))

Embed(url, width, height, force)

Copy link

Given a URL, displays an embedded resource, such as a video or external document. Embeds are preprocessed to display quickly and securely in Coda; use force=true to try to load the URL directly in your browser. For width and height, use 0 for defaults.

Inputs

url
The URL to embed
width
Optional.
height
Optional.
force
Optional. If true, try to load the URL directly using your browser (some URLs may not load)
Embed("https://www.youtube.com/watch?v=dQw4w9WgXcQ")
Embed("https://www.theverge.com/2017/10/19/16497444/coda-spreadsheet-krypton-shishir-mehrotra", 400, 500)

Hyperlink(url, display value)

Copy link

Creates a link with the specified URL and display text.

Hyperlink("www.google.com", "Google")
Google

HyperlinkCard(url)

Copy link

Creates a card view of a link with the specified URL.

HyperlinkCard("cnn.com")

Image(url, width, height, name, style)

Copy link

Returns an image from the provided url.

Inputs

url
width
Optional.
height
Optional.
name
Optional.
style
Optional. One of auto or circle
Image("https://pbs.twimg.com/profile_images/671865418701606912/HECw8AzK.jpg")

Rectangle(width, height, color, name)

Copy link

Returns a rectanglar image of the provided color and size.

Inputs

width
height
Optional.
color
Optional. Color as RGB hex #RRGGBB (black if omitted)
name
Optional. hover text
Rectangle(200, 20, "#007AF5")

Spatial

Distance(location1, location2, unit)

Copy link

Returns the distance (in kilometers) between two locations (lat/long) on earth using the Haversine formula.

Inputs

location1
A location represented by LOCATION(lat, lon)
location2
A location represented by LOCATION(lat, lon)
unit
Optional. Units (M)iles, (N)autical miles or (K)ilometers. Defaults to (K)ilometers if not specified.
Distance(Location(33.9206418,-118.3303341), Location(37.4274787, -122.1719077))
521.8529425485297

Location(latitude, longitude, altitude, heading, speed, accuracy, altitudeAccuracy)

Copy link

Returns a lat-long object from the provided numbers.

Inputs

latitude
latitude position in decimal degrees.
longitude
longitude position in decimal degrees.
altitude
Optional. altitude relative to sea level.
heading
Optional. direction of travel in degrees.
speed
Optional. speed in meters per second.
accuracy
Optional. accuracy of lat/long values in meters.
altitudeAccuracy
Optional. accuracy of altitude in meters.
Location(33.9206418,-118.3303341)
[33.9206418,-118.3303341, , ]

String

Character(number)

Copy link

Returns the unicode character corresponding to the number provided.

Concatenate(Character(191), "Que Pasa?")
¿Que pasa?
Concatenate(Character(34), "Keep me in quotes", Char(34))
"Keep me in quotes"

Concatenate(string)

Copy link

Combines a set of values together into a single text.

Concatenate("Notes for", Today())
Notes for 3/8/2017

EncodeForUrl(string)

Copy link

Encodes text so it can be used in the query string of a URL.

EncodeForUrl("The quick / Brown fox?")
The%20quick%20%2F%20Brown%20fox%3F

EndsWith(string, suffix)

Copy link

Returns true if the text ends with the given suffix, false if not.

Inputs

string
suffix
Suffix of the string
EndsWith("Hello world", "Find me")
false
EndsWith("Hello world", "world")
true

Format(template, arg1, arg)

Copy link

Returns a formatted string by replacing variables with items in a list.

Inputs

template
Template format. To substitute a value, use {X} or {X:Y}. X is the nth argument after the format string.The Y part is optional. It determines how to pad the string if the value is not as long as Y.
arg1
1st argument - matched with {1}
arg
any number of arg 2...n
Format("This is my {1} and it is {2}", "doc", "great")
This is my doc and it is great
Format("{1:0000}-{2:00}-{3:00}", Today().Year(), Today().Month(), Today().Day())
2018-06-05

Join(join, value)

Copy link

Returns the text of a list of items joined together by the provided value.

Inputs

join
Value inserted between every part
value
Values to join together
Join("-", "This", "is", "Awesome")
This-is-Awesome

Left(string, numberOfCharacters)

Copy link

Returns the text from a provided value after truncating the specified number of characters to the left.

Inputs

string
numberOfCharacters
Number of characters to return
Left("Hello world", 3)
Hel

LeftPad(string, targetLength, padString)

Copy link

Pads the first string with another string (repeated, if needed) so that the resulting string reaches the given length. The padding is applied from the start (left) of the current string.

Inputs

string
targetLength
The length of the resulting string once the current string has been padded. If the value is lower than the current string's length, the current string will be returned as is.
padString
Optional. The string to pad the current string with. If this string is too longto stay within the target length, it will be truncated and the left-most part will be applied. The default value is " " (space).
LeftPad("10", 3)
10
LeftPad("99", 5, "0")
00099
LeftPad("foo", 1)
foo

Length(string)

Copy link

Returns length of the given text.

Length("Hello world")
11

Lower(string)

Copy link

Returns the provided text in lower case.

Lower("Hello WORLD")
hello world

Middle(string, startIndex, extractLength)

Copy link

Return the middle of the provided text starting from the specified number of characters from the left and the right.

Middle("Hello world", 3, 5)
llo w

RegexMatch(string, regex)

Copy link

Returns true if the provided text matches the regular expression, false otherwise.

RegexMatch("Top Floor Pacific Heights Flat w/Parking (marina / cow hollow) $1200 1bd 800ft", "([$]\d+)")
true

RegexReplace(string, regex, replacement)

Copy link

Returns the provided text after replacing all regular expression matches with the given value.

RegexReplace("Top Flat w/Parking (marina / cow hollow) $1200 1bd 800ft", "([$]\d+)", "$2000")
Top Flat w/Parking (marina / cow hollow) $2000 1bd 800ft

Repeat(string, numberOfRepetitions)

Copy link

Returns the specified text repeated a number of times.

Repeat("ha", 4)
hahahaha

Replace(string, position, length, replacement)

Copy link

Replaces part of a text string with a different text string based on the character position.

Replace("Spreadsheets", 1, 6, "Bed")
Bedsheets

Right(string, numberOfCharacters)

Copy link

Returns the text from a provided value after truncating the specified number of characters to the right.

Right("Hello world", 3)
rld

RightPad(string, targetLength, padString)

Copy link

Pads the first string with another string (repeated, if needed) so that the resulting string reaches the given length. The padding is applied from the end (right) of the current string.

Inputs

string
targetLength
The length of the resulting string once the current string has been padded. If the value is lower than the current string's length, the current string will be returned as is.
padString
Optional. The string to pad the current string with. If this string is too longto stay within the target length, it will be truncated and the left-most part will be applied. The default value is " " (space).
RightPad("10", 3)
10
RightPad("99", 5, "0")
99000
RightPad("foo", 1)
foo

Split(string, delimiter)

Copy link

Returns a list of items by dividing the provided text by a specified character.

Split("I-need-these-apart-3/10/2017", "-")
[I, need, these, apart, 3/10/2017]

StartsWith(string, prefix)

Copy link

Returns true if the text ends with the given prefix, false if not.

Inputs

string
prefix
Prefix of the string
StartsWith("Hello world", "Find me")
false
StartsWith("Hello world", "Hello")
true

Substitute(string, searchFor, replaceWith)

Copy link

Replaces part of a text string with a different text string.

Substitute("Hello world", "Hello", "Good morning")
Good morning world

ToByteSize(value, base)

Copy link

Converts the supplied number into a size of bytes string value.

Inputs

value
base
Optional. conversion base, 2 or 10 (default)
ToByteSize(265318)
265.32 kB
ToByteSize(265318, 2)
259.1 KB

ToHexadecimal(value, places)

Copy link

Converts the supplied number into a hexadecimal string value.

Inputs

value
places
Optional. padding width
ToHexadecimal(10)
A
ToHexadecimal(10, 4)
000A

Trim(string)

Copy link

Removes the leading and trailing spaces from the provided text.

Trim(" loooking good! ")
looking good!
Trim("Stay positive ")
Stay positive

Upper(string)

Copy link

Converts the provided text to uppercase.

Upper("hello")
HELLO

Actions

AddOrModifyRows(table, expression, Column, Value of column)

Copy link

Adds a row to the table if no matching rows are found, else modifies all of the rows that match the filter.

AddOrModifyRows(Tasks, Status = "Open", Description, "Send out metrics")
An action which when triggered will add a row to Tasks table and set the Description column to "Send out metrics" if there are no rows that have status set to "Open". If it finds matching rows, will update the Description in all rows to "Send out metrics".

AddRow(table, Column, Value of column)

Copy link

Adds a row to the table.

AddRow(Tasks, Description, "Send out metrics")
An action which when triggered will add a row to Tasks table and set the Description column to "Send out metrics".

DeleteRows(data)

Copy link

Deletes the specified rows while skipping over missing rows.

DeleteRows(Tasks.filter(Status != "Done"))
An action which when triggered will deleteall rows returned by the filter.

ModifyRows(data, Column, Value of column)

Copy link

Modifies rows with provided values.

ModifyRows(Tasks.filter(Status != "Done"), Status, "Done")
An action which when triggered will update the Status column in all rows returned by the filter to Done.

Notify(Person(s), Text)

Copy link

Notifies a person through Coda.

Notify([Owner], "Hey [Owner], can you update your status?"
A notification will be created against the person(s) within [Owner] stating the text

OpenWindow(URL)

Copy link

Opens a new window with the provided location.

OpenWindow("https://www.google.com")
An action which when triggered will open a new window with the specified input.

RunActions(action)

Copy link

Runs the actions on the buttons in the column.

RunActions(Tasks.CloseBugs)
An action which when triggered will click all buttons in the CloseBugs column.

Dropbox

Item(account, ref)

Copy link

Gets basic information for a user's file or folder.

Inputs

account
The Dropbox account used to pull in this data.
ref
Reference to a file or folder.

ItemsInFolder(account, ref)

Copy link

Gets a list of items contained in a user's folder.

Inputs

account
The Dropbox account used to pull in this data.
ref
Reference to a file or folder.

Members(account, ref)

Copy link

Gets owner and other members for a user's file.

Inputs

account
The Dropbox account used to pull in this data.
ref
Reference to a file or folder.

ReceivedFiles(account)

Copy link

Gets a user's received files.

Inputs

account
The Dropbox account used to pull in this data.

Revisions(account, ref)

Copy link

Gets revisions for a user's file.

Inputs

account
The Dropbox account used to pull in this data.
ref
Reference to a file or folder.

SharedFolders(account)

Copy link

Gets a user's shared folders.

Inputs

account
The Dropbox account used to pull in this data.

SharedLinks(account, refScope)

Copy link

Gets a user's shared links.

Inputs

account
The Dropbox account used to pull in this data.
refScope
Optional. Scope to this file or folder reference.

SpaceUsage(account)

Copy link

Gets the user's space usage.

Inputs

account
The Dropbox account used to pull in this data.

User(account)

Copy link

Gets the user's information.

Inputs

account
The Dropbox account used to pull in this data.

Figma

Comments(account, fileUrl)

Copy link

Given the ID of a file, returns the comments for the file.

Inputs

account
The Figma account used to pull in this data.
fileUrl
The URL of a file. For example, "https://figma.com/file/[...]".

File(account, frameUrl)

Copy link

Get live data from a Figma file.

Inputs

account
The Figma account used to pull in this data.
frameUrl
The URL of a file or frame. For example, "https://figma.com/file/[...]/?nodeId=[...]".

FileHistory(account, fileUrl)

Copy link

Given the ID of a file, returns the version history of the file.

Inputs

account
The Figma account used to pull in this data.
fileUrl
The URL of a file. For example, "https://figma.com/file/[...]".

Image(account, frameUrl)

Copy link

Given the ID of a frame, returns an image for the file.

Inputs

account
The Figma account used to pull in this data.
frameUrl
The URL of a file or frame. For example, "https://figma.com/file/[...]/?nodeId=[...]".

PostComment(account, frameUrl, comment)

Copy link

Given the ID of a frame, posts a comment for that frame.

Inputs

account
The Figma account used to take this action.
frameUrl
The URL of a file or frame. For example, "https://figma.com/file/[...]/?nodeId=[...]".
comment
The text of the comment. For example, "Wow!".

ProjectFiles(account, projectUrl)

Copy link

Given the ID of a project, returns the IDs, names, thumbnails, and last modified times for files in that project.

Inputs

account
The Figma account used to pull in this data.
projectUrl
The URL of the project to list files from. For example, "https://figma.com/files/project/[...]".

Projects(account, teamUrl)

Copy link

Given the ID of a team, returns the IDs and names of all projects.

Inputs

account
The Figma account used to pull in this data.
teamUrl
The URL of the team to list projects from. For example, "https://figma.com/files/team/[...]".

FullContact

Company(account, domain)

Copy link

Get enrichment data for a company.

Inputs

account
The FullContact account used to pull in this data.
domain
The domain name of the company to lookup.

Person(account, email, twitter, phone)

Copy link

Get enrichment data for a person; at least one parameter must be set.

Inputs

account
The FullContact account used to pull in this data.
email
Optional. The email address of the contact
twitter
Optional. Twitter handle of the contact. Acceptable forms include handle (with or without "@") as well as the URL to the profile.
phone
Optional. Phone number of the contact

GitHub

Commit(account, commitUrl)

Copy link

Get live data from a Github commit.

Inputs

account
The GitHub account used to pull in this data.
commitUrl
The URL of the commit. For example, "https://github.com/[org]/[repo]/commits/[commit-sha]".

Commits(account, repoUrl, beginSha, endSha)

Copy link

Get live data from a range of Github commits (max of 250 commits).

Inputs

account
The GitHub account used to pull in this data.
repoUrl
The URL of the repository to list pull requests from. For example "https://github.com/[org]/[repo]".
beginSha
The SHA of the first commit.
endSha
Optional. The SHA of the last commit - defaults to HEAD if not specified.

Issue(account, issueUrl)

Copy link

Get live data from a Github issue.

Inputs

account
The GitHub account used to pull in this data.
issueUrl
The URL of the issue. For example, "https://github.com/[org]/[repo]/issues/[id]".

MergePullRequest(account, pullRequestUrl)

Copy link

Merges a pull request.

Inputs

account
The GitHub account used to take this action.
pullRequestUrl
The URL of the pull request. For example, "https://github.com/[org]/[repo]/pull/[id]".

PullRequest(account, pullRequestUrl)

Copy link

Get live data from a Github pull request.

Inputs

account
The GitHub account used to pull in this data.
pullRequestUrl
The URL of the pull request. For example, "https://github.com/[org]/[repo]/pull/[id]".

PullRequests(account, repoUrl, base)

Copy link

List pull requests for a repo.

Inputs

account
The GitHub account used to pull in this data.
repoUrl
The URL of the repository to list pull requests from. For example "https://github.com/[org]/[repo]".
base
Optional. The name of the base branch. For example, "master".

Repo(account, repoUrl)

Copy link

Get live data from a Github repo.

Inputs

account
The GitHub account used to pull in this data.
repoUrl
The URL of the repository to list pull requests from. For example "https://github.com/[org]/[repo]".

Repos(account, username, organization)

Copy link

List repositories for an organization or username.

Inputs

account
The GitHub account used to pull in this data.
username
Optional. The username of the GitHub user. For example, "alice".
organization
Optional. Organization to list repositories. For example, "nasa".

User(account, username)

Copy link

Get live data about a Github user.

Inputs

account
The GitHub account used to pull in this data.
username
The username of the GitHub user. For example, "alice".

Gmail

CreateDraft(account, to, subject, content, cc, bcc)

Copy link

Creates a draft email in your Gmail account's draft folder.

Inputs

account
The Gmail account used to take this action.
to
The email address. For example, "alice@example.com".
subject
The subject line of the email.
content
The text of the email.
cc
Optional. An email address to CC.
bcc
Optional. An email address to BCC.

MessageCount(account, search)

Copy link

Returns the count of messages in your Gmail account that match the specified Gmail search term.

Inputs

account
The Gmail account used to pull in this data.
search
Optional. The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important". For a list of available options, see https://support.google.com/mail/answer/7190?hl=en

Messages(account, search, maxResults)

Copy link

Returns messages that match the provided search term.

Inputs

account
The Gmail account used to pull in this data.
search
Optional. The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important". For a list of available options, see https://support.google.com/mail/answer/7190?hl=en
maxResults
Optional. The maximum number of threads to return.

SendEmail(account, to, subject, content, cc, bcc, from, replyTo)

Copy link

Sends an email from your Gmail account.

Inputs

account
The Gmail account used to take this action.
to
The email address. For example, "alice@example.com".
subject
The subject line of the email.
content
The text of the email.
cc
Optional. An email address to CC.
bcc
Optional. An email address to BCC.
from
Optional. The email address to send the email from.
replyTo
Optional. The email's reply-to address. This is where replies to the email should be sent.

ThreadCount(account, search)

Copy link

Returns the count of threads in your Gmail account that match the specified Gmail search term.

Inputs

account
The Gmail account used to pull in this data.
search
Optional. The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important". For a list of available options, see https://support.google.com/mail/answer/7190?hl=en

Threads(account, search, maxResults)

Copy link

Returns email threads that match the provided search term.

Inputs

account
The Gmail account used to pull in this data.
search
Optional. The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important". For a list of available options, see https://support.google.com/mail/answer/7190?hl=en
maxResults
Optional. The maximum number of threads to return.

Google Calendar

BusyTimes(account, calendar, minDate, maxDate)

Copy link

Returns busy times from the given calendar.

Inputs

account
The Google Calendar account used to pull in this data.
calendar
Optional. The URL, ID, or name of the calendar to use.
minDate
Optional. The earliest date. For example, `Today() - Days(14)`.
maxDate
Optional. The latest date. For example, `Today() + Days(14)`.

Calendars(account)

Copy link

Returns available calendars.

Inputs

account
The Google Calendar account used to pull in this data.

CreateEvent(account, summary, start, end, isAllDay, description, calendar, recurrenceFrequency, recurrenceCount, attendees)

Copy link

Adds an event to the calendar.

Inputs

account
The Google Calendar account used to take this action.
summary
The title of the event.
start
The start date and time. For example, `Now()`
end
The end date and time. For example, `Now() + Hours(1)`
isAllDay
Optional. If true, make the event all day. If false, use the start and end times
description
Optional. The description of event.
calendar
Optional. The URL, ID, or name of the calendar to use.
recurrenceFrequency
Optional. If specified, must be one of "YEARLY", "MONTHLY", "WEEKLY", "EVERY WEEKDAY", "DAILY", or "HOURLY"
recurrenceCount
Optional. The count of recurring instances of this event; default is to repeat forever.
attendees
Optional. A list of attendee emails for the event.

Event(account, event, calendar)

Copy link

Get data about a Google Calendar event.

Inputs

account
The Google Calendar account used to pull in this data.
event
The URL or ID of an event.
calendar
Optional. The URL, ID, or name of the calendar to use.

Events(account, calendar, minDate, maxDate, search, maxResults, flattenRecurring)

Copy link

Returns events from the given calendar.

Inputs

account
The Google Calendar account used to pull in this data.
calendar
Optional. The URL, ID, or name of the calendar to use.
minDate
Optional. The earliest date. For example, `Today() - Days(14)`.
maxDate
Optional. The latest date. For example, `Today() + Days(14)`.
search
Optional. A search terms to filter events. You can leave this blank to return all events.
maxResults
Optional. The maximum number of items to return.
flattenRecurring
Optional. True by default. If set to false, recurring events will be returned as a single event instead of a series of separate events.

QuickAdd(account, description, calendar)

Copy link

Adds an event to the calendar given a descriptive string, for example "Meet with Chris for coffee tomorrow at 10am at Starbucks".

Inputs

account
The Google Calendar account used to take this action.
description
The text describing the event to be created. For example, "Dinner at 7pm".
calendar
Optional. The URL, ID, or name of the calendar to use.

UpdateEvent(account, event, summary, start, end, isAllDay, description, calendar, attendees)

Copy link

Updates an existing event.

Inputs

account
The Google Calendar account used to take this action.
event
The URL or ID of the Google Calendar event to modify.
summary
The title of the event.
start
The start date and time. For example, `Now()`
end
The end date and time. For example, `Now() + Hours(1)`
isAllDay
Optional. If true, make the event all day. If false, use the start and end times
description
Optional. The description of event.
calendar
Optional. The URL, ID, or name of the calendar to use.
attendees
Optional. A list of attendee emails for the event.

Google Natural Language

AnalyzeEntities(text)

Copy link

Inspects the given text for known entities (proper nouns such as public figures, landmarks, etc.) and returns information about those entities.

Inputs

text
The text to analyze.

AnalyzeSentiment(text)

Copy link

Inspects the given text and identifies the prevailing emotional opinion.

Inputs

text
The text to analyze.

AnalyzeSyntax(text)

Copy link

Inspects the given text and extracts linguistic information into a series tokens (part of speech, lemma, etc.

Inputs

text
The text to analyze.

ClassifyText(text)

Copy link

Inspects the given text and classifies content into Google's content categories.

Inputs

text
The text to analyze.

Greenhouse

Application(account, url)

Copy link

Get live data about a Greenhouse application.

Inputs

account
The Greenhouse account used to pull in this data.
url
The URL or ID of the application. For example, "https://app.greenhouse.io/people/[...]?application_id=[...]".

Applications(account)

Copy link

Get list of Greenhouse applications.

Inputs

account
The Greenhouse account used to pull in this data.

Candidate(account, id)

Copy link

Get live data about a Greenhouse candidate.

Inputs

account
The Greenhouse account used to pull in this data.
id
The email, URL, or ID of the candidate. For example, "alice@example.com" or "https://app.greenhouse.io/people/[...]".

Candidates(account)

Copy link

Get list of Greenhouse candidates.

Inputs

account
The Greenhouse account used to pull in this data.

CreateCandidate(account, firstName, lastName, jobUrl, referringUserEmail, company, title, email)

Copy link

Create a new candidate.

Inputs

account
The Greenhouse account used to take this action.
firstName
The first name of the candidate.
lastName
The last name of the candidate.
jobUrl
The job URL or ID. For example, "https://app.greenhouse.io/sdash/[...]".
referringUserEmail
The email or ID of the Greenhouse user adding the candidate (likely you).
company
Optional. The current company of the candidate.
title
Optional. The current title of the candidate.
email
Optional. The email of the candidate.

CreateProspect(account, firstName, lastName, referringUserEmail, company, title, email)

Copy link

Create a new prospect.

Inputs

account
The Greenhouse account used to take this action.
firstName
The first name of the prospect.
lastName
The last name of the prospect.
referringUserEmail
The email or ID of the Greenhouse user adding the prospect (likely you).
company
Optional. The current company of the prospect.
title
Optional. The current title of the prospect.
email
Optional. The email of the prospect.

Job(account, url)

Copy link

Get live data about a Greenhouse job.

Inputs

account
The Greenhouse account used to pull in this data.
url
The URL or ID of the job. For example, "https://app.greenhouse.io/sdash/[...]".

Jobs(account)

Copy link

Get list of Greenhouse jobs.

Inputs

account
The Greenhouse account used to pull in this data.

Instagram

Media(mediaUrl)

Copy link

Get data about an Instagram post.

Inputs

mediaUrl
The URL for the Instagram post.

Intercom

AddNote(account, email, note)

Copy link

Adds a note to a user.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
note
The text of the note to add.

AssociateUserWithCompany(account, emailOrUserUrl, companyNameOrUrl)

Copy link

Associates a user with a company.

Inputs

account
The Intercom account used to take this action.
emailOrUserUrl
The email of the user, or the URL of the user. For example, "alice@example.com" or "https://app.intercom.io/[...]/users/[...]".
companyNameOrUrl
The name of the company, or the URL of the company. For example, "ACME" or "https://app.intercom.io/[...]/companies/[...]

CloseConversation(account, email, message, attachmentUrl, conversationUrl)

Copy link

Closes a conversation with the given user.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
message
The text of the message to send.
attachmentUrl
Optional. The URL of the attachment.
conversationUrl
Optional. The URL of the conversation. For example, "https://app.intercom.io/[...]/conversations/[...]".

Company(account, companyNameOrUrl)

Copy link

Gets information about a company.

Inputs

account
The Intercom account used to pull in this data.
companyNameOrUrl
The name of the company, or the URL of the company. For example, "ACME" or "https://app.intercom.io/[...]/companies/[...]

Conversation(account, conversationUrl)

Copy link

Get live data from an Intercom conversation.

Inputs

account
The Intercom account used to pull in this data.
conversationUrl
The URL of the conversation. For example, "https://app.intercom.io/[...]/conversations/[...]".

Conversations(account, isUnassigned, userEmail)

Copy link

Gets conversations from Intercom.

Inputs

account
The Intercom account used to pull in this data.
isUnassigned
Optional. If specified, returns unassigned conversations.
userEmail
Optional. If specified, returns conversations from the given user.

CreateCompany(account, name, website, companyId, industry, size, monthlySpend, plan)

Copy link

Creates a company.

Inputs

account
The Intercom account used to take this action.
name
The name of the company. For example, "ACME".
website
Optional. The website of the company. For example, "https://example.com".
companyId
Optional. The company's ID.
industry
Optional. The industry the company is a part of.
size
Optional. The number of employees the company has.
monthlySpend
Optional. The amount of monthly revenue received from this company.
plan
Optional. The plan this company is on.

CreateConversation(account, email, message)

Copy link

Creates a conversation.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
message
The text of the message to send.

CreateLead(account, email, name, userId, phone, isUnsubscribed)

Copy link

Creates a lead.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
name
Optional. The name of the lead.
userId
Optional. The user's ID.
phone
Optional. The phone number of the lead. For example "555-555-5555".
isUnsubscribed
Optional. True if the lead is unsubscribed; false otherwise.

CreateUser(account, email, name, userId, phone, isUnsubscribed)

Copy link

Creates a user.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
name
Optional. The name of the user.
userId
Optional. The user's ID.
phone
Optional. The phone number of the user. For example "555-555-5555".
isUnsubscribed
Optional. True if the lead is unsubscribed; false otherwise.

Lead(account, email)

Copy link

Get live data about an Intercom lead.

Inputs

account
The Intercom account used to pull in this data.
email
The email of the user. For example, "alice@example.com".

Message(account, messageUrl)

Copy link

Get live data from an Intercom message.

Inputs

account
The Intercom account used to pull in this data.
messageUrl
The URL of the message. For example, "https://app.intercom.io/[...]/conversation/[...]part_id=[...]".

NoteConversation(account, email, note, attachmentUrl, conversationUrl)

Copy link

Adds a note to a conversation.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
note
The text of the note to add.
attachmentUrl
Optional. The URL of the attachment.
conversationUrl
Optional. The URL of the conversation. For example, "https://app.intercom.io/[...]/conversations/[...]".

Notes(account, email)

Copy link

Gets a list of notes for a user.

Inputs

account
The Intercom account used to pull in this data.
email
The email of the user. For example, "alice@example.com".

ReplyToConversation(account, email, message, attachmentUrl, conversationUrl)

Copy link

Replies to a conversation with a user.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
message
The text of the message to send.
attachmentUrl
Optional. The URL of the attachment.
conversationUrl
Optional. The URL of the conversation. For example, "https://app.intercom.io/[...]/conversations/[...]".

TagUser(account, email, tag)

Copy link

Tags a user.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
tag
The name of the tag to add.

Tags(account)

Copy link

Gets a list of tags for the app.

Inputs

account
The Intercom account used to pull in this data.

UnassignConversation(account, email, message, attachmentUrl, conversationUrl)

Copy link

Unassigns a conversation.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
message
Optional. The text of an optional message to send.
attachmentUrl
Optional. The URL of the attachment.
conversationUrl
Optional. The URL of the conversation. For example, "https://app.intercom.io/[...]/conversations/[...]".

UntagUser(account, email, tag)

Copy link

Untags a user.

Inputs

account
The Intercom account used to take this action.
email
The email of the user. For example, "alice@example.com".
tag
The name of the tag to remove.

User(account, emailOrUserUrl)

Copy link

Get live data about an Intercom user.

Inputs

account
The Intercom account used to pull in this data.
emailOrUserUrl
The email of the user, or the URL of the user. For example, "alice@example.com" or "https://app.intercom.io/[...]/users/[...]".

MLB

Batting(playerNameOrUrl, gameType, season, career)

Copy link

Returns batting statistics for the player.

Inputs

playerNameOrUrl
The full name of the active MLB player, or, a URL to the player's profile on MLB.com (such as http://m.mlb.com/player/121597/nolan-ryan)
gameType
Optional. The type of game to return stats for. Valid values are regular, spring_training, exhibition, all_star, division_series, wild_card, lcs, ws. If no type is specified, regular season stats are returned.
season
Optional. The year to return statistics for (e.g 2018). If unspecified, the current year is used.
career
Optional. If specified, returns career statistics for the player instead of season stats.

BattingProjection(playerNameOrUrl, season)

Copy link

Returns batting projections for the player.

Inputs

playerNameOrUrl
The full name of the active MLB player, or, a URL to the player's profile on MLB.com (such as http://m.mlb.com/player/121597/nolan-ryan)
season
Optional. The year to return statistics for (e.g 2018). If unspecified, the current year is used.

Pitching(playerNameOrUrl, gameType, season, career)

Copy link

Returns pitching statistics for the player.

Inputs

playerNameOrUrl
The full name of the active MLB player, or, a URL to the player's profile on MLB.com (such as http://m.mlb.com/player/121597/nolan-ryan)
gameType
Optional. The type of game to return stats for. Valid values are regular, spring_training, exhibition, all_star, division_series, wild_card, lcs, ws. If no type is specified, regular season stats are returned.
season
Optional. The year to return statistics for (e.g 2018). If unspecified, the current year is used.
career
Optional. If specified, returns career statistics for the player instead of season stats.

PitchingProjection(playerNameOrUrl, season)

Copy link

Returns pitching projections for the player.

Inputs

playerNameOrUrl
The full name of the active MLB player, or, a URL to the player's profile on MLB.com (such as http://m.mlb.com/player/121597/nolan-ryan)
season
Optional. The year to return statistics for (e.g 2018). If unspecified, the current year is used.

Player(playerNameOrUrl)

Copy link

Get live data about an MLB player.

Inputs

playerNameOrUrl
The full name of the active MLB player, or, a URL to the player's profile on MLB.com (such as http://m.mlb.com/player/121597/nolan-ryan)

NBA

Player(playerName)

Copy link

Returns general information about the player.

Inputs

playerName
The full name of the NBA player.

Stats(playerName, season, playoffs)

Copy link

Returns statistics about the player's performance.

Inputs

playerName
The full name of the NBA player.
season
Optional. The season to retrieve statistics for. For example, use "2017" for the 2017-2018 season. If playoffs is also specified, returns the playoffs for the given calendar year. If unspecified, the current season is used.
playoffs
Optional. If specified, returns statistics for the playoffs for the given season.

Slack

CreateChannel(account, channel)

Copy link

Creates a channel.

Inputs

account
The Slack account used to take this action.
channel
The name of the channel to create. For example, "#new-channel".

Message(account, messageUrl)

Copy link

Get data about a Slack message.

Inputs

account
The Slack account used to pull in this data.
messageUrl
The URL of a slack message. For example, "https://[...].slack.com/archives/[...]".

PostMessage(account, content, channelOrEmail)

Copy link

Posts the given message to the specified channel.

Inputs

account
The Slack account used to take this action.
content
The text of the message.
channelOrEmail
The channel to send this message, or the email address of the user if sending directly. For example, "#general" or "person@email.com".

Spotify

AddTracksToPlaylist(account, playlistUrlOrId, trackUris)

Copy link

Adds tracks to an existing playlist

Inputs

account
The Spotify account used to take this action.
playlistUrlOrId
The url or id of the existing playlist
trackUris
A comma separated list of Spotify track URIs.

Album(account, albumIdOrUrl)

Copy link

Gets data about a Spotify album.

Inputs

account
The Spotify account used to pull in this data.
albumIdOrUrl
The URL or Spotify ID of an album.

AudioFeatures(account, trackIdOrUrl)

Copy link

Gets audio features for the given track.

Inputs

account
The Spotify account used to pull in this data.
trackIdOrUrl
The URL or Spotify ID of a track.

CreatePlaylist(account, name, description, isPublic, isCollaborative)

Copy link

Creates a new playlist.

Inputs

account
The Spotify account used to take this action.
name
The name of the new playlist
description
Optional. Optional description of the playlist
isPublic
Optional. Whether the new playlist is public (true by default).
isCollaborative
Optional. Whether the new playlist is collaborative (false by default).

NewReleases(account)

Copy link

Gets a list of new album releases.

Inputs

account
The Spotify account used to pull in this data.

Next(account)

Copy link

Skip to next track in the user's currently playing playlist

Inputs

account
The Spotify account used to take this action.

Pause(account)

Copy link

Pauses user's currently playing track

Inputs

account
The Spotify account used to take this action.

Play(account)

Copy link

Start or resume user's playback

Inputs

account
The Spotify account used to take this action.

Playlist(account, playlistUrlOrId)

Copy link

Gets data about a Spotify playlist.

Inputs

account
The Spotify account used to pull in this data.
playlistUrlOrId
The URL or Spotify ID of a playlist.

Playlists(account)

Copy link

Gets the list of playlists for this user.

Inputs

account
The Spotify account used to pull in this data.

Previous(account)

Copy link

Skip to previous track in the user's currently playing playlist

Inputs

account
The Spotify account used to take this action.

Track(account, trackIdOrUrl)

Copy link

Gets data about a Spotify track.

Inputs

account
The Spotify account used to pull in this data.
trackIdOrUrl
The URL or Spotify ID of a track.

Stocks

Dividends(ticker, period)

Copy link

Returns a list of dividend payouds for the provided ticker of a range of time.

Inputs

ticker
A ticker symbol to retrieve information for (e.g. GE, WMT).
period
Optional. The period over which to return the dividends. Valid values are "5y","2y","1y","ytd","6m","3m","1m".If none is specified, "1m" is used which will return one month of data.

Earnings(ticker)

Copy link

Returns a list of earnings data from the four most recent reported quarters for the provided ticker.

Inputs

ticker
A ticker symbol to retrieve information for (e.g. GE, WMT).

Financials(ticker, getAnnualFinancials)

Copy link

Returns income statement, balance sheet, and cash flow data from the four most recent reported quarter or years for the provided ticker.

Inputs

ticker
A ticker to retrieve financials for (e.g. GE, WMT).
getAnnualFinancials
Optional. If true, returns annual financials for the given ticker, otherwise returns quarterly financials

HistoricalQuotes(ticker, period)

Copy link

Returns a list of quotes for the provided ticker of a range of time..

Inputs

ticker
A ticker symbol to retrieve information for (e.g. GE, WMT).
period
Optional. The period over which to return the quotes. Valid values are "5y","2y","1y","ytd","6m","3m","1m".If none is specified, "1m" is used which will return one month of data.

Info(ticker)

Copy link

Get data about a company.

Inputs

ticker
A ticker symbol to retrieve information for (e.g. GE, WMT).

News(ticker, limit)

Copy link

Get live news about a company.

Inputs

ticker
Optional. A ticker symbol to retrieve news for (e.g. GE, WMT). If unspecified, returns news about the general market.
limit
Optional. The number of articles to return. If unspecified, returns the last ten articles.

Price(ticker)

Copy link

Returns the most recent price for the provided ticker.

Inputs

ticker
A ticker symbol to retrieve information for (e.g. GE, WMT).

Quote(ticker)

Copy link

Get live data about a company's stock.

Inputs

ticker
A ticker symbol to retrieve information for (e.g. GE, WMT).

Twilio

SendSMS(account, fromNumber, toNumber, message)

Copy link

Sends a SMS text message.

Inputs

account
The Twilio account used to take this action.
fromNumber
The phone number that sends the message. This must be a number you've associated with your account in Twilio.
toNumber
The phone number to send the message to.
message
The text of the message.

Walmart Shopping

Product(productIdOrUrl)

Copy link

Get data about a Walmart product.

Inputs

productIdOrUrl
The URL or ID of a product.

Weather

Current(location, isMetric)

Copy link

Get live data about the current weather conditions.

Inputs

location
A city name, postal code, point of interest, or "latitude, longitude" string. For example, "San Francisco" or 94107.
isMetric
Optional. If true, returns metric values (Celsius, millimeters). If false, return imperial values (Fahrenheit, inches). Defaults to false.

DailyForecast(location, date, isMetric)

Copy link

Returns the forecasted weather conditions for the specified location and date. Supports the upcoming 5 days.

Inputs

location
A city name, postal code, point of interest, or "latitude, longitude" string. For example, "San Francisco" or 94107.
date
The date of the forecast. Supports the upcoming 5 days.
isMetric
Optional. If true, returns metric values (Celsius, millimeters). If false, return imperial values (Fahrenheit, inches). Defaults to false.

Wikipedia

Article(title)

Copy link

Get data from a Wikipedia article.

Inputs

title
The title or URL of the article on Wikipedia

YouTube

Video(mediaUrl)

Copy link

Get data about a YouTube video.

Inputs

mediaUrl
The URL for the YouTube video.