AI-Powered Healthcare Platform

Innovation Program Application

Contact Information

Full Name *

Organization/Institute/Company *

Job Role/Title *

Business Email *

Phone Number

Organization Overview

Which best describes your organization? *

Please provide a short description of your organization and mission. *

Project Details

Project Name/Initiative *

Expected project start date *

Is this a multi-phase initiative? *

Yes No

Please provide a short description of the problem you are solving. *

Project Size (i.e. number of participants, clinicians, etc.) *

Funding Context

What funding challenges are you currently facing? *

Do you have grant funding, or are you applying for one? *

Yes - We have grant funding Yes - We have applied for a grant No - We have departmental funding for this project Not Sure

Funding Source

How would Health Studio investment in your project accelerate or alleviate budgetary concerns? *

Impact & Commitment

What outcomes or patient/research impacts do you hope to achieve? *

Anything else you'd like us to know?

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*)?$

Innovation Program Application

Contact Information

Organization Overview

Project Details

Funding Context

Impact & Commitment

Solutions

Public Health

Resources

Terms

Hello

Hello

Hello

Hello

Hello

Hello

Innovation Program Application

Contact Information

Organization Overview

Project Details

Funding Context

Impact & Commitment

Add Schema

Add Value

Solutions

Public Health

Resources

Terms

Caution!

Hello

Hello

Hello

Hello

Hello

Hello