SnapApp by BlueVector AI

Select Language
English

German Spanish
SnapApp Applications

Marketplace

Community

Website

Show All Applications

Add Cases

Name

Type *

Description

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

Expression

Output

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
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
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
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
BASE_URL()	Returns the base URL of the app `BASE_URL()` Returns: https://www.appsheet.com/
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_DB("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
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_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%
GENERATE_IMAGE()	Returns a generated Image based on the input prompt `GENERATE_IMAGE("Cute Dog playing football ","512x512",1)` Returns: Image
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
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
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
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
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
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
REMOVE_HTML_TAGS()	Removes HTML tags from a string `REMOVE_HTML_TAGS("Hello ")` Returns: Hello `REMOVE_HTML_TAGS("Hello ")` Returns: Hello
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')
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 objects from DB table. Optional second parameter to specify fields. Optional third and foruth parameter to specify filter column and filter value. Optional fifth parameter to specify whether to flatten the list." filters:- Optional parameter to apply multiple filters. It should be a list of tuples. Each tuple should have 2 elements. First element should be the column name and second element should be the value. For example, filters=[("column1", 10), ("column2", 20)] will return rows where column1 = 10 and column2 = 20. order_by:- Optional parameter to specify the column name to sort the results. It should be a string. For example, order_by="column1" will sort the results by column1. If you want to sort in descending order, you can add a "-" in front of the column name. For example, order_by="-column1" will sort the results by column1 in descending order. `SELECT("table", "field")` Returns: [{...}, {...}, ...] `SELECT("table", "field,field2")` Returns: [{...}, {...}, ...] `SELECT("table", "field", "filter_column", "filter_value")` Returns: [{...}, {...}, ...] `SELECT("table", "field", "filter_column", "filter_value", True)` Returns: [field, field, ...] `SELECT("table", "", filters=[("column1", 10), ("column2", 20)])` Returns: [(record1), (record2), ...] `SELECT("table", "", order_by="column1")` Returns:
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). Returns a text string from a GCS object. `SPEECH_TO_TEXT("example.mp3")` 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
BUILD_FIELD_DATA()	None `BUILD_FIELD_DATA(q)` Returns: Any
CALCULATE_CURRENT_PROGRESS()	None `CALCULATE_CURRENT_PROGRESS(questions)` Returns: Any
EXTRACT_NAME_FROM_URL()	this function extracts the name from the url Returns:
FETCH_OAUTH_TOKEN()	None Returns:
GENERATE_BACKLINKS()	`GENERATE_BACKLINKS(url)` Returns: Any
GENERATE_KB_ARTICLE()	None Returns:
GENERATE_KEYWORDS()	`GENERATE_KEYWORDS(user_id,website,start_date,end_date)` Returns: Any
GENERATE_PATH_TIMELINE()	Generate a timeline for a path and related courses. `GENERATE_PATH_TIMELINE(path_id,user_id)` Returns: Text
GENERATE_SEO_SUGGESTIONS()	Returns:
GENERATE_SLIDES_NEW()	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()	`GET_OUTH_TOKEN('google_apis',USERID())` Returns: The Decrypted Token
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_QUESTIONS()	None `GET_QUESTIONS(quiz_id)` Returns: Any
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 `KEYWORD_RANKINGS(user_id, url, start_date, end_date)` 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_DATE()	None `RENDER_DATE(q)` Returns: Any
RENDER_ENUM()	None `RENDER_ENUM(q)` Returns: Any
RENDER_ENUM_BUTTONS()	None `RENDER_ENUM_BUTTONS(q, options, current_answer)` Returns: Any
RENDER_ENUM_DROPDOWN()	None `RENDER_ENUM_DROPDOWN(q, options, current_answer)` Returns: Any
RENDER_ENUM_STACKED()	None `RENDER_ENUM_STACKED(q, options, current_answer)` Returns: Any
RENDER_ERROR()	None `RENDER_ERROR(msg)` Returns: Any
RENDER_FIELD_FOR_QUESTION()	None `RENDER_FIELD_FOR_QUESTION(q)` Returns: Any
RENDER_HEADER()	None `RENDER_HEADER(questions)` Returns: Any
RENDER_LONG_TEXT()	None `RENDER_LONG_TEXT(q)` Returns: Any
RENDER_NO_QUESTION()	None `RENDER_NO_QUESTION()` Returns: Any
RENDER_QUIZ()	None `RENDER_QUIZ(quiz_id)` Returns: Any
RENDER_TEXT()	None `RENDER_TEXT(q)` Returns: Any
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
BUILD_FIELD_DATA()	None `BUILD_FIELD_DATA(q)` Returns: Any
CALCULATE_CURRENT_PROGRESS()	None `CALCULATE_CURRENT_PROGRESS(questions)` Returns: Any
EXTRACT_NAME_FROM_URL()	this function extracts the name from the url Returns:
FETCH_OAUTH_TOKEN()	None Returns:
GENERATE_BACKLINKS()	`GENERATE_BACKLINKS(url)` Returns: Any
GENERATE_KB_ARTICLE()	None Returns:
GENERATE_KEYWORDS()	`GENERATE_KEYWORDS(user_id,website,start_date,end_date)` Returns: Any
GENERATE_SEO_SUGGESTIONS()	Returns:
GENERATE_SLIDES_NEW()	Returns:
GET_COURSE_DETAILS_101()	Returns:
GET_COURSE_HTML()	`GET_COURSE_HTML(course_id,user_id)` Returns: None
GET_KEYWORD_RANKING()	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_QUESTIONS()	None `GET_QUESTIONS(quiz_id)` Returns: Any
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 `KEYWORD_RANKINGS(user_id, url, start_date, end_date)` Returns: Any
RENDER_DATE()	None `RENDER_DATE(q)` Returns: Any
RENDER_ENUM()	None `RENDER_ENUM(q)` Returns: Any
RENDER_ENUM_BUTTONS()	None `RENDER_ENUM_BUTTONS(q, options, current_answer)` Returns: Any
RENDER_ENUM_DROPDOWN()	None `RENDER_ENUM_DROPDOWN(q, options, current_answer)` Returns: Any
RENDER_ENUM_STACKED()	None `RENDER_ENUM_STACKED(q, options, current_answer)` Returns: Any
RENDER_ERROR()	None `RENDER_ERROR(msg)` Returns: Any
RENDER_FIELD_FOR_QUESTION()	None `RENDER_FIELD_FOR_QUESTION(q)` Returns: Any
RENDER_HEADER()	None `RENDER_HEADER(questions)` Returns: Any
RENDER_LONG_TEXT()	None `RENDER_LONG_TEXT(q)` Returns: Any
RENDER_NO_QUESTION()	None `RENDER_NO_QUESTION()` Returns: Any
RENDER_QUIZ()	None `RENDER_QUIZ(quiz_id)` Returns: Any
RENDER_TEXT()	None `RENDER_TEXT(q)` Returns: Any
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: 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 objects from DB table. Optional second parameter to specify fields. Optional third and foruth parameter to specify filter column and filter value. Optional fifth parameter to specify whether to flatten the list." filters:- Optional parameter to apply multiple filters. It should be a list of tuples. Each tuple should have 2 elements. First element should be the column name and second element should be the value. For example, filters=[("column1", 10), ("column2", 20)] will return rows where column1 = 10 and column2 = 20. order_by:- Optional parameter to specify the column name to sort the results. It should be a string. For example, order_by="column1" will sort the results by column1. If you want to sort in descending order, you can add a "-" in front of the column name. For example, order_by="-column1" will sort the results by column1 in descending order. `SELECT("table", "field")` Returns: [{...}, {...}, ...] `SELECT("table", "field,field2")` Returns: [{...}, {...}, ...] `SELECT("table", "field", "filter_column", "filter_value")` Returns: [{...}, {...}, ...] `SELECT("table", "field", "filter_column", "filter_value", True)` Returns: [field, field, ...] `SELECT("table", "", filters=[("column1", 10), ("column2", 20)])` Returns: [(record1), (record2), ...] `SELECT("table", "", order_by="column1")` Returns:
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_DB("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
SENDER_EMAIL_NAME()	The email sender name `SENDER_EMAIL_NAME()` Returns: Default Email Sender Name
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_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%
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
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
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
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
REMOVE_HTML_TAGS()	Removes HTML tags from a string `REMOVE_HTML_TAGS("Hello ")` Returns: Hello `REMOVE_HTML_TAGS("Hello ")` Returns: Hello
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
RIGHT()	Returns the rightmost characters from a string `RIGHT("abc", 1)` Returns: c `RIGHT("abc", 2)` Returns: bc `RIGHT("abc", 3)` Returns: abc
SPEECH_TO_TEXT()	SPEECH_TO_TEXT(object). Returns a text string from a GCS object. `SPEECH_TO_TEXT("example.mp3")` 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,user_id)` Returns: Text
GET_OAUTH_TOKEN()	`GET_OUTH_TOKEN('google_apis',USERID())` Returns: The Decrypted Token
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
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*)?$

Add Cases

Products

Terms

More

Hello

Hello

Hello

Hello

Hello

Hello

Add Cases

Add Schema

Add Value

Hello

Hello

Hello

Hello

Hello

Hello