Quickbase Code Pages Developer Lab
Get Started
Before beginning the lessons, create the small Quickbase table that every example in this lab uses.
Do This Before Lesson 1A
Create a Quickbase table named People.
The lessons assume that this table already exists. If you skip this step, the table DBID, Field IDs, API queries, and returned records shown throughout the lab will not correspond to anything in your own Quickbase application.
In other words: yes, this boring little table matters. 😄
1. Create a Quickbase Application
You can use an existing training application or create a new Quickbase application specifically for these lessons.
Nothing about the application needs to be complicated. The lab is intentionally using a tiny dataset so that the API behavior stays easy to inspect.
2. Create a Table Named People
Inside the application, create a table with this exact name:
PeopleQuickbase will automatically create its normal system fields, including Record ID#.
3. Add These Fields
| Field Name | Suggested Type | Purpose |
|---|---|---|
| Name | Text | Stores the person's name. |
| Age | Numeric | Stores the person's age. |
| Favorite Color | Text | Stores a color value such as Blue, Green, Red, or Purple. |
4. Add a Few Sample Records
Add several records so that the API lessons have something to retrieve.
| Name | Age | Favorite Color |
|---|---|---|
| Alice | 32 | Blue |
| Marcus | 41 | Green |
| Olivia | 27 | Purple |
The exact names, ages, and colors do not matter. The important thing is that the table contains records with values in all three fields.
5. Your Field IDs May Be Different
This is important.
The tutorial examples use Field IDs from the original training People table:
Record ID# → Field ID 3
Name → Field ID 6
Age → Field ID 7
Favorite Color → Field ID 8Quickbase assigns Field IDs when fields are created. Depending on how your table was built, your Field IDs may not match these numbers.
Always use the Field IDs from your own Quickbase table when running the examples.
6. You Will Also Need the Table DBID
Lessons 1A and 1B identify the People table using its Quickbase table DBID.
The tutorial source contains an example such as:
const TABLE_DBID = "YOUR_TABLE_DBID";Replace that placeholder with the DBID for your own People table.
Lesson 1A explains why Quickbase APIs use the table DBID and Field IDs instead of depending only on the visible table and field names.
Ready for Lesson 1A
Before continuing, you should have:
- A Quickbase application
- A table named People
- A Name field
- An Age field
- A Favorite Color field
- Several sample records
- The table DBID
- The Field IDs for each field
Once those exist, the rest of the tutorial finally stops looking like mysterious numbers thrown at Quickbase. 😂