AI-Powered Healthcare Platform

Contact Us

Name *

Email *

Type *

Leave your message here...

Type
Draw

By selecting Adopt and Sign, I agree that the signature and initials will be the electronic representation of my signature and initials for all purposes when I (or my agent) use them on documents, including legally binding contracts just the same as pen-and-paper signature or initial.

Before proceeding with the deletion of the record from the object, it's crucial to review its dependencies across various components.

Please take a moment to examine all the dependent components where this record is being utilized.

Table of dependent components where the record is being utilized.
Object	Field	Row ID

I understand the risks and choose to proceed with the deletion

Objects

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: All
ABS()	Arithmetic absolute value. If the value is a string, it will be converted to a number. `ABS("-3.14")` Returns: 3.14 `ABS(-2.718)` Returns: 2.718
ACCOUNTID()	The current account ID `ACCOUNTID()` Returns: UUID
ADDRESS_TO_LATLNG()	Converts an address to latitude and longitude. A point is a tuple with 2 values: latitude and longitude. `ADDRESS_TO_LATLNG("1600 Amphitheatre Parkway, Mountain View, CA 94043")` Returns: (37.4223878,-122.0841877)
AND()	Returns a YesNo expression `AND(TRUE, TRUE)` Returns: Yes `AND(TRUE, FALSE)` Returns: No `AND(FALSE, TRUE)` Returns: No `AND(FALSE, FALSE)` Returns: No
ANY()	Returns a random choice from a list `ANY(["a", "b", "c"])` Returns: a random value - a, b, or c `ANY([1, 2, 3])` Returns: a random value - 1, 2, or 3
AVERAGE()	Returns mean of a list `AVERAGE([1, 2, 3])` Returns: 2 `AVERAGE([3.14, 2.71, 1.41])` Returns: 2.42
BASE_URL()	Returns the base URL of the app `BASE_URL()` Returns: https://www.appsheet.com/
BOOLEAN() or BOOL()	Converts a value to a boolean `BOOLEAN("true")` Returns: Yes `BOOLEAN("false")` Returns: No `BOOLEAN(1)` Returns: Yes `BOOLEAN(0)` Returns: No
CEILING()	Returns the smallest integer greater than or equal to a number `CEILING(3.14)` Returns: 4 `CEILING(-3.14)` Returns: -3
CONCAT()	Concatenates two or more text strings `CONCAT("Hello", " ", "World")` Returns: Hello World `CONCAT("Hello", " ", "World", "!")` Returns: Hello World!
CONCAT_WS()	Concatenates two or more text strings with a separator `CONCAT_WS(" ", "Hello", "World")` Returns: Hello World `CONCAT_WS(" ", "Hello", "World", "!")` Returns: Hello World !
CONCATENATE()	Concatenates two or more text strings `CONCATENATE("Hello", " ", "World")` Returns: Hello World `CONCATENATE("Hello", " ", "World", "!")` Returns: Hello World!
CONTAINS()	Returns a YesNo expression `CONTAINS("Hello World", "World")` Returns: Yes `CONTAINS("Hello World", "World!")` Returns: No
CONTEXT()	Returns current context `CONTEXT('application')` Returns: my-app `CONTEXT('solution')` Returns: my-solution `CONTEXT('page')` Returns: my-page `CONTEXT('view')` Returns: my-view `CONTEXT('view-type')` Returns: list-view `CONTEXT('object')` Returns: my-object `CONTEXT('Bot')` Returns: False `CONTEXT('Browser')` Returns: Chrome/Safari/Firefox `CONTEXT('DeviceType')` Returns: Mobile/Web `CONTEXT('Device')` Returns: Uid of the device from cookie `CONTEXT('OS')` Returns: iOS/Linux/Windows
COUNT()	Returns the number of items in an iterable. If the argument is a table name, it will return the number of rows. `COUNT([1, 2, 3])` Returns: 3 `COUNT([3.14, 2.71, 1.41])` Returns: 3 `COUNT("table_name")` Returns: Number
CURRENTAPP()	The ID of the active application `CURRENTAPP()` Returns: UUID
DATE()	Returns a date from a string `DATE("2020-01-01")` Returns: 2020-01-01 `DATE("2020-01-01 00:00:00")` Returns: 2020-01-01
DATEADD()	Adds a number of days `DATEADD("2020-01-01", 1)` Returns: 2020-01-02 `DATEADD("2020-01-01", -1)` Returns: 2019-12-31
DATEDIFF()	Returns the number of days between two dates. DATEDIFF("2020-01-01", "2020-12-31") returns 365 `DATEDIFF("2020-01-01", "2020-12-31")` Returns: 365 `DATEDIFF("2020-12-31", "2020-01-01")` Returns: -365
DATETIME()	Returns a datetime from a string `DATETIME("2020-01-01")` Returns: 2020-01-01 00:00:00 `DATETIME("2020-01-01 12:34:56")` Returns: 2020-01-01 12:34:56
DAY()	Returns the day of the month `DAY("2020-01-01")` Returns: 1 `DAY("2020-12-31")` Returns: 31
DLP_SSN()	Returns a de-identified SSN `DLP_SSN("123-45-6789")` Returns: 123-XX-XXXX
ENCODEURL()	Returns a URL encoded string `ENCODEURL("https://www.google.com/search?q=hello world")` Returns: https%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3Dhello+world
ENDSWITH()	Returns a YesNo expression `ENDSWITH("Hello World", "World")` Returns: Yes `ENDSWITH("Hello World", "World!")` Returns: No
EOMONTH()	Returns the last day of the month `EOMONTH("2020-01-01")` Returns: 2020-01-31 `EOMONTH("2020-12-31")` Returns: 2020-12-31
EOWEEK()	Returns the last day of the week `EOWEEK("2020-01-01")` Returns: 2020-01-05 `EOWEEK("2020-12-31")` Returns: 2021-01-02
EXISTS()	Returns a YesNo expression `EXISTS("users", "id", 1)` Returns: Yes `EXISTS("users", "id", 999)` Returns: No
EXTRACTDATES()	Returns a list of dates from a string `EXTRACTDATES("2020-01-01, 2020-01-03")` Returns: ['2020-01-01', '2020-01-03']
EXTRACTEMAILS()	Returns a list of emails from a string `EXTRACTEMAILS("admin@example.com hello@example.com")` Returns: ['admin.example.com', 'hello@example.com']
EXTRACTNUMBERS()	Returns a list of numbers from a string `EXTRACTNUMBERS("1 2 3")` Returns: [1, 2, 3]
EXTRACTPHONES()	Returns a list of phone numbers from a string `EXTRACTPHONES("123-456-7890")` Returns: ['123-456-7890']
EXTRACTURLS()	Returns a list of URLs from a string `EXTRACTURLS("https://www.google.com")` Returns: ['https://www.google.com'] `EXTRACTURLS("https://www.google.com https://www.example.com")` Returns: ['https://www.google.com', 'https://www.example.com']
FIND()	Returns the position of a substring. Returns -1 if not found. `FIND("needle", "needle in haystack")` Returns: 0 `FIND("rock", "in haystack")` Returns: -1
FLOAT()	Converts a value to float `FLOAT("3.14")` Returns: 3.14 `FLOAT(3)` Returns: 3.0
FLOOR()	Returns the largest integer less than or equal to a number `FLOOR(1.1)` Returns: 1 `FLOOR(1.9)` Returns: 1
FORMAT_DATETIME()	FORMAT_DATETIME(value, format,default_timezone[optional],ignore_timezone[optional]) Returns Datetime based on the input input `FORMAT_DATETIME(Sat, 15 Jun 2024 00:00:00 GMT,"%Y-%m-%d %H:%M:%S")` Returns: 2024-05-20 05:07:51 `FORMAT_DATETIME(2024-06-13 12:28:47,"%Y-%m-%d")` Returns: 2024-06-15 `FORMAT_DATETIME(2024-06-13 12:28:47,"%d-%m-%Y %H:%M:%S")` Returns: 20-05-2024 05:07:51
FORMAT_NUMBER()	Returns a formatted number `FORMAT_NUMBER("32", "{:08.0f}")` Returns: 00000032 `FORMAT_NUMBER(1234567.89, "{:10.2f}")` Returns: 1,234,567.89 `FORMAT_NUMBER(1234567.89, "{:10.2e}")` Returns: 1.23e+06 `FORMAT_NUMBER(1234567.89, "{:10.2g}")` Returns: 1.2e+06 `=FORMAT_NUMBER(.99, "{:7.2%}")` Returns: 99.00%
FORMAT_TIME()	FORMAT_TIME(Value,Military Time, Ignore Seconds, Default timezone('optional)) Returns Time based on the input `FORMAT_TIME('05:44:18',True,True,'America/Denver')` Returns: 05:44 `FORMAT_TIME("05:44:18 AM",False,True,"Pacific/Saipan")", "returns": "03:44 PM"}` Returns: 1. AppSheet 2. Bubble
GENERATE_CHILD_RECORDS()	GENERATE_CHILD_RECORDS(table, record ID, prompt, number of records, enhance prompt) Generates child records based on the input prompt and table. The number of records and optimise prompt is optional. `GENERATE_CHILD_RECORDS("superheros", "72570e47-2dc6-477d-97e7-c7b410ddc487" ,"Add details for 3 superheroes from Marvel", 3, True)` Returns: List of record IDs
GENERATE_IMAGE()	Returns a generated Image based on the input prompt `GENERATE_IMAGE("Cute Dog playing football ","512x512",1)` Returns: Image
GENERATE_RECORDS()	GENERATE_RECORDS(table, prompt, number of records, enhance prompt) Generates records based on the input prompt and table. The number of records and optimise prompt is optional. `GENERATE_RECORDS("superheros", "Add details for 3 superheroes from Marvel", 3, True)` Returns: List of record IDs
GENERATE_SIGNED_URL()	GENERATE_SIGNED_URL(url, [expiration=3600]) Returns a signed URL from GCS. `GENERATE_SIGNED_URL("bucket-name/example.png")` Returns: signed URL
GENERATE_TEXT()	GENERATE_TEXT(prompt, context, datasource) Returns a generated text based on the input prompt. Pass a datastore path to be used for grounding. `GENERATE_TEXT("Give me a name for a blog website")` Returns: Blogger's Home `GENERATE_TEXT("Give two names for a tech product, list them in numbers")` Returns: 1. AppSheet 2. Bubble
GENERATE_TEXT_WITH_IMAGE()	Returns a generated text with an image prompt and text prompt. Pass a datastore path to be used for grounding. `GENERATE_TEXT_WITH_IMAGE("image.jpg","Describe the image")` Returns: Text
GET()	Returns a value from a dictionary or a list `GET([1,7,8],0)` Returns: 1
HAS_PERMISSION()	Returns a YesNo expression `HAS_PERMISSION("send_mail")` Returns: Yes `HAS_PERMISSION("cases.create")` Returns: No `HAS_PERMISSION("cases.case_number.read")` Returns: No
HOUR()	Returns the hour `HOUR("2020-01-01 12:00:00")` Returns: 12 `HOUR("2020-01-01 00:00:00")` Returns: 0
IF()	Returns one value if a condition is true, and another value if it is false `IF(True, "Yes", "No")` Returns: Yes `IF(False, "Yes", "No")` Returns: No
IFS()	Returns one value if a condition is true, and another value if it is false for multiple conditions `IFS(True, "Yes", False, "No")` Returns: Yes `IFS(FALSE, "Yes", TRUE, "No")` Returns: No
IMAGE()	IMAGE(url). Returns a signed URL from GCS. `IMAGE("bucket-name/example.png")` Returns: signed URL
IN()	Returns a YesNo expression `IN("a", ["a", "b", "c"])` Returns: Yes `IN("d", ["a", "b", "c"])` Returns: No
INDEX()	Returns the value at a specific position in a list. Indexes start at 1. `INDEX(["a", "b", "c"], 1)` Returns: a `INDEX(["a", "b", "c"], 2)` Returns: b `INDEX(["a", "b", "c"], 3)` Returns: c `INDEX(["a", "b", "c"], 4)` Returns:
INT()	Converts a value to an integer `INT("3")` Returns: 3 `INT(2.718)` Returns: 2
ISBLANK()	Returns a YesNo expression `ISBLANK("")` Returns: Yes `ISBLANK("a")` Returns: No
ISDATE()	Returns a YesNo expression `ISDATE("2020-01-01")` Returns: Yes `ISDATE("a")` Returns: No
ISNOTBLANK()	Returns a YesNo expression `ISNOTBLANK("")` Returns: No `ISNOTBLANK("a")` Returns: Yes
ISNULL()	Returns a YesNo expression, if the value is null or None `ISNULL(1)` Returns: No `ISNULL(0)` Returns: No `ISNULL(None)` Returns: Yes
ISNUMBER()	Returns a YesNo expression `ISNUMBER(1)` Returns: Yes `ISNUMBER("a")` Returns: No
KG_SEARCH()	KG_SEARCH(query, [limit=10]). Returns a list of entities from Google's Knowledge Graph. `KG_SEARCH("Barack Obama")` Returns: [{"name": "Barack Obama", "type": "Person", "description": "44th U.S. President", "url": "https://en.wikipedia.org/wiki/Barack_Obama"}]
LATLNG_TO_ADDRESS()	LATLNG_TO_ADDRESS(latitude, longitude). Returns an address from a latitude and longitude. `LATLNG_TO_ADDRESS(40.714224, -73.961452)` Returns: 277 Bedford Ave, Brooklyn, NY 11211, USA
LEFT()	Returns the leftmost characters in a text string `LEFT("abc", 1)` Returns: a `LEFT("abc", 2)` Returns: ab `LEFT("abc", 3)` Returns: abc `LEFT("abc", 4)` Returns: abc
LEN()	The string length `LEN("abc")` Returns: 3 `LEN("a")` Returns: 1 `LEN("")` Returns: 0
LIST()	Returns a list of values `LIST("a", "b", "c")` Returns: ['a', 'b', 'c'] `LIST(1, 2, 3)` Returns: [1, 2, 3]
LOOKUP()	LOOKUP(value, object, field, return-column). Returns a single value from a table if found. `LOOKUP("admin@example.com", "users", "email", "name")` Returns: List
LOWER()	Lowercase a string `LOWER("ABC")` Returns: abc `LOWER("aBc")` Returns: abc
MARKDOWN_TO_HTML()	Converts Markdown to HTML `MARKDOWN_TO_HTML("# Hello")` Returns: Hello `MARKDOWN_TO_HTML("## Hello")` Returns: Hello
MAX()	Returns the largest value in a list of numbers `MAX([1, 2, 3])` Returns: 3 `MAX([3, 2, 1])` Returns: 3 `MAX([3.14, 2.71])` Returns: 3.14
MAXROW()	Returns the largest row number in a table `MAXROW("table", "field")` Returns: 3
MID(arg, start, length)	Returns a specific number of characters from a text string starting at the position you specify. `MID("abc", 1, 1)` Returns: a `MID("abc", 1, 2)` Returns: ab `MID("abc", 1, 3)` Returns: abc `MID("abc", 1, 4)` Returns: abc
MIN()	Returns the smallest value in a list of numbers `MIN([1, 2, 3])` Returns: 1 `MIN([3, 2, 1])` Returns: 1 `MIN([3.14, 2.71])` Returns: 2.71
MINROW()	Returns the smallest row number in a table `MINROW("table", "field")` Returns: 1
MINUTE()	Returns the minute `MINUTE("2020-01-01 12:34:56")` Returns: 34
MONTH()	Returns the month `MONTH("2020-01-01 12:34:56")` Returns: 1
NLP_SENTIMENT()	NLP_SENTIMENT(text). Returns a sentiment score from -1 to 1. `NLP_SENTIMENT("I love this product")` Returns: 0.9 `NLP_SENTIMENT("I hate this product")` Returns: -0.9
NOT()	Returns a YesNo expression `NOT(True)` Returns: No `NOT(No)` Returns: Yes
NOW(timezone='UTC')	The datetime in %Y-%m-%d %H:%M:%S format. The timezone is optional with a default of UTC. Complete list of timezones can be found at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones `NOW()` Returns: 2020-12-31 12:34:56 `NOW("America/Denver")` Returns: 2020-12-31 07:34:56
OR()	Returns a YesNo expression `OR(True, False)` Returns: Yes `OR(Yes, No)` Returns: Yes `OR(No, No)` Returns: No
POWER()	Returns the result of a number raised to a power `POWER(2, 3)` Returns: 8 `POWER(3, 2)` Returns: 9 `POWER(3.14, 2)` Returns: 9.8596
PREDICT()	PREDICT(model, input). Returns a prediction from a model. `PREDICT("my-model", {"sepal_length": 5.1, "sepal_width": 3.5, "petal_length": 1.4, "petal_width": 0.2})` Returns: setosa
RANDBETWEEN()	Returns a random number between the two numbers `RANDBETWEEN(1, 10)` Returns: 5
RE_FIND()	Returns the first match of a regular expression `RE_FIND("([0-9]+)", "abc123def456")` Returns: 123 `RE_FIND("([a-z]+)", "abc123def456")` Returns: abc
RE_FINDALL()	Returns a list of all matches of a regular expression `RE_FINDALL("([0-9]+)", "abc123def456")` Returns: ['123', '456'] `RE_FINDALL("([a-z]+)", "abc123def456")` Returns: ['abc', 'def']
RE_MATCH()	Returns the first match of a regular expression at the beginning of a string `RE_MATCH("([0-9]+)", "123def456")` Returns: 123 `RE_MATCH("([a-z]+)", "abc123def456")` Returns: abc
RE_SEARCH()	Returns the first match of a regular expression anywhere in a string `RE_SEARCH("([0-9]+)", "abc123def456")` Returns: 123 `RE_SEARCH("([a-z]+)", "abc123def456")` Returns: abc
RE_SUB()	Returns a string with all matches of a regular expression replaced `RE_SUB("([0-9]+)", "X", "abc123def456")` Returns: abcXdefX `RE_SUB("([a-z]+)", "X", "abc123def456")` Returns: X123X456
REF_LABEL()	Get Ref Label of record `REF_LABEL("permits", "1745c746-aaa5-4ecf-96e7-49392458d42c")` Returns: ON-0017
REF_ROWS()	Define related table and column `REF_ROWS("users", "claim_id")` Returns: ('users', 'claim_id')
REMOVE_HTML_TAGS()	Removes HTML tags from a string `REMOVE_HTML_TAGS("Hello ")` Returns: Hello `REMOVE_HTML_TAGS("Hello ")` Returns: Hello
RIGHT()	Returns the rightmost characters from a string `RIGHT("abc", 1)` Returns: c `RIGHT("abc", 2)` Returns: bc `RIGHT("abc", 3)` Returns: abc
ROUND()	Returns a number rounded to a specified number of decimal places `ROUND(3.14159, 2)` Returns: 3.14 `ROUND(3.14159, 3)` Returns: 3.142 `ROUND(3.14159, 4)` Returns: 3.1416
SECOND()	Returns the second `SECOND("2020-01-01 12:34:56")` Returns: 56
SELECT()	Returns a list of records from a database table. - columns: (Optional) A list or comma-separated string of column names to retrieve. Defaults to "". - where_column: (Optional) The column name to filter by. - where_value: (Optional) The value to match for where_column. - flatten: (Optional) If True, returns a list of values from the first column only. - dictionary: (Optional) If True, returns each record as a dictionary. Cannot be used with flatten. - filters: (Optional) A list of tuples for multiple filters, e.g., filters=[("column1", 10), ("column2", 20)]. - order_by: (Optional) A string (column name) or a list of tuples for multiple sort columns, e.g., order_by=[("column1", "ASC"), ("column2", "DESC")]. `SELECT("table", "field1,field2")` Returns: [(val1, val2), ...] `SELECT("table", "field1", "filter_col", "filter_val")` Returns: [(val1), (val1), ...] `SELECT("table", "field1", "filter_col", "filter_val", flatten=True)` Returns: [val1, val1, ...] `SELECT("table", "field1,field2", dictionary=True)` Returns: [{'field1': val1, 'field2': val2}, ...] `SELECT("table", "", filters=[("col1", 10, ">")])` Returns: [(val1, val2, ...), ...] `SELECT("table", "", filters=[("col1", 10)])` Returns: [(col1, 10, ...), ...] `SELECT("table", "", order_by=[("col1", "DESC")])` Returns: [(val1, val2, ...), ...]
SENDER_EMAIL()	The email sender `SENDER_EMAIL()` Returns: Default Email Sender
SENDER_EMAIL_NAME()	The email sender name `SENDER_EMAIL_NAME()` Returns: Default Email Sender Name
SORT()	Returns a list of values sorted in ascending order. Optional second boolean parameter to sort in descending order. `SORT([3, 2, 1])` Returns: [1, 2, 3] `SORT([1, 2, 3], True)` Returns: [3, 2, 1]
SPEECH_TO_TEXT()	SPEECH_TO_TEXT(object,'en-us'). Returns a text string from a GCS object. `SPEECH_TO_TEXT("example.mp3","en-us")` Returns: Hello World
SPLIT()	Returns a list of substrings from a text string, separated by a delimiter `SPLIT("Hello World", " ")` Returns: ['Hello', 'World']
SQRT()	Returns the square root of a number `SQRT(4)` Returns: 2 `SQRT(9)` Returns: 3 `SQRT(9.0)` Returns: 3.0
STARTSWITH()	Returns a YesNo expression `STARTSWITH("Hello World", "Hello")` Returns: Yes `STARTSWITH("Hello World", "World")` Returns: No
STATIC_MAP()	STATIC_MAP(latitude, longitude, zoom, width, height, map_type). Returns a static map image from Google Maps. Maps Documentation. This returns a GCS blob URI. You can use the GENERATE_SIGNED_URL() function to display the image. map_type can be one of the following: roadmap, satellite, terrain, hybrid. `STATIC_MAP(40.714224, -73.961452, 12, 400, 400)` Returns: signed URL `STATIC_MAP(ADDRESS_TO_LATLNG("1616 Federal Blvd, Denver, CO 80204, USA"), None, 12, 400, 400)` Returns: File
STREET_VIEW()	STREET_VIEW(latitude, longitude, heading, pitch, fov, width, height). Returns a street view image from Google Maps. Street View Documentation. This returns a GCS blob URI. You can use the GENERATE_SIGNED_URL() function to display the image. `STREET_VIEW(40.714224, -73.961452, 90, 0, 90, 400, 400)` Returns: signed URL
SUBSTITUTE()	Returns a text string with all occurrences of a substring replaced with another substring `SUBSTITUTE("Hello World", "World", "Universe")` Returns: Hello Universe
SUM()	Returns the sum of a list of numbers `SUM([1, 2, 3])` Returns: 6 `SUM([1.1, 2.2, 3.3])` Returns: 6.6
SUMMARIZE_DOCUMENT(url)	SUMMARIZE_DOCUMENT(url) Returns a summarized text of the input document. Supports PDF files. `SUMMARIZE_DOCUMENT(url = pdf_url)` Returns: Summarized text of the pdf
TEXT()	Returns a text string representation of a value `TEXT(123)` Returns: 123 `TEXT(123.45)` Returns: 123.45
TEXT_TO_SPEECH()	TEXT_TO_SPEECH(text). Returns a GCS blob URI from a text string. You can use the GENERATE_SIGNED_URL() function to play the audio. `TEXT_TO_SPEECH("Hello World")` Returns: signed URL `TEXT_TO_SPEECH("Hello World", "FEMALE")` Returns: signed URL `TEXT_TO_SPEECH("Hello World", "MALE")` Returns: signed URL `TEXT_TO_SPEECH("Hello World", "NEUTRAL")` Returns: signed URL
TIME()	Returns the time portion of a datetime `TIME("2020-01-01 12:34:56")` Returns: 12:34:56 `TIME(NOW())` Returns: 12:34:56
TIMENOW(timezone='UTC')	The time in %H:%M:%S format. Similar to TIME(NOW()). The timezone is optional with a default of UTC. Complete list of timezones can be found at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones `TIMENOW()` Returns: 12:34:56 `TIMENOW("America/Denver")` Returns: 07:34:56
TITLE()	Returns a text string in title case `TITLE("hello world")` Returns: Hello World
TODAY(timezone='UTC')	The date in %Y-%m-%d format. The timezone is optional with a default of UTC. Complete list of timezones can be found at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones `TODAY()` Returns: 2020-01-01 `TODAY("America/Denver")` Returns: 2019-12-31
TOP()	Returns the first n items in a list `TOP([1, 2, 3], 2)` Returns: [1, 2] `TOP([1, 2, 3], 4)` Returns: [1, 2, 3]
TOTALHOURS()	Returns the total number of hours in a time `TOTALHOURS("12:34:56")` Returns: 12.582222222222223
TOTALMINUTES()	Returns the total number of minutes in a time `TOTALMINUTES("12:34:56")` Returns: 754.9333333333333
TOTALSECONDS()	Returns the total number of seconds in a time `TOTALSECONDS("12:34:56")` Returns: 45296.0
TRANSLATE_DOCUMENT()	TRANSLATE_DOCUMENT("URI", "source_language", "target_language"). Returns a translated document from a GCS URI. `TRANSLATE_DOCUMENT("gs://bucket-name/file-name", "en", "es")` Returns: GCS URI
TRANSLATE_DOCUMENT_BATCH()	TRANSLATE_DOCUMENT_BATCH("URI", "source_language", "target_language"). Returns a translated document from a GCS URI. `TRANSLATE_DOCUMENT_BATCH("gs://bucket-name/file-name", "en", "es")` Returns: GCS URI
TRANSLATE_TEXT()	TRANSLATE_TEXT(text, [source_language='auto', target_language='en']). Returns a translated string. Similar to the GOOGLETRANSLATE() function in Google Sheets. `TRANSLATE_TEXT("Hola Amigo")` Returns: Hi friend `TRANSLATE_TEXT("Hola Amigo", "es", "en")` Returns: Hi friend
TRIM()	Returns a text string with whitespace removed from the start and end `TRIM(" Hello World ")` Returns: Hello World `TRIM("Hello World")` Returns: Hello World
UNIQUE()	Returns a list of unique values from a list `UNIQUE([1, 2, 3, 1, 2, 3])` Returns: [1, 2, 3]
UPPER()	Uppercase a string `UPPER("Hello World")` Returns: HELLO WORLD
URL_TO_PDF()	URL_TO_PDF(url). Returns a PDF file from a URL. `URL_TO_PDF("https://example.com")` Returns: URI `URL_TO_PDF("https://example.com","vendors")` Returns: URI
USEREMAIL()	Returns the current user's email `USEREMAIL()` Returns: email
USERID()	Returns the current user's ID `USERID()` Returns: UUID
USERLOCALE()	The active locale e.g. en, de, es, zh `USERLOCALE()` Returns: en, de, es, fr, or zh
USERNAME()	Returns the current user's fullname `USERNAME()` Returns: Full Name
USERROLE()	Returns the current user's role ID `USERROLE()` Returns: UUID
UTCNOW()	The datetime for UTC timezone in %Y-%m-%d %H:%M:%S format `UTCNOW()` Returns: 2020-01-01 12:34:56
WEEKDAY()	Returns the day of the week for a date `WEEKDAY("2020-01-01")` Returns: 1
YEAR()	Returns the year `YEAR("2020-01-01")` Returns: 2020
EXTRACT_NAME_FROM_URL()	this function extracts the name from the url Returns:
FETCH_OAUTH_TOKEN()	None Returns:
GENERATE_BACKLINKS()	Returns:
GENERATE_KB_ARTICLE()	None Returns:
GENERATE_KEYWORDS()	Returns:
GENERATE_PATH_TIMELINE()	Generate a timeline for a path and related courses. `GENERATE_PATH_TIMELINE( '[[path_id]]',USERID())` Returns: HTML
GENERATE_SEO_SUGGESTIONS()	Returns:
GENERATE_SLIDES_NEW()	Returns:
GET_BLOG_POST()	None Returns:
GET_BLOGS()	None Returns:
GET_COURSE_DETAIL()	this is the course details of a function that Runs a query to join courses, modules, module items and user module items to to show course/module information applicable to the current user. `GET_COURSE_DETAIL( '[[course_id]]')` Returns: LIST
GET_COURSE_DETAILS_101()	Returns:
GET_COURSE_HTML()	`GET_COURSE_HTML(course_id,user_id)` Returns: None
GET_KEYWORD_RANKING()	Returns:
GET_OAUTH_TOKEN()	Returns:
GET_PAGES()	Returns:
GET_PERFORMANCE_SCORE()	this function takes the url and returns the performance sore of the website using pagespeed insight API Returns:
GET_QUIZ_HTML()	Returns:
GET_RANDOM_KEYWORD()	Returns:
GET_URL_SUBTYPE()	None Returns:
GET_URL_TYPE()	Returns:
GET_USER_MODULE_ITEMS()	Returns:
KEYWORD_DETAILS()	This function returns the details for each keywords in the url `KEYWORD_DETAILS(user_id, url, start_date, end_date)` Returns: Any
KEYWORD_RANKINGS()	This function generates keyword ranking Returns:
MAKE_ALL_FILES_LIVE()	None `MAKE_ALL_FILES_LIVE()` Returns: Any
NOTAFREEMAIL()	Confirm email address is valid and is not from a free email domain (e.g. gmail.com, yahoo.com etc) `NOTAFREEMAIL( 'email@yahoo.com')` Returns: False `NOTAFREEMAIL( 'ted@bluevector.ai')` Returns: True
RENDER_QUESTIONS_BY_DATA_TYPE()	Returns:
RESUBMIT_SITEMAP_OR_URL()	Returns:
RUN_SEO_REPORT()	`RUN_SEO_REPORT(user_id,report_id,start_date,end_date,search_engine_id)` Returns: Any
SNAPAPP_SEO_SELECT_TEST()	Returns:
UPDATE_ANSWERS()	Returns:
URL_RETURNS()	Returns:
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Any
ANY()	Returns a random choice from a list `ANY(["a", "b", "c"])` Returns: a random value - a, b, or c `ANY([1, 2, 3])` Returns: a random value - 1, 2, or 3
GET()	Returns a value from a dictionary or a list `GET([1,7,8],0)` Returns: 1
IF()	Returns one value if a condition is true, and another value if it is false `IF(True, "Yes", "No")` Returns: Yes `IF(False, "Yes", "No")` Returns: No
IFS()	Returns one value if a condition is true, and another value if it is false for multiple conditions `IFS(True, "Yes", False, "No")` Returns: Yes `IFS(FALSE, "Yes", TRUE, "No")` Returns: No
LOOKUP()	LOOKUP(value, object, field, return-column). Returns a single value from a table if found. `LOOKUP("admin@example.com", "users", "email", "name")` Returns: List
EXTRACT_NAME_FROM_URL()	this function extracts the name from the url Returns:
FETCH_OAUTH_TOKEN()	None Returns:
GENERATE_BACKLINKS()	Returns:
GENERATE_KB_ARTICLE()	None Returns:
GENERATE_KEYWORDS()	Returns:
GENERATE_SEO_SUGGESTIONS()	Returns:
GENERATE_SLIDES_NEW()	Returns:
GET_BLOG_POST()	None Returns:
GET_BLOGS()	None Returns:
GET_COURSE_DETAILS_101()	Returns:
GET_COURSE_HTML()	`GET_COURSE_HTML(course_id,user_id)` Returns: None
GET_KEYWORD_RANKING()	Returns:
GET_OAUTH_TOKEN()	Returns:
GET_PAGES()	Returns:
GET_PERFORMANCE_SCORE()	this function takes the url and returns the performance sore of the website using pagespeed insight API Returns:
GET_QUIZ_HTML()	Returns:
GET_RANDOM_KEYWORD()	Returns:
GET_URL_SUBTYPE()	None Returns:
GET_URL_TYPE()	Returns:
GET_USER_MODULE_ITEMS()	Returns:
KEYWORD_DETAILS()	This function returns the details for each keywords in the url `KEYWORD_DETAILS(user_id, url, start_date, end_date)` Returns: Any
KEYWORD_RANKINGS()	This function generates keyword ranking Returns:
MAKE_ALL_FILES_LIVE()	None `MAKE_ALL_FILES_LIVE()` Returns: Any
RENDER_QUESTIONS_BY_DATA_TYPE()	Returns:
RESUBMIT_SITEMAP_OR_URL()	Returns:
RUN_SEO_REPORT()	`RUN_SEO_REPORT(user_id,report_id,start_date,end_date,search_engine_id)` Returns: Any
SNAPAPP_SEO_SELECT_TEST()	Returns:
UPDATE_ANSWERS()	Returns:
URL_RETURNS()	Returns:
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Date
DATE()	Returns a date from a string `DATE("2020-01-01")` Returns: 2020-01-01 `DATE("2020-01-01 00:00:00")` Returns: 2020-01-01
DATEADD()	Adds a number of days `DATEADD("2020-01-01", 1)` Returns: 2020-01-02 `DATEADD("2020-01-01", -1)` Returns: 2019-12-31
EOMONTH()	Returns the last day of the month `EOMONTH("2020-01-01")` Returns: 2020-01-31 `EOMONTH("2020-12-31")` Returns: 2020-12-31
EOWEEK()	Returns the last day of the week `EOWEEK("2020-01-01")` Returns: 2020-01-05 `EOWEEK("2020-12-31")` Returns: 2021-01-02
TODAY(timezone='UTC')	The date in %Y-%m-%d format. The timezone is optional with a default of UTC. Complete list of timezones can be found at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones `TODAY()` Returns: 2020-01-01 `TODAY("America/Denver")` Returns: 2019-12-31
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: DateTime
NOW(timezone='UTC')	The datetime in %Y-%m-%d %H:%M:%S format. The timezone is optional with a default of UTC. Complete list of timezones can be found at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones `NOW()` Returns: 2020-12-31 12:34:56 `NOW("America/Denver")` Returns: 2020-12-31 07:34:56
UTCNOW()	The datetime for UTC timezone in %Y-%m-%d %H:%M:%S format `UTCNOW()` Returns: 2020-01-01 12:34:56
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Datetime
DATETIME()	Returns a datetime from a string `DATETIME("2020-01-01")` Returns: 2020-01-01 00:00:00 `DATETIME("2020-01-01 12:34:56")` Returns: 2020-01-01 12:34:56
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Email
SENDER_EMAIL()	The email sender `SENDER_EMAIL()` Returns: Default Email Sender
USEREMAIL()	Returns the current user's email `USEREMAIL()` Returns: email
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: File
STATIC_MAP()	STATIC_MAP(latitude, longitude, zoom, width, height, map_type). Returns a static map image from Google Maps. Maps Documentation. This returns a GCS blob URI. You can use the GENERATE_SIGNED_URL() function to display the image. map_type can be one of the following: roadmap, satellite, terrain, hybrid. `STATIC_MAP(40.714224, -73.961452, 12, 400, 400)` Returns: signed URL `STATIC_MAP(ADDRESS_TO_LATLNG("1616 Federal Blvd, Denver, CO 80204, USA"), None, 12, 400, 400)` Returns: File
STREET_VIEW()	STREET_VIEW(latitude, longitude, heading, pitch, fov, width, height). Returns a street view image from Google Maps. Street View Documentation. This returns a GCS blob URI. You can use the GENERATE_SIGNED_URL() function to display the image. `STREET_VIEW(40.714224, -73.961452, 90, 0, 90, 400, 400)` Returns: signed URL
TEXT_TO_SPEECH()	TEXT_TO_SPEECH(text). Returns a GCS blob URI from a text string. You can use the GENERATE_SIGNED_URL() function to play the audio. `TEXT_TO_SPEECH("Hello World")` Returns: signed URL `TEXT_TO_SPEECH("Hello World", "FEMALE")` Returns: signed URL `TEXT_TO_SPEECH("Hello World", "MALE")` Returns: signed URL `TEXT_TO_SPEECH("Hello World", "NEUTRAL")` Returns: signed URL
URL_TO_PDF()	URL_TO_PDF(url). Returns a PDF file from a URL. `URL_TO_PDF("https://example.com")` Returns: URI `URL_TO_PDF("https://example.com","vendors")` Returns: URI
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Image
GENERATE_IMAGE()	Returns a generated Image based on the input prompt `GENERATE_IMAGE("Cute Dog playing football ","512x512",1)` Returns: Image
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: JSON
KG_SEARCH()	KG_SEARCH(query, [limit=10]). Returns a list of entities from Google's Knowledge Graph. `KG_SEARCH("Barack Obama")` Returns: [{"name": "Barack Obama", "type": "Person", "description": "44th U.S. President", "url": "https://en.wikipedia.org/wiki/Barack_Obama"}]
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: List
EXTRACTDATES()	Returns a list of dates from a string `EXTRACTDATES("2020-01-01, 2020-01-03")` Returns: ['2020-01-01', '2020-01-03']
EXTRACTEMAILS()	Returns a list of emails from a string `EXTRACTEMAILS("admin@example.com hello@example.com")` Returns: ['admin.example.com', 'hello@example.com']
EXTRACTNUMBERS()	Returns a list of numbers from a string `EXTRACTNUMBERS("1 2 3")` Returns: [1, 2, 3]
EXTRACTPHONES()	Returns a list of phone numbers from a string `EXTRACTPHONES("123-456-7890")` Returns: ['123-456-7890']
EXTRACTURLS()	Returns a list of URLs from a string `EXTRACTURLS("https://www.google.com")` Returns: ['https://www.google.com'] `EXTRACTURLS("https://www.google.com https://www.example.com")` Returns: ['https://www.google.com', 'https://www.example.com']
GENERATE_CHILD_RECORDS()	GENERATE_CHILD_RECORDS(table, record ID, prompt, number of records, enhance prompt) Generates child records based on the input prompt and table. The number of records and optimise prompt is optional. `GENERATE_CHILD_RECORDS("superheros", "72570e47-2dc6-477d-97e7-c7b410ddc487" ,"Add details for 3 superheroes from Marvel", 3, True)` Returns: List of record IDs
GENERATE_RECORDS()	GENERATE_RECORDS(table, prompt, number of records, enhance prompt) Generates records based on the input prompt and table. The number of records and optimise prompt is optional. `GENERATE_RECORDS("superheros", "Add details for 3 superheroes from Marvel", 3, True)` Returns: List of record IDs
LIST()	Returns a list of values `LIST("a", "b", "c")` Returns: ['a', 'b', 'c'] `LIST(1, 2, 3)` Returns: [1, 2, 3]
RE_FINDALL()	Returns a list of all matches of a regular expression `RE_FINDALL("([0-9]+)", "abc123def456")` Returns: ['123', '456'] `RE_FINDALL("([a-z]+)", "abc123def456")` Returns: ['abc', 'def']
SELECT()	Returns a list of records from a database table. - columns: (Optional) A list or comma-separated string of column names to retrieve. Defaults to "". - where_column: (Optional) The column name to filter by. - where_value: (Optional) The value to match for where_column. - flatten: (Optional) If True, returns a list of values from the first column only. - dictionary: (Optional) If True, returns each record as a dictionary. Cannot be used with flatten. - filters: (Optional) A list of tuples for multiple filters, e.g., filters=[("column1", 10), ("column2", 20)]. - order_by: (Optional) A string (column name) or a list of tuples for multiple sort columns, e.g., order_by=[("column1", "ASC"), ("column2", "DESC")]. `SELECT("table", "field1,field2")` Returns: [(val1, val2), ...] `SELECT("table", "field1", "filter_col", "filter_val")` Returns: [(val1), (val1), ...] `SELECT("table", "field1", "filter_col", "filter_val", flatten=True)` Returns: [val1, val1, ...] `SELECT("table", "field1,field2", dictionary=True)` Returns: [{'field1': val1, 'field2': val2}, ...] `SELECT("table", "", filters=[("col1", 10, ">")])` Returns: [(val1, val2, ...), ...] `SELECT("table", "", filters=[("col1", 10)])` Returns: [(col1, 10, ...), ...] `SELECT("table", "", order_by=[("col1", "DESC")])` Returns: [(val1, val2, ...), ...]
SORT()	Returns a list of values sorted in ascending order. Optional second boolean parameter to sort in descending order. `SORT([3, 2, 1])` Returns: [1, 2, 3] `SORT([1, 2, 3], True)` Returns: [3, 2, 1]
SPLIT()	Returns a list of substrings from a text string, separated by a delimiter `SPLIT("Hello World", " ")` Returns: ['Hello', 'World']
TOP()	Returns the first n items in a list `TOP([1, 2, 3], 2)` Returns: [1, 2] `TOP([1, 2, 3], 4)` Returns: [1, 2, 3]
UNIQUE()	Returns a list of unique values from a list `UNIQUE([1, 2, 3, 1, 2, 3])` Returns: [1, 2, 3]
GET_COURSE_DETAIL()	this is the course details of a function that Runs a query to join courses, modules, module items and user module items to to show course/module information applicable to the current user. `GET_COURSE_DETAIL( '[[course_id]]')` Returns: LIST
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Number
ABS()	Arithmetic absolute value. If the value is a string, it will be converted to a number. `ABS("-3.14")` Returns: 3.14 `ABS(-2.718)` Returns: 2.718
AVERAGE()	Returns mean of a list `AVERAGE([1, 2, 3])` Returns: 2 `AVERAGE([3.14, 2.71, 1.41])` Returns: 2.42
CEILING()	Returns the smallest integer greater than or equal to a number `CEILING(3.14)` Returns: 4 `CEILING(-3.14)` Returns: -3
COUNT()	Returns the number of items in an iterable. If the argument is a table name, it will return the number of rows. `COUNT([1, 2, 3])` Returns: 3 `COUNT([3.14, 2.71, 1.41])` Returns: 3 `COUNT("table_name")` Returns: Number
DATEDIFF()	Returns the number of days between two dates. DATEDIFF("2020-01-01", "2020-12-31") returns 365 `DATEDIFF("2020-01-01", "2020-12-31")` Returns: 365 `DATEDIFF("2020-12-31", "2020-01-01")` Returns: -365
DAY()	Returns the day of the month `DAY("2020-01-01")` Returns: 1 `DAY("2020-12-31")` Returns: 31
FIND()	Returns the position of a substring. Returns -1 if not found. `FIND("needle", "needle in haystack")` Returns: 0 `FIND("rock", "in haystack")` Returns: -1
FLOAT()	Converts a value to float `FLOAT("3.14")` Returns: 3.14 `FLOAT(3)` Returns: 3.0
FLOOR()	Returns the largest integer less than or equal to a number `FLOOR(1.1)` Returns: 1 `FLOOR(1.9)` Returns: 1
HOUR()	Returns the hour `HOUR("2020-01-01 12:00:00")` Returns: 12 `HOUR("2020-01-01 00:00:00")` Returns: 0
INDEX()	Returns the value at a specific position in a list. Indexes start at 1. `INDEX(["a", "b", "c"], 1)` Returns: a `INDEX(["a", "b", "c"], 2)` Returns: b `INDEX(["a", "b", "c"], 3)` Returns: c `INDEX(["a", "b", "c"], 4)` Returns:
INT()	Converts a value to an integer `INT("3")` Returns: 3 `INT(2.718)` Returns: 2
LEN()	The string length `LEN("abc")` Returns: 3 `LEN("a")` Returns: 1 `LEN("")` Returns: 0
MAX()	Returns the largest value in a list of numbers `MAX([1, 2, 3])` Returns: 3 `MAX([3, 2, 1])` Returns: 3 `MAX([3.14, 2.71])` Returns: 3.14
MAXROW()	Returns the largest row number in a table `MAXROW("table", "field")` Returns: 3
MIN()	Returns the smallest value in a list of numbers `MIN([1, 2, 3])` Returns: 1 `MIN([3, 2, 1])` Returns: 1 `MIN([3.14, 2.71])` Returns: 2.71
MINROW()	Returns the smallest row number in a table `MINROW("table", "field")` Returns: 1
MINUTE()	Returns the minute `MINUTE("2020-01-01 12:34:56")` Returns: 34
MONTH()	Returns the month `MONTH("2020-01-01 12:34:56")` Returns: 1
NLP_SENTIMENT()	NLP_SENTIMENT(text). Returns a sentiment score from -1 to 1. `NLP_SENTIMENT("I love this product")` Returns: 0.9 `NLP_SENTIMENT("I hate this product")` Returns: -0.9
POWER()	Returns the result of a number raised to a power `POWER(2, 3)` Returns: 8 `POWER(3, 2)` Returns: 9 `POWER(3.14, 2)` Returns: 9.8596
RANDBETWEEN()	Returns a random number between the two numbers `RANDBETWEEN(1, 10)` Returns: 5
ROUND()	Returns a number rounded to a specified number of decimal places `ROUND(3.14159, 2)` Returns: 3.14 `ROUND(3.14159, 3)` Returns: 3.142 `ROUND(3.14159, 4)` Returns: 3.1416
SECOND()	Returns the second `SECOND("2020-01-01 12:34:56")` Returns: 56
SQRT()	Returns the square root of a number `SQRT(4)` Returns: 2 `SQRT(9)` Returns: 3 `SQRT(9.0)` Returns: 3.0
SUM()	Returns the sum of a list of numbers `SUM([1, 2, 3])` Returns: 6 `SUM([1.1, 2.2, 3.3])` Returns: 6.6
TOTALHOURS()	Returns the total number of hours in a time `TOTALHOURS("12:34:56")` Returns: 12.582222222222223
TOTALMINUTES()	Returns the total number of minutes in a time `TOTALMINUTES("12:34:56")` Returns: 754.9333333333333
TOTALSECONDS()	Returns the total number of seconds in a time `TOTALSECONDS("12:34:56")` Returns: 45296.0
WEEKDAY()	Returns the day of the week for a date `WEEKDAY("2020-01-01")` Returns: 1
YEAR()	Returns the year `YEAR("2020-01-01")` Returns: 2020
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Point
ADDRESS_TO_LATLNG()	Converts an address to latitude and longitude. A point is a tuple with 2 values: latitude and longitude. `ADDRESS_TO_LATLNG("1600 Amphitheatre Parkway, Mountain View, CA 94043")` Returns: (37.4223878,-122.0841877)
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Text
BASE_URL()	Returns the base URL of the app `BASE_URL()` Returns: https://www.appsheet.com/
CONCAT()	Concatenates two or more text strings `CONCAT("Hello", " ", "World")` Returns: Hello World `CONCAT("Hello", " ", "World", "!")` Returns: Hello World!
CONCAT_WS()	Concatenates two or more text strings with a separator `CONCAT_WS(" ", "Hello", "World")` Returns: Hello World `CONCAT_WS(" ", "Hello", "World", "!")` Returns: Hello World !
CONCATENATE()	Concatenates two or more text strings `CONCATENATE("Hello", " ", "World")` Returns: Hello World `CONCATENATE("Hello", " ", "World", "!")` Returns: Hello World!
CONTEXT()	Returns current context `CONTEXT('application')` Returns: my-app `CONTEXT('solution')` Returns: my-solution `CONTEXT('page')` Returns: my-page `CONTEXT('view')` Returns: my-view `CONTEXT('view-type')` Returns: list-view `CONTEXT('object')` Returns: my-object `CONTEXT('Bot')` Returns: False `CONTEXT('Browser')` Returns: Chrome/Safari/Firefox `CONTEXT('DeviceType')` Returns: Mobile/Web `CONTEXT('Device')` Returns: Uid of the device from cookie `CONTEXT('OS')` Returns: iOS/Linux/Windows
DLP_SSN()	Returns a de-identified SSN `DLP_SSN("123-45-6789")` Returns: 123-XX-XXXX
ENCODEURL()	Returns a URL encoded string `ENCODEURL("https://www.google.com/search?q=hello world")` Returns: https%3A%2F%2Fwww.google.com%2Fsearch%3Fq%3Dhello+world
FORMAT_DATETIME()	FORMAT_DATETIME(value, format,default_timezone[optional],ignore_timezone[optional]) Returns Datetime based on the input input `FORMAT_DATETIME(Sat, 15 Jun 2024 00:00:00 GMT,"%Y-%m-%d %H:%M:%S")` Returns: 2024-05-20 05:07:51 `FORMAT_DATETIME(2024-06-13 12:28:47,"%Y-%m-%d")` Returns: 2024-06-15 `FORMAT_DATETIME(2024-06-13 12:28:47,"%d-%m-%Y %H:%M:%S")` Returns: 20-05-2024 05:07:51
FORMAT_NUMBER()	Returns a formatted number `FORMAT_NUMBER("32", "{:08.0f}")` Returns: 00000032 `FORMAT_NUMBER(1234567.89, "{:10.2f}")` Returns: 1,234,567.89 `FORMAT_NUMBER(1234567.89, "{:10.2e}")` Returns: 1.23e+06 `FORMAT_NUMBER(1234567.89, "{:10.2g}")` Returns: 1.2e+06 `=FORMAT_NUMBER(.99, "{:7.2%}")` Returns: 99.00%
FORMAT_TIME()	FORMAT_TIME(Value,Military Time, Ignore Seconds, Default timezone('optional)) Returns Time based on the input `FORMAT_TIME('05:44:18',True,True,'America/Denver')` Returns: 05:44 `FORMAT_TIME("05:44:18 AM",False,True,"Pacific/Saipan")", "returns": "03:44 PM"}` Returns: 1. AppSheet 2. Bubble
GENERATE_SIGNED_URL()	GENERATE_SIGNED_URL(url, [expiration=3600]) Returns a signed URL from GCS. `GENERATE_SIGNED_URL("bucket-name/example.png")` Returns: signed URL
GENERATE_TEXT()	GENERATE_TEXT(prompt, context, datasource) Returns a generated text based on the input prompt. Pass a datastore path to be used for grounding. `GENERATE_TEXT("Give me a name for a blog website")` Returns: Blogger's Home `GENERATE_TEXT("Give two names for a tech product, list them in numbers")` Returns: 1. AppSheet 2. Bubble
GENERATE_TEXT_WITH_IMAGE()	Returns a generated text with an image prompt and text prompt. Pass a datastore path to be used for grounding. `GENERATE_TEXT_WITH_IMAGE("image.jpg","Describe the image")` Returns: Text
IMAGE()	IMAGE(url). Returns a signed URL from GCS. `IMAGE("bucket-name/example.png")` Returns: signed URL
LATLNG_TO_ADDRESS()	LATLNG_TO_ADDRESS(latitude, longitude). Returns an address from a latitude and longitude. `LATLNG_TO_ADDRESS(40.714224, -73.961452)` Returns: 277 Bedford Ave, Brooklyn, NY 11211, USA
LEFT()	Returns the leftmost characters in a text string `LEFT("abc", 1)` Returns: a `LEFT("abc", 2)` Returns: ab `LEFT("abc", 3)` Returns: abc `LEFT("abc", 4)` Returns: abc
LOWER()	Lowercase a string `LOWER("ABC")` Returns: abc `LOWER("aBc")` Returns: abc
MARKDOWN_TO_HTML()	Converts Markdown to HTML `MARKDOWN_TO_HTML("# Hello")` Returns: Hello `MARKDOWN_TO_HTML("## Hello")` Returns: Hello
MID(arg, start, length)	Returns a specific number of characters from a text string starting at the position you specify. `MID("abc", 1, 1)` Returns: a `MID("abc", 1, 2)` Returns: ab `MID("abc", 1, 3)` Returns: abc `MID("abc", 1, 4)` Returns: abc
PREDICT()	PREDICT(model, input). Returns a prediction from a model. `PREDICT("my-model", {"sepal_length": 5.1, "sepal_width": 3.5, "petal_length": 1.4, "petal_width": 0.2})` Returns: setosa
RE_FIND()	Returns the first match of a regular expression `RE_FIND("([0-9]+)", "abc123def456")` Returns: 123 `RE_FIND("([a-z]+)", "abc123def456")` Returns: abc
RE_MATCH()	Returns the first match of a regular expression at the beginning of a string `RE_MATCH("([0-9]+)", "123def456")` Returns: 123 `RE_MATCH("([a-z]+)", "abc123def456")` Returns: abc
RE_SEARCH()	Returns the first match of a regular expression anywhere in a string `RE_SEARCH("([0-9]+)", "abc123def456")` Returns: 123 `RE_SEARCH("([a-z]+)", "abc123def456")` Returns: abc
RE_SUB()	Returns a string with all matches of a regular expression replaced `RE_SUB("([0-9]+)", "X", "abc123def456")` Returns: abcXdefX `RE_SUB("([a-z]+)", "X", "abc123def456")` Returns: X123X456
REF_LABEL()	Get Ref Label of record `REF_LABEL("permits", "1745c746-aaa5-4ecf-96e7-49392458d42c")` Returns: ON-0017
REMOVE_HTML_TAGS()	Removes HTML tags from a string `REMOVE_HTML_TAGS("Hello ")` Returns: Hello `REMOVE_HTML_TAGS("Hello ")` Returns: Hello
RIGHT()	Returns the rightmost characters from a string `RIGHT("abc", 1)` Returns: c `RIGHT("abc", 2)` Returns: bc `RIGHT("abc", 3)` Returns: abc
SENDER_EMAIL_NAME()	The email sender name `SENDER_EMAIL_NAME()` Returns: Default Email Sender Name
SPEECH_TO_TEXT()	SPEECH_TO_TEXT(object,'en-us'). Returns a text string from a GCS object. `SPEECH_TO_TEXT("example.mp3","en-us")` Returns: Hello World
SUBSTITUTE()	Returns a text string with all occurrences of a substring replaced with another substring `SUBSTITUTE("Hello World", "World", "Universe")` Returns: Hello Universe
SUMMARIZE_DOCUMENT(url)	SUMMARIZE_DOCUMENT(url) Returns a summarized text of the input document. Supports PDF files. `SUMMARIZE_DOCUMENT(url = pdf_url)` Returns: Summarized text of the pdf
TEXT()	Returns a text string representation of a value `TEXT(123)` Returns: 123 `TEXT(123.45)` Returns: 123.45
TITLE()	Returns a text string in title case `TITLE("hello world")` Returns: Hello World
TRANSLATE_DOCUMENT()	TRANSLATE_DOCUMENT("URI", "source_language", "target_language"). Returns a translated document from a GCS URI. `TRANSLATE_DOCUMENT("gs://bucket-name/file-name", "en", "es")` Returns: GCS URI
TRANSLATE_DOCUMENT_BATCH()	TRANSLATE_DOCUMENT_BATCH("URI", "source_language", "target_language"). Returns a translated document from a GCS URI. `TRANSLATE_DOCUMENT_BATCH("gs://bucket-name/file-name", "en", "es")` Returns: GCS URI
TRANSLATE_TEXT()	TRANSLATE_TEXT(text, [source_language='auto', target_language='en']). Returns a translated string. Similar to the GOOGLETRANSLATE() function in Google Sheets. `TRANSLATE_TEXT("Hola Amigo")` Returns: Hi friend `TRANSLATE_TEXT("Hola Amigo", "es", "en")` Returns: Hi friend
TRIM()	Returns a text string with whitespace removed from the start and end `TRIM(" Hello World ")` Returns: Hello World `TRIM("Hello World")` Returns: Hello World
UPPER()	Uppercase a string `UPPER("Hello World")` Returns: HELLO WORLD
USERLOCALE()	The active locale e.g. en, de, es, zh `USERLOCALE()` Returns: en, de, es, fr, or zh
USERNAME()	Returns the current user's fullname `USERNAME()` Returns: Full Name
GENERATE_PATH_TIMELINE()	Generate a timeline for a path and related courses. `GENERATE_PATH_TIMELINE( '[[path_id]]',USERID())` Returns: HTML
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Time
TIME()	Returns the time portion of a datetime `TIME("2020-01-01 12:34:56")` Returns: 12:34:56 `TIME(NOW())` Returns: 12:34:56
TIMENOW(timezone='UTC')	The time in %H:%M:%S format. Similar to TIME(NOW()). The timezone is optional with a default of UTC. Complete list of timezones can be found at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones `TIMENOW()` Returns: 12:34:56 `TIMENOW("America/Denver")` Returns: 07:34:56
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: Tuple
REF_ROWS()	Define related table and column `REF_ROWS("users", "claim_id")` Returns: ('users', 'claim_id')
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: UUID
ACCOUNTID()	The current account ID `ACCOUNTID()` Returns: UUID
CURRENTAPP()	The ID of the active application `CURRENTAPP()` Returns: UUID
USERID()	Returns the current user's ID `USERID()` Returns: UUID
USERROLE()	Returns the current user's role ID `USERROLE()` Returns: UUID
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Returns: YesNo
AND()	Returns a YesNo expression `AND(TRUE, TRUE)` Returns: Yes `AND(TRUE, FALSE)` Returns: No `AND(FALSE, TRUE)` Returns: No `AND(FALSE, FALSE)` Returns: No
BOOLEAN() or BOOL()	Converts a value to a boolean `BOOLEAN("true")` Returns: Yes `BOOLEAN("false")` Returns: No `BOOLEAN(1)` Returns: Yes `BOOLEAN(0)` Returns: No
CONTAINS()	Returns a YesNo expression `CONTAINS("Hello World", "World")` Returns: Yes `CONTAINS("Hello World", "World!")` Returns: No
ENDSWITH()	Returns a YesNo expression `ENDSWITH("Hello World", "World")` Returns: Yes `ENDSWITH("Hello World", "World!")` Returns: No
EXISTS()	Returns a YesNo expression `EXISTS("users", "id", 1)` Returns: Yes `EXISTS("users", "id", 999)` Returns: No
HAS_PERMISSION()	Returns a YesNo expression `HAS_PERMISSION("send_mail")` Returns: Yes `HAS_PERMISSION("cases.create")` Returns: No `HAS_PERMISSION("cases.case_number.read")` Returns: No
IN()	Returns a YesNo expression `IN("a", ["a", "b", "c"])` Returns: Yes `IN("d", ["a", "b", "c"])` Returns: No
ISBLANK()	Returns a YesNo expression `ISBLANK("")` Returns: Yes `ISBLANK("a")` Returns: No
ISDATE()	Returns a YesNo expression `ISDATE("2020-01-01")` Returns: Yes `ISDATE("a")` Returns: No
ISNOTBLANK()	Returns a YesNo expression `ISNOTBLANK("")` Returns: No `ISNOTBLANK("a")` Returns: Yes
ISNULL()	Returns a YesNo expression, if the value is null or None `ISNULL(1)` Returns: No `ISNULL(0)` Returns: No `ISNULL(None)` Returns: Yes
ISNUMBER()	Returns a YesNo expression `ISNUMBER(1)` Returns: Yes `ISNUMBER("a")` Returns: No
NOT()	Returns a YesNo expression `NOT(True)` Returns: No `NOT(No)` Returns: Yes
OR()	Returns a YesNo expression `OR(True, False)` Returns: Yes `OR(Yes, No)` Returns: Yes `OR(No, No)` Returns: No
STARTSWITH()	Returns a YesNo expression `STARTSWITH("Hello World", "Hello")` Returns: Yes `STARTSWITH("Hello World", "World")` Returns: No
NOTAFREEMAIL()	Confirm email address is valid and is not from a free email domain (e.g. gmail.com, yahoo.com etc) `NOTAFREEMAIL( 'email@yahoo.com')` Returns: False `NOTAFREEMAIL( 'ted@bluevector.ai')` Returns: True
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

This table contains a list of expressions and their descriptions.
Name	Description	Action
Fields
Select an Object from above to list the Object's Fields

This table contains a list of expressions and their descriptions.
Name	Description	Action
DATE_YYYYMMDD_REGEX	^\d{4}\-(0?[1-9]\|1[012])\-(0?[1-9]\|[12][0-9]\|3[01])$
EMAIL_REGEX	^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+.[a-zA-Z0-9-.]+$
SSN_REGEX	^\d{3}-?\d{2}-?\d{4}$
URL_REGEX	^(http\|https)://[a-zA-Z0-9-.]+.[a-zA-Z]{2,3}(/\S*)?$

Contact Us

Solutions

Public Health

Resources

Terms

Hello

Hello

Hello

Hello

Hello

Hello

Contact Us

Add Schema

Add Value

Solutions

Public Health

Resources

Terms

Caution!

Hello

Hello

Hello

Hello

Hello

Hello