I have 2 columns in my table where I am trying to calculate the number of days since the row was last updated.
The ‘last updated’ column is a ChangeTimestamp watching columns for changes.
The ‘DaysSinceUpdate’ is a number column with App Formula = HOUR(TODAY() - [Last Updated]) / 24
When I look at a details form I get a ‘-1’ result on the field, but when clicking into the form view the correct duration shows. What am I missing?
Details View
Form Voew
Solved! Go to Solution.
App Formula expressions in real columns will only re-calculate when the record is edited.
App Formula expressions in virtual columns will be re-calculated upon every sync.
Also seeing my data source has the value ‘-1’ which is incorrect
This is actually a different problem. The ‘-1’ value is because the form has not populated a value in the row yet.
So - the field ‘DaysSinceUpdate’ is not being triggered or calculated until I open the form view.
Should I be using a formula in my data source to calculate this instead?
App Formula expressions in real columns will only re-calculate when the record is edited.
App Formula expressions in virtual columns will be re-calculated upon every sync.
Doh! Thank you, @Marc_Dillon
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |