Imports
I'm seeing an odd character when importing data. How can I get rid of it?
The error glyph shows up when a special character is imported in a file without the correct encoding. Excel spreadsheets don’t use UTF-8 character encoding, so it's more likely to happen when importi…
How do I update existing data using an import?
If you want to update data that already exists in one of your tables using an import, this article section will show you the steps: Updating an Existing Table. There are two important items in that a…
My import is failing or getting stuck. What do I do?
Stuck Import. If your import is stuck at X% and it's been a few hours, send us a link to the table where you're importing and we can get that cleared up for you. Prevent Imports From Getting Stuck. W…
Can I undo or reverse an import?
If you need to reverse an import, we can help with that. Right now there isn't a way for users to undo an import from within the builder. Our team will need to manually make that change for you. You…
I'm having trouble importing into a specific type of field. What can I do?
We have guides for importing into different field types and information on field types that can't be imported into: Import Connections. Import Names & Addresses. Import Images. Import Dates & Times.…
Some of my fields aren't importing correctly. How can I fix that?
Check Your Matching: Columns to Fields. The first thing you want to check if some of your fields aren't importing is whether you're matching the right fields for those columns when importing. For exa…
I'm having trouble importing into a connection field. What can I do?
First Time Importing Connection. If it's your first time importing into a connection field, we recommend that you start by reviewing this article: Importing Connections. Importing Multiple Connection…
Can I import something other than data? Like tables, pages, views, etc?
Tables. You can create new tables and add in data for those tables using a single import. This article section shows you the steps for doing that: Creating a New Table Via Import. Pages, Views, and O…
My import is taking a long time. Can you take a look?
We’d be happy to look into this for you. To get started we will need the following information: A link to the table where you're importing the file. A sample copy of the file you're importing. The es…
I'm getting an error when importing. What do I do?
There are two import errors that can pop up sometimes for users: Error: Number of columns is inconsistent at line {line number}. Error: Invalid opening quote at line {line number}. Both can typically…
Do the validation rules on fields trigger when importing data?
No, validation rules on fields won't trigger when you're importing data. They will only trigger on forms.
Can I schedule or automate imports?
To schedule or automate imports, you will need to use a service like Zapier or our API. Using Zapier, you can create rules (zaps) that will import records from hundreds of other services. For example…
Can my users import data from the live app, instead of going through the builder/back-end?
Right now there isn't an option for letting users import CSV files from the live app. They would need to have access to the builder and you can only have a limited number of shared builders with acce…
I am importing data for the first time. How do I do that?
To get started with imports, we recommend that you review this article: Import Records. We include screenshots in our steps so you know exactly where to click while going through the import process.…
Can I import data into more than one table at the same time?
Right now there isn't an option for importing data into multiple tables at the same time. This includes not being able to create connected records in table B when importing records into table A. You…
