Quickbase

My Apps

New apps will be added to your account close

Create your own free Quickbase app

Quickbase Exchange has hundreds of free apps for any business process.
It's simple to get started and you don't need to be technical to do it.

Project Management
Customer Support
Sales & CRM
Marketing

Team Management
Human Resources
Information Technology
Industry-specific solutions

Find an app in Quickbase Exchange

We need to check with your admin first...

We know you're eager to create your first app-but your account settings don't let you create apps yet. We've asked your account admin to allow it, and you'll get an email from us when you can.

Prefer a more hands-on solution? Can't wait? Try a 30-day free trial, and get started creating apps immediately.

Build a new app from scratch Import a spreadsheet to create a new app

Start a trial

Quickbase is a web-site that lets you select, customize, and share online workgroup applications. The application you are using right now is powered by Quickbase.

Chances are that your organization has purchased the Quickbase service, in which case you might be able to build and deploy your own web application for little or no additional cost.

You have permission to create your own web applications.

To find out more about Quickbase, visit our web site.

Terms of Service

QuickBase Support Center

Manager: Ritchie Almonte

Company:

For which table?

Formula Functions Reference Sample Formulas Images & Attachments

Home

Filters

Category

Special
Type Conversion

Result Type

Boolean
Multi-select Text
Text
User
text

Some field contains 'user AND ...

Category	Function Name	Arguments	Result Type	Explanation	Examples	Display Reference	More Examples

Special	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.	Display Reference	More examples
Type Conversion	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.	Display Reference	More examples
Special	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.	Display Reference	More examples
Special	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.	Display Reference	More examples
Special	UserRoles	("ID/Name/Empty")	Multi-select 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.	Display Reference	More examples
Special	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.	Display Reference	More examples

Is there an easy way to create a calendar or timeline from a table report?

Yes. If the application administrator has specified default calendar and timeline settings for an application, you can easily create a calendar or timeline from a table report just by clicking a link. Quickbase uses the default settings as a basis for creating the calendar or timeline.

To create a calendar or timeline from a table report:

Display a table report.
In the menu at the top of the report, click Other, and then click Report Table as a Calendar or Report Table as a Timeline.
Save the calendar or timeline by clicking Save this report.

Note: If calendar or timeline defaults have not been set, then Report as Calendar and Report as Timeline won't appear as options. Read how to set defaults for calendars and for timelines.

Client Performance Report

Network latency: ()

The time taken for page load once the page is received from the server:()

The total process of navigation and page load: ()

From inline js at page top..
        .. to the time until docready:( s)
        .. to the time until window load begins: ( s)
        .. to the time until window load ends: ( s)

When you bring additional fields into a conversion, Quickbase 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, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Field label
Column heading override
Justification
What does auto mean?

Quickbase will send a report of the events currently displayed on your calendar.
Email addresses



		Don't show me this message again