Other functions
- ISO_WEEKNUM() : ISO week number (week starting Monday)
- WEEKNUM() : week number (week starting Sunday)
- ROWID() : display a row's unique identifier (auto number)
- SWITCH() : choose a value based on multiple cases (alternative to nested IFs)
- DISTANCE() : calculate the distance between two points (as the crow flies)
- COORDINATES() : create a coordinate pair (X, Y)
- COORDX() : extract the X value from a coordinate pair
- COORDY() : extract the Y value from a coordinate pair
- EMPTY() : return an empty value
- IF() : IF... THEN... ELSE condition
- IS_EMPTY() : test whether a field is empty
- GEOLOC() : geolocate an address (latitude, longitude)
- URL_TRIGGER() : call a webhook from an action button
- CONCAT_URL() : format or create a dynamic webhook URL
- CONCAT() : concatenate text (combine fields)