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.
