Timestamp for individual fields

[pmcfarlain]

I'd like to be able to timestamp when each individual column is updated. Basically, when column "x" is updated, the column "timestamp_x" is updated with the time "x" was updated and when column "y" is updated, column "timestamp_y" is updated with the time "y" was updated and so on. Is there a way to do this with a trigger? Or within the datapage with HTML or with a calculated value? Let me know if you know a solution! Thanks!

[TellMeWhy]

10 minutes ago, pmcfarlain said:

I have a table of phases and the goal is to save the time that each phase was completed. I can make a separate table for the timestamps if that would improve speed but I'm still not clear on how to grab the timestamp when a specific column is updated. Are you suggesting I make another table with the previous statuses and just compare if it has changed from one table to the other? I'll definitely have to use the audit trail suggestion in the future but I'm not sure it's as helpful in this specific instance since the columns are simple checkboxes and I don't need to save previous data from them, only the time that they were updated.

Thanks!

I see, then you'll probably need one update block for each field. Your Timestamp field should be a Text or Date Field (you need to use concatenate block if it's a text field)

For example this one, update #inserted so it will put the timestamp in the field, when #inserted and table check is not equal means it's been updated/changed

[TellMeWhy]

Yeah, I guess you can do it on trigger, multiple update blocks for each field where table.fieldX not equal to #inserted.fieldX so you'll know it's been updated when the value is not equal to old one, but, what's your purpose with this? Timestamp with each field would not seem ideal since it can be a lot of fields for your table, and it may slow it down.

What's usually done, though, is something like Audit Trails where you have a separate table to store the changes made

 

[pmcfarlain]

On 6/25/2021 at 2:35 PM, TellMeWhy said:

Yeah, I guess you can do it on trigger, multiple update blocks for each field where table.fieldX not equal to #inserted.fieldX so you'll know it's been updated when the value is not equal to old one, but, what's your purpose with this? Timestamp with each field would not seem ideal since it can be a lot of fields for your table, and it may slow it down.

What's usually done, though, is something like Audit Trails where you have a separate table to store the changes made

 

I have a table of phases and the goal is to save the time that each phase was completed. I can make a separate table for the timestamps if that would improve speed but I'm still not clear on how to grab the timestamp when a specific column is updated. Are you suggesting I make another table with the previous statuses and just compare if it has changed from one table to the other? I'll definitely have to use the audit trail suggestion in the future but I'm not sure it's as helpful in this specific instance since the columns are simple checkboxes and I don't need to save previous data from them, only the time that they were updated.

Thanks!