Documentation Index

Fetch the complete documentation index at: https://help.quickbase.com/llms.txt

Use this file to discover all available pages before exploring further.

Create an app from Lucidchart

  • 1 minute(s) read
Prev Next

You can create an app based on a Lucidchart entity relationship diagram (ERD) diagram. This enables you to visualize, design, and plan the schema of your app with your colleagues in Lucidchart, then quickly import it into Quickbase to create the new app. learn more about this partnership with Lucidchart.

As you create your ERD in Lucidchart, be sure it meets the following requirements before importing it to Quickbase:

  • It includes a "Field, Type" block, not a "Key, Field" block. Otherwise, your fields will be imported as text and names will not carry over.

  • It contains supported relationships (see also Feature limitations).

Here's a Lucidchart diagram that you can use as template when you start designing your app.

Example Lucidchart entity relationship diagram template for designing a Quickbase app

To create your app from a Lucidchart ERD:

  1. Open your diagram in Lucidchart.

  2. In the left panel under Entity Relationship, Select Export. 

  3. Under Which system are you using?, select Quickbase. 

  4. Under Export, Select Copy to Clipboard, then select Done.

  5. In Quickbase, Select Create new app. Select Import from Lucidchart.

  6. If necessary, select an account.

  7. In the field, paste the commands (JSON) you copied from Lucidchart. 

  8. Select Create app.

Feature limitations

Here are some things to know as you use this feature. In Lucidchart:

  • Use the Export link under the Entity Relationship Shapes category, not File > Export.

  • You may need to add the Entity Relationship shapes category.

Also note:

  • Only Quickbase-supported relationship structures import properly. This includes any one-to-many relationship The following relationships are not supported:

    • One-to-one

    • Many-to-many between just two tables

  • Custom key fields cannot be specified through this feature.

  • Summary and lookup fields cannot be created through this feature.

  • This feature automatically creates a relationship's reference field if there is a relationship set up between two tables in your Lucidchart diagram.

  • You can use this feature to create tables, but not put data into tables.

  • The following maximum limitations apply:

    • Tables = 80

    • Fields = 50 (per table)

    • Relationships = 50

    • Field choices = 50 (per table)

Field types supported by Quickbase

This list can help you determine what field names to use in your Lucidchart diagram before you import it to Quickbase:

Lucidchart database diagram template showing supported field types and their Quickbase equivalents

Lucidchart code view showing the JSON export format for importing into Quickbase