Filters

Filters
is OR ...
 
Function Name
Arguments
Result Type
Explanation
Examples
 
Numbers  (11 Functions) 
Abs (Number n) Number Returns the absolute value of the Number n. Abs(3.5) returns 3.5
Abs(-3.5) returns 3.5
Exp (Number n) Number Returns e raised to the nth power, where e is approximately 2.71828182845905 This exponential function is for use in logarithmic calculations that track growth. For example, you can use it to figure compounding interest. Exp(2) returns 7.389056 (which is e, or 2.71828182845905, to the 2nd power)

Exp(5) returns 148.413159 (e to the 5th power)
Frac (Number n) Number Returns the fractional part of the Number n. The result is the same sign as n. For any Number n, Int(n) + Frac(n) is the same as n. Frac(3.4) returns 0.4
Frac(-2.3) returns -0.3
Int (Number n) Number Returns the integer part of Number n. Note that if n is a negative fraction, the result is closer to 0 than n is (compare to function Floor). Int(3.6) returns 3
Int(3) returns 3
Int(-3.6) returns -3
Ln (Number n) Number Returns the natural (base e) logarithm of n. Exp(Ln(72)) returns 72
Log (Number n) Number Returns the base 10 logarithm of n. Log(100) returns 2
10 ^ Log(72) returns 72
Mod (Number n, Number m) Number Returns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.) You might use this function to auto-assign tasks to staff members. For details, please read this article Mod(7,3) returns 1
Mod(-7,3) returns 2
Mod(7,-3) returns -1
Mod(-7,-3) returns -2

Sample auto-assign formula:

If (Mod([Record ID#],ToNumber([number_of_reps])) = 0, ToUser("jsmith"),
Mod([Record ID#],ToNumber([number_of_reps])) = 1, ToUser("bboop"),
Mod([Record ID#],ToNumber([number_of_reps])) = 2, ToUser("ppeabody"))
PV (Number rate, Number nskip, Number amt) Number Calculates the Present Value of a future payment. Rate is the discount rate for one time period. Nskip is the number of time periods before the payment occurs. Amt is the amount of the payment. PV(.10, 2, 121) returns 100
PV (Number rate, Number nskip, Number amt, Number npay) Number Calculates the Present Value of a series of future payments. Rate is the discount rate for one time period. Nskip is the number of time periods before the first payment occurs. Amt is the amount of each payment. Npay is the number of payments in the series, spaced one time period apart. PV(.10, 1, 100, 3) returns 248.69
Rem (Number n, Number d) Number Returns a number that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.) Rem(7,3) returns 1
Rem(-7,3) returns -1
Rem(7,-3) returns 1
Rem(-7,-3) returns -1
Sqrt (Number n) Number Returns the square root of n. Sqrt(9) returns 3
Sqrt(16) returns 4
Dates  (27 Functions) 
AdjustMonth (Date d, Number m) Date Returns the date which is m months after the given date d, with the same day number. If the day doesn't exist in that month, the last day of that month is returned. AdjustMonth([Ordered On], 3) returns the date three months after the date in the Ordered On field.

AdjustMonth(ToDate("2/20/99"), 2) returns April 20, 1999
AdjustMonth(ToDate("4/29/99"), -2) returns February 28, 1999
AdjustYear (Date d, Number y) Date Returns the date which is y years after the given date d, with the same month and day. If the day doesn't exist in that month, the last day of that month is returned. AdjustYear([Last Appt], 1) returns the date one year after the date in the Last Appt field.
AdjustYear([Date],-1) returns the date one year before the value in the Date field,
AdjustYear(ToDate("2/20/99"), 2) returns February 20, 2001
AdjustYear(ToDate("2/29/00"), -1) returns February 28, 1999
Date (Number year, Number month, Number day) Date Creates a date from a year, month and day. Date(2000, 1, 10) returns the date January 10, 2000
Day (Date d) Number Returns the day of the month of the given Date d. Day([Start Date]) returns the day of the month for the date that appears in the Start Date field.

Day(ToDate("Jan 10, 2000")) returns 10
DayOfWeek (Date d) Number Returns the number of days by which the given date d follows the first day of the week (Sunday returns 0). DayOfWeek([Start Date]) returns the number of the day of the week for the date that appears in the Start Date field.
DayOfWeek(ToDate("Aug 23, 2000")) returns 3
DayOfWeek(ToDate("Aug 20, 2000")) returns 0
DayOfYear (Date d) Number Returns the number of days by which the given date d follows the first day of the year (January 1 returns 0). DayOfYear(ToDate("Jan 1, 2000")) returns 0
DayOfYear(ToDate("Jan 10, 2000")) returns 9
FirstDayOfMonth (Date d) Date Returns the first day of the month in which the date falls. FirstDayOfMonth([Order Date]) returns the first day of the month in which the Order Date occurs.

FirstDayOfMonth(Today()) returns the first day of the current month.
FirstDayOfPeriod (Date d, Duration p, Date r) Date Returns the first day of the period in which the date d falls. The cycle of periods is defined by the given Duration p, repeated in sequence starting at the given reference date r. If the period p is not a whole number of days, the fractional part is ignored. Useful for handling biweekly pay periods.

FirstDayOfPeriod([date field], Weeks(2), Date(2000,5,1)) returns the date that is the start of the two week period in which the date in the date field falls. The initial two week period that starts the cycle begins on May 1, 2000.


FirstDayOfPeriod(Today(), Days(365), Date(2005,7,1)) returns the date July 1st of the current year-long period. Between 7/1/06 and 7/1/07 this would be July 1, 2006. (As the years go on, this method won't account for leap years.)
FirstDayOfWeek (Date d) Date Returns the first day (Sunday) of the week in which the date falls. FirstDayOfWeek([Start Date]) returns the date of the Sunday (first day of the week) in which the Start Date occurs.
FirstDayOfWeek(ToDate("7/30/2007")) returns the date 7-29-07
FirstDayOfYear (Date d) Date Returns the first day of the year in which the date falls. FirstDayOfYear([Termination Date]) returns the first day of the year in which the Termination date occurs.

FirstDayOfYear(Today()) returns the first day of the current year.
IsLeapDay (Date d) Boolean Returns true if d is February 29. IsLeapDay([Date Due]) returns true if the value in the Date Due field falls on a leap day like 2/29/08.
IsLeapYear (Date d) Boolean Returns true if the date d falls in a leap year. IsLeapYear([Release Date]) returns true if the date in the Release Date field falls in a leap year like 2008. If it occurs in a non leap year, like 2007, the result is false.
IsLeapYear (Number y) Boolean Returns true if the year y is a leap year. IsLeapYear(2007) returns false.
IsLeapYear(2008) returns true.
IsWeekday (Date d) Boolean Returns true if d is a weekday, otherwise false. IsWeekday([Deliver On]) returns true if the date in the Deliver On field is a weekday. If not, the result is false.

IsWeekday(ToDate("6/20/2003")) returns true
LastDayOfMonth (Date d) Date Returns the last day of the month in which the date falls. LastDayOfMonth([Service Date]) returns the date of the last day of the month in which the Service Date occurs.

LastDayOfMonth(ToDate("2/12/2008")) returns 
02-29-2008
LastDayOfPeriod (Date d, Duration p, Date r) Date Returns the last day of the period in which the date falls. The cycle of periods is defined by the given Duration p, repeated in sequence starting at the given reference date r. If the period p is not a whole number of days, the fractional part is ignored. LastDayOfPeriod([Payment Date], [Quarter Length in Days], [Fiscal Year Start Date]) returns the last day of the quarter in which the Payment Date falls.
LastDayOfWeek (Date d) Date Returns the last day (Saturday) of the week in which the date falls. LastDayOfWeek([Date A]) + Days(1) returns the Sunday date of the week that follows the one in which Date A falls.
LastDayOfYear (Date d) Date Returns the last day of the year in which the date falls. LastDayOfYear([Registration Date]) returns the last day of the year in which the Registration Date falls.

LastDayOfYear(Todate("August 4, 2009")) returns 12-31-2009
Month (Date d) Number Returns the month number of the Date d. January is month 1. Month([Start Date]) returns the number of the month within the date that appears in the Start Date field.

Month(ToDate("Jan 10, 2000") returns 1
NextDayOfWeek (Date d, Number n) Date Returns the first day after the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on. NextDayOfWeek([Date Submitted], 2) returns the first Tuesday that follows the Date in the Date Submitted field.
PrevDayOfWeek (Date d, Number n) Date Returns the last day before the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on. PrevDayOfWeek([Date Due], 5) returns the date of the last Friday that occurse before the Date Due.
Today () Date Returns the current date in the local time zone. Today() - [Estimated Finish Date] calculates the duration since the Estimated Finish Date occurred.
ToWeekdayN (Date d) Date If the given date d is a weekday returns it, otherwise returns the next occurring weekday. To WeekdayN([Order Date]) returns the date in the Order Date field if it's a weekday. If not, it returns the date of the next weekday.

ToWeekdayN(ToDate("6/21/2003")) returns 6/23/2003
ToWeekdayP (Date d) Date If the given date d is a weekday returns it, otherwise returns the previously occurring weekday. ToWeekdayP(ToDate("6/21/2003")) returns 6/20/2003
WeekdayAdd (Date d, Number n) Date Returns the date that is n weekdays past the given date d. n may be negative to move backward in time. WeekdayAdd([Start], [Duration]) returns the date that results if you add the value in the Duration field to the date in the Start field and count only weekdays. 

WeekdayAdd(ToDate("6/20/2003"), 2) returns 6/24/2003

WeekdayAdd(ToDate("6/24/2003"), -2) returns 6/20/2003

If you have a date field named "Start Date" and that field has a value of 6/23/2003, then WeekdayAdd([Start Date], -2) returns 6/20/2003
WeekdaySub (Date d2, Date d1) Number Returns the number of weekdays in the interval starting with d1 and ending on the day before d2 (same as subtracting Dates, but the result is the number of weekdays instead of a Duration). It is the inverse of WeekdayAdd. WeekdaySub([Finish], [Start]) returns the number of weekdays between the dates in the Start and Finish fields.

WeekdaySub(ToDate("6/24/2003"), ToDate("6/20/2003") ) returns 2

Year (Date d) Number Returns the year number of the Date d. Year([Start Date]) returns the year of the date that appears in the Start Date field.

Year(ToDate("Jan 10, 2000")) returns 2000
Special  (18 Functions) 
AppID () Text Returns a text value containing the database ID of the app. AppID() in this app returns "6ewwzuuj"
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).

Dbid () Text Returns a Text value containing the database ID of a table. Dbid() in this database returns "6ewwzuuj"
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).

Includes (UserList ul, UserList ul1,UserList ul2 ..) Boolean This function takes 2 or more list-user field types as arguments and returns true if the contents of all the the arguments together, except for the first, are included in the contents of first argument; false otherwise. Includes ([Assigned To] , [Manager], [Employee])

This will return true if all the users in the Manager field and Employee field are selected for Assigned To field.
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.
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.  
ToUserList (User u ..) UserList Concatenates the contents of one or more user type fields into a user list field type. 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. Note: This field is of type List-User and therefore exercises the limit of 10 entries. If the resulting value of this field in a record exceeds the maximum entries allowed the resulting value will be set to blank. ToUserList([Sales Manager], [Business Manager]) takes the values in the Sales Manager field and Business Manager field and returns the combined value into another field.
ToUserList (UserList ul ..) UserList Concatenates contents of 1 or more list-user field types into the returning field. 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. Note: This field is of type List-User and therefore exercises the limit of 10 entries. If the resulting value of this field in a record exceeds the maximum entries allowed the resulting value will be set to blank. ToUserList([Sales Managers], [Business Managers]) takes the values in the Sales Manager field and Business Manager field and returns the combined value into another field.
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/"
User () User Returns the user currently accessing the database. With this function you can create a view that selects only the records modified by the user who is currently viewing the database.
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.
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.
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.
UserRoles ("ID/Role/Empty") Text Returns information about the current user’s role. Use in a Formula-Multi-select text field. UserRoles("ID") returns the role ID. UserRoles("Name”) returns the role name. UserRoles(""), or empty, returns the role ID and name in the format ID/name. 

Usage examples, based on the user role, include showing or hiding form elements, validating data, sending a webhook or email notification, or dynamic instructional text.


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.
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". 
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.

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
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
This report will be listed only for you, in the group Mine.
Only you can see the report in the panel. You can't ever list it for other users. You can still let others open it by sending them links.
Please wait while your new report is saved...
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