Refresh data in almost real time

Hi , I am trying to compare two fields - current time and an expected time. Based on the difference between these two I want to update a status. However the refresh doesn’t seem to be happening in real time. Is there a way to solve this?
Even if there is an option to auto-refresh the page - that should solve the problem.

Thanks a lot for any inputs!

Hi and welcome!

Sorry but I couldn’t figure out from your message what you are trying to do or where you are trying to do it.

Can you spell out what you are doing in more detail? Is this code? JavaScript custom code in the browser? Or is it airtable formulas? Or airtable automation scripts?

Also please explain what you have already tried and where you got stuck?