Import Quickbase app schemas to FastField forms

  • Updated
  • ~ minute read

This article explains how to import Quickbase tables and child tables when creating a new form in FastField.

In this article

Builders add the Quickbase integration to global workflows to connect data. This sends form responses from FastFields to an app in Quickbase. During setup, builders map the fields between the form and the app. 

 

Import Quickbase app schemas to FastField forms.jpg

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.

Important

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

Import QB table to FF.jpg

  1. In FastFields, go to My Forms.
  2. Select the New Form button, and then select Import from Quickbase.
  3. Select your integration, and then enter the App ID.
  4. Choose a table, and then select Next.
    This selects the table to base the FastField form on.
  5. Map the fields to include in the form. 
    To include a child table as a subform, select the table name and map the fields.
  6. 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

Related articles