Auto update of column not happening

nagaraj_mallaia · 11-26-2020 12:28 PM

Hi All,

I have date column as today and now. And it’s not changing next day untill we open the record and save.
Based on the date field andother field will be changed to inactive.
But date is not updating everyday old date is there.

Steve

Normal (not virtual) columns with an App formula will not update until/unless the row is updated through a form or by an action.

nagaraj_mallaia

Hi,

Thanks for the comments.

I have to compare the today date and due date and need to update the “Active” column to “N”.
if([Current Date]>=[NEXT DUE DATE],“N”,“Y”).

I cant open each and every row and do the action and set to today date bcoz table has 100 rows. Is there any way to update all the 100 rows to today’s date.

Steve

If you don’t need the computed-column’s value stored in your spreadsheet, you could replace the normal column with a virtual column, which will automatically update every time the app syncs. If you do need the value stored, the only option is to update the row, but you can automate the update with an action, and either attach the update action to a form-saved event, create a workflow to perform the update when appropriate, or use a scheduled report to update periodically.