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

Filters

Filters
 
Field Name
fid
Related dbid - Table Name
Type
Description
Keyfield
IsRecordID
Required
Autofilled
Unique
Formula
Choices
Maxlength
Width
Numlines
Fieldhelp
Defaultvalue
Currencysymbol
Currencyformat
Decimalplaces
Bold
Appearsbydefault
Nowrap
Snapshot
Snapfid
Cover Text
See
Revision
History
Keep all revisions
Reference
Lookup
Related Table Name
Related Table dbid
Reference
or Lookup
field
Related Lookupfield fid
IsDblink
Dblink Target dbid
Dblink
Target
fid
Dblink
Source
fid
KeyImage
ReqImage
Status
Field's Related
Lookup Field
Lookup Source - Field Name
Field's Related
Snapshot Field
Snapshot Source - Field Name
Related
Table -
Seq #
Related
Version
Logs
Prevfieldprop
Reportfields
Related dbid
Field Usage Page URL
Field Properties Page URL
Number of
Revisions
User Choices
Default User
Display User As
Shared
Multiple
Choice
Shared MultiChoice dbid
Shared
MultiChoice
fid
Lookup Source - Field Name(Cross App)
Shared MultiChoice Table Name
Shared MultiChoice Field Name
Reference Source - Field Name(Cross App)
Field's Related
Reference
Field
QuickBase Tool
Searchable
Relationships
# of Relationships
the field
is part of
# of Reports
the field
part of
Foreign
key
Number format
Abbreviate
 
% Complete 83 Tasks percent         Yes         10           0   Yes Yes         No                                   3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                           Yes Relationships 0 10   3  
Actual Cost 67 Projects currency                   10       $ Between sign and number 2     Yes         No                                   2 7 Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                             Relationships 0 2   3  
Actual Finish Date 84 Tasks date         Yes                         Yes Yes         No                                   3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                           Yes Relationships 0 3      
Actual Hours 70 Projects float                   10                           No                                   2 7 Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                             Relationships 0 1   3  
Add Document 64 Projects url             URLRoot() & "db/" & [_DBID_DOCUMENT_LIBRARY] & "?a=API_GenAddRecordForm&_fid_37=" & URLEncode ([Project ID])& "&z=" & Rurl()                                 No                                   2   Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                             Relationships 0 0      
Add Issue 32 Projects url             URLRoot() & "db/" & [_dbid_critical_issues] & "?act=API_GenAddRecordForm&_fid_12=" & [Project ID] & "&z=" & Rurl()                                 No                                   2   Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                           Yes Relationships 0 0      
Add Similar Project 47 Projects url             "javascript:void(window.open('" &
URLRoot() & "tools/copyParentChildren.html?a=dbpage&dbid=" & Dbid() &
"&namefid=16&pagename=copyParentChildren.html&rid=" &
[Project ID] &
"','copyRecursive','top=240,left=320,width=400,height=150,location=no,menubar=no,toolbar=no'))"
                    Yes           No                                   2   Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                             Relationships 0 3      
Add Task 34 Projects url             URLRoot() & "db/" & [_DBID_TASKS] & "?act=API_GenAddRecordForm&_fid_48=" & [Project ID] &  "&z=" & Rurl()                                 No                                   2   Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                           Yes Relationships 0 0      
Address 21 Contacts text         Yes       0   1             Yes           No                                   1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties                           Yes Relationships 0 0      
Assigned To 67 Tasks userid         Yes                         Yes Yes         No Yes   Resources bf4sfyesz Yes                         3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties       fullnamelf               113   Yes Relationships 1 15      
Assigned To 36 Issues userid         Yes                         Yes Yes         No Yes   Resources bf4sfyesz Yes                         4 7 Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties       fullnamelf               113   Yes Relationships 1 10      
Attachment 9 Document Library file                                   Yes         Yes No                                   5 7 Logs Prevfieldprop Reportfields bf4sfyesy Usage Properties 3                         Yes Relationships 0 7      
Author 29 Document Library userid         Yes                         Yes Yes         No Yes   Resources bf4sfyesz Yes                         5 7 Logs Prevfieldprop Reportfields bf4sfyesy Usage Properties       fullnamelf               113   Yes Relationships 1 7      
Business email 54 Resources text         Yes       0   1                         No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                           Yes Relationships 0 0      
Business fax 25 Resources phone         Yes       0   1             Yes Yes         No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                           Yes Relationships 0 4      
Business Phone 9 Resources phone         Yes       0   1             Yes Yes         No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                           Yes Relationships 0 4      
Calculated Finish Date 10 Tasks date             WeekdayAdd([Start], [Duration])                     Yes Yes         No                                   3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                           Yes Relationships 0 10      
City 22 Contacts text         Yes       0   1             Yes           No                                   1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties                           Yes Relationships 0 0      
Client Name 7 Contacts text         Yes     ABC Company
Acme Technology
Aircrafts Inc
Healthy Care
Sample Co
Large Bank and Trust
0 40 1             Yes           No                                   1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties                           Yes Relationships 0 0      
Company 61 Projects text                 0   0             Yes           No   Yes Contacts bf4sfyesj Yes 7               2 Client Name     2   Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                           Yes Relationships 0 5      
Company 41 Issues text                 0   0                         No   Yes Projects bf4sfyesu Yes 61               24 Company     4   Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                           Yes Relationships 0 1      
Company 39 Document Library text                 0   0             Yes           No   Yes Projects bf4sfyesu Yes 61               24 Company     5   Logs Prevfieldprop Reportfields bf4sfyesy Usage Properties                           Yes Relationships 0 4      
Company 24 Resources text         Yes       0   1             Yes           No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                           Yes Relationships 0 4      
Contact Name 62 Projects text                 0   0                         No   Yes Contacts bf4sfyesj Yes 6               1 Name     2   Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                           Yes Relationships 0 0      
Country 20 Contacts text                 0   1             Yes           No   Yes DEMO:  Common Lookup Values : Countries bf47vxank : bf47vxapp Yes 6               0       1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties               Country           Yes Relationships 0 0      
Customer Contact 60 Projects float         Yes         10   Use this field to identify the key customer contact associated with this project.       0     Yes         No Yes   Contacts bf4sfyesj Yes                         2 7 Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                       20   Yes Relationships 1 0   0  
Customer: Project 21 Time Cards text                 0   1             Yes           No   Yes Projects bf4sfyesu Yes 36                       7 7 Logs Prevfieldprop Reportfields bf4sfyete Usage Properties                           Yes Relationships 0 0      
Date Created 1 Contacts timestamp                                     Yes         No                                   1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties                             Relationships 0 0      
Date Created 1 Projects timestamp                                               No                                   2 7 Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                             Relationships 0 0      
Date Created 1 Tasks timestamp                                               No                                   3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                             Relationships 0 0      
Date Created 1 Issues timestamp                                               No                                   4 7 Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                             Relationships 0 0      
Date Created 1 Document Library timestamp                                               No                                   5 7 Logs Prevfieldprop Reportfields bf4sfyesy Usage Properties                             Relationships 0 0      
Date Created 1 Resources timestamp                                               No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                             Relationships 0 0      
Date Created 1 Time Cards timestamp                                     Yes         No                                   7 7 Logs Prevfieldprop Reportfields bf4sfyete Usage Properties                             Relationships 0 0      
Date Identified 16 Issues date         Yes                                     No                                   4 7 Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                           Yes Relationships 0 4      
Date Modified 2 Contacts timestamp                                     Yes         No                                   1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties                             Relationships 0 1      
Date Modified 2 Projects timestamp                                               No                                   2 7 Logs Prevfieldprop Reportfields bf4sfyesu Usage Properties                             Relationships 0 1      
Date Modified 2 Tasks timestamp                                               No                                   3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                             Relationships 0 1      
Date Modified 2 Issues timestamp                                               No                                   4 7 Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                             Relationships 0 2      
Date Modified 2 Document Library timestamp                                   Yes           No                                   5 7 Logs Prevfieldprop Reportfields bf4sfyesy Usage Properties                             Relationships 0 3      
Date Modified 2 Resources timestamp                                               No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                             Relationships 0 1      
Date Modified 2 Time Cards timestamp                                     Yes         No                                   7 7 Logs Prevfieldprop Reportfields bf4sfyete Usage Properties                             Relationships 0 1      
Date Resolved 32 Issues date         Yes                         Yes           No                                   4 7 Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                           Yes Relationships 0 4      
Days Overdue 33 Tasks duration             If([Status] = "Completed" or [Status] = "Cancelled", null, ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date]))                     Yes           No                                   3   Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                           Yes Relationships 0 9      
Days Overdue 26 Issues duration             If([Status] = "Closed", null, ToDays(Today() - [Due Date]) <= 0, null, Today() - [Due Date])                                 No                                   4   Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                           Yes Relationships 0 2      
Department 9 Contacts text         Yes       0   1             Yes           No                                   1 7 Logs Prevfieldprop Reportfields bf4sfyesj Usage Properties                           Yes Relationships 0 0      
Department 21 Resources text         Yes     Management
Marketing
Consulting
Design
Engineering
QA
Sales
Operations
0 40 1             Yes           No                                   6 7 Logs Prevfieldprop Reportfields bf4sfyesz Usage Properties                           Yes Relationships 0 5      
Description 7 Tasks text         Yes       0 40 6 Enter a detailed definition of the task.                       No                                   3 7 Logs Prevfieldprop Reportfields bf4sfyesv Usage Properties                           Yes Relationships 0 2      
Description 8 Issues text         Yes       0 40 6 Enter a detailed definition of the issue.           Yes           No                                   4 7 Logs Prevfieldprop Reportfields bf4sfyesw Usage Properties                           Yes Relationships 0 8      
Description 7 Document Library text         Yes       0   6                         No                                   5 7 Logs Prevfieldprop Reportfields bf4sfyesy Usage Properties                           Yes Relationships 0 0      
Result Pages:  1  2  3  4    
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 in the panel group , for . This report will be in the panel, but hidden, for now. This report will be listed only for you, in the group Mine. Show options
Everybody can see the report in the panel.
Users who have my role will see the report in the panel.
Users who have any of these roles will see the report in the panel.
 Client
 Administrator
 Client-Reports Only
 Client Admin
 Demo
The report doesn't appear in the panel until you say otherwise. To see the report, create a bookmark in your browser.

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.
Group for this report: Personal reports always appear in 'Mine'
Please wait while your new report is saved...
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:

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

Read more about converting a column into a table.

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