This article explains how to import Quickbase tables and child tables when creating a new form in FastField.
Builders add the Quickbase integration to global workflows to connect data. This sends form submissions from FastField to an app in Quickbase. During setup, builders map the fields between the form and the app.
When builders create a new form in FastField, they have the option to import from Quickbase. This imports the tables from a specific Quickbase app. If the table being imported has child tables, they become subforms in FastField.
When a builder imports a form from Quickbase, they must map fields from the Quickbase table to the FastField form.
This table explains the current field mappings supported by this integration.
Warning
Before adding the integration to a workflow, you need to set up the integration. Learn more about setting up the integration.
Import a form from Quickbase
In FastField, go to My Forms.
Select the New Form button, and then select Import from Quickbase.
Select your integration, and then enter the App ID.
Choose a table, and then select Next.
This selects the table to base the FastField form on.Map the fields to include in the form.
To include a child table as a subform, select the table name and map the fields.Save your changes.
This opens the form builder, where you can continue editing your form.
Field mappings
This table explains the current field mappings supported by this integration.
Quickbase field type | FastField field type |
|---|---|
Text | Text |
Text Multi-line | Text |
Rich Text | Text |
Text Multiple Choice | List |
Numeric | Numeric |
Currency | Numeric |
Date | Date |
Duration | Numeric |
File Attachment | Single Photo (Allow Camera) |
Single Photo (Allow File Library) | |
Video | |
Embedded Photo | |
Audio | |
Street 1 | Location/GPS |
Text | |
City | Text |
State | Text |
Postal Code | Text |
Country | Text |
Phone Number | Formatted Numeric (US Phone) |
Record ID # Key Field | Add Related Quickbase Table Mapping |
Reference field | Data Table |
Limitations
Submission failure notifications
If a FastField form submission fails to upload a new or updated record to a Quickbase table, no alert is sent to notify anyone of this failure. An Upsert Failure log displays in the Submissions activity log within FastField, however.
We are planning to add notifications for upsert failures in the future.
Field mappings
Currently, the following fields cannot be mapped with complete accuracy between Quickbase and FastField.
Multi-choice fields that pull choices from another field or table are mapped as Text fields with no choices to select
Lookup cannot be mapped
User fields cannot be mapped
Attachment fields in Quickbase cannot be mapped to a Document Viewer field in FastField
Rating fields are not mapped to Quickbase when the N/A option is selected