How do I add present time to row when a change has been made in that row?

Ask for Help
1

I know I’ve done this before, but how? It will be easy, but I don’t have a clue anymore.
This is what I want to do:
When something changes in a row, I want 2 columns filled: one with the time of change, one with the name of the changer.
How do I do this again?

2

How is the change being made, via an Edit Form?

If yes, you can just use a screen column to set the when, and a user profile column to set the who.

Actually, scratch that (sorry). You just need an On Submit action that does a Set Column values.

  • the who gets set with a value from the user profile
  • the when gets set with the current time
3

Ah thanks!

4

This should also works just fine in an edit screen, I believe. Current time special value for when, user’s name for who.

1 Like
5

yeah, that was my initial thought, and then it didn’t seem right and I didn’t have time to test it.

Problem is I’m almost always using custom forms, so I rarely get to use these options. I need to find a way to wean myself off custom forms, haha :crazy_face:

1 Like
6

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.