We are updating our
Terms of Service .
See our
blog post highlighting the changes.
By continuing to use the Quickbase Service, the new Terms of Service will become effective on the renewal date for each account that you manage.
If you do not accept the changes, please notify us thirty days in advance of your renewal date.
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
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.
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
Basics
Report & Charts panel
Each table has a panel listing its reports and charts, organized in groups.
You and others can see the report in the panel.
Summarize Data
Summarize
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Result
Inspection Result Audit Field
Inspector Email
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Edit Legacy Inspection
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Result (Checklist) (OLD)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-View Legacy Inspection
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zView Level II Inspection
zWaiting to be reinspected
# of Inspections
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Select a field...
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Result
Inspection Result Audit Field
Inspector Email
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Edit Legacy Inspection
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Result (Checklist) (OLD)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-View Legacy Inspection
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zView Level II Inspection
zWaiting to be reinspected
# of Inspections
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Summarize By:
Totals
Averages
Maximums
Minimums
Std. Deviation
Distinct Count
Display As:
Normal Value
Percent of column total
Percent of crosstab total
Running total down column
Running total across crosstab
Hide totals
Hide totals row
Grouping and crosstabs
Rows
Group by
3rd Party Attachment
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Conditional Acceptance Notes
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Notes
Inspection Result
Inspection Result Audit Field
Inspector Email
Inspector Recommended Corrections
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Repair Tech Notes
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
z3rd Party Inspection Notes (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Conditional Acceptance Notes (FOR REFERENCE ONLY)
zL2-Corrections Made
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Notes (FOR REFERENCE ONLY)
zL2-Inspection Result (Checklist) (OLD)
zL2-Inspector recommended corrections (FOR REFERENCE ONLY)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zWaiting to be reinspected
Combine
then by
3rd Party Attachment
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Conditional Acceptance Notes
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Notes
Inspection Result
Inspection Result Audit Field
Inspector Email
Inspector Recommended Corrections
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Repair Tech Notes
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
z3rd Party Inspection Notes (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Conditional Acceptance Notes (FOR REFERENCE ONLY)
zL2-Corrections Made
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Notes (FOR REFERENCE ONLY)
zL2-Inspection Result (Checklist) (OLD)
zL2-Inspector recommended corrections (FOR REFERENCE ONLY)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zWaiting to be reinspected
Combine
then by
3rd Party Attachment
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Conditional Acceptance Notes
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Notes
Inspection Result
Inspection Result Audit Field
Inspector Email
Inspector Recommended Corrections
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Repair Tech Notes
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
z3rd Party Inspection Notes (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Conditional Acceptance Notes (FOR REFERENCE ONLY)
zL2-Corrections Made
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Notes (FOR REFERENCE ONLY)
zL2-Inspection Result (Checklist) (OLD)
zL2-Inspector recommended corrections (FOR REFERENCE ONLY)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zWaiting to be reinspected
Combine
then by
3rd Party Attachment
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Conditional Acceptance Notes
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Notes
Inspection Result
Inspection Result Audit Field
Inspector Email
Inspector Recommended Corrections
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Repair Tech Notes
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
z3rd Party Inspection Notes (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Conditional Acceptance Notes (FOR REFERENCE ONLY)
zL2-Corrections Made
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Notes (FOR REFERENCE ONLY)
zL2-Inspection Result (Checklist) (OLD)
zL2-Inspector recommended corrections (FOR REFERENCE ONLY)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zWaiting to be reinspected
Combine
then by
3rd Party Attachment
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Conditional Acceptance Notes
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Notes
Inspection Result
Inspection Result Audit Field
Inspector Email
Inspector Recommended Corrections
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Repair Tech Notes
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
z3rd Party Inspection Notes (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Conditional Acceptance Notes (FOR REFERENCE ONLY)
zL2-Corrections Made
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Notes (FOR REFERENCE ONLY)
zL2-Inspection Result (Checklist) (OLD)
zL2-Inspector recommended corrections (FOR REFERENCE ONLY)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zWaiting to be reinspected
Combine
then by
3rd Party Attachment
3rd Party Inspected By
3rd Party Inspection?
Barcode
Building
Class 2 Listed
Class 2, ITE. SELV Power Supply
Conditional Acceptance Expiration Date
Conditional Acceptance has Expired
Conditional Acceptance Notes
Date Created
Date Modified
Division
Equipment Name
Equipment Status
Fail Value in this Inspection? (UNDER DEVELOPMENT)
failed_due_to_deterioration
IC_High_i_1
IC_Low_i
IC_Low_ii
IC_Low_iii
IC_Low_iv
IC_Low_v
IC_Low_vi
IC_Low_vii
IC_Med_i
IC_Med_ii
IC_Med_iii
Initial Inspection by
Inspection Completed Date
Inspection Date Formula (Completed Date or Date Created)
Inspection Level (Lookup from Equipment)
Inspection Notes
Inspection Result
Inspection Result Audit Field
Inspector Email
Inspector Recommended Corrections
Key Barcode
L2-IC_High_ET_1
L2-IC_High_ET_2
L2-IC_High_ET_3
L2-IC_High_ET_4
L2-IC_High_ET_5
L2-IC_High_ET_6
L2-IC_High_ET_7
L2-IC_High_i_1
L2-IC_High_i_2
L2-IC_High_i_3
L2-IC_High_i_4
L2-IC_High_ii_1
L2-IC_High_ii_2
L2-IC_High_ii_3
L2-IC_High_ii_4
L2-IC_High_ii_5
L2-IC_High_ii_6
L2-IC_High_ii_7
L2-IC_High_iii_1
L2-IC_High_iv_1
L2-IC_High_ix_1
L2-IC_High_ix_2
L2-IC_High_ix_3
L2-IC_High_ix_4
L2-IC_High_ix_5
L2-IC_High_ix_6
L2-IC_High_ix_7
L2-IC_High_ix_8
L2-IC_High_v_1
L2-IC_High_vi_1
L2-IC_High_vi_2
L2-IC_High_vi_3
L2-IC_High_vi_4
L2-IC_High_vi_5
L2-IC_High_vii_1
L2-IC_High_vii_2
L2-IC_High_vii_3
L2-IC_High_vii_4
L2-IC_High_vii_5
L2-IC_High_vii_6
L2-IC_High_vii_7
L2-IC_High_viii_1
L2-IC_High_viii_2
L2-IC_High_x_1
L2-IC_High_x_2
L2-IC_High_x_3
L2-IC_High_x_4
L2-IC_High_x_5
L2-IC_High_x_6
L2-IC_High_x_7
L2-IC_High_xi_1
L2-IC_High_xi_2
L2-IC_High_xi_3
L2-IC_High_xi_4
L2-IC_High_xii_1
L2-IC_Low_i
L2-IC_Low_ii
L2-IC_Low_iii
L2-IC_Low_iv
L2-IC_Low_v
L2-IC_Low_vi
L2-IC_Low_vii
L2-IC_Med_i
L2-IC_Med_ii
L2-IC_Med_iii
L2-NEC / 70E
L2-NFPA 79
L2-UL 508
L2-UL 508A
L2-UL 60950-1
L2-UL 61010-1
Last Modified By
Maximum Inspection Date
Re-inspected by
re-inspection date
Record ID#
Record Owner
Related Equipment Identification
Repair Status
Repair Status Audit Field
Repair Tech Notes
Resp. Person email
Responsible Person
Risk Group
Room Number
Send Notifications to Responsible Person?
xxConditional Acceptance Date Formula (120 days)
xxHas been Conditionally Accepted at Some Point?
xxHigh Risk Fail Value
xxLow Risk Fail
xxMedium Risk Fail Value
xxOhmar Sowle User for CA Exp Reminders
z3rd Party Date of Inspection (OLD)
z3rd Party Inspection Notes (OLD)
zConditional Acceptance Flag
zEquipment Identification - Risk_group pick
zEquipment passed after re-inspection
zFail Null
zFailed_flag
zInitial Inspection Completed
zInspection Level (Multi-Choice) (OLD)
zInspection Result (Checklist) (OLD)
zInspection Result (Lookup)
zL2-30 Day Conditional Expiration (FOR REFERENCE ONLY)
zL2-Class 2 Listed
zL2-Class 2, ITE. SELV Power Supply
zL2-conditional acceptance expiration date
zL2-Conditional Acceptance Flag
zL2-Conditional Acceptance Notes (FOR REFERENCE ONLY)
zL2-Corrections Made
zL2-Equipment passed after re-inspection
zL2-Fail Null
zL2-failed_due_to_deterioration
zL2-Failed_flag
zL2-Initial Inspection by
zL2-Initial Inspection Completed
zL2-Inspection Completed Date
zL2-Inspection Notes (FOR REFERENCE ONLY)
zL2-Inspection Result (Checklist) (OLD)
zL2-Inspector recommended corrections (FOR REFERENCE ONLY)
zL2-Legacy Inspection
zL2-Legacy re-inspect
zL2-Re-inspected by
zL2-re-inspection date
zL2-Reminder User
zL2-Repair Status
zL2-Repair Status Changed By
zL2-Repair Status Changed Date
zL2-uninspected flag
zL2-Waiting to be reinspected
zLegacy Inspection Sheet
zuninspected flag
zWaiting to be reinspected
Combine
Crosstabs
Don't group columns
Group columns
Columns
Sorting
Columns to display
Report formulas (None added)
Report formulas let you build data for just this report. Use them to generate your own text, numbers, dates and so on.
They can be used throughout this report.
Read about report formulas
Add a report formula
Summary formulas (None added)
A summary formula lets you add a column to this summary with numbers, such as averages, that would otherwise require a separate table to "roll up".
Step 1: Define summary variables
Summary formulas use variables you define here, not ordinary fields.
The variables are recognized only in these formulas.
Step 2: Write summary formulas
Use your variables as you would normally use fields. For example, an Income formula might be "[Revenue (tot)] - [Expense (tot)]".
Add a summary formula
Step 3: Next you can...
Go to Summarize to show your summary formulas in columns.
Go to Sorting to sort your rows by your formulas.
Options
Color-Coding
Use a field or formula to add colors to table report rows.
Use a field or formula to add colors to Kanban cards.
Use a field or formula to add colors to calendar events.
Use a field or formula to add colors to map pins. (Colors only apply to maps on dashboards.)
Use a field or formula to add colors to timeline rows.
Use a field or formula to add colors. Applies to table reports, Kanban reports, and calendars.
Drilldown Report
Pick a report
Defines what report will be shown when you click a group in the summary report
Default report
None (drilldown is disabled)
ABPDU_Level I ABPDU_Level II ADMIN - Duplicate Inspections ADMIN - Inspection Result Fields Clean-Up Bad records, need to clean up_Level II Clean Checklist_Level II Conditional Acceptance All_Level II Conditional Acceptance Expired Records_Level II Conditional Accepted Equipment by Building_Level II Conditional Accepted Equipment by date_Level II Conditional Accepted Equipment by Responsible Person_Level II Embedded for Equipment Identification Embedded for Equipment Identification - NEW Embedded list of Level I Inspections Embedded list of Level II Inspections Equipment passed after re-insprection_Level II Equipment waiting for Re-inspection_Level II Inspection Summary Inspectors 2016-Present Legacy Inspections_Level II Level I & Level II Report List All List All with Barcode List Changes Monthly YTD Inspections Table Summary-Level I Table Summary_Level II Third Party Inspections z recomended vs non z recommended zzInspection Result Breakdown_Level II
How can I match records using a boolean expression?
You can match records using any boolean expression using a Custom Formula Column.
This allows you, for example, to match records where one of several different fields matches a
certain value or to match records based on combining data from multiple fields.
To do this, first create a custom checkbox column by selecting Custom Options and then
selecting Define a custom formula column for this report . Choose Checkbox as the field type
and enter your desired boolean
formula.
The formula should return true for records you want to display.
Then in the Matching section of your report,
select <Custom Column> as the field, and choose Is yes as the matching criteria.
foo
We're glad you're interested in doing more with Quickbase!
Now we need to make you official before you share apps or manage your account.
Verifying your email lets you share Quickbase with others in your company.
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)
Show fields from
Show fields from
Show fields from a related table
Please wait while your new report is saved...
If you want to show multi-day events like tasks or projects, set a start and end date for the event. To do so:
Set the start. Click the Base the calendar on dropdown, and select the field that marks the start of an event.
Set the end. Click the End date dropdown, and tell Quickbase which date field marks the end of the event. You can
choose from Date, Date/Time, Formula - Date, or Formula - Work Date fields appearing in your app. If you choose a formula field for the end date, Quickbase will
calculate the end date based on the start date (from step 1) and a duration. Click here to edit the
formula of the field you've selected in the End date dropdown.
Read
more about creating a calendar.
Grid Edit Override
When a user clicks the Grid Edit link at the top of a report,
the columns displayed on the subsequent Grid Edit screen are determined by settings
on the table's Forms Usage page.
You may override the Form Usage settings for this report. To do so, click the Grid Edit Override dropdown and select
one of your custom forms. Then, when a user clicks Grid Edit within this report, Grid Edit shows the columns (fields) from that form, in the same order that they appear on the form.
If you want, you can even hide the Grid Edit link for this report. To do so, select disable from the override dropdown.
Typically you'll override grid edit settings by report when you have also decided to override the
edit/display form used for a report.
Learn more about
customizing grid edit
and
setting form preferences by report
.
Too Many Legend Values
The field foo selected for the foo legend contains too many distinct values foo .
Reduce the number of values to or less by using the Matching section to restrict the number of records.
Adding milestones to your timeline
The Milestone dropdown lists checkbox type fields.
If you want some records to appear as milestones on your timeline, you must:
Create a checkbox type field.
Select that checkbox field from the Milestone dropdown list here in the
Report Builder.
Turn on the checkbox within records that are milestones.
In your timeline report, the milestone marker
appears at the "ending date" of any event for which you've turned the
milestone checkbox on.
Read more about: Milestones
Creating a timeline
Turn on Sort groups by starting field to
reorder your top-level groupings and show them in chronological order. Within
each
group,
subgroups
will
also sort chronologically.
If you care most about WHEN things are happening and
like to tackle the earliest items first, this feature's for you. For example,
say you've created a timeline of tasks and grouped it by project. In that case, the project
headings appear in alphabetical order. But, if you select the Sort groups by starting field
checkbox, Quickbase reorders your timeline. The project containing the task with the earliest start date moves
to the top of the list. This chronological order creates a cascade effect.
"Order the cards manually" will be available for all Kanban reports in this table.
This may take a moment.
"Order the cards manually" is now available.
You can disable it using the table's Advanced Settings