Project Portal™
Project Tables Module
The Project Tables Module is a robust application that allows administrative users the ability to define and populate on-line database tables. The module was created for presenting data that does not necessarily fit well into the Environmental Database Module. Tables Administrative Users are able to very specifically define which tables they want to create and also to insert columns of their specification (i.e., text, numeric, yes/no, date, memo) into those tables. Tables can then be used to communicate data to other users in the Project Portal system.
The tables provide "live editing" in that the data in them are editable right on the web precluding the need to download a file, make edits to it, then save and re-upload again. For database tables that store large amounts of data, table Administrative Users are able to create and save queries called "Views" which users can use to immediately call up data that they commonly need to view. Views also allow a Project Tables Administrative User to establish relationships between the tables. This becomes useful when two or more tables contain different but related data. Users can click on the record on one table to view related records in another table.
Although Project Tables may be created and used for any type of data, Project Tables have commonly been used in the system by users to manage and communicate invoices, waste tracking data and allocations.
