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.
