Outsource Work Tracker - Create Report
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.
Calendar Events
Base the calendar on
Select a field...
Date Created
Date Modified
End Date
End Date2
End DateTime
Initial Date
Pre-Con Meeting Held
Project Work Schedule - Start Date
Self - Start Date
Start Date
Start DateTime
Station - Apparatus Notification Date
Station - CCD
Station - Date Created
Station - Date Modified
Station - Date Received
Station - Latest Schedule Cancellation
Station - Permit Expiration Date
Week Of
End date
Select a field...
Date Created
Date Modified
End Date
End Date2
End DateTime
Initial Date
Pre-Con Meeting Held
Project Work Schedule - Start Date
Self - Start Date
Start Date
Start DateTime
Station - Apparatus Notification Date
Station - CCD
Station - Date Created
Station - Date Modified
Station - Date Received
Station - Latest Schedule Cancellation
Station - Permit Expiration Date
Week Of
Each day displays
Select a field...
# of Timesheets
3rd Party Contact
3rd Party Vendor Scheduled
Additional Permit Needed
Address Number
Address Street
Assigned Safety Representative
Calendar Entry
Caltrans Calendar Info
Caltrans District
Caltrans Inspector Name
Caltrans Permit Number
Caltrans Required
Cancel Reason
Cancelled Schedule
CHP Required
Civil Assist
Civil Calendar Entry
Civil/Electric
Clearance Type
COI Submitted
Completion of Work Submitted
Crew - Approver
Crew - Assigned To
Crew - Department
Crew - Foreman
Crew - Foreman - Color Code
Crew - Foreman - Email
Crew - Foreman - Name
Crew - Foreman - Phone Number
Crew - General Foreman - Phone Number
Crew - General Foreman Name
Crew - Today Job Addresses
Crew List
Crew Name
Crew Size
Crew Type
CrewId
CrewResources
CWC Sent
Date Created
Date Modified
Display Address
End Date
End Date2
End DateTime
End Time
Energized
Equipment Needed
Fire Watch
Flagger Certs Submitted
FMP Completed
FMP Notes
GF Name
Grounding Details
Grounding Required
Grounding Verified
Hole Digging
Hole Digging Complete
Hole Digging Complete Notes
Hole Digging Notes
Initial Date
Initial Foreman
Initial RID
Initial Station
Job Station
Last Modified By
LCS Submitted
LCS Upload
Locations Completed
Multi Crew Calendar Entry
Multi Crew Calendar Entry 2
No Parks Notes
No Parks Required
Notes
Notification of Work
OAN
Open Points
Outlook Calendar Entry
Pole Size
Pre-Con Meeting Held
Program - CC
Program - Circuit Name
Project Work Schedule - Primary TD
Project Work Schedule - Start Date
QEW Contact
QEW Needed
Quick Notes
Record ID#
Record Owner
Redirect
Related Crew
Related employee
Related Program
Related Project Work Schedule
Related safety employee
Related Station
Request USA
Safety Representative Phone
Schedule Buffer
Schedule Notes
Scheduled GF
Scheduled Locations
Self
Self - Crew - Foreman - Name
Self - Related Station
Self - Start Date
Show Grounding History Only
Start Date
Start DateTime
Start Time
Station - Address
Station - Address: City
Station - Address: Postal Code
Station - Address: Street 1
Station - Address: Street 2
Station - Apparatus Notification Date
Station - CCD
Station - Circuit Name
Station - Cross Streets
Station - Date Created
Station - Date Modified
Station - Date Received
Station - District
Station - Google Maps Link
Station - GPS Location2
Station - Job Source
Station - Job Status
Station - Latest Schedule Cancellation
Station - Latitude
Station - Longitude
Station - OAN
Station - Permit City
Station - Permit Expiration Date
Station - Permit Link 1
Station - Permit Number
Station - Record ID#
Station - Record ID#2
Station - Record ID#3
Station - Region
Station - Related unit code1 - Description
Station - Related unit code10 - Description
Station - Related unit code11 - Description
Station - Related unit code12 - Description
Station - Related unit code2 - Description
Station - Related unit code3 - Description
Station - Related unit code4 - Description
Station - Related unit code5 - Description
Station - Related unit code6 - Description
Station - Related unit code7 - Description
Station - Related unit code8 - Description
Station - Related unit code9 - Description
Station - Reporting Flag
Station - Structure Number
Station - TC1
Station - TC10
Station - TC11
Station - TC12
Station - TC13
Station - TC14
Station - TC2
Station - TC3
Station - TC4
Station - TC5
Station - TC6
Station - TC7
Station - TC8
Station - TC9
Station - TD/SAP Number
Station - TD/Structure
Station - Timesheet District
Station - Work Type
Status
Tags
TC
TC # of Men
TC Equipment Rental Needed
TC Equipment Required
TC Notes
TCT Certs Submitted
Today's Crew Log
Total Hours
TR0429 Submitted
Tree Trim Notes
Tree Trim Required
Week Number
Week Of
Optional Field...
# of Timesheets
3rd Party Contact
3rd Party Vendor Scheduled
Additional Permit Needed
Address Number
Address Street
Assigned Safety Representative
Calendar Entry
Caltrans Calendar Info
Caltrans District
Caltrans Inspector Name
Caltrans Permit Number
Caltrans Required
Cancel Reason
Cancelled Schedule
CHP Required
Civil Assist
Civil Calendar Entry
Civil/Electric
Clearance Type
COI Submitted
Completion of Work Submitted
Crew - Approver
Crew - Assigned To
Crew - Department
Crew - Foreman
Crew - Foreman - Color Code
Crew - Foreman - Email
Crew - Foreman - Name
Crew - Foreman - Phone Number
Crew - General Foreman - Phone Number
Crew - General Foreman Name
Crew - Today Job Addresses
Crew List
Crew Name
Crew Size
Crew Type
CrewId
CrewResources
CWC Sent
Date Created
Date Modified
Display Address
End Date
End Date2
End DateTime
End Time
Energized
Equipment Needed
Fire Watch
Flagger Certs Submitted
FMP Completed
FMP Notes
GF Name
Grounding Details
Grounding Required
Grounding Verified
Hole Digging
Hole Digging Complete
Hole Digging Complete Notes
Hole Digging Notes
Initial Date
Initial Foreman
Initial RID
Initial Station
Job Station
Last Modified By
LCS Submitted
LCS Upload
Locations Completed
Multi Crew Calendar Entry
Multi Crew Calendar Entry 2
No Parks Notes
No Parks Required
Notes
Notification of Work
OAN
Open Points
Outlook Calendar Entry
Pole Size
Pre-Con Meeting Held
Program - CC
Program - Circuit Name
Project Work Schedule - Primary TD
Project Work Schedule - Start Date
QEW Contact
QEW Needed
Quick Notes
Record ID#
Record Owner
Redirect
Related Crew
Related employee
Related Program
Related Project Work Schedule
Related safety employee
Related Station
Request USA
Safety Representative Phone
Schedule Buffer
Schedule Notes
Scheduled GF
Scheduled Locations
Self
Self - Crew - Foreman - Name
Self - Related Station
Self - Start Date
Show Grounding History Only
Start Date
Start DateTime
Start Time
Station - Address
Station - Address: City
Station - Address: Postal Code
Station - Address: Street 1
Station - Address: Street 2
Station - Apparatus Notification Date
Station - CCD
Station - Circuit Name
Station - Cross Streets
Station - Date Created
Station - Date Modified
Station - Date Received
Station - District
Station - Google Maps Link
Station - GPS Location2
Station - Job Source
Station - Job Status
Station - Latest Schedule Cancellation
Station - Latitude
Station - Longitude
Station - OAN
Station - Permit City
Station - Permit Expiration Date
Station - Permit Link 1
Station - Permit Number
Station - Record ID#
Station - Record ID#2
Station - Record ID#3
Station - Region
Station - Related unit code1 - Description
Station - Related unit code10 - Description
Station - Related unit code11 - Description
Station - Related unit code12 - Description
Station - Related unit code2 - Description
Station - Related unit code3 - Description
Station - Related unit code4 - Description
Station - Related unit code5 - Description
Station - Related unit code6 - Description
Station - Related unit code7 - Description
Station - Related unit code8 - Description
Station - Related unit code9 - Description
Station - Reporting Flag
Station - Structure Number
Station - TC1
Station - TC10
Station - TC11
Station - TC12
Station - TC13
Station - TC14
Station - TC2
Station - TC3
Station - TC4
Station - TC5
Station - TC6
Station - TC7
Station - TC8
Station - TC9
Station - TD/SAP Number
Station - TD/Structure
Station - Timesheet District
Station - Work Type
Status
Tags
TC
TC # of Men
TC Equipment Rental Needed
TC Equipment Required
TC Notes
TCT Certs Submitted
Today's Crew Log
Total Hours
TR0429 Submitted
Tree Trim Notes
Tree Trim Required
Week Number
Week Of
Optional Field...
# of Timesheets
3rd Party Contact
3rd Party Vendor Scheduled
Additional Permit Needed
Address Number
Address Street
Assigned Safety Representative
Calendar Entry
Caltrans Calendar Info
Caltrans District
Caltrans Inspector Name
Caltrans Permit Number
Caltrans Required
Cancel Reason
Cancelled Schedule
CHP Required
Civil Assist
Civil Calendar Entry
Civil/Electric
Clearance Type
COI Submitted
Completion of Work Submitted
Crew - Approver
Crew - Assigned To
Crew - Department
Crew - Foreman
Crew - Foreman - Color Code
Crew - Foreman - Email
Crew - Foreman - Name
Crew - Foreman - Phone Number
Crew - General Foreman - Phone Number
Crew - General Foreman Name
Crew - Today Job Addresses
Crew List
Crew Name
Crew Size
Crew Type
CrewId
CrewResources
CWC Sent
Date Created
Date Modified
Display Address
End Date
End Date2
End DateTime
End Time
Energized
Equipment Needed
Fire Watch
Flagger Certs Submitted
FMP Completed
FMP Notes
GF Name
Grounding Details
Grounding Required
Grounding Verified
Hole Digging
Hole Digging Complete
Hole Digging Complete Notes
Hole Digging Notes
Initial Date
Initial Foreman
Initial RID
Initial Station
Job Station
Last Modified By
LCS Submitted
LCS Upload
Locations Completed
Multi Crew Calendar Entry
Multi Crew Calendar Entry 2
No Parks Notes
No Parks Required
Notes
Notification of Work
OAN
Open Points
Outlook Calendar Entry
Pole Size
Pre-Con Meeting Held
Program - CC
Program - Circuit Name
Project Work Schedule - Primary TD
Project Work Schedule - Start Date
QEW Contact
QEW Needed
Quick Notes
Record ID#
Record Owner
Redirect
Related Crew
Related employee
Related Program
Related Project Work Schedule
Related safety employee
Related Station
Request USA
Safety Representative Phone
Schedule Buffer
Schedule Notes
Scheduled GF
Scheduled Locations
Self
Self - Crew - Foreman - Name
Self - Related Station
Self - Start Date
Show Grounding History Only
Start Date
Start DateTime
Start Time
Station - Address
Station - Address: City
Station - Address: Postal Code
Station - Address: Street 1
Station - Address: Street 2
Station - Apparatus Notification Date
Station - CCD
Station - Circuit Name
Station - Cross Streets
Station - Date Created
Station - Date Modified
Station - Date Received
Station - District
Station - Google Maps Link
Station - GPS Location2
Station - Job Source
Station - Job Status
Station - Latest Schedule Cancellation
Station - Latitude
Station - Longitude
Station - OAN
Station - Permit City
Station - Permit Expiration Date
Station - Permit Link 1
Station - Permit Number
Station - Record ID#
Station - Record ID#2
Station - Record ID#3
Station - Region
Station - Related unit code1 - Description
Station - Related unit code10 - Description
Station - Related unit code11 - Description
Station - Related unit code12 - Description
Station - Related unit code2 - Description
Station - Related unit code3 - Description
Station - Related unit code4 - Description
Station - Related unit code5 - Description
Station - Related unit code6 - Description
Station - Related unit code7 - Description
Station - Related unit code8 - Description
Station - Related unit code9 - Description
Station - Reporting Flag
Station - Structure Number
Station - TC1
Station - TC10
Station - TC11
Station - TC12
Station - TC13
Station - TC14
Station - TC2
Station - TC3
Station - TC4
Station - TC5
Station - TC6
Station - TC7
Station - TC8
Station - TC9
Station - TD/SAP Number
Station - TD/Structure
Station - Timesheet District
Station - Work Type
Status
Tags
TC
TC # of Men
TC Equipment Rental Needed
TC Equipment Required
TC Notes
TCT Certs Submitted
Today's Crew Log
Total Hours
TR0429 Submitted
Tree Trim Notes
Tree Trim Required
Week Number
Week Of
New records
Allow new Schedule records to be created from each calendar day
Options
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
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.
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