Jump to content

Generate coordinates on bulk update of records


Recommended Posts

Hello all,

We have a table where some basic information is uploaded into it via an API including the proerty address, we then do a bulk update of the remaining information required for these records via a Tubular Report bulk update feature.

I know that Lat/Long coordinates can be inserted into the table when using a Submission or SIngle Record Update form as described here>> 

 

I have asked the question in this post but thought it might be useful to start a separate thread in case someone else is also looking for this type of solution, it would be handy if this feature could be inclded in a triggered action but I can't find anyway of currently doing that so this would be the "next best" option if it can be done.

Thanks for looking and any help would be greatly appreciated!

Cheers, Roosta

 

Link to comment
Share on other sites

  • 2 weeks later...

Hello,

The solution mentioned is sending a query to the Google Maps API to retrieve the lat/long coordinates from an address. That is not possible with Triggered actions but it should be possible to create a Zappier/Make scenario to send such request to Google Maps API and update your Caspio table with the coordinates. 

With Make it might be easier as they already have the Google Maps location integrated and you can create a WebHook in Caspio to trigger the scenario when a new record is inserted to the table.

Link to comment
Share on other sites

@Barry

Thanks for the suggestions, we already considered Zapier as we use it for a lot of other processes but as Caspios Webhooks progresses we are looking to transfer what we can to that and utilise the Webhook/API calls we get free within our package rather than paying for a third party service.

Had a look at Make before but don't particualarly want to start using another third party automation service just for this and we are looking at alternatives to geocoding the addresses before upload to the system which would solve the issue anyway.

Just a pity there isn't a way to intergrate directly in triggered actions, perhaps when the Caspio Webhooks matures it might be something that can be fully processed there but I won't hold my breath! :lol:

Thanks for looking and taking the time to respond cheers, Roosta

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...