How do I Create a New Table?
A table consists of data arranged into rows and columns. Each row is called a ‘record’ and each column is called a ‘field’. When a user completes a Web Form they are entering data into each field and creating a new record. Tables are the backbone of your Caspio Apps. They hold all of your data and are usually the starting point of your DataPage design.
Steps to create a new table:
1. In the Explorer window, click on Tables
After logging on to Caspio Bridge look at the Explorer window in the center of the screen. On the left hand side you will see a dark grey panel labeled ‘Objects’. Click on the Tables button. This will take you to the Tables view. From this location you can create and edit your tables as well as view and edit your raw data.
2. Press the New Table button
The tool bar across the top of the Tables section gives you quick access to the main tasks associated with tables. For now, press the New Table button to create a new table. This will open a window asking you to name your new table. Your table name must not contain spaces or special characters. You can, however, use underscores.
3. Name your fields and choose their data types
After you name your new table you will begin creating in the Design view. Your first step will be to create the fields that will be included in each record. Name each field (e.g. First_Name, Last_Name, State, etc.) and select the field's data type. The table design wizard also allows you to enter a default label to be used in future DataPages.
4. Save your table design and close the design window
After naming and formatting your fields you can save and close the table design view. You can change a table's design later by clicking on the Design button. Now that your table fields have been formatted, you can open the table by clicking the Open button to view and edit your data.
Toolbar – Quick Reference:
|Press the New Table button to create a new, empty table.|
|Press the Design button to edit a table’s fields.|
|Press the Open Table button to view and edit the data stored in a table.|
|Press the Delete Table button to delete an entire table.|