Reply to comment

Before the release of address fields, you may have created several separate fields to capture address information. For example, you may have the following fields:

  • Mailing Address 1
  • Mailing Address 2
  • Mailing City
  • Mailing State
  • Mailing Zip
  • Mailing Country

 With the new Address field type, you no longer need to capture address information in multiple fields.

Converting your older-style multiple address fields into the new single Address field type is a matter of performing these steps: 

  1. Add a new field of type Address. This is where you’ll be moving the old address data into.

    Tip:
    When updating apps with an existing field named Address, I recommend renaming the field to Address (Old) before adding a new Address field with the same name. Otherwise, the new field will be called Address2 and you’ll need to rename it after creation.

  2. Create a report for all records you wish to update. The report should display only the key field (usually Record ID#) and each of the old-style address fields (Mailing Address 1, Mailing Address 2, etc).

  3. View the report and save as a spreadsheet…

  4. With the spreadsheet in hand, we can now do an Import/Update to insert the old address into the new Address field.

    Tip:
    To aid in the import/update process, consider updating the saved spreadsheet address column names to match the following:
    Address: Street 1
    Address: Street 2
    Address: City
    Address: State/Region
    Address: Postal Code
    Address: Country

  5. Note the name of your updated spreadsheet, then navigate to the Import/Export page within the table you wish to update and import the spreadsheet from file.

  6. Verify that all of the columns in your spreadsheet are mapped correctly to subfields of the new Address field.

  7. You should get a warning about updating records – this is good! Click Insert/Update.

 To verify the changes, preview some of the updated records to ensure the new address field is populated.

Once you are sure that everything looks OK, you can now start the process of updating references to the old address field to the new one, including updating any relationships that may be looking up the old address. 

Tip:
Many users have created a Formula – URL field to link an address to Google Maps. Since Google Maps integration is now built-in to QuickBase, this field should no longer be needed. 

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit