I’m using Baserow self-hosted on Docker, and I’ve encountered an issue with a formula field.
I have two fields in my table:
A DateTime field named “Time Review”
A Formula field with the formula: now() - field('Time Review')
This formula is meant to calculate the time elapsed since the “Time Review” date, displaying a real-time interval that updates automatically. Initially, this worked perfectly. However, in the last few days, the formula field has stopped updating continuously.
Current Issue: To see the updated time interval, I now have to manually go into “Edit Field” for the formula and click “Save.” This manually refreshes the value, but I need it to update automatically without manual intervention.
Thank you for your response.
It’s working good before. I’m not sure why is it happened now. It is same setup.
I updated to lastest version Baserow 1.28
thank you for your patience! We haven’t started working on this yet as we’re currently focused on other tasks. To help us prioritize your request, we need some additional information to understand better and replicate the bug and assess its potential impact.
Could you confirm if the issue occurs with other tables as well? Additionally, if you check the logs, you should find entries for baserow.contrib.database.fields.tasks.run_periodic_fields_updates. Could you verify if there are any errors around the same time and share the relevant log excerpt with us?
Thank you for your help, we’ll look into it as soon as possible.
Yes I checked again it happen to all other tables.
Ok, it likely is something specific to your instance because they are working properly on our SaaS. Any additional information you might have on replicating it is greatly appreciated.
May I ask to find this log I need to go to Audit log feature?
No, if you run the all-in-image of Baserow with Docker, you should be able to see them with Docker Desktop or using the docker logs command.
I have the same problem, I have a formula field to check how much days are left before a call which didn’t update for 100’s of days if no changes where made in the row or if I didn’t manually click on save on the edit formula screen to trigger an update.
I just running on Docker windows, it is working before.
But suddenly I don’t know why it is stopped working.
Until now tables still not updated this formula field.
If you have Docker Desktop, you should see baserow in the list of the running containers. If you click on it, it should show Baserow logs. If you don’t have Docker Desktop, you should be able to see the logs from the terminal with docker logs baserow.
Every 10 minutes, you should see that a task named baserow.contrib.database.fields.tasks.run_periodic_fields_updates() starts and ends without errors, like in the image attached below. Could you please check that? If you see any errors, could you please share the logs?
Yes, could you please export the workspace and import it back into a new one to verify if it has the same problem? You should be able to see a similar error for other fields.
If so, please send me (either here or privately) your exported workspace so I can try to debug it in my dev environment. If sensible/private information exists, you can export it without data and change the field names.
This is screenshot when I search with your task name, it looks like it has no errors.
@kieuminhnhat, I cannot see exactly when the task ends. You should see something like Task baserow.contrib.database.fields.tasks.run_periodic_fields_updates[625f67f7-7443-45a9-9814-9c5a48986203] succeeded in 1.5668367509788368s: None or an error like @Marnik 's screnshot.
Ok ,this guide should solve your issue: Baserow
The numbers there are very high, but consider a default of 64, that error can happen even in situation with less tables.
Please try to follow the guide and double that number to see if it fixes the problem.
Upon reviewing the logs, I discovered that some of the fields showing update failures don’t actually exist in the database. Maybe it’s trying to update inexisting fields and that’s why others fail too ?
