Updating the Field value

Question

Hi,I have a comment field in my table and it has some data in that field.&nbsp;When the user opens the form in the edit mode, I need the comment field should be cleared and it should allow user to enter new Comment.Suppose,The Comment field has data in it, "t2".When the user opens the form in the edit mode, the comment field should become empty and it should allow the user to enter the data in the comment field.Is their any way ?

eomdevelepors · Answer

Change the field type to a multi line text field and there is an option to log changes. This will allow you to add new values and still see a log of the old values.Hope this helps

vivekvishwanat3 · Answer

But it stores the old comment in the field.&nbsp; (t2,t2,t) are the old comments, I don't need them. How can we not include the old comments and just show the new comment when the record is saved?

eomdevelepors · Answer

So you dont want to save the old comments? Whats the purpose of saving it if you dont need it?

Anyway, you can set a rule when the record is opened it should change the comment field to blank. You also need to uncheck the log edits in settings of the field.

vivekvishwanat3 · Answer

I have tried with the dynamic form rules(like, when record is opened, or when record is saved). it is not working. I might be wrong somewhere.
is their any logic you think that will work fine for this situation?

eomdevelepors · Answer

Without seeing the dynamic form rule, I will not be able to tell you what is wrong.

Forum Discussion

Updating the Field value

Related Content

Jinja If statement equals field value

Color Coding based on field value

Jinja Max Value of a Field

User field not updating

Carrying the old value of a field into a webhook