I’m using the Google Maps plugin to get latitude and longitude from an address field, and I’ve set it up as a computed column in the data table.
As I build and test the app, I’ve noticed the lat/long sometimes refreshes—even when I’m just making unrelated changes to the record. Does this behavior count as an update each time?
I only need to capture the lat/long once when the record is created, so I want to make sure we’re not unintentionally using updates just by modifying other fields in the same row.
I recommend creating some sort of action sequence that writes this static attitude longitude to a text column rather than using the integration column. It’s possible that the integration column will continue to rack up updates whereas the action will only incur one update per address.
@OptionOneShaun I asked the team for best practices here. The response is that changes should only be triggered when any part of the address changes.
However, best thing to do is create a workflow that writes to a static text column and then clears the coordinates that are being used by the integration. It’s also the best practice for AI columns to be sure they don’t refresh themselves without you realizing it.