contains
 
Function Name
Arguments
Result Type
Explanation
Examples
More Examples
 
Type Conversion  (8 Functions) 
ToBoolean (Text x) Boolean Converts the values "1", "true" or "yes" to true, other values to false. Case is ignored. ToBoolean("Yes") returns true
ToBoolean("0") returns false
More examples
ToDate (Text x) Date Converts the text value x into a Date. x can be several of the popular date formats, including "January 30, 2000", "1/30/00", "2000/1/30", "1-30-2000" ToDate("Jan 30, 2000") takes the text "Jan 30, 2000" and returns it as a date type value. More examples
ToFormattedText (Date d, Text f) Text Returns a Text value which is the formatted text version of the date specified. 
The Text argument to the function specifies the format. Choose one of:
   MMDDYYYY
   MMDDYY
   DDMMYYYY
   DDMMYY
   YYYYMMDD
ToFormattedText(Date(2000,01,30),"MMDDYYYY")  returns "01-30-2013" 
ToFormattedText(Date(2000,01,30),"MMDDYY")  returns "01-30-13" 
ToFormattedText(Date(2000,01,30),"DDMMYYYY")  returns "30-01-2013" 
ToFormattedText(Date(2000,01,30),"DDMMYY")  returns "30-01-13" 
ToFormattedText(Date(2000,01,30),"YYYYMMDD")  returns "2013-01-30"
More examples
ToFormattedText (Date/Time t, Text f) Text Returns a Text value which is the formatted text version of the date/time specified. 
The Text argument to the function specifies the format. Choose one of:
   MMDDYYYY
   MMDDYY
   DDMMYYYY
   DDMMYY
   YYYYMMDD
ToFormattedText([Date Created],"MMDDYYYY")  returns "01-30-2013 10:34 PM" 
ToFormattedText([Date Created],"MMDDYY")  returns "01-30-13 10:34 PM" 
ToFormattedText([Date Created],"DDMMYYYY")  returns "30-01-2013 10:34 PM" 
ToFormattedText([Date Created],"DDMMYY")  returns "30-01-13 10:34 PM" 
ToFormattedText([Date Created],"YYYYMMDD")  returns "2013-01-30 10:34 PM"
More examples
ToFormattedText (Number n, Text f) Text Returns a Text value which is the formatted text version of the number specified. 
The Text argument to the function specifies the format. Choose one of:
  none_dot -  returns the number formatted like 12345678.85
  comma_dot - returns the number formatted like 12,345,678.85
  comma_dot_2 - returns the number formatted like 1,23,45,678.85
  none_comma - returns the number formatted like 12345678,85
  dot_comma - returns the number formatted like 12.345.678,85
  dot_comma_2 - returns the number formatted like 1.23.45.678,85
ToFormattedText(2394729834.85, "comma_dot") returns 2,394,729,834.85 More examples
ToNumber (Text x) Number Returns the number represented by the Text value x. ToNumber("-12.3") returns -12.3
ToNumber("") returns null
More examples
ToText (<any> x) Text Returns a Text value containing the print representation of the argument x. ToText(3.4) returns "3.4"
ToText(null) returns ""
ToText(true) returns "1"
ToText(Date(2000,12,16)) returns "12-16-2000"
ToText(ToTimeOfDay("4pm")) returns "4:00 pm"
ToText(Hours(2)+Minutes(20)) returns "2:20"
ToText([Date Created]) returns "12-15-2000 10:34 PM"

ToText([Record Owner]) returns the user name or email address of the user who appears in the Record Owner field.

ToText([AssignedTo]), where AssignedTo is a list-user field type, returns a semi-colon separated list of the user names or email addresses of the users  who appear in the AssignedTo field.
More examples
ToTimeOfDay (Text x) TimeOfDay Converts the text value x into a TimeOfDay. x can be several of the popular time formats, including "3 pm", "3:04 am", "22:00", "2:03:29 am", "12:03:29.345". ToTimeofDay("16:32") returns the time 4:32pm More examples
Text  (19 Functions) 
Begins (Text u, Text v) Boolean Returns true if the text u begins with the text v, otherwise returns false. Begins("abcdef", "cd") returns false
Begins("abcdef", "abcd") returns true
More examples
Contains (Text u, Text v) Boolean Returns true if v is contained in u, otherwise returns false. Contains("abcdef", "cd") returns true
Contains([Status], "open") returns true if the Status field contains the word "open"
More examples
Ends (Text u, Text v) Boolean Returns true if the text u ends with the text v, otherwise returns false. Ends("abcdef", "cd") returns false
Ends("abcdef", "cdef") returns true
More examples
Left (Text t, Number n) Text Returns the leftmost n characters from the Text argument t. Left("abcd", 2) returns "ab" More examples
Left (Text t, Text d) Text Returns the left part of a text value up to but not including the first occurrence of a delimiter character.  The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. Left("abc/def",";/,") returns "abc"
Left("Michael Smith", " ") returns "Michael"
More examples
Length (Text t) Number Returns the number of characters in t. Length("abc") returns 3 More examples
List (Text d, Text t1, Text t2, ...) Text Concatenates (strings together) all arguments starting with the second argument, using the first argument as the delimiter between them. If one of the arguments is blank, it and the corresponding delimiter are omitted. List("-", "a", "b", "d") returns "a-b-d"

List(", ", "a", "b", "", "d") returns "a, b, d"

List(", ", [Last Name], [First Name]) returns "Last Name, First Name" if both fields are not empty, returns "Last Name" if [First Name] is empty, and returns "First Name" if [Last Name] is empty.

List("\n", "Name", "Address Line 1", "", List(", ", "City", "State"), "Zip") returns
"Name
Address Line 1
City, State
Zip"
More examples
Lower (Text t) Text Returns t converted to lower case. Lower("ABC") returns "abc" More examples
Mid (Text t, Number p, Number n) Text Returns n characters from the middle of t, starting at position p.  The first character is position 1. Mid("abcd", 2, 3) returns "bcd"
Mid("abcd", 4, 4) returns "d"
More examples
NotLeft (Text t, Number n) Text Returns what remains after excluding the leftmost n characters from the Text argument t. NotLeft("abcde", 2) returns "cde" More examples
NotLeft (Text t, Text d) Text Returns what remains after excluding the left part of a text value up to and including the first occurrence of a delimiter character.  The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters.

If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
NotLeft("abc/ def/ghi"," ;/,") returns "def/ghi"
NotLeft("Michael    Wissner", " ") returns "Wissner"
More examples
NotRight (Text t, Number n) Text Returns what remains after excluding the rightmost n characters from the Text argument t. NotRight("ABCDE", 2) returns "ABC" More examples
NotRight (Text t, Text d) Text Returns what remains after excluding the right part of a text value starting at the last occurrence of a delimiter character.  The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters.

If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
NotRight("abc/ def"," ;/,") returns "abc"
NotRight("Michael   Wissner", " ") returns "Michael"
More examples
Part (Text t, Number p, Text d) Text Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character. The first argument, t, is the value to be searched. The second argument, p, is the position of the part in the argument t. The first part starting on the left is position 1.  Negative part numbers can be used to start from the right. The third argument, d, is a text value containing all the possible delimiter characters.

If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
Part("hh:mm:ss",1,":") returns "hh"
Part("hh:mm:ss",3,":") returns "ss"
Part("hh:mm:ss",-1,":") returns "ss"
Part("hh:mm",3,":") returns ""
Part("abc, def,ghi",2," ,") returns "def"
Part([Append],2,"[") returns all text from the Append field that lives between the first [ character and the second [ character. This example shows how to extract only the most recent entry from an append field.
More examples
Right (Text t, Number n) Text Returns the rightmost n characters from the Text argument t. Right("ABCD", 2) returns "CD" More examples
Right (Text t, Text d) Text Returns the right part of a text value starting at the character after the last occurrence of a delimiter character.  The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. Right("abc/def",";/,") returns "def"
Right("Michael Wissner", " ") returns "Wissner"
More examples
Trim (Text t) Text Returns t with leading and trailing white space characters removed. White space characters are space, tab, CR and LF. Trim("  ABC ") returns "ABC" More examples
Upper (Text t) Text Returns t converted to upper case. Upper("abc") returns "ABC" More examples
URLEncode (Text t) Text Encodes the text t so that it can be used in a URL, by substituting special character combinations for certain reserved characters, like '&' and '=' and space. URLEncode("abc def&ghi=4") returns "abc+def%26ghi%3D4" More examples
Aggregation  (3 Functions) 
Count (<any> x, ...) Number Counts the number of non-null arguments. For Text arguments, non-blanks are counted. For Boolean arguments, trues are counted.

This function can also be used in the context of a Summary report where it will count the # of Non-null records for each grouping, if used to specify the field to check in a Calculated Column.
Count ("", "abc", true, false, 53) returns 3

For the Summary Report example, a formula might look something like this:

Count([Field])

This might be used if the customer were trying to determine - within the Summary Report groups - how many of these records had a value in [Field]
More examples
Max (<any> x, <any> y, ...) <same type as x and y> This function can take 2 or more arguments of any data type, as long as they are all the same type. The result is the same data type as the arguments. Null values are ignored.

For Numbers, returns the argument that is greatest.
For Text, returns the argument that sorts last alphabetically.
For Durations, returns the argument that is longest.
For Dates returns the argument that is latest.
For Date/Time, returns the argument that is latest.
For TimeOfDays, returns the argument that is latest.
For Booleans returns the argument that is largest, treating false as less than true.
Max (Days(2), Weeks(1)) returns 1 week
Max (10, 20, 30, 40) returns 40
Max (10, null, 30) returns 30
Max (null, null, null) returns null
More examples
Min (<any> x, <any> y, ...) <same type as x and y> This function can take 2 or more arguments of any data type, as long as they are all the same type. The result is the same data type as the arguments.  Null values are ignored.

For Numbers, returns the argument that is least.
For Text, returns the argument that sorts first alphabetically.
For Durations, returns the argument that is shortest.
For Dates returns the argument that is earliest.
For Date/Time, returns the argument that is earliest.
For TimeOfDays, returns the argument that is earliest.
For Booleans returns the argument that is smallest, treating false as less than true.
Min (10, 20, 30, 40) returns 10
Min ([Date1], [Date2]) returns whichever date field's value is earlier
Min (Days(2), Weeks(1)) returns 2 days
in (10, null, 30) returns 10
Min (null, null, null) returns null
More examples
Null Handling  (1 Function)  
IsNull (<any> x) Boolean Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.

The result of this function is true if x is null, otherwise false. The argument x may be of any data type (except text or boolean).
IsNull([Start Date]) returns true if the field named Start Date is undefined or empty.
IsNull(3.4) returns false
More examples
Special  (12 Functions) 
Case (<any> x, <any> val1, <any> result1, ..., <any> else-result) <same type as result1> Case() is a variation of the If() function. If you want to test many conditions against a single field, use the Case() function instead of the If() function. 

QuickBase evaluates the value x and compares it to each of the values that follow (val1 and so on) sequentially. If the value X matches any value, QuickBase returns the corresponding result which lives behind the comma following the matched value. If value x is not equal to any of the values, QuickBase returns the else-result at the end of the formula.

The else-result is optional. If omitted, QuickBase assumes it's null (empty). 

The value x may be of any data type, but all of the values must be of the same type as x.  
 
Case([Grade], "A", 100, "B", 90, null)

This formula says: If the value in the Grade field is A, then return 100. If the value in the Grade field is B, then return 90. Otherwise, return nothing (null).

More examples
Dbid () Text Returns a Text value containing the database ID of a table. Dbid() in this database returns "6ewwzuuj" More examples
If (Boolean condition1, <any> result1, ..., <any> else-result) <same type as result1> If condition1 is true, returns result1, otherwise returns else-result. 

You can include additional condition/result pairs before the final else-result (as in the first example).  QuickBase evaluates the conditions in sequence until one is found to be true, and then the corresponding result is returned.

The else-result is optional. If omitted, QuickBase assumes it's null (or empty - a blank).

All conditions must be of type Boolean (return a true or a false). Results may be of any type, but they must all be the same type.
If([Grade]="A", 100, [Grade]="B", 90)

This formula says: if the value in the Grade field is A, then return 100. If the value in the Grade field is B, then return 90.

IF([Order Complete]=TRUE, [Subtotal] + [Tax], null)

This formula says: If the Order Complete checkbox is on, then add the value in the subtotal field to the value in the tax field and display it. If not, then leave the field empty (or null).

More examples
IsUserEmail (Text x) Boolean Returns true if x is the email address of the current user. IsUserEmail("john_smith@example.com") would return true if John Smith were accessing the table containing the formula field. More examples
ToUser (Text t) User Converts a user name or e-mail address to a user value. A "user" is an individual with whom you've shared your application. You'd translate something like an e-mail address into a user value so that QuickBase recognizes the user. When you do so, you can take advantage of user fields to design permissions and/or views. For example, show a user only those tasks that have been assigned to her. ToUser([Email Address]) takes the values in the Email Address field and returns their corresponding user values.
ToUser("jsmith") returns the user with the user name "jsmith". 
ToUser("jsmith@example.com") returns the user possessing that e-mail address.  
More examples
URLRoot () Text Returns the first part of the URL used to access QuickBase, including the protocol and the site name. URLRoot() returns "https://www.quickbase.com/" More examples
UserListToEmails (UserList ul) text Returns a semi-colon separated list of email addresses for all the users selected on the User List field.

This function won't work for users who have hidden their e-mail address by choosing a screen name.
UserListToEmails([Assigned To]) returns the semi-colon separated list of email addresses of the QuickBase users who are part of Assigned To field for a record. More examples
UserListToNames (UserList ul, Text format) text Returns a semi-colon separated list of users' full names. Specify text format by including "FF" to return the full names with the first name first. Or, include "LF" to return the full names with the last name first. UserListToNames([Volunteers], "LF"), returns "Smith, Michael; Jones, Nancy" where the Volunteers are the users Michael Smith and Nancy Jones. More examples
UserListToNames (UserList ul) text Returns a semi-colon separated list of the users' full names, first name first. UserListToNames([Volunteers]) returns the full names of the users listed in the Volunteers field. More examples
UserToEmail (User x) Text Returns the user's e-mail address.

This function won't work for users who have hidden their e-mail address.
UserToEmail([Last Modified By]) returns the email address of the QuickBase user who last modified a record. More examples
UserToName (User x, Text format) Text Returns a given user's full name. Specify text format by including "FF" to return the full name with the first name first. Or, include "LF" to return the full name with the last name first. UserToName([Record Owner], "LF"), returns "Smith, Michael" where the record owner is the user Michael Smith. More examples
UserToName (User x) Text Returns the user's full name, first name first. UserToName([Record Owner]) returns the full name of the user listed in the Record Owner field. 

Use this function to turn a user name into a full name. For example: 

UserToName(ToUser("bboop")) might return "Betty Boop". 
More examples
Binary Operators (act on multiple values)  (7 Functions) 
& <any> u, <any> v Text Returns a text value that is the concatenation of u and v. Use this operator to link strings of characters together in a formula text field. 

If u or v is not a text value, QuickBase automatically inserts the function ToText() to convert the value to text before concatenating it.

Does not support User or UserList.
"abc" & "def" returns "abcdef"
"abc" & 5 returns "abc5"
[First Name] & " " & [Last Name] concatenates the values in the First Name and Last Name field with a space in between them.
More examples
< <any> x, <any> y Boolean Returns true if x is less than y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
3 < 4 returns true
4 < 3 returns false
"abcdef" < "gh" returns true
More examples
<= <any> x, <any> y Boolean Returns true if x is less than or equal to y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
3 <= 4 returns true
"abcdef" <= "gh" returns true
More examples
<> <any> x, <any> y Boolean Returns true if x is not equal to y, otherwise returns false.  

x and y must be the same type.

As with most other functions, null argument values produce a null result, so it is not possible to test for null with this operator. To test for null, use IsNull() instead.
(3 / 4 <> 0.75) returns false More examples
= <any> x, <any> y Boolean Returns true if x is equal to y, otherwise returns false.

x and y must be the same type. 

As with most other functions, null argument values produce a null result, so it is not possible to test for null with this operator. To test for null, use IsNull() instead.
(3 / 4 = 0.75) returns true
More examples
> <any> x, <any> y Boolean Returns true if x is greater than y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
3 > 4 returns false

[Actual Completion Date] >= [Projected Completion Date] returns true if the value in the the Actual Completion Date field is greater than the date in the Project Completion Date field.

Weeks(1) > Days(6) returns true
More examples
>= <any> x, <any> y Boolean Returns true if x is greater than or equal to y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
[Actual Completion Date] >= [Projected Completion Date] returns true if the value in the the Actual Completion Date field is greater than or equal to the date in the Project Completion Date field.

ToDate("Jan 1, 2000") >= ToDate("Feb 1, 1999") returns true
More examples
SUMMARY
  Category Number of
Functions
 
    Graph
Type Conversion 8
Text 19
Aggregation 3
Null Handling 1
Special 12
Binary Operators (act on multiple values) 7
  Totals (6 groups) 50

We're glad you're interested in doing more with Quick Base!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quick Base with others in your company.

Your work email
Your company
Report Name *
Description



This report will be saved as a personal report (only you can view it)
You've made changes
Save
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quick Base often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quick Base finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quick Base needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table