Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to automatically copy postcode from custom field to standard location field

We are importing job cards into trello, and importing the postcode for the job card (where the completed job will end up) into a custom field. Is there any way we can set up a rule to automatically copy the postcode from the custom field into the provided location field so that we can view each job card in map view? 

Or is there an alternative work around to viewing all the job cards in map view without manually having to add the postcode to the location field of each card? 

2 answers

@Mervyn Marsh @Hariii Umaiii 

Some time back I (think) wrote a program that update the location with Map Power Up installed, the map does not show on the card. Not sure whether that has changed recently. 

@Mervyn Marsh @Hariii Umaiii 

Given my test just now (see my reply to @Iain Dooley ) you should be able to import locations with address, locationName and the coordinates. You need to translate the postal code to the above. If it is a matter of creating new cards it will be a lot easier. To update an existing card then you need the cross reference.

@Mervyn Marsh @Hariii Umaiii 

Update: used free USA census geocoding website to get coordinates and update a card - address, locationName and coordinates.

0 votes
Iain Dooley Community Leader Jul 04, 2021

@Mervyn Marsh as far as I'm aware there is no way to write to the pluginData of other powerups than your own, only to read from them.

@Iain Dooley

Picture is from Trello API documentation for Update a Card. It seems that something has changed

 

 Screen Shot 2021-07-05 at 7.26.18 AM.jpg

Like Iain Dooley likes this
Iain Dooley Community Leader Jul 04, 2021

@milynnus neat! 

@Iain Dooley 

Just managed to update the coordinates, address and locationName. The Map View changed on the card. Basically used the coordinates of New Location to replace the attributes  on the test card...one with dummy address and name.Screen Shot 2021-07-05 at 7.44.51 AM.jpgScreen Shot 2021-07-05 at 7.44.36 AM.jpg

Thanks for this. 

 

I'm not that tech savvy, but could you run through (ideally step by step) how we could create a butler rule to automate the process? 

 

Currently we have a post code in a custom field box, and we would somehow like to create a Butler rule which could copy the the location information from the custom field into the pre-existing location field on trello that links to the Map view. 

 

Trust that makes sense, and thanks again. 

This is also for UK postcodes and addresses

@Mervyn Marsh 

This will require programming. Please leave me your contact via my profile page : website. 

Endpoint will only be available for 24 hrs to minimise use of event quota.

More info here :https://trello.com/c/TVe3Rf7V/51-update-card-location-information-using-geocoding-services

@Mervyn Marsh @Hariii Umaiii 

Here's the endpoint you can call using Butler Http Request

URL is https://60389.wayscript.io/coordinates?country=UK

Payload for testing is

{
"card_id": "",
"street": "",
"city": "",
"state": "",
"zip": "GU50BD",
"display_address": "",
"display_locationName": ""
},

It will return {httpresponse.latitude} and {httpresponse.longitude}

The update to the card to show on Map View will need your Trello credentials. The endpoint will eventually be password protected. It is currently not activated hence it will just return the coordinates.

For USA it will be

URL is https://60389.wayscript.io/coordinates?country=USA

Payload for testing is

{
"card_id": "",
"street": "60 Lincoln Center Plaza",
"city": "",
"state": "",
"zip": "10023",
"display_address": "",
"display_locationName": ""
},

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

62 views 0 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you