An Introduction to Tables
In Gridfox, Tables are used to define the data that you would like to store in your Projects. For example,
- In a CRM Project, you may have a Table for Companies and another for Opportunities
- In a Marketing Campaign Planner Project, you may have a Table for Campaigns and another for Activities
- In a Project Tracker Project, you may have a Table for Projects and another for Tasks
Fields are then added to Tables to describe what you would like to store about Records in the Table. For example,
- On a Tasks Table, you may have Fields for Task Description, Task Owner and Due Date
- On an Events Table, you may have Fields for Start Date, End Date and Event Name
- On a Customers Table, you may have Fields for Customer Name, Sector and Number of Employees
You can think of Tables like worksheets on a spreadsheet, where Fields are the columns in the spreadsheet worksheet.
Your Tables can then be linked together to allow your Users to create relationships between different Records.
Setting Up Tables
To set up Tables for your Project you will need to: