Functions alphabetically
Here are the articles in this section:
abs
To return the absolute value of a number
acos
To calculate the arccosine
age
To return the number of full years between now and a given date (e.g. a person’s age)
appointment
To convert given time-related values to an appointment
asin
To calculate the arsine
atan
To calculate the arctangent
atan2
To return the arctangent of the quotient
avg
To return the average of a number array
capitalize
To capitalize the first letter of each word.
ceil
To round up a given number to the nearest integer
chosen
To return all values of a multiple-choice field as an array or return “true” or “false” if a given value equals the ID o...
concat
To return all items of an array in one string.
contains
To check if a given string contains the exact given match.
cos
To calculate the cosine
createCalendarEvent
To create an event in the Apple Calendar App
createCalendarReminder
To create a reminder in the Apple Calendar App
date
To convert to or return a date value
datetime
To convert to or return a timestamp
day
To return the day of the month from a given date value as a number
days
To return the number of days between 2 dates
degrees
To convert an angle from radians to degrees
duration
To return the duration of an appointment
endof
To return the end of an appointment.
even
To return "true" if the number is even
exp
To calculate the natural exponential function
file
To return a specific file based on the file name from a given record
floor
To round down a given number to the nearest integer
format
To format a given value
ln
To calculate the natural logarithm
log
To calculate the logarithm
month
To return the month from a date value as a number
monthIndex
To return a given month as a number out of a string
monthName
To return the full month name of a given date value
now
To return the current timestamp
odd
To return “true” if the number is odd
pow
To calculate the power of a number
quarter
To return the quarter of a given date as a number
radians
To convert an angle from degrees to radians
random
To return a random number
round
To round a given number
sign
To return the signum of a number
sin
To calculate the sine
sqr
To calculate the square
sqrt
To calculate the square root
start
To return the start timestamp of an appointment
sum
To return the total sum of a number array
tan
To calculate the tangent
time
To return the current time
timeinterval
To convert a given time-related value to a time interval, i.e. a duration
timestamp
To convert a given time-related value to a timestamp
today
To return the current date (without time).
week
To return the calendar week of a given date value
weekday
To return the weekday of a given date value as a number
weekdayIndex
To return a given weekday name as a number
weekdayName
To return the full weekday name of a given date value
workdays
To return the number of working days between 2 given dates
year
To return the year of a given date value.
yearmonth
To return the month and the year of a given date value
yearquarter
To return the quarter and the year of a given date value
yearweek
To return the week and the year of a given date value‌