I am trying to figure out how to create a field that will update every time the "CLIENT STATUS" field is changed and maybe another field that says how many days that record has been in that status. Any ideas? Thanks!
Need Field that Shows When Status Field was Last Updated
+1
+8Hey there!
For the first field request, on getting a field that will update everytime the "CLIENT STATUS" is changed you can use the field type Last Modified Time and select the specific field. This will update the timestamp with the last modification on the selected field
You can set up a formula field maybe called "time_in_status" that uses the field explained above and the following formula
DATETIME_DIFF(NOW(),{last_update_status},'days')
You can also use TODAY() instead of NOW(). Only note about this formula field is that it will reset everytime the client/record changes status. So if you'd like to keep historical track of the days in status, you would need up to set up some status timestamp scheme
+25Hey there!
For the first field request, on getting a field that will update everytime the "CLIENT STATUS" is changed you can use the field type Last Modified Time and select the specific field. This will update the timestamp with the last modification on the selected field
You can set up a formula field maybe called "time_in_status" that uses the field explained above and the following formula
DATETIME_DIFF(NOW(),{last_update_status},'days')
You can also use TODAY() instead of NOW(). Only note about this formula field is that it will reset everytime the client/record changes status. So if you'd like to keep historical track of the days in status, you would need up to set up some status timestamp scheme
Better use the TODAY() function, as it request less load.
Jan - Databaser
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.