Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Prevent Bing map API function from running/refreshing when the query is edited.

hello all, I created a function that calls the Bing map web service, it works great and gives me distance traveled and duration between my start and finish locations, however it is a bit slow.   My...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous you cannot avoid the full refresh, as soon as you refresh, it is going to refresh and make that function call for each row. 

     

     

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

It would really help if you actually posted the code you are using, so we aren't guessing what it is doing.  And some sample data so we can see your data structure/column names.

What's the full error message?

Which step is generating it?

If you only want to call the function when a column does not contain null then use this.  Assuming you want to check the [Address] and [Work Location] columns for null

each if [Address] <> null and [Work Location] <> null then fnDistince([Address], [Work Location]) else null

Regards

Phil

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ok let me get what you asked for, but the addresses will never be null, it's the expanded columns (TravelDistance, TravelDuration)  that will be null with new records. I am trying to prevent the refresh of existing records.