Issue with Formula Field Not Updating Automatically in Baserow (Docker Self-Host)

Baserow Help
, ,
1

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.

408_30-10-2024
408_30-10-2024698×518 42 KB

Result not updated automatically

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.

409_30-10-2024
409_30-10-2024601×515 18.3 KB

410_30-10-2024
410_30-10-2024741×448 37.5 KB

When click Saved, the result update

Potential Cause? My database setup includes several hundred tables and rows, but I don’t believe this should be too much for Baserow to handle.

Question: Has anyone else faced this issue or found a solution to ensure the formula field with now() updates continuously in Baserow?

Thanks in advance for any advice!

2

Hey @kieuminhnhat, apologies for the delay with the response. We’ll investigate the issue: Formula field with NOW() function not updating automatically (#3153) · Issues · Baserow / baserow · GitLab :slightly_smiling_face:

1 Like
3

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