Timestamp in Long Text

[Neilemmo]

I have a client that would like to see when (Date and Time) and who (UserEmail) have amended or input data into a Long Text field.

Is there a way for him to see this?

[Steve]

You’ll have to design your app to capture that information.

[1minManager]

Yes you can setup a changetimestamp column to monitor that longtext column

[Neilemmo]

Any tips you can offer in how to set that up would be much appreciated.

[1minManager]

So there are 2 ways you can do this. The easy way is to have a ChangeTimestamp column pointing at this column. Plus and another column with an initial value of UserEmail() and a Reset on Edit formula of [Timestamp Column]=Now(). This would tell you when and by whom it was last edited.

If you wanted to track all changes you’d need to create a subtable. Then use Automation so that upon saving this record it would create a record in the subtable.

[Neilemmo]

Thank you. I’ll give it a whirl.