I have a shared view that should react to data that has changed in another table in the base, however it seems to take a while before the change is reflected in the shared view. Does anyone know what the frequency of the cache refresh for a shared view is? Is it possible to change it?
Essentially I have a directory of freelancers that can be used by all contributors to network with each other. Part of that networking is finding out who is near you. Each entry in the directory has a long and lat associated with it and I have implemented a function that calculates distances based on who is selected in a linked table (i.e the person selected there is the point from which distance calculations are performed).
I've implemented it this way so that I don't have to get charged for geocoding API calls and because the contributors are not users on my base (they don't have Airtable accounts, they just contribute by filling in their details on a form and viewing the directory by the shared view). There is no budget for this service, I'm doing it to be helpful to the community I'm part of.
Obviously it all works instantly if I select the person in the linked table when logged into the base myself but the shared view takes sometime to update, which can cause frustration for the users. If I can tell them it will take a certain amount of time before it updates that would be useful. If I could shorten that time all the better.
Also open to suggestions of other ways to implement this if people think there is a better way.
