Coda

Formulas

Arrays

Contains(value, search)

Copy link

Checks if a list contains any value from a list

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

Inputs

value
A value or list of values to search in
search…
A value or list of values to search for

Output

Outputs True if any value in search exists in value.

ContainsAll(value, search)

Copy link

Checks if a list contains all values from a list

ContainsAll("Dog", "Cat", "Mouse")
False
ContainsAll(List("Cat", "Rabbit"), "Cat", "Mouse")
False
List("Cat", "Mouse", "Rabbit").ContainsAll(List("Cat", "Mouse"))
True

Inputs

value
A value or list of values to search in
search…
A value or list of values to search for

Output

Outputs True if all values in search exists in value.

ContainsOnly(value, search)

Copy link

Checks if a list contains only values from a list

ContainsOnly("Dog", List("Dog", "Mouse"))
False
List("Dog", "Mouse", "Cat").ContainsOnly("Cat", "Mouse")
False
List("Dog", "Mouse").ContainsOnly("Mouse", "Dog")
True
ContainsOnly(List("Dog", "Dog"), "Dog")
True

Inputs

value
A value or list of values to search in
search…
A value or list of values to search for

Output

Outputs True if only values in search exist in value.

First(list)

Copy link

Get the first value from a list

List(1, 3, 5, 7, 11, 13).First()
1

Inputs

list
A table, column, or list of values

Output

Outputs the first value in list or blank if the list is empty.

FormulaMap(list, formula)

Copy link

Run a formula for every item in a list

List("Dog", "Cat").FormulaMap(Upper(CurrentValue))
[DOG, CAT]

Inputs

list
A table, column, or list of values
formula
A formula to evaluate for each item. Can reference currentValue.

Output

Evaluates formula for every value in list and outputs a list of all formula outputs.

In(search, value)

Copy link

Checks if a value is in a list

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

Inputs

search
A value to search for
value…
A value or list of values to search in

Output

Outputs True if search is found in value.

Last(list)

Copy link

Get the last value from a list

List(1, 3, 5, 7, 11, 13).Last()
13

Inputs

list
A table, column, or list of values

Output

Outputs the last value in list or blank if the list is empty.

List(value)

Copy link

Make a list of values

List(1, 3, 5, 7, 11, 13)
[1,3,5,7,11,13]
List("Dog", "Cat", "Mouse").NTH(2)
"Cat"

Inputs

value…
A value or list of values to include in the list

Output

Outputs a list of value(s) or an empty list if no value is provided.

ListCombine(value)

Copy link

Merge and flatten lists

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]

Inputs

value…
A value or list of values to include in the combined list

Output

Outputs a list of all value(s). Nested lists are flattened in the output.

Nth(list, position)

Copy link

Returns the nth item in a list from the number provided

List(1,3,5,7,11).Nth(1)
1
List("Dog", "Cat", "Mouse").Nth(3)
"Mouse"

Inputs

list
A table, column, or list of values
position
The position to retrieve a value for. The first item in the list has index 1.

Output

Outputs the value from list at position or Blank if position is past the end of the list.

Sequence(start, end, by)

Copy link

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

Sequence(1, 10)
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
Sequence(0, 50, 10)
[0, 10, 20, 30, 40, 50]

Required Inputs

start
The number to start from
end
The number to end at

Optional Inputs

by
The increment or step between numbers in the sequence. Defautls to 1 or -1 depending on start and end

Output

Outputs a list of numbers from start to end. Step size is controlled via the by input.

Unique(value)

Copy link

Deduplicate values

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

Inputs

value…
A value to deduplicate

Output

Outputs a list of unqiue value(s). Depuplicates against each item in a value if it is a lists.

Collections

Count(list)

Copy link

Counts the size of a list

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

Inputs

list…
A table, column, or list of values

Output

Outputs the count of a values in list(s).

CountUnique(value)

Copy link

Counts number of unique values

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

Inputs

value…
A value or list of values to be counted

Output

Outputs a count of all of the unique value(s) ignoring duplicates. Counts each unique item in a value if it is a list.

Find(needle, haystack, startAt)

Copy link

Get the position of a value

Find("world", "hello world")
7

Required Inputs

needle
A value you wish to find
haystack
A string or list you want to find the needle in

Optional Inputs

startAt
The position to search from. Counts from 1 (default)

Output

Outputs the first position of needle in haystack starting at startAt. Works with text and lists.

Slice(value, start, end)

Copy link

Get part of a list or text

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

Required Inputs

value
A text string or list of values
start
The position to start from. Counts from 1

Optional Inputs

end
The position to end at. Counts from 1

Output

Outputs a part of the provided value based on the start and end positions.

Splice(value, start, deleteCount, insertValue)

Copy link

Remove and add to a list or text

Splice(List(1, 2, 3, 4, 5), 2, 3, List("Dog", "Cat"))
[1, Dog, Cat, 5]

Inputs

value
A list or text to modify
start
The position to start from. Counts from 1
deleteCount
The number of items or characters to delete
insertValue…
The value, text, or list of values to insert

Output

Outputs value with deleteCount values removed and insertValue(s) added at start position.

Dates

Created(object)

Copy link

Get the created date/time for a row or other object

ExampleTable.Created()
3/8/2017 9:23:18 AM

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.

Output

Outputs the created date/time for object.

CurrentTimezone()

Copy link

Get the user's current time zone

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

Output

Outputs the user's current time zone.

Date(year, month, day)

Copy link

Create a date value

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

Inputs

year
The year as a number
month
The month as a number
day
The day as a number

Output

Outputs the date of the provided year, month, and day.

DateTimeTruncate(dateTime, unit)

Copy link

Round a date/time

Time(1, 30, 45).DateTimeTruncate("minute")
1:30 AM
Time(1, 30, 45).DateTimeTruncate("hour")
1:00 AM

Inputs

dateTime
A date/time
unit
The unit to round to. Can be "year", "quarter", "month", "day", "hour", "minute" or "second".

Output

Outputs dateTime rounded to the nearest unit.

Day(dateTime)

Copy link

Get the day-of-month from a date/time

Day(Date(2013, 4, 18))
18

Inputs

dateTime
A date/time

Output

Outputs the day of month of the given dateTime as a number.

DocumentTimezone()

Copy link

Get the document's timezone

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

Output

Outputs the document's timezone.

EndOfMonth(dateTime, monthOffset)

Copy link

Get the last day of a given month

EndOfMonth(Today(), 3)
6/30/2017
EndOfMonth(Date(2017, 03, 20), 1)
4/30/2017

Inputs

dateTime
A date/time
monthOffset
The number of months to move forward or backwards. 0 is month of dateTime. 1 is the following month, -1 is the previous month.

Output

Outputs the date for the last day of the month of dateTime plus monthOffset.

EpochToDate(epochTime)

Copy link

Convert epoch time to date

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

Inputs

epochTime
The number of seconds since Jan 1st, 1970

Output

Outputs epochTime as a date.

Hour(dateTime)

Copy link

Get the hour from a date/time

Hour(Time(1, 30, 45))
1

Inputs

dateTime
A date/time

Output

Outputs the hour of the given dateTime as a number.

IsoWeekNumber(dateTime)

Copy link

Get the week number of a date in the ISO week numbering system (where weeks start on Monday)

IsoWeekNumber(Date(2019, 6, 30))
26

Inputs

dateTime
A date/time

Output

Outputs the week of dateTime as a number between 1 and 52.

Minute(dateTime)

Copy link

Get the minute from a date/time

Minute(Time(1, 30, 45))
30

Inputs

dateTime
A date/time

Output

Outputs the minute of the given dateTime as a number.

Modified(object)

Copy link

Get the modified date/time for a row or other object

Table.Modified()
3/10/2017 8:56:23 AM

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.

Output

Outputs the modified date/time for object.

Month(dateTime)

Copy link

Get the month from a date

Month(Date(2013, 4, 18))
4

Inputs

dateTime
A date/time

Output

Outputs the month of the given dateTime as a number.

MonthName(dateTime, format)

Copy link

Get the month name for a date

MonthName(Date(2013, 4, 18))
April

Required Inputs

dateTime
A date/time

Optional Inputs

format
Use "MMM" for appreviated month name, or "MMMM" for full month name.

Output

Outputs the month name for given dateTime as text.

NetWorkingDays(startDate, endDate, holidays)

Copy link

Count working days between dates

NetWorkingDays(Date(2016, 2, 1), Date(2016, 2, 3))
3

Required Inputs

startDate
The date to count from
endDate
The date to count to

Optional Inputs

holidays
A list of dates to exclude from the count (e.g. holidays)

Output

Outputs the count of working days between startDate and endDate excluding holidays.

Get the current date/time

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

Output

Outputs the current date and time. Updates once per second.

RelativeDate(dateTime, months)

Copy link

Add months to a date/time

RelativeDate(Date(2016, 1, 1), 2)
3/1/2016

Inputs

dateTime
A date/time
months
Months to add (can be negative)

Output

Outputs months added to dateTime rounded to the day.

Second(dateTime)

Copy link

Get the "second" from a date/time

Second(Time(1, 30, 45))
45

Inputs

dateTime
A date/time

Output

Outputs the seconds part of the given dateTime as a number.

Time(hour, minute, second)

Copy link

Create a time value

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

Inputs

hour
The hour as a number
minute
The minute as a number
second
The second as a number

Output

Outputs the time of the provided hour, minute, and second.

TimeValue(time)

Copy link

Convert a time to a number

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

Inputs

time
A time or date/time

Output

Outputs time as a decimal ratio of the day.

ToDate(text)

Copy link

Convert text into a date value

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

Inputs

text
Text in a recognized date format such as "MM-DD-YY" or "YYYY/MM/DD"

Output

Outputs the value of text parsed into a date. Outputs blank if text can't be parsed.

ToDateTime(datetime)

Copy link

Converts text into a date/time

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

Inputs

datetime
Text in a recognized date format such as "MM-DD-YY HH:MM:SS"

Output

Outputs the value of datetime parsed into a date and time. Outputs blank if datetimecan't be parsed.

ToTime(value)

Copy link

Converts a value into a time

ToTime("5:30:18 PM")
5:30:18 PM
ToDateTime("2013-03-14 18:13:23").ToTime()
6:13:23 PM

Inputs

value
A value to convert

Output

Outputs the value of value parsed into a time. Outputs blank if valuecan't be parsed.

Today()

Copy link

Get today's date

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

Output

Outputs the current date. Updates daily.

WeekNumber(dateTime, returnType)

Copy link

Get the week number of a date

WeekNumber(Date(1776, 7, 4))
27

Required Inputs

dateTime
A date/time

Optional Inputs

returnType
Currently unused parameter

Output

Outputs the week of dateTime as a number between 1 and 52.

Weekday(dateTime, returnType)

Copy link

Get the day-of-week of a date/time as a number

Weekday(Date(1776, 7, 4))
5

Required Inputs

dateTime
A date/time

Optional Inputs

returnType
Currently unused parameter

Output

Outputs the day-of-week of dateTime as a number between 1 and 7. Sunday = 1.

WeekdayName(dateTime)

Copy link

Get the day-of-week of a date as text

WeekdayName(Date(1776, 7, 4))
Thursday

Inputs

dateTime
A date/time

Output

Outputs the day-of-week of dateTime as text ("Monday", "Tuesday", etc.).

Workday(startDate, numWorkingDays, holidays)

Copy link

Adds working days to a date

Workday(Date(2016, 2, 1), 5)
2/8/2016

Required Inputs

startDate
The date to count from
numWorkingDays
Number of work days (Mon-Fri) to move the date forward

Optional Inputs

holidays
A list of dates to exclude from the count (e.g. holidays)

Output

Outputs a date based on your startDate plus the numWorkingDays you wish to move forward skipping over any dates included in holidays.

Year(dateTime)

Copy link

Get the year of a date

Year(Date(1776, 7, 4))
1776

Inputs

dateTime
A date/time

Output

Outputs the year of the given dateTime as a number.

Duration

Days(days)

Copy link

Create a time duration (for days)

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

Inputs

days
The number of days

Output

Outputs a time duration for the specified number of days.

Duration(days, hours, minutes, seconds)

Copy link

Create a time duration

Duration(4, 3, 2, 1)
4 days 3 hrs 2 mins 1 sec

Optional Inputs

days
The number of days
hours
The number of hours
minutes
The number of minutes
seconds
The number of seconds

Output

Outputs a time duration for the specified number of days, hours, minutes, and seconds.

Hours(hours)

Copy link

Create a time duration (for hours)

Hours(12)
12 hrs
Hours(36)
1 day 12 hours

Inputs

hours
The number of hours

Output

Outputs a time duration for the specified number of hours.

Minutes(minutes)

Copy link

Create a time duration (for minutes)

Minutes(3)
3 min
Minutes(84)
1 hour 24 mins

Inputs

minutes
The number of minutes

Output

Outputs a time duration for the specified number of minutes.

Seconds(seconds)

Copy link

Create a time duration (for seconds)

Seconds(38)
38 seconds
Seconds(80)
1 min 20 seconds

Inputs

seconds
The number of seconds

Output

Outputs a time duration for the specified number of seconds.

ToDays(duration)

Copy link

Convert a time duration into a number of days

ToDays(Hours(12))
0.5
ToDays(Duration(days: 1, hours: 6))
1.25

Inputs

duration
The time duration to convert

Output

Outputs a number of days for the specified duration.

ToHours(duration)

Copy link

Convert a time duration into a number of hours

ToHours(Minutes(120))
2
ToHours(Duration(days: 1, hours: 6))
30

Inputs

duration
The time duration to convert

Output

Outputs a number of hours for the specified duration.

ToMinutes(duration)

Copy link

Convert a time duration into a number of minutes

ToMinutes(Seconds(120))
2
ToMinutes(Duration(days: 1, hours: 6))
1800

Inputs

duration
The time duration to convert

Output

Outputs a number of minutes for the specified duration.

ToSeconds(duration)

Copy link

Convert a time duration into a number of seconds

ToSeconds(Minutes(120))
7200
ToSeconds(Duration(days: 1, hours: 6))
108000

Inputs

duration
The time duration to convert

Output

Outputs a number of seconds for the specified duration.

Filters

AverageIf(list, expression)

Copy link

Compute the average of a filtered list of numbers

List(1,2,3,4).AverageIf(CurrentValue > 2)
3.5

Inputs

list
List of numbers or number column
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.

Output

Outputs the average of a list of numbers for values matching expression. Blank values are ignored.

CountIf(list, expression)

Copy link

Get the count for a filtered list

States.CountIf(Population < 1000000)
7
CountIf(List(1,2,3,4), CurrentValue > 2)
2

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.

Output

Outputs the count of values in list for values matching expression. Blank values are ignored.

Filter(list, expression)

Copy link

Gets a list of values that match your filter

Fruits.Filter(Color = "Green")
[@Lime, @Kiwi, @Honeydew]
List(1,2,3,4).Filter(CurrentValue > 2)
[3, 4]

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.

Output

Outputs a list of all values in list that match expression.

IsFromTable(row, table)

Copy link

Check if a reference is from a table

IsFromTable(@Bill Clinton, [Presidents])
true

Inputs

row
The row to check
table
The table to search

Output

Outputs True if row is a row in table. Otherwise outputs False.

Lookup(table, column, match value)

Copy link

Get the rows from a table that match your filter

Lookup(Tasks, Project, thisRow)
[@Get estimate, @Schedule work, @Get permit]
Lookup(Tasks, Status, "Not Started")
[@Schedule work, @Get permit]

Inputs

table
The table to get rows from
column
The column to search in table
match value
The value to search for in column

Output

Outputs the rows from a table where column is the same as match value. We recommend using Table.Filter() instead.

Matches(value, control)

Copy link

Checks if a Coda control matches a value

[Color Column].Matches([Color Select Control])
true

Inputs

value
A value to check against the control
control
A control to check against the value

Output

Outputs True if the given value matches the control. Otherwise outputs False.

SumIf(list, expression)

Copy link

Compute the sum for a filtered list

List(1,2,3,4).SumIf(CurrentValue > 2)
7

Inputs

list
List of numbers or number column
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.

Output

Outputs the sum of a list of numbers for values matching expression. Blank values are ignored.

Info

IsBlank(value)

Copy link

Check if a value is blank

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

Inputs

value
A value to check

Output

Outputs True if the given value is blank. Otherwise, outputs False.

IsDate(value)

Copy link

Checks if a value is a date

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

Inputs

value
A value to check

Output

Outputs True if the given value is a date. Otherwise, outputs False.

IsLogical(value)

Copy link

Checks if a value is true of false

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

Inputs

value
A value to check

Output

Outputs True if the given value is True or False. Outputs Falseif it's neither.

IsNotBlank(value)

Copy link

Checks if a value is not blank

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

Inputs

value
A value to check

Output

Outputs True if the given value is not blank. Otherwise, outputs False.

IsNotText(value)

Copy link

Checks if a value is not text

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

Inputs

value
A value to check

Output

Outputs True if the given value is not blank. Otherwise, outputs False.

IsNumber(value)

Copy link

Checks if a value is a number

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

Inputs

value
A value to check

Output

Outputs True if the given value is a number. Otherwise, outputs False.

IsText(value)

Copy link

Checks if a value is text

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

Inputs

value
A value to check

Output

Outputs True if the given value is text. Otherwise, outputs False.

ToNumber(value, base)

Copy link

Convert a value to a number

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

Required Inputs

value
A value to convert

Optional Inputs

base
The base or radix used to parse value. Defaults to 10.

Output

Outputs value as a number if conversion with base is possible. Otherwise outputs value.

ToText(value)

Copy link

Convert a value to text

ToText(11431)
"11431"

Inputs

value
A value to convert

Output

Outputs value as text.

Logical

And(value)

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

Inputs

value…
A value to check

Output

Outputs True if all value(s) are true. Otherwise returns False.

False()

Copy link

Outputs false

False()
false

Output

Outputs False.

If(condition, ifTrue, ifFalse)

Copy link

Get a value conditionally (single condition)

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

Inputs

condition
An expression that outputs true or false
ifTrue
A value to output if condition is true
ifFalse
A value to output if condition is false

Output

Outputs ifTrue if the condition is true. Otherwise outputs ifFalse.

IfBlank(value, ifBlank)

Copy link

Get a value with fallback if blank

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

Inputs

value
The value to return if not blank
ifBlank
The value outputted if valueis blank

Output

Outputs ifBlank if value is blank. Otherwise outputs value.

Not(value)

Copy link

Negate a true or false value

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

Inputs

value
A value to negate

Output

Outputs True if valueis false and False if value is true.

Or(value)

Copy link

Check if any input is true

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

Inputs

value…
A value to check

Output

Outputs True if any value is true. Otherwise outputs False.

Switch(expression, value, result, arg)

Copy link

Get a value conditionally. Handles multiple conditions

Switch(Year(Today()), 2019, "The past", 2020, "The now", 2021, "The future")
The now
Switch("In progress", "Done", 10, "Open", 1, 5)
5

Inputs

expression
A value or expression to check
value
Check if this matches expression
result
If value matches expression output this value
arg…
Any number of value and result pairs followed by an optional default value

Output

Outputs the first result where value matches expression. Outputs an optional final value if no value matches.

SwitchIf(condition, ifTrue, arg)

Copy link

Get a value conditionally. Handles multiple conditions with a fallback

SwitchIf(Today() > Date(2019, 01, 20), "Hello future!", Year(Today()) = 2017, "Hello present!", Today() < Date(2017, 03, 04), "Hello past!")
Hello present!

Inputs

condition
A formula that ouputs true or false
ifTrue
A value to output if condition is true
arg…
Any number of condition and ifTrue pairs followed by an optional default value

Output

Outputs the first ifTrue value where condition is true. Outputs the an optional final value if no condition is true.

True()

Copy link

Outputs true

True()
true

Output

Outputs true.

Math

AbsoluteValue(number)

Copy link

Get the absolute value of a number

AbsoluteValue(-14)
14
AbsoluteValue(123)
123

Inputs

number
A number

Output

Outputs number without the sign, so negative numbers become positive in the output.

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

Inputs

value…
A numeric value or list of numeric values

Output

Outputs the average value. Blank values are ignored. All items in value are averaged if value is a list.

BinomialCoefficient(n, k)

Copy link

Calculates the Binomial Coefficient

BinomialCoefficient(6, 2)
15

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

Output

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

Ceiling(value, factor)

Copy link

Rounds a number up to the nearest multiple

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

Required Inputs

value
A number to round up

Optional Inputs

factor
A number multiple that value should round up to. Defaults to 1

Output

Outputs value rounded up to the nearest multiple of factor.

Even(value)

Copy link

Rounds a number up to the nearest even number

Even(3)
4
Even(2.33)
4

Inputs

value
A number to round

Output

Outputs value rounded up to the nearest even number.

Exponent(value)

Copy link

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

Exponent(2)
7.389056099

Inputs

value
A number

Output

Outputs Euler's number for value e (~2.718) raised to a power.

Factorial(value)

Copy link

Calculates the product of an integer and all the integers below it

Factorial(4)
24

Inputs

value
An integer number

Output

Outputs the product of an integer value and all the integers below it. If the number if a decimal will only use the initial integer. Note: Inputs greater than 19 may cause precision errors.

Floor(value, factor)

Copy link

Rounds a number down to the nearest multiple

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

Required Inputs

value
A number to round down

Optional Inputs

factor
A number multiple that value should round up to. Defaults to 1

Output

Outputs value rounded down to the nearest multiple of factor.

IsEven(value)

Copy link

Checks if a value is even

IsEven(17)
false
IsEven(6)
true

Inputs

value
A value to check

Output

Outputs True if value is even. Otherwise returns False.

IsOdd(value)

Copy link

Checks if a value is odd

IsOdd(17)
true
IsOdd(6)
false

Inputs

value
A value to check

Output

Outputs True if value is odd. Otherwise returns False.

Ln(number)

Copy link

Get the natural logarithm of a number. (Base e)

Ln(100)
4.605170186

Inputs

number
A number

Output

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

Log(number, base)

Copy link

Get the logarithm of a number for a given base

Log(128, 2)
7

Inputs

number
A number
base
Logarithm base to use

Output

Outputs the logarithm of number to base.

Log10(number)

Copy link

Get the logarithm of a number (base 10)

Log10(100)
2

Inputs

number
A number

Output

Get the logarithm of number (base 10).

Max(value)

Copy link

Get the maximum number or date/time

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

Inputs

value…
A numeric value or list of numeric values

Output

Outputs the maximum value. Blank values are ignored. Checks all items in value if value is a list.

Median(value)

Copy link

Get the median number or date/time

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

Inputs

value…
A numeric value or list of numeric values

Output

Outputs the median value. Blank values are ignored. Checks all items in value if value is a list.

Min(value)

Copy link

Gets the minimum number or date/time

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

Inputs

value…
A numeric value or list of numeric values

Output

Outputs the minimum value. Blank values are ignored. Checks all items in value if value is a list.

Mode(value)

Copy link

Get the most common value

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

Inputs

value…
A value or list of values

Output

Outputs the mode (most frequently occurring) value. Blank values are ignored. Checks all items in value if value is a list.

Odd(value)

Copy link

Rounds a number up to the nearest odd number

Odd(2)
3
Odd(1.23)
3

Inputs

value
A number to round

Output

Outputs value rounded up to the nearest odd number.

Percentile(dataset, percentile)

Copy link

Get the value at a given percentile of a dataset

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

Inputs

dataset
A list of numbers
percentile
The percentile from dataset to return

Output

Outputs the interpolated value at the given percentile within dataset.

PercentileRank(dataset, value)

Copy link

Get percentile rank of a value in a dataset

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

Inputs

dataset
A list of numbers
value
The value to find within dataset

Output

Outputs the percentile rank of value within dataset.

The mathematical π (pi) constant

Pi()
3.141592654

Output

Outputs the mathematical π (pi) constant.

Power(number, exponent)

Copy link

Calculates a number raised to a power

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

Inputs

number
A number to be raised to a power
exponent
The power to raise number by

Output

Outputs number raised to exponent.

Product(value)

Copy link

Multiplies numbers together

Product(3, 5, 2)
30

Inputs

value…
A number of list of numbers to multiply

Output

Outputs the mathematical product of all values. Blank values are ignored. Multiplies all itmes in value if value is a list.

Quotient(dividend, divisor)

Copy link

Divide one number by another

Quotient(10, 5)
2

Inputs

dividend
A number to divide
divisor
A number to divide dividend by

Output

Outputs dividend divided by divisor.

Random(updateContinuously)

Copy link

Generate a random number

Random()
0.423029953691942

Optional Inputs

updateContinuously
If true the output will change on every doc edit. Otherwise, the number will only be generated once. Defaults to true.

Output

Outputs a random number between 0 and 1. Regnerates on every edit by default.

Rank(value, dataset, ascending)

Copy link

Returns the ordered position of a value in a list

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

Required Inputs

value
The value to rank
dataset
The list of numbers to sort and then search

Optional Inputs

ascending
If true dataset will be sorted in ascending order, else descending. Defaults to true.

Output

Outputs the position of a value within dataset when sorted.

Remainder(dividend, divisor)

Copy link

Gets the remainder from dividing two numbers

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

Inputs

dividend
A number of divide
divisor
A number to divide dividend by

Output

Outputs the remainder when dividend is divided by divisor.

Round(number, places)

Copy link

Round a number

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

Required Inputs

number
A number to round

Optional Inputs

places
The number of decimal places to round to

Output

Outputs number rounded to the specific number of decimal places.

RoundDown(number, places)

Copy link

Round a number down

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

Required Inputs

number
A number to round

Optional Inputs

places
The number of decimal places to round to

Output

Outputs number rounded down to the specified number of decimal places.

RoundTo(value, factor)

Copy link

Rounds one number to the nearest integer multiple of another

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

Inputs

value
A number to round
factor
A numeric multiple that value should round to

Output

Outputs value rounded to the nearest multiple of factor. If no factor is specifed rounds to the nearest integer.

RoundUp(number, places)

Copy link

Round a number up

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

Required Inputs

number
A number to round

Optional Inputs

places
The number of decimal places to round to

Output

Outputs number rounded up to the specified number of decimal places.

Sign(number)

Copy link

Get the sign of a number

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

Inputs

number
A number

Output

Outputs -1 if number is negative, 0 if number is zero, or 1 if number is positive.

SquareRoot(number)

Copy link

Calculates the square root of a number

SquareRoot(64)
8

Inputs

number
A number

Output

Outputs the square root of number.

Sum(value)

Copy link

Adds numbers together

Sum(1, 2, 3, 4)
10

Inputs

value…
A number or list of numbers to sum

Output

Outputs the mathematical sum of all values. Blank values are ignored. Sum all items in value if value is a list.

SumProduct(list1, list2)

Copy link

Calculates the total from multiplying two lists

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

Inputs

list1
A list of numbers
list2
An equally sized list of numbers

Output

Outputs the total sum of the products of list1 and list2. Each list must be of equal size.

Truncate(number, places)

Copy link

Truncates a number

Truncate(3.14159, 4)
3.1415

Required Inputs

number
A number

Optional Inputs

places
The number of decimal places to truncate at

Output

Outputs number truncated to places.

Misc

ParseCSV(csvString, delimiter)

Copy link

Converts a CSV to list

ParseCSV("Hello,World,!", ",")
["Hello", "World", "!"]
ParseCSV("I'm a TSV", Character(9))
["I'm", "a", "TSV"]

Required Inputs

csvString
A delimited string value.

Optional Inputs

delimiter
The delimiter to use. Defaults to ","

Output

Outputs a list of items by parsing a csvString delimited by a delimiter. The delimiter can be changed to work with other formats like TSV. You can also use our CSV importer for one-off imports.

Url(object, displayText)

Copy link

Get the url for an object

ExampleTable.Url()
https://coda.io/d/_d[your doc here]

Required Inputs

object
A Coda object. This includes tables, columns, rows, and docs.

Optional Inputs

displayText
Display Text to give to the URL object.

Output

Outputs a URL for object.

Object

ParseJSON(jsonString, path)

Copy link

Parses a JSON string

ParseJSON('{"name": "Mike", "location": "New York"}', "#/name")
[Mike]

Required Inputs

jsonString
A JSON string. For example: '{"name": "Bob", "age": 42}'

Optional Inputs

path
A path within the JSON; for example, "#/pull_request/state"

Output

Outputs the value parsed from jsonString at path. If path is not specified, outputs the entire parsed value.

People

CreatedBy(object)

Copy link

Get the creator for a row or other object

thisRow.CreatedBy()
@John Doe

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.

Output

Outputs the user who created object.

ModifiedBy(object)

Copy link

Returns the user who modified the previous item

thisRow.ModifiedBy()
@John Doe

Inputs

object
A Coda object. This includes tables, views, columns, rows, sections, and docs.

Output

Outputs the user who modified object most recently.

User()

Copy link

Get the current logged in user

User()
@John Doe

Output

Outputs the current user. Will be different for every user. Note: * User().email returns the current user emails * User().name returns the current users name *User().photo returns the current users photo *User().state returns the current users doc access (e.g. write access).

Ranges

BulletedList(value)

Copy link

Create a bulleted list of values

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

Inputs

value…
A value or list of values

Output

Outputs a bulleted list of given value(s).

NumberedList(value)

Copy link

Create a numbered list of values

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

Inputs

value…
A value or list of values

Output

Outputs a numbered list of given value(s).

Relational

RowId(row)

Copy link

A unique ID for a row

thisRow.RowId()
14

Inputs

row
A row in a table

Output

Outputs a unique ID for row.

Sort(dataset, ascending, column)

Copy link

Sort a list or column

List(1, 5, 3, 4, 2).Sort()
[1, 2, 3, 4, 5]
States.Sort(true, Population)
[California, Texas, New York...]

Required Inputs

dataset
A list or column to be sorted

Optional Inputs

ascending
True for ascending or False for descending
column
Column to sort on if sorting a table

Output

Outputs dataset in sorted order. Sort order and criteria are specified by the ascending and column inputs.

Shape

ClipCircle(image)

Copy link

Crops an image into a circle

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

Inputs

image
An image to crop

Output

Outputs a cropped circular image.

Embed(url, width, height, force)

Copy link

Get an HTML embed for a URL

Embed("https://www.youtube.com/watch?v=dQw4w9WgXcQ")
Embed("https://www.theverge.com/2017/10/19/16497444/coda-spreadsheet-krypton-shishir-mehrotra", 400, 500)

Required Inputs

url
The URL or web address to display

Optional Inputs

width
How wide to render the embed. Use 0 for default.
height
How tall to render the embed. Use 0 for default.
force
Load the URL directly in your browser. Used for pages with sign ins.

Output

Outputs an HTML embed for url with the specified width and height.

Hyperlink(url, displayValue)

Copy link

Create a link

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

Required Inputs

url
The URL or web address to link to

Optional Inputs

displayValue
The text to show

Output

Outputs a link that shows the given displayValue and navigates to url.

HyperlinkCard(url)

Copy link

Creates rich url card

HyperlinkCard("cnn.com")

Inputs

url
The URL or web address to display

Output

Outputs a card for the given url.

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

Copy link

Gets an image for a URL

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

Required Inputs

url
The URL of an image. Includes GIF, PNG, and JPG

Optional Inputs

width
How wide to render the image. Use 0 for default.
height
How tall to render the image. Use 0 for default.
name
Text to appear when hovering over the image
style
One of auto or circle

Output

Outputs an image for url with the specified width, height, name, and style.

Rectangle(width, height, color, name)

Copy link

Generates a rectangle

Rectangle(200, 20, "#007AF5")

Required Inputs

width
How wide to render the rectangle.

Optional Inputs

height
How tall to render the rectangle. Use 0 for default.
color
Color as RGB hex #RRGGBB (black if omitted)
name
Text to appear when hovering over the rectangle

Output

Outputs a rectangle with specified width, height, color, and name.

Spatial

Distance(location1, location2, unit)

Copy link

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

Distance(Location(33.9206418,-118.3303341), Location(37.4274787, -122.1719077))
521.8529425485297

Required Inputs

location1
Coordinates of lat and long. Use Location()
location2
Coordinates of lat and long. Use Location()

Optional Inputs

unit
"M"iles, "N"autical miles or "K"ilometers. Defaults to "K"ilometers if not specified

Output

Outputs the distance in specified unit between location1 and location2 using the Haversine formula.

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

Copy link

Get location for the provided lat-long

Location(33.9206418,-118.3303341)
[33.9206418,-118.3303341, , ]

Required Inputs

latitude
Position in decimal degrees
longitude
Position in decimal degrees

Optional Inputs

altitude
Altitude relative to sea level
heading
Direction of travel in degrees
speed
Meters per second
accuracy
accuracy of latitude and longitude in meters
altitudeAccuracy
accuracy of altitude in meters

Output

Outputs a single location object using latitude and longitude. Can also optionally include altitude, heading, speed, accuracy, and altitudeAccuracy. Useful with Distance().

String

Character(charNumber)

Copy link

Create a unicode character (symbol)

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

Inputs

charNumber
A number that matches a unicode value

Output

Outputs a single unicode character matching the charNumber given. https://en.wikipedia.org/wiki/List_of_Unicode_characters.

Concatenate(text)

Copy link

Combine multiple text values

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

Inputs

text…
Any text value. Includes text, numbers, and dates

Output

Outputs the combined text of all text values as a single text value.

EncodeForUrl(text)

Copy link

Encodes text use in a URL

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

Inputs

text
The text to encode

Output

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

EndsWith(text, suffix)

Copy link

Check if text ends with a suffix

EndsWith("Hello world", "Find me")
false
EndsWith("Hello world", "world")
true

Inputs

text
The text to check
suffix
The ending sub-text to check for

Output

Outputs True if text ends with suffix. Otherwise outputs False.

Format(template, text)

Copy link

Substitute values into a text template

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

Inputs

template
A text value. 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.
text…
The text to insert at {X}. The first will insert at {1}, the second at {2} and so on

Output

Outputs text with all {X} values in template replaced with the matching text.

Join(delimiter, text)

Copy link

Combine multiple text values with a delimiter

Join("-", "This", "is", "Awesome")
This-is-Awesome

Inputs

delimiter
A text value to use as a delimiter
text…
Text or list of text values

Output

Outputs text combining all text(s) with delimiter in-between every item.

Left(text, numberOfCharacters)

Copy link

Extract starting characters from text

Left("Hello world", 3)
Hel

Inputs

text
The text to extract a prefix from
numberOfCharacters
The number of characters to output

Output

Outputs the starting numberOfCharacters from text.

LeftPad(text, targetLength, padString)

Copy link

Pad text from the left

LeftPad("10", 3)
10
LeftPad("99", 5, "0")
00099
LeftPad("foo", 1)
foo

Required Inputs

text
The value to pad the start of
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.

Optional Inputs

padString
The text to pad text with. Defaults to " " (space)

Output

Outputs text padded with padString at the start so that the resulting text has the given targetLength.

Length(text)

Copy link

Returns length of the given text

Length("Hello world")
11

Inputs

text
A text value

Output

Outputs the number of characters in text.

Lower(text)

Copy link

Convert text to lower case

Lower("Hello WORLD")
hello world

Inputs

text
A text value

Output

Outputs text with all characters made lower case.

Middle(text, start, numberOfCharacters)

Copy link

Extract characters from the middle of text

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

Inputs

text
A text value
start
The character position to start from. Starts at 1
numberOfCharacters
The number of characters to extract

Output

Outputs numberOfCharacters from text starting at position.

RegexMatch(text, regularExpression)

Copy link

Check if text matches a regular expression

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

Inputs

text
A text value
regularExpression
A Javascript regular expression. See https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions#Using_special_characters for documentation and test expressions at https://www.regextester.com

Output

Outputs True if text matches regularExpression.

RegexReplace(text, regularExpression, replacementText)

Copy link

Substitute regular expression matches

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

Inputs

text
A text value
regularExpression
A Javascript regular expression. See https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions#Using_special_characters for documentation and test expressions at https://www.regextester.com
replacementText
Text to substitute

Output

Outputs text with all regularExpression matches replaced with replacementText.

Repeat(text, repetitions)

Copy link

Repeats text multiple times

Repeat("ha", 4)
hahahaha

Inputs

text
The text to repeat
repetitions
How many times to repeat text

Output

Outputs text based on repeating text by the number of repetitions specified.

Replace(text, start, numberOfCharacters, replacementText)

Copy link

Replace a range within text

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

Inputs

text
A text value
start
The character position to start from. Starts at 1
numberOfCharacters
The number of characters to remove
replacementText
Text to substitute

Output

Outputs text with numberOfCharacters removed starting at and replaced with replacementText.

Right(text, numberOfCharacters)

Copy link

Extract ending characters from text

Right("Hello world", 3)
rld

Inputs

text
The text to extract a suffix from
numberOfCharacters
The number of characters to output

Output

Outputs ending characters of text.

RightPad(text, targetLength, padText)

Copy link

Pad text from the right

RightPad("10", 3)
10
RightPad("99", 5, "0")
99000
RightPad("foo", 1)
foo

Required Inputs

text
The value to pad the start of
targetLength
The length of the resulting text once text has been padded. If the value is lower than the current text's length, then text will be returned as is.

Optional Inputs

padText
The string to pad text with. Defaults to " " (space)

Output

Outputs text padded with padText at the end so that the resulting text has the given targetLength.

Split(text, delimiter)

Copy link

Split text on a delimiter

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

Inputs

text
A text value to split up
delimiter
The character that marks the dividing points of text

Output

Outputs a list generated from splitting text by the delimiter character.

StartsWith(text, prefix)

Copy link

Check if text starts with specified characters

StartsWith("Hello world", "Find me")
false
StartsWith("Hello world", "Hello")
true

Inputs

text
The text to check
prefix
The prefix to check for

Output

Outputs True if text starts with prefix. Otherwise outputs False.

Substitute(text, searchFor, replacementText)

Copy link

Replace a matching substring in some text

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

Inputs

text
A text value
searchFor
The text value to search for
replacementText
Text to substitue

Output

Outputs text with the first searchFor match replaced with replacementText.

ToByteSize(byteCount, base)

Copy link

Pretty-print a byte count (KB, MB, GB, etc.)

ToByteSize(265318)
265.32 kB
ToByteSize(265318, 2)
259.1 KB

Required Inputs

byteCount
A number of bytes

Optional Inputs

base
conversion base, 2 or 10 (default)

Output

Outputs a text rendering of byteCount (KB, MB, GB, etc.).

ToHexadecimal(decimalNumber, targetLength)

Copy link

Convert a number to a hexadecimal string

ToHexadecimal(10)
A
ToHexadecimal(10, 4)
000A

Required Inputs

decimalNumber
A decimal number

Optional Inputs

targetLength
The target length

Output

Outputs a text of decimalNumber converted to hexadecimal. Left-pads result with 0's to satisfy targetLength if specified.

Trim(text)

Copy link

Trim starting and ending spaces from text

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

Inputs

text
A text value

Output

Outputs text with all of the leading and trailing spaces removed.

Upper(text)

Copy link

Convert text to upper case

Upper("hello")
HELLO

Inputs

text
A text value

Output

Outputs text with all characters made upper case.

Actions

AddOrModifyRows(table, expression, column, columnValue)

Copy link

Modify matching rows or add one if none match

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".

Inputs

table
The table to modify
expression
Filter to rows you want to modify
column…
The column to populate
columnValue…
The value to set in column

Output

Outputs an action which (when run) will modify all rows in table matching expression with specified columnValue(s). If no rows match, will add a new row.

AddRow(table, column, columnValue)

Copy link

Add 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".

Inputs

table
The table to modify
column…
The column to populate
columnValue…
The value to set in column

Output

Outputs an action which (when run) will add a new row to table and update the specified column(s) with columnValue(s).

DeleteRows(rows)

Copy link

Deletes specified rows

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

Inputs

rows
A list of rows to delete

Output

Outputs an action which (when run) will delete each row in rows.

ModifyRows(rows, column, columnValue)

Copy link

Modify values in one or more rows

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.

Inputs

rows
The rows in a table to modify
column…
The column to modify
columnValue…
The value to set in column

Output

Outputs an action value which (when run) will modify the specified column(s) with columnValue(s) for each row in rows.

Notify(people, message)

Copy link

Notify doc users

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

Inputs

people
The person or list of people to notify
message
The message to send

Output

Outputs an action which (when run) will send message to people via an email and in-app notification.

OpenWindow(url)

Copy link

Open a link in a new tab

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

Inputs

url
The web address to open

Output

Outputs an action which (when run) will open url in a new browser tab.

Refresh(column)

Copy link

Refresh Pack columns

Refresh(PR)
The PR column will be refreshed.

Inputs

column…
The column to refresh

Output

Outputs an action which (when run) refreshes Pack data in column(s).

RunActions(action)

Copy link

Run one or more actions

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

Inputs

action…
The action to run

Output

Outputs an action which (when run) will run all provided action(s).

Barcode

CODE128(data)

Copy link

Generates a CODE128 barcode

Inputs

data
Data to generate a code for, usually a URL.

EAN13(EAN13)

Copy link

Generates an EAN13 barcode

Inputs

EAN13
Number to generate a EAN13 code for.

ISBN(ISBN)

Copy link

Generates an ISBN barcode

Inputs

ISBN
Number to generate an ISBN code for.

PDF417(data)

Copy link

Generates a PDF417 barcode

Inputs

data
Data to generate a code for, usually a URL.

QR(data)

Copy link

Generates a QR barcode

Inputs

data
Data to generate a code for, usually a URL.

UPC(UPC)

Copy link

Generates a UPC barcode

Inputs

UPC
Number to generate a UPC code for.

UPCE(UPC)

Copy link

Generates a UPC-E barcode

Inputs

UPC
Number to generate a UPC code for.

Cross-doc

AddRow(account, tableUrl, column, value)

Copy link

Adds a row to the specified table with the given values.

Inputs

account
The Cross-doc account used to take this action.
tableUrl
The URL of the table to add a row to.
column…
The name of the column to set the value for.
value…
The value to set for the column.

DeleteRow(account, rowUrl)

Copy link

Deletes the row.

Inputs

account
The Cross-doc account used to take this action.
rowUrl
The URL of the row to delete.

ModifyRow(account, rowUrl, column, value)

Copy link

Modifies the row with the given values.

Inputs

account
The Cross-doc account used to take this action.
rowUrl
The URL of the row to modify.
column…
The name of the column to set the value for.
value…
The value to set for the column.

PushButton(account, rowUrl, column)

Copy link

Pushes the button at the given location.

Inputs

account
The Cross-doc account used to take this action.
rowUrl
The URL of the row to push the button on.
column
The name of the column that contains the button.

Discourse

Category(account, url)

Copy link

Retrieves a category and the latest topics.

Inputs

account
The Discourse account used to pull in this data.
url
A Discourse category URL. For example, "https://discourse.example.com/c/latest".

Post(account, url)

Copy link

Retrieve information about a post.

Inputs

account
The Discourse account used to pull in this data.
url
A Discourse topic or post URL. For example, "https://discourse.example.com/t/hello-there/1/2".

Topic(account, url)

Copy link

Retrieve information about a topic.

Inputs

account
The Discourse account used to pull in this data.
url
A Discourse topic URL. For example, "https://discourse.example.com/t/hello-there/1".

Dropbox

Item(account, fileOrFolder)

Copy link

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

Inputs

account
The Dropbox account used to pull in this data.
fileOrFolder
Name of a file or folder.

ItemsInFolder(account, folder)

Copy link

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

Inputs

account
The Dropbox account used to pull in this data.
folder
Name of a folder.

Members(account, file)

Copy link

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

Inputs

account
The Dropbox account used to pull in this data.
file
Name of a file.

ReceivedFiles(account)

Copy link

Gets a user's received files.

Inputs

account
The Dropbox account used to pull in this data.

Revisions(account, file)

Copy link

Gets revisions for a user's file.

Inputs

account
The Dropbox account used to pull in this data.
file
Name of a file.

SharedFolders(account)

Copy link

Gets a user's shared folders.

Inputs

account
The Dropbox account used to pull in this data.

SharedLinks(account, folderScope)

Copy link

Gets a user's shared links.

Required Inputs

account
The Dropbox account used to pull in this data.

Optional Inputs

folderScope
Folder scope of linked file(s) or folder(s).

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/[...]".

GitHub

CodeSearch(account, query, username, organization, repoUrl)

Copy link

Search the GitHub repo for code. See https://help.github.com/en/articles/searching-code for limitations

Required Inputs

account
The GitHub account used to pull in this data.
query
The query to use to search for code, supporting GitHub search query syntax

Optional Inputs

username
The username of the GitHub user. For example, "alice".
organization
Organization to list repositories. For example, "nasa".
repoUrl
The URL of the repository to list commits or pull requests from. For example "https://github.com/[org]/[repo]".

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

Required Inputs

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

Optional Inputs

endSha
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.

Required Inputs

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

Optional Inputs

base
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 commits or pull requests from. For example "https://github.com/[org]/[repo]".

Repos(account, username, organization)

Copy link

List repositories for an organization or username.

Required Inputs

account
The GitHub account used to pull in this data.

Optional Inputs

username
The username of the GitHub user. For example, "alice".
organization
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.

Required 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.

Optional Inputs

cc
An email address to CC.
bcc
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.

Required Inputs

account
The Gmail account used to pull in this data.

Optional Inputs

search
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.

Required Inputs

account
The Gmail account used to pull in this data.

Optional Inputs

search
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
The maximum number of threads to return.

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

Copy link

Sends an email from your Gmail account.

Required 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.

Optional Inputs

cc
An email address to CC.
bcc
An email address to BCC.
from
The email address to send the email from.
replyTo
The email's reply-to address. This is where replies to the email should be sent.
hideSignature
Should the email include the document link.

ThreadCount(account, search)

Copy link

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

Required Inputs

account
The Gmail account used to pull in this data.

Optional Inputs

search
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.

Required Inputs

account
The Gmail account used to pull in this data.

Optional Inputs

search
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
The maximum number of threads to return.

Google Calendar

BusyTimes(account, calendar, minDate, maxDate)

Copy link

Returns busy times from the given calendar.

Required Inputs

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

Optional Inputs

calendar
The URL, ID, or name of the calendar to use.
minDate
The earliest date. For example, `Today() - Days(14)`.
maxDate
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, color, location, showAsAvailable, conferenceType)

Copy link

Adds an event to the calendar.

Required 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)`

Optional Inputs

isAllDay
If true, make the event all day. If false, use the start and end times
description
The description of event.
calendar
The URL, ID, or name of the calendar to use.
recurrenceFrequency
If specified, must be one of "YEARLY", "MONTHLY", "WEEKLY", "EVERY WEEKDAY", "DAILY", or "HOURLY"
recurrenceCount
The count of recurring instances of this event; default is to repeat forever.
attendees
A list of attendee emails for the event.
color
The color of the event
location
The location of the event
showAsAvailable
If true, does not block time on the calendar for the attendee.
conferenceType
If specified, must be one of "Hangouts", "Classic Hangouts", "Meet"

Event(account, event, calendar)

Copy link

Get data about a Google Calendar event.

Required Inputs

account
The Google Calendar account used to pull in this data.
event
The URL or ID of an event.

Optional Inputs

calendar
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.

Required Inputs

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

Optional Inputs

calendar
The URL, ID, or name of the calendar to use.
minDate
The earliest date. For example, `Today() - Days(14)`.
maxDate
The latest date. For example, `Today() + Days(14)`.
search
A search terms to filter events. You can leave this blank to return all events.
maxResults
The maximum number of items to return.
flattenRecurring
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".

Required 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".

Optional Inputs

calendar
The URL, ID, or name of the calendar to use.

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

Copy link

Updates an existing event.

Required 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)`

Optional Inputs

isAllDay
If true, make the event all day. If false, use the start and end times
description
The description of event.
calendar
The URL, ID, or name of the calendar to use.
attendees
A list of attendee emails for the event.
color
The color of the event
location
The location of the event
showAsAvailable
If true, does not block time on the calendar for the attendee.

Google Contacts

AddContact(account, firstName, lastName, groupName, emailAddress, phoneNumber)

Copy link

Add a new contact.

Required Inputs

account
The Google Contacts account used to take this action.
firstName
The first name of the contact to create.
lastName
The last name of the contact to create.

Optional Inputs

groupName
The name of the group to add the new contact to, for example "Coworkers".
emailAddress
The email address to add to the new contact.
phoneNumber
The phone number to add to the new contact.

CreateGroup(account, groupName)

Copy link

Create a new contact group.

Inputs

account
The Google Contacts account used to take this action.
groupName
The name of the group to create, for example "Coworkers".

DeleteGroup(account, groupName)

Copy link

Delete an existing contact group.

Inputs

account
The Google Contacts account used to take this action.
groupName
The name of the group to delete, for example "Coworkers".

Group(account, groupName)

Copy link

Retrieve details for a contact group.

Inputs

account
The Google Contacts account used to pull in this data.
groupName
The name of the group, for example "Coworkers".

Groups(account)

Copy link

Retrieve the list of available contact groups.

Inputs

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

Google Drive

DriveFile(account, url)

Copy link

Gets metadata for a Google Drive file

Inputs

account
The Google Drive account used to pull in this data.
url
The url to a Google Drive file.

DriveFileThumbnail(account, url)

Copy link

Gets a thumbnail for a Google Drive file

Inputs

account
The Google Drive account used to pull in this data.
url
The url to a Google Drive file.

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.

Google Search Console

PageAnalytics(account, pageUrl, startdate, endDate, facetByQuery, facetByCountry, facetByDevice, filterByQuery, minimumImpressions, exactQueryMatch, invertQueryResults)

Copy link

Returns analytics about the given page over the specified time period

Required Inputs

account
The Google Search Console account used to pull in this data.
pageUrl
URL of the page to return data for

Optional Inputs

startdate
Date to start fetching data for (defaults to seven days ago)
endDate
Date to end fetching data for (defaults to today)
facetByQuery
True if the results should be faceted by query
facetByCountry
True if the results should be faceted by country
facetByDevice
True if the results should be faceted by device type
filterByQuery
If specified, returns only page results that contain the given query
minimumImpressions
If specified, filters groups that do not meet the minimum impression count. Defaults to 50.
exactQueryMatch
True if results should only include exact query matches
invertQueryResults
True if results should not include the given query

QueryAnalytics(account, siteUrl, query, startdate, endDate, facetByPageUrl, facetByCountry, facetByDevice, filterByPageUrl, minimumImpressions, exactQueryMatch, invertQueryResults)

Copy link

Returns analytics about the given query over the specified time period

Required Inputs

account
The Google Search Console account used to pull in this data.
siteUrl
URL of the site to pull analytics data for.
query
Query to search for

Optional Inputs

startdate
Date to start fetching data for (defaults to seven days ago)
endDate
Date to end fetching data for (defaults to today)
facetByPageUrl
True if the results should be faceted by page URL
facetByCountry
True if the results should be faceted by country
facetByDevice
True if the results should be faceted by device type
filterByPageUrl
If specified, returns only page results that contain the given page URL
minimumImpressions
If specified, filters groups that do not meet the minimum impression count.
exactQueryMatch
True if results should only include exact query matches
invertQueryResults
True if results should not include the given query

Sites(account)

Copy link

Returns available sites from Google Search Console.

Inputs

account
The Google Search Console account used to pull in this data.

Google Translate

Languages()

Copy link

Retrieves the list of officially supported languages.

Translate(text, targetLanguage, sourceLanguage)

Copy link

Translates a word or phrase between languages

Required Inputs

text
The text to translate.
targetLanguage
The ISO 639-1 code or English name of the target language.

Optional Inputs

sourceLanguage
The ISO 639-1 code or English name of the language of the text to be translated. This will be autodetected based on the input if omitted.

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/[...]".

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

Copy link

Create a new candidate.

Required 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).

Optional Inputs

company
The current company of the candidate.
title
The current title of the candidate.
email
The email of the candidate.

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

Copy link

Create a new prospect.

Required 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).

Optional Inputs

company
The current company of the prospect.
title
The current title of the prospect.
email
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 take this action.

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.

Required 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.

Optional Inputs

attachmentUrl
The URL of the attachment.
conversationUrl
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.

Required Inputs

account
The Intercom account used to pull in this data.

Optional Inputs

isUnassigned
If specified, returns unassigned conversations.
userEmail
If specified, returns conversations from the given user.

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

Copy link

Creates a company.

Required Inputs

account
The Intercom account used to take this action.
name
The name of the company. For example, "ACME".

Optional Inputs

website
The website of the company. For example, "https://example.com".
companyId
The company's ID.
industry
The industry the company is a part of.
size
The number of employees the company has.
monthlySpend
The amount of monthly revenue received from this company.
plan
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.

Required Inputs

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

Optional Inputs

name
The name of the lead.
userId
The user's ID.
phone
The phone number of the lead. For example "555-555-5555".
isUnsubscribed
True if the lead is unsubscribed; false otherwise.

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

Copy link

Creates a user.

Required Inputs

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

Optional Inputs

name
The name of the user.
userId
The user's ID.
phone
The phone number of the user. For example "555-555-5555".
isUnsubscribed
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.

Required 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.

Optional Inputs

attachmentUrl
The URL of the attachment.
conversationUrl
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.

Required 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.

Optional Inputs

attachmentUrl
The URL of the attachment.
conversationUrl
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.

Required Inputs

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

Optional Inputs

message
The text of an optional message to send.
attachmentUrl
The URL of the attachment.
conversationUrl
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/[...]".

Jira

CreateIssue(account, projectName, issueType, summary, description)

Copy link

Create a new issue.

Required Inputs

account
The Jira account used to take this action.
projectName
Name of the project for which issues should be fetched
issueType
Type of the issue in Jira. For example: "Bug", "Task", etc
summary
Summary of issue

Optional Inputs

description
Expanded description of the issue

LaTeX

Math(source)

Copy link

Generate LaTeX output.

Inputs

source
Source TeX code.

Lever

Candidate(account, url)

Copy link

Get metadata from Lever for a candidate.

Inputs

account
The Lever account used to pull in this data.
url
A Lever candidate url.

Posting(account, url)

Copy link

Get metadata from Lever for a posting.

Inputs

account
The Lever account used to pull in this data.
url
A Lever posting url.

MLB

Batting(playerNameOrUrl, gameType, season, career)

Copy link

Returns batting statistics for the player.

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

Optional Inputs

gameType
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
The year to return statistics for (e.g 2018). If unspecified, the current year is used.
career
If specified, returns career statistics for the player instead of season stats.

BattingProjection(playerNameOrUrl, season)

Copy link

Returns batting projections for the player.

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

Optional Inputs

season
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.

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

Optional Inputs

gameType
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
The year to return statistics for (e.g 2018). If unspecified, the current year is used.
career
If specified, returns career statistics for the player instead of season stats.

PitchingProjection(playerNameOrUrl, season)

Copy link

Returns pitching projections for the player.

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

Optional Inputs

season
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.

Required Inputs

playerName
The full name of the NBA player.

Optional Inputs

season
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
If specified, returns statistics for the playoffs for the given season.

Shopify

AdjustInventory(account, variantId, adjustment, location)

Copy link

Adjusts the inventory for a given variant at a given location by a given amount.

Inputs

account
The Shopify account used to take this action.
variantId
The id of the variant for which to update inventory.
adjustment
A positive or negative number to add to the current inventory level.
location
The name of the location for which the inventory should be updated.

CreateCustomer(account, email, firstName, lastName, phone, tags, note, address1, address2, city, zip, provinceCode, country, countryCode, company)

Copy link

Creates a new Shopify customer and returns the ID.

Required Inputs

account
The Shopify account used to take this action.

Optional Inputs

email
Email of the customer.
firstName
First name of the customer.
lastName
Last name of the customer.
phone
Phone number of the customer.
tags
Arbitrary tags to describe the customer, comma-separated.
note
Arbitrary text notes about the customer.
address1
The first address line, if adding an address for the customer.
address2
The second address line, if adding an address for the customer.
city
The address city, if adding an address for the customer.
zip
The address zip, if adding an address for the customer.
provinceCode
The address state or province code, if adding an address for the customer.
country
The address country name, if adding an address for the customer.
countryCode
The address country code, if adding an address for the customer. If you provide a country code, Shopify requires that you also provide a country field.
company
The address company, if adding an address for the customer.

CreateProduct(account, title, description, type, options, tags, vendor, published, publishedScope, images)

Copy link

Creates a new Shopify product and returns the ID.

Required Inputs

account
The Shopify account used to take this action.
title
The product title

Optional Inputs

description
The product description
type
Product type
options
A comma-separated list of up to 3 options for how this product can vary. Options are thigns like "Size" or "Color".
tags
A comma separated string of product tags
vendor
The product vendor
published
Whether or not this product should be published to the online store. Default: true.
publishedScope
Either "web" or "global". If "global", the product is published both in the Online Store as well as the Point of Sale (if it existis). If "web", the product is published only in the Online Store.
images
One or more images to include in the product listing.

CreateSimpleProduct(account, title, description, type, tags, vendor, published, publishedScope, images, price, sku, barcode, compareAtPrice, cost, fulfillmentService, inventoryManagement, inventoryPolicy, taxable, taxCode, weight, weightUnit)

Copy link

Creates a new Shopify product that only has a single variant and returns the ID.

Required Inputs

account
The Shopify account used to take this action.
title
The product title

Optional Inputs

description
The product description
type
Product type
tags
A comma separated string of product tags
vendor
The product vendor
published
Whether or not this product should be published to the online store. Default: true.
publishedScope
Either "web" or "global". If "global", the product is published both in the Online Store as well as the Point of Sale (if it existis). If "web", the product is published only in the Online Store.
images
One or more images to include in the product listing.
price
The price of the item.
sku
The SKU identifier for the item.
barcode
A barcode, UPC, or ISBN identifier for the item.
compareAtPrice
The original price of the item. If this field is set, the item will be labeled as being on sale.
cost
The unit cost of the inventory item.
fulfillmentService
Either "manual" if this item is fulfilled manually, or the handle of a third-party fulfillment service.
inventoryManagement
Either "shopify" if this item's inventory is tracked in the Shopify admin, or the handle of a third-party fulfillment service if inventory is tracked there
inventoryPolicy
Either "deny" if this item cannot be sold when it is out of stock, or "continue" to allow the item to be sold even when out of stock.
taxable
Whether or not tax should be charged on this item.
taxCode
Specifies the Avalara tax code for the product variant, if the Avalara app is installed for this store.
weight
The weight of the item, in the given weight unit.
weightUnit
The weight unit for this product, one of "g", "kg", "oz", or "lb"

CreateVariant(account, productId, option1, option2, option3, price, sku, barcode, compareAtPrice, cost, fulfillmentService, inventoryManagement, inventoryPolicy, taxable, taxCode, weight, weightUnit)

Copy link

Creates a new Shopify variant and returns the ID.

Required Inputs

account
The Shopify account used to take this action.
productId
The id of the parent product for this variant.

Optional Inputs

option1
The value for the first of up to 3 options for the item. Options are things like Size or Color.
option2
The value for the second of up to 3 options for the item. Options are things like Size or Color.
option3
The value for the third of up to 3 options for the item. Options are things like Size or Color.
price
The price of the item.
sku
The SKU identifier for the item.
barcode
A barcode, UPC, or ISBN identifier for the item.
compareAtPrice
The original price of the item. If this field is set, the item will be labeled as being on sale.
cost
The unit cost of the inventory item.
fulfillmentService
Either "manual" if this item is fulfilled manually, or the handle of a third-party fulfillment service.
inventoryManagement
Either "shopify" if this item's inventory is tracked in the Shopify admin, or the handle of a third-party fulfillment service if inventory is tracked there
inventoryPolicy
Either "deny" if this item cannot be sold when it is out of stock, or "continue" to allow the item to be sold even when out of stock.
taxable
Whether or not tax should be charged on this item.
taxCode
Specifies the Avalara tax code for the product variant, if the Avalara app is installed for this store.
weight
The weight of the item, in the given weight unit.
weightUnit
The weight unit for this product, one of "g", "kg", "oz", or "lb"

SetInventory(account, variantId, quantity, location)

Copy link

Overwrites the inventory for a given variant at a given location.

Inputs

account
The Shopify account used to take this action.
variantId
The id of the variant for which to update inventory.
quantity
The new quantity to which to set the inventory level.
location
The name of the location for which the inventory should be updated.

UpdateCustomer(account, customerId, email, firstName, lastName, phone, tags, note)

Copy link

Updates an existing Shopify customer.

Required Inputs

account
The Shopify account used to take this action.
customerId
The id of the customer to update.

Optional Inputs

email
Email of the customer.
firstName
First name of the customer.
lastName
Last name of the customer.
phone
Phone number of the customer.
tags
Arbitrary tags to describe the customer, comma-separated.
note
Arbitrary text notes about the customer.

UpdateProduct(account, productId, title, description, type, tags, vendor, published, publishedScope)

Copy link

Updates an existing Shopify product.

Required Inputs

account
The Shopify account used to take this action.
productId
The id of the product to update.

Optional Inputs

title
The product title
description
The product description
type
Product type
tags
A comma separated string of product tags
vendor
The product vendor
published
Whether or not this product should be published to the online store. Default: true.
publishedScope
Either "web" or "global". If "global", the product is published both in the Online Store as well as the Point of Sale (if it existis). If "web", the product is published only in the Online Store.

UpdateVariant(account, variantId, option1, option2, option3, price, sku, barcode, compareAtPrice, cost, fulfillmentService, inventoryManagement, inventoryPolicy, taxable, taxCode, weight, weightUnit)

Copy link

Updates an existing Shopify variant.

Required Inputs

account
The Shopify account used to take this action.
variantId
The id of this variant.

Optional Inputs

option1
The value for the first of up to 3 options for the item. Options are things like Size or Color.
option2
The value for the second of up to 3 options for the item. Options are things like Size or Color.
option3
The value for the third of up to 3 options for the item. Options are things like Size or Color.
price
The price of the item.
sku
The SKU identifier for the item.
barcode
A barcode, UPC, or ISBN identifier for the item.
compareAtPrice
The original price of the item. If this field is set, the item will be labeled as being on sale.
cost
The unit cost of the inventory item.
fulfillmentService
Either "manual" if this item is fulfilled manually, or the handle of a third-party fulfillment service.
inventoryManagement
Either "shopify" if this item's inventory is tracked in the Shopify admin, or the handle of a third-party fulfillment service if inventory is tracked there
inventoryPolicy
Either "deny" if this item cannot be sold when it is out of stock, or "continue" to allow the item to be sold even when out of stock.
taxable
Whether or not tax should be charged on this item.
taxCode
Specifies the Avalara tax code for the product variant, if the Avalara app is installed for this store.
weight
The weight of the item, in the given weight unit.
weightUnit
The weight unit for this product, one of "g", "kg", "oz", or "lb"

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.

Required Inputs

account
The Spotify account used to take this action.
name
The name of the new playlist

Optional Inputs

description
Optional description of the playlist
isPublic
Whether the new playlist is public (true by default).
isCollaborative
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, device)

Copy link

Pauses user's currently playing track

Required Inputs

account
The Spotify account used to take this action.

Optional Inputs

device
The id of the device this command is targeting. If not supplied, the user’s currently active device is the target.

Play(account, device, context)

Copy link

Start or resume user's playback

Required Inputs

account
The Spotify account used to take this action.

Optional Inputs

device
The id of the device this command is targeting. If not supplied, the user’s currently active device is the target.
context
Spotify URI or Spotify URL of the context to play. Valid contexts are albums, artists, playlists.

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.

Required Inputs

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

Optional Inputs

period
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.

HistoricalQuotes(ticker, period)

Copy link

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

Required Inputs

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

Optional Inputs

period
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.

Optional Inputs

ticker
A ticker symbol to retrieve news for (e.g. GE, WMT). If unspecified, returns news about the general market.
limit
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).

Trigonometry

ArcCosine(ratio)

Copy link

Returns the angle (in radians) whose cosine is the given number.

Inputs

ratio
A trigonometric ratio

ArcSine(ratio)

Copy link

Returns the arcsine of a number (in radians).

Inputs

ratio
A trigonometric ratio

ArcTangent(ratio)

Copy link

Returns the angle (in radians) whose tangent is the given number.

Inputs

ratio
A trigonometric ratio

Cosine(angle)

Copy link

Returns the cosine of a number (in radians).

Inputs

angle
An angle measured in radians.

HyperbolicCosine(angle)

Copy link

Returns the hyperbolic cosine of a number (in radians).

Inputs

angle
An angle measured in radians.

HyperbolicSine(angle)

Copy link

Returns the hyperbolic sine of a number (in radians).

Inputs

angle
An angle measured in radians.

HyperbolicTangent(angle)

Copy link

Returns the hyperbolic tangent of a number (in radians).

Inputs

angle
An angle measured in radians.

Sine(angle)

Copy link

Returns the angle (in radians) whose sine is the given number

Inputs

angle
An angle measured in radians.

Tangent(angle)

Copy link

Returns the tangent of a number (in radians).

Inputs

angle
An angle measured in radians.

ToDegrees(angle)

Copy link

Converts radians to degrees.

Inputs

angle
An angle measured in radians.

ToRadians(angle)

Copy link

Converts degrees to radians.

Inputs

angle
An angle measured in degrees.

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.

Unsplash

PhotoSearch(keywords, orientation, index)

Copy link

Get an Unsplash photo for a keyword search.

Required Inputs

keywords
Keywords for photo search.

Optional Inputs

orientation
Filter search results by photo orientation. Valid values are landscape, portrait, and squarish.
index
Return the nth photo available.

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.

Required Inputs

location
A city name, postal code, point of interest, or "latitude, longitude" string. For example, "San Francisco" or 94107.

Optional Inputs

isMetric
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.

Required 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.

Optional Inputs

isMetric
If true, returns metric values (Celsius, millimeters). If false, return imperial values (Fahrenheit, inches). Defaults to false.

Wikipedia

Article(title, locale)

Copy link

Get data from a Wikipedia article.

Required Inputs

title
The title or URL of the article on Wikipedia

Optional Inputs

locale
Language code of the Wikipedia edition to use (default: "en")

YouTube

Video(mediaUrl)

Copy link

Get data about a YouTube video.

Inputs

mediaUrl
The URL for the YouTube video.
Copyright © 2020 Coda. All Rights Reserved.