Remove country from address

AppSheet AppSheet Q&A
1

Hi everyone,
I have an address type column and when i add address i get entire address. I want to remove the country from the address. How do i do it ?

Thanks in advance.

2

Provided you have enabled Use my Google Maps integration via UX > Options > Map View, just turn it off.

1 Like
3

But I need that too. Thanks for your reply.

4

Basically you can create an Action for this table and set it as Data: change the values of some columns in this row and then set it as a Form Saved Event of your Form UX.

Assuming that your [AddressColumn] returns the address seperated by commas where the country name is at the end i.e. Mulholland Drive 16, 12345, CA, USA

SUBSTITUTE(
	[AddressColumn],
	","&INDEX(SPLIT([AddressColumn],","),COUNT(SPLIT([AddressColumn],",")))
	,""
)
1 Like