[steven_stewart]

Hi All,

I need to find a way to track the time-stamp of when a change is made to a drop-down field. I need these time-stamps to be usable in a KPI and easy to access from an end-user perspective. Right now, the only method I can think of is to create a DATE field for each status value. Then create a work-flow to populate that status’s change date into a specific date field for that status. Is there an easier/cleaner method for this? System Notes includes to many other items and confuses the team that I am building this for. Let me know your thoughts. Thanks in advance!
This is a cached copy. Click here to see the original post.

[david.smith]

Do you need historical data or just for the time the user is on this particular record?

If you need to keep historical data I would create a simple suitelet and do a post on the field change event. Write the data to a custom record.

If you just need it for the page I would use localstorage.

[egrubaugh]

System Notes are searchable, so what about building a Saved Search on System Notes that filters down to only the field(s) you’re interested in, then adding that Saved Search as a Custom Sublist on the relevant record?

---

david.smith replied on 09/15/2016, 09:51 AM: System notes are only written when the record is saved. If that is sufficient then I agree. I read into this as the need to track when the field changes, not when the record is saved with that field change. Maybe my misunderstanding.

[steven_stewart]

Hey Guys, thanks for all the help on this one. I actually ended up creating multiple Date fields with workflows to populate them when the status is selected. This makes it easier to report and easier for the end user to access. Again, you guys are great, thank you for the help.

[Author]

Posts