About Tables
Tables are the building blocks of every DataPage. They define the structure in which your data is stored. Consider them as a set of data arranged in rows and columns. Columns are fields and rows are records. When a table is first created, it only has fields. Records are added later, perhaps ...
- Creating a Table
By creating a table, you design a place-holder for your data through defining fields and their data types. Select New Table from the Files menu or, while in the Tables view , click on the toolbar. Enter your table name when prompted and click OK. The Table Design window appears. For each ...
- Data Types
Data types indicate and enforce the type of data that can be stored in a field in a table. The following data types are supported in Caspio Bridge: AutoNumber AutoNumber is a numeric field that is maintained automatically by Caspio Bridge. AutoNumbers start with 1 and increment b ...
- Importing Data
Caspio Bridge lets you import data to your account in a number of formats: Microsoft Access database Microsoft Excel workbook CSV (Comma Separated Values) Text: Tab Delimited Text: Fixed Width Caspio Bridge XML Custom XML Compress large files in ZIP format for faster upload. To impor ...
- Exporting Data
Caspio Bridge data can be exported to your local computer at any time. The following data formats are supported: Microsoft Access database Microsoft Excel workbook Caspio Bridge XML CSV (Comma Separated Values text file) All exported files are compressed in ZIP format for faster download. To ...
- Managing Data
Caspio Bridge makes it easy to see and edit data through DataPages. However, the data in smaller tables can also be directly modified in Caspio Bridge through the Datasheet window. The Datasheet window presents the data of tables or views in a spreadsheet-like window. Each row represents one ...
- Modifying Tables
The structure of an existing table may be modified at any time. Caspio Bridge prevents certain modifications that would result in data loss. Caspio Bridge tables are the foundation of most other objects such as Views and DataPages. Modifying a table can make its dependent objects unus ...
- Table Security
Table Security matters when multiple administrative users have access to your account and is not related to Web User Authentication. If only one user has access to your account, or if your account provides for only one seat, this option does not apply. Caspio Bridge allows for fine-grained con ...
