Any way to Autofill Street Adress, State and Country based on ZIP CODE?

[integraOdontoSj]

I think the question sums it all.

I read https://support.google.com/appsheet/answer/10106435 and thought there was something there, but as long as I can tell it's just a form for appsheet to recognize the adress as... an adress.

My data structure is pretty much already set, being:

Zip Code,

Street Adress,

Number,

Complement (apt, suite, etc),

State,

Country.

Its all in portuguese, as I'm from Brazil, but the app still recognizes everything.

What I don't know if it's possible or not is regarding the autofill. Since Ive already got the zip code first, it'd save me a lot of time hehe.

Thanks!

[1minManager]

There are only two reasons to mark a column as an address.  1 - so you can get a pin in the app that if you click on it will take you to google maps.  2 - so it can display that record, via the address column, in a map view.

The address column accepts basically whatever google maps would and tries to convert that into a location.  So Zip on its own is fine, but also business name for example.

Simon, 1minManager.com

[integraOdontoSj]

Hello. Thanks for the reply... But I don't think it really says anything about my question. Is it possible to have the adress autofilled as soon as you fill the zip code?

[1minManager]

From Wikipedia - "As of October 2019, there are 41,702 ZIP Codes in the United States" so each property likely shares a zip code with multiple others.  Therefore you cannot go from a zip code to a specific address.  You can however have just a zipcode in a appsheet address column.

[Tommy62]

Sie benötigen eine PLZ-Datenbank https://www.postalcodezip.com/de/daten-brasilien . Kann Ihnen aber nur davon abraten, nach PLZ die Adresse automatisch ausfüllen zu lassen. Würde dies anhand des Namens machen.