Address Field Type - Use via Google Data Connector if connector field is constructed like address field?

  • 0
  • 2
  • Question
  • Updated 4 months ago
  • Doesn't Need an Answer
Address Field Type - Possible to use via Google Data Connector if a field is constructed with the address1,address2,city,st/province,code, country array structure?

I've kind of hoodwinked my tables with some complicated Quickbase Actions, a distinct table and looping relationships --

we use Google Drive Data Connector to bring in CSV files as tables. 

I'd like to somehow construct a field in the CSV that can then get converted into an ADDRESS type in the table.

I've scoured help but not seen anything. 

There doesn't seem to be a data type "address" within the Data Connector field definition process. 

Is there a way to do that. I realize I can do a manual import, but I'm looking for a data connector way to do this. 

Any ideas?
Photo of joe vandervest

joe vandervest

  • 94 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of joe vandervest

joe vandervest

  • 94 Points 75 badge 2x thumb
Figured this out on my own....

Here's the scoop ---

To do this I had to.....

1. Create a detail table just for the special address field
2. Using the google connector data create a webhook for new records added to the connected field that update the address sub-fields using field ID and write the values in them that we need. I have two relationships in both directions to the address table, so I write both key values needed in the detail table - one going, the other coming.    I bring the ADDRESS field into the main table via the reverse lookup relationship. 
3. I solved the State abbreviation through a relationship from the abbreviations I have to get state names. I'm thinking of expanding that by adding country code and then canadian provinces.
4. I used a Quickbase Action to update existing records in the detail table when something changes in the master. this allows me to address the address sub fields and fill them. 
5. you can use formulas in the master field to create fields that match to the address field sub-field expectations. 
6. just did some minor changes in existing data used by the data connector to force the QBA trigger to fire and thereby populate the tables. 

works just fine. 
Photo of Lee Gilmore

Lee Gilmore

  • 762 Points 500 badge 2x thumb
This might be exactly what I'm experiencing or similar. I have a Google Drive sync table that contains Address Fields similar to QB. However, the initial sync labeled these fields as Text fields. I'm unable to just change the field type to City, State, Zip, etc.

I decided I might add new fields and self populate them with data via an excel import/export but Quick Base disables the ability to import a CSV to a sync table.

If I understand your solution, I have to orchestrate an entirely new table to store and maintain addresses? Then use a webhook to populate the parent table based on the child table? I did get lost in your explanation.