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â€Ś