I have 3 columns:
[Name]
[Signature]
[Date]
My goal is: Set TODAY() as the initial value of [Date], after the [Signature] field is signed.
This is working, when I add a new row. But it is not working, when i edit an existing row.
So my workaround for column [Date] is:
Show if: ISNOTBLANK([Signature])
Initial Value: IFS(ISNOTBLANK([Signature]) , TODAY())
Reset on edit if: ISBLANK([Signature])
But this is also not working.
When I change it to:
Show if: ISNOTBLANK([Signature])
Initial Value: IFS(ISNOTBLANK([Name]) , TODAY())
Reset on edit if: ISBLANK([Signature])
It is working. But only if I 1. enter a Name and 2. sign in the signature field.
If I first sign in the signature field and then enter a name, there will be no initial value in [Date].
As far as I understand, we cannot refer to the same column in the Initial Value AND in die Reset on edit. Am I right?
How about a ChangeTimestamp field?
Thank you @Aleksi. In my case this is exactly what I need. Because I donโt need to change the [Date] column manually. So I hide it and make it a ChangeTimestamp.
Youโre welcome
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |