Creating an app from Lucidchart

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. Read 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.

To create your app from a Lucidchart ERD:

1. Open your diagram in Lucidchart.
2. In the left panel under Entity Relationship, click Export.
   
3. Under Which system are you using?, select Quickbase.
   
4. Under Export, click Copy to Clipboard, then click Done.
5. In Quickbase, click Create new app. Click Import from Lucidchart.
6. If necessary, select an account.
7. In the field, paste the commands (JSON) you copied from Lucidchart.
   
8. Click 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: