This question has been flagged

I use oe_browse() to retrieve data from Odoo and everything works fine. But I would need to refresh de synchronization periodically as data on Odoo side gets updated and has to be reflected in the linked Google Sheet.


There are 2 functions in Google Sheets which are normally used for refreshing calculations:

1. Spreadsheet Settings > Calculations > Recalculation > On change and every minute: This does only work with NOW, TODAY, RAND and RANDBETWEEN functions.

2. Add NOW() to calculation like +NOW()-NOW(): This only works out with numerical calculations.


Any idea how to get this done?

Avatar
Discard

I have same issue also