Sneaky way to make a formula address field?
Since a formula address field does not exist, I was trying to come up with a way to update a regular address field, with a table to table import, or...??
My situation is I have a 'Combined Table' t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendRE:
However, on a table to table import, I am not allowed to choose each specific address field (street 1, 2, etc)
I just had a quick look at the set up for a saved table to table import and indeed you can only import into the individual subfieldS within an address field and that sounds like exactly what you want.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I can import TO the subfield, but not FROM the subfield. So in the dropdown list....I cannot pick the street subfield. Nor can I make a formula field to extract the street from my originating address field....or can I? I don't know how to extract a street subfield from an address field, via a formula text.
------------------------------
Mike Tamoush
------------------------------
Ive realized my error. My address is a lookup field, thus did not include all the subfields. I need to lookup every single subfield. Then it should all work as expected.
------------------------------
Mike Tamoush
------------------------------