Skip to main content

Reports: QBL v0.4

This article contains information about a QBL object. QBL objects are the supported Quickbase schema elements you see textually represented in the YAML file generated by Quickbase when you export a solution. Each object has associated properties. 

The following table lists information about the properties of this object. 

In this article

Calendar report

Property Name Required Default Allowed Values
ColorCoding False   See nested properties
    ColorBy False    
    ColorFormula False    
Filters False   See nested properties
    Criteria False Default Any string
    DynamicFields False Default One of: Default, None
Array of items of type: Reference to Field, ReportFormula
    AllowQuickSearch False False true or false
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false
CalendarEvents False   See nested properties
    StartDate False    
    EndDate False    
    DisplayFields False    
    AllowRecordCreationFromCalendar False    
    DisplayCalendarEventsAs False    
    MaxEventsPerDay False    
    FirstDayOfTheWeek False    
    InitialMonthToDisplay False CurrentMonth One of: CurrentMonth, NextMonth, PreviousMonth, SpecificMonth
        SpecificMonthToDisplay False   See nested properties
            Month False January One of: January, February, March, April, May, June, July, August, September, October, November, December
            Year False   Any integer

Default timeline report

Property Name Required Default Allowed Values
SortAndGroup False Default Array of items of type:
One of: Default, ManualOrder
SortGroupsByStartField False    
Timeline False    
Columns False Default Array of items of type: Reference to Field, ReportFormula
One of: Default

Formula checkbox report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula date report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula date time report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula duration report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Formula email address report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula list users report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula multi-select text report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula numeric report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Formula numeric currency report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Formula numeric percent report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Formula numeric rating report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Formula phone number report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula rich text report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula text report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula time of day report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula URL report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Formula user report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Grid edit report

Property Name Required Default Allowed Values
Sort False Default Array of items of type:
One of: Default, ManualOrder
AllowEditingRecords False True true or false
AllowViewingRecords False True true or false
HideTotals False False true or false
Columns False Default Array of items of type:
Reference to Field, ReportFormula
One of: Default
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false
Filters False   See nested properties
    Criteria False Default Any string

Kanban report

Property Name Required Default Allowed Values
Sort False Default Array of items of type:
One of: Default, ManualOrder
ColorCoding False   See nested properties
ColorBy False    
ColorFormula False    
Filters False   See nested properties
Criteria False Default Any string
DynamicFields False Default One of: Default, None
Array of items of type:
Reference to Field, ReportFormula
AllowQuickSearch False False true or false
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false
CardGroups False   See nested properties
GroupBy True   Reference to QB::Field::TextMultipleChoice, QB::Field::User, QB::Field::AddressCountry, or QB::Field::AddressState
Values False All One of: All
Array of items of type:
Any string
DisplayFields False Default One of: Default
Array of items of type:
Reference to Field, ReportFormula

Map report

Property Name Required Default Allowed Values
ColorCoding False   See nested properties
ColorBy False    
ColorFormula False    
Sort False Default Array of items of type:
One of: Default, ManualOrder
Columns False Default Array of items of type:
Reference to Field, ReportFormula
One of: Default
Filters False   See nested properties
Criteria False Default Any string
DynamicFields False Default One of: Default, None
Array of items of type:
Reference to Field, ReportFormula
AllowQuickSearch False False true or false
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false
AddressField False Default One of: Default
Reference to QB::Field::Address
MapType False Road One of: Road, Satellite, Hybrid, Terrain
Icons False NoIcons One of: NoIcons
Any string

Summary column report

Property Name Required Default Allowed Values
Source True   One of: CountOfRecords
Reference to Field, ReportFormula, or SummaryFormula
SummarizeBy False None One of: CountOfRecords, Total, Average, Minimum, Maximum, StdDeviation, DistinctCount, None
DisplayAs False NormalValue One of: NormalValue, PercentOfColumnTotal, PercentOfCrosstabTotal, RunningTotalForColumn, RunningTotalForCrosstab

Summary report

Property Name Required Default Allowed Values
HideTotals False False true or false
DrilldownReport False Default One of: Default, None
Reference to Report or Chart
Filters False   See nested properties
    Criteria False Default Any string
    AllowQuickSearch False False true or false
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false
GroupingAndCrosstabs False   See nested properties
    Rows False   Array of items of type
    Crosstabs False None One of: None
        Source False    
        GroupBy False    
Sort False Default Array of items of type:
One of: Default

Summary formula checkbox report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula date report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula date time report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula duration report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Summary formula email address report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula list users report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula multi-select text report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula numeric report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Summary formula numeric currency report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Summary formula numeric percent report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Summary formula numeric rating report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string
DecimalPlaces False 0 Any integer

Summary formula phone number report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula rich text report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula text report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula time of day report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula URL report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary formula user report

Property Name Required Default Allowed Values
Label False "" Any string
Formula False "" Any string

Summary variable report

Property Name Required Default Allowed Values
Source True  

One of: CountOfRecords

Reference to Field or ReportFormula
SummarizeBy False None

One of: CountOfRecords, Total, Average, Minimum, Maximum, StdDeviation, DistinctCount, None

Table report

Property Name Required Default Allowed Values
SortAndGroup False Default Array of items of type:
One of: Default, ManualOrder
ColumnsUI False Default Array of items of type:
One of: Default
ColorCoding False   See nested properties
    ColorBy False    
    ColorFormula False    
    Appearance False    
AllowEditingRecords False True true or false
AllowViewingRecords False True true or false
HideTotals False False true or false
Columns False Default Array of items of type:
Reference to Field, ReportFormula
One of: Default
Filters False   See nested properties
    Criteria False Default Any string
    DynamicFields False Default One of: Default, None
Array of items of type:
Reference to Field, ReportFormula
    AllowQuickSearch False False true or false
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false
DisplayOnlyNewOrChangedRecords False False true or false
ShowSummaryTable False    
HideMainTable False    

Timeline report

Property Name Required Default Allowed Values
SortAndGroup False Default Array of items of type:
One of: Default, ManualOrder
SortGroupsByStartField False    
Filters False   See nested properties
    Criteria False Default Any string
    DynamicFields False Default One of: Default, None
Array of items of type:
Reference to Field, ReportFormula
    AllowQuickSearch False False true or false
ColorCoding False   See nested properties
    ColorBy False    
    ColorFormula False    
    Appearance False    
ColumnsUI False Default Array of items of type:
One of: Default
Columns False Default Array of items of type:
Reference to Field, ReportFormula
One of: Default
Timeline False    
RolePermissions False    
Name True   Any string
Description False "" Any string
ShowDescription False False true or false

Report group

Property Name Required Default Allowed Values
Name True   Any string
Reports True   Array of items of type:
Reference to QB::Report, QB::Chart

Related articles

Top