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!
Hey 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
+4Manuel_Tanco wrote:
Hey 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
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.