Comments History Form Issues

[Frank_FEr]

Hi,

I am using the formula below to create a "Comment History" on a Form, but every time I edit the other columns on the form, the same comments are posted again. Is it possible to reset/blank the "comment" column after saving the form? That way I only save to "comment history" when I edit the "comment" column?

(
[Comments History]
& IFS(
ISNOTBLANK([Comments]),
CONCATENATE(
"
----
",
[Requestor]," ","(",USEREMAIL(),")"," - “,Now(),
"
",
[Comments]
)
)
)

[dbaum · Accepted solution]

You could set the column's initial value to an empty string (i.e., "") and enable the reset on edit property.

[dbaum · Accepted solution]

You could set the column's initial value to an empty string (i.e., "") and enable the reset on edit property.

[Frank_FEr]

That worked, thanks @dbaum 

[dbaum · Accepted solution]

Also, I see that another thread where you posted this question explains how to clear a column's value using an action, which you can configure to be the form view's form saved action.