The first step in creating a web application is to create its data tables. Tables hold your data. You can create tables in the Tables area of your App. Data can be submitted into these tables using web forms or imported from external files, such as Excel. Tables can also be exported in various file formats and saved onto your computer.
Views are created from one or more tables. You can use a view to filter the data of a table and/or include a subset of its base table. For example, if you have a table of all your global customers, you can create a view from that table to only display customers from a specific country. You can also create a view that consolidates data from multiple tables. For example, you can pull out customer records from one table and their orders from another table and show the data in a single view.
Read the following articles to learn more about tables and views:
- Modifying a Table’s Design
- Creating Tables
- Data Types
- Lookup Tables
- Managing Data in Datasheet
- Importing Data
- Exporting Data
- Database Relationships
- Scheduled Import and Export (DataHub)
- Table and Database Design Best Practices