Column auto-update upon view refresh - can it be done?

I am putting together a company/contract database to show a list of companies and the current status of their contracts with me (expired/active/etc)

Therefore I would like the company list view to show the current status of their contract, based upon the contract start date and duration, and the current date.

I've added the code to the contracts form to automatically calculate the expiry date for the record, in the On User Input/On Update events of the start date and duration fields.

I have linked to this contract table within the client form, and created a formula field "Expired" that returns a boolean value based upon whether (start date - expiry date) is negative or positive.

This works okay when I edit individual Client rows - the field updates itself on load - but so far I haven't found a way to keep it up to date without manually editing. I would seemingly have to open/edit every single row every day in order to update the field contents, which is not a practical solution.

Is there a way to get all the rows to update their field contents automatically, such as a custom action, or even better an "on load" view event where I can call a "refresh" function to update all rows with current data?

If not, can it be added soon to Zoho Creator?