let |
Defines a local variable within a formula. |
let(x, 5, x * x) |
Defines x as 5, then calculates x * x, resulting in 25. |
lets |
Allows for multiple variable assignments within one formula. |
lets(a, 10, b, 20, a + b) |
Assigns a as 10 and b as 20, then adds them to get 30. |
map() |
Applies a function to each item in a list. |
prop("Tasks").map(task => task.status) |
Applies a function to each task in the "Tasks" list to get their status. |
filter() |
Filters items in a list based on a condition. |
prop("Numbers").filter(number => number > 5) |
Filters the "Numbers" list to include only numbers greater than 5. |
length() |
Determines the number of items in a list or the length of a string. |
length(prop("Tasks")) |
Returns the number of tasks in the "Tasks" list. |
round() |
Rounds a number to the nearest whole number within formulas. |
round(average(prop("Scores"))) |
Averages the values in the "Scores" list and rounds the result. |
ifs() |
Evaluates multiple conditions, returning a value for the first true condition. |
ifs(prop("Age") > 18, "Adult", "Minor") |
Returns "Adult" if the "Age" is greater than 18, otherwise "Minor". |
dateAdd() (Advanced) |
Adds a specified time to a date, used in more complex scenarios. |
dateAdd(prop("Start Date"), 5, "days") |
Adds 5 days to the "Start Date", calculating a new date. |
dateBetween() (Advanced) |
Finds the difference between two dates, used in more complex scenarios. |
dateBetween(now(), prop("Due Date"), "days") |
Calculates the number of days between today and the "Due Date". |
map() & filter() combined |
Uses map() and filter() together for complex data processing. |
prop("Tasks").map(task => task.status).filter(status => status == "Complete") |
Maps the "status" of each task in the "Tasks" list, then filters to only include those that are "Complete". |