If QuickBase's pre-built templates don't address your needs, you can create your own application from scratch. Starting from scratch lets you lay out the basic structure of your application before entering any data. You define the application by specifying the initial tables, fields and relationships between tables.
This topic shows you how to create an application from scratch. Before you begin, you should familiarize yourself with these topics:
QuickBase lets you choose two different methods to create an application from scratch:
Database style--When you create an app using database style, QuickBase gives you a very simple interface, similar to one you'd use to create any other database. You give the application a name, and then create the tables, and fields that will comprise your app.
Spreadsheet style--This method mimics a spreadsheet. When you create a new column in spreadsheet mode, it becomes a field in your app. Note that, with spreadsheet style, you can create only one table when you initially create your app. Once it's created, though, you can add tables at any time.
To create an application in a database style:
From the My QuickBase page, click Add a New Application.
Click the From Scratch tab.
Make sure Database is selected on the left.
Complete the screen as necessary, naming the application, and creating and naming tables. For each table:
Click Fields to define the appropriate fields.
Name each field and specify the right field type.
Click OK.
You can also choose to define relationships in multi-table application. Here, you simply identify the Master and Details table in each relationship and click OK. (For more information, see About relationships.
If you choose to create an application spreadsheet style, you'll be able to create only a single table initially. Once the app has been created, you can add tables at any time.
To create an application in a spreadsheet style:
From the My QuickBase page, click Add a New Application.
Click the From Scratch tab.
Make sure Spreadsheet is selected on the left.
Name the application. The application name will also be used as the name of your first table.
Define the fields that will comprise your table by entering Field Labels in the grid on the screen and click Create. QuickBase tries to determine the field type that should be assigned to each field and displays a screen with its suggestions.
Confirm (or change) the field type of each field and click OK.
Click Continue To This Application.
QuickBase displays the dashboard page
of your new app. You can now start adding data, or add more tables
if you'd like.