Getting address parts from address autocomplete result

[paullynun]

Hi,

How do you get the parts (address, city, Postal code) of an address from the result of an autocomplete from an address field?

The address field provides the ability to complete a partial address. This is great!
From this result, does AppSheet has an build in way to extract address parts like (address, city, Postal code)?
(I have seen other applications doing all this work.)

The only thing I found is coding the following (Assuming [Adresse ID] is an address field.

[Adresse]= INDEX(SPLIT([Adresse ID],", “),1)
[City]= INDEX(SPLIT([Adresse ID],”, “),2)
[Postal code]= CONCATENATE(INDEX(SPLIT(INDEX(SPLIT([Adresse ID],”, “),3),” “),2),INDEX(SPLIT(INDEX(SPLIT([Adresse ID],”, “),3),” "),3))

[Steve]

paullynun:

The address field provides the ability to complete a partial address. This is great!
From this result, does AppSheet has an build in way to extract address parts like (address, city, Postal code)?

Nope.

[Phil]

Hi Paul,

I am not sure this would solve your problem, but AppSheet can construct a complete address from a set of individual address fields such as Street, City, State, Zip, Country. This allows you to refer to the individual components of the address.

See topic “Automatically Computed Address Field” in this article https://help.appsheet.com/en/articles/1013271-column-types-diving-deeper

[paullynun]

Hi @Phil.

Thanks for the info! I have learned this morning watching a video. Unfortunately the solution I look is the other way around. It starts with a lazy user who starts entering an address which gets auto-completed and then address parts are extracted for him.

[Aditya_Vinayak_]

Hi Phil,

I made the below fields:

1) Area - Data Type Address
2) City - Data Type Address
3) State - Data Type Address
4) Country - Data Type Address
5) Postal Code - Data Type Address

But it doesnt autopopulate for me. Only the address field gets filled with the full address

please help