Timestamp Field
I have a field name Password and another field name Timestamp. The Password field can be edited by a user. I want the timestamp field to be updated whenever the Password field is changed. How would I ...
Forum Discussion
It depended on whether you are allowing users to edit via Grid Edit.
If you are forcing them to use a form, then you can use a simple form rule.
When the record is saved
And
Password has changed
Change the value in Timestamp to the current date/time
If you are forcing them to use a form, then you can use a simple form rule.
When the record is saved
And
Password has changed
Change the value in Timestamp to the current date/time
- You can make that field read only so that it can only be updated when the password is changed and users cannot fake the date/time.
- Thank you! This makes sense :)
- Question: in grid edit, would you write a webhook?
- I would do it with an Action.
To do that you need to create a report link field so that the @ctiin knows which record to edit. Create a report link field which links to the record being edited. It�s a cute trick which works well.
Post back if you need more details with that report link setup. - That�s perfect. Thanks
- Do you know a way of implementing this using dynamic form rules for multi-select text fields? I notice that "has changed" doesn't appear as one of the choices when creating the dynamic rule. Working great for numeric and text fields though!
- I have not tested form rules on multi-select fields but I�ve take your word for it that they don�t work for the has changed rule.
But if you make a new formula Text field
ToText([my multi select field])
Then you will have a text field and presumably the form role will work. But you will need to have this field be on the form it�s self so that the form will remember to recalculate it. You don�t need to have a visible on the form so you can create a dummy form rule to hide it but it does need to be on the form. - Brilliant idea thanks! I'm sure that will solve it
- Unfortunately it seems the dynamic form rules don't notice the change in the formula text field. I assume this is because it is changed via a formula rather than the user directly editing the referenced field. Any idea of a workaround for the workaround?
- Did you put that formula text field visibly on the form for your testing?
