Updating the Field value

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
Hi,
I have a comment field in my table and it has some data in that field. 
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 ?
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Micro Dev

Micro Dev

  • 834 Points 500 badge 2x thumb
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
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb
But it stores the old comment in the field.
  (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?
Photo of Micro Dev

Micro Dev

  • 834 Points 500 badge 2x thumb
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.
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb
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?
Photo of Micro Dev

Micro Dev

  • 834 Points 500 badge 2x thumb
Without seeing the dynamic form rule, I will not be able to tell you what is wrong.