Importing

Rather than recreating data you’ve already stored elsewhere, Tap Forms allows for simple importing via Tap Forms Archive, Form Template, Records, Bento Template, or Contacts. Found under File, importing can help you quickly develop your forms, add hard-to-copy data, and streamline your workflow.

In this topic, we’ll cover how to import records into your database documents, and it all starts with a CSV or Excel XLSX file. By importing one of these file types, Tap Forms can understand the data within the file and convert them into records with field data. Utilizing the top row of your file as the field types, Tap Forms can seamlessly integrate your fields into a new form.

*If the Import Records option is greyed out, please make sure you have a document already opened and that document is in the foreground.

*If you choose an existing form to import your records into, you must make sure that the first row values match the field names exactly as you have them named in your form. Otherwise Tap Forms will create a new field for every value in the first row which does not match a field name in the form you’re importing into.

Before you import your files, it’s important to take proper inventory. First, make sure that if you’re using a CSV file, it has either a .csv, .txt, .mer, or .tsv file extension. Then, check that you know the comma delimiter settings. If you’re importing a XLSX file, you don’t have to worry about comma delimiters, line endings, or file encodings – just have your data in the first data sheet.

Once you’re ready to go, click File > Import > Records. To start, choose the file you’d like to import into Tap Forms; if your records have attachments or photos, you can select those as well. Next, it’s time to select specific settings for your file.

File Encoding

Perhaps the most important of these settings is under “File encoding”. Essentially, selecting the right encoding format will ensure that the characters within the file are viewable and understood by Tap Forms. It’s unlikely that you’ll have problems with this, and the default of Unicode (UTF-8) will likely suit your needs. However, if you write in a language with specific characters, you might have to tinker with these settings.

Comma Delimiter, Date Format, and Time Format

These three settings are important for the correct formatting of your data, but are probably already set to your default method. In some instances, there may be conflicts – like if your date format was entered in another country or your time value has seconds included – so make sure to double check both your file and these defaults.

Select a Form

If you’re importing records into a form you’ve already created in Tap Forms, you can use the dropdown menu to identify and select this form. You can also create a new form with a title here.

Assign Field Types

Finally, it’s time to assign field types to your records. If you want your records to be outfitted with unique field types (check boxes, ratings, etc.), this is the place to do that. This certainly comes in handy when importing records from another Tap Forms document, as you’ll already know what field type you’re looking for.

*You can also assign field types within the first row of your CSV or XLSX file by appending the field type tag to the field name. For example: Movie Title<text>,Revenue<number>,Rating<rating>,Cover Image<photo>. If you use the Export Records feature and enable the Export Field Type Tags option, then you’ll see Tap Forms put the field type tags on the first row of the export file.

Record navigator and “Add Missing Fields to Form”

Along the bottom of the window are a pair of arrows.

These allow you to quickly switch between records so you can make sure everything is set up quickly.

You’ll also see a check box for “Add missing fields to form”. By ticking this box, any fields that you have in your records that aren’t currently in the form will be added – this is especially important when starting a new form from scratch.

Copyright 2016, Tap Zapp Software Inc. All Rights Reserved.