Embedded Files
Data Lists are Key to Data Management
The familiar Rows and Columns that we see in every spreadsheet are fundamental to the design of a Database. In fact the IntelliOffice Database is made up of over 100 different "spreadsheets" that are all related in a structured way.
A very common List (or Table) is the Space List which pulls together the Buildings, Floors and Spaces along with area information from the CAD drawings and staff lists from the Human Resources system.
Advanced Smart List
The Building List is a good example of an Advanced Smart List, you can still click on a "Row" to view and edit the details in a Form but you can see a variety of KPIs and gauges that quickly show the current status of the Building.
Clicking on a Building will reveal the Floor Smart List.
Floor Smart List
A great deal of valuable information about a building is visible on on this Smart List. Reports and PDF Buttons, plus many Floor Plan options are now all in one place.
Click Here to learn more about working with Drawings
Space List View
The Space List View has many built in functions that help manage the records, you can Search, Export, Filter and Sort plus run Restrictions to view the Over and Under Utilization of work spaces plus Occupied and Unoccupied rooms.
The Columns represent the Fields that are seen in Forms as well as additional calculated data and information that is created by the system. This is one way to explore the Database Table Structure and see which Fields are available to an organization.
Some Tables may have hundreds of Fields and thousands of Records. There are many Functions built into the system that assist you with the management of data.
Space List Menu Controls
Space List Menu Controls
- Edit Multiple - Select Records to Bulk Edit
- Refresh List - Request Database to rerun the List for latest content
- Search Box - X to Clear Box, Magnifying Glass to execute Search
- Export - Send Data to Excel Spreadsheet
- View All Linked Spaces
- View All UnLinked Spaces
- View All Spaces
- Show Occupiable Space
- Show Occupiable and Unoccupiable Space
- Show All Occupancy Statuses
- Area of each Space - Sort Ascending or Descending
Report abuse