Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I update my app to use the new Address fields?

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. 

Comments

Hi François, Yes, to start

Hi François,

 

Yes, to start with our Address fields we wanted to have a simple setup to see what people think, and then build on it from there based on the needs of our various users. If you have a minute please hop over to our User Voice site and share your thoughts on where we should take Address fields in the future!

You can access User Voice from your 'My Apps' page, and then clicking the orange feedback button from the left hand side of the screen.  You can also access User Voice by clicking the following link:

 

http://quickbase.uservoice.com

 

Thanks!

Brian

Intuit QuickBase

Get more from addresses

It looks like we can't access latitude and longitude data which seems to be retrieved by this new field. I'd like to be able to access them as well as I access individual address lines

Post new comment

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