CommentCapture data vanishes after a while

[Jim_DiModica]

Our ContactUs form's comments field is named CommentCapture. I have a Smart List used to display Contact form submissions. Its "View" includes CommentCapture.

If you submit the form with a comment in the CommentCapture field, the entire record including comments will display when viewing the Smart Filter's "Leads" tab. If however, you nav away from that page and return to it (even seconds) later the CommentCapture field will be empty. And an examination of that lead's Lead Info will show the comment in the Comment History field, and not in the CommentCapture field.

How can I have the comments display -- and not disappear -- when viewing Smart Filter results?

Thanks!

[SanfordWhiteman]

Sounds like you have a flow step that is deliberately moving the latest comment into the Comment History field instead of copying the latest comment.

[Jim_DiModica]

I believe you're right, Sanford. Please review screen-shot.
I think they wanted to accommodate the history of a lead's comments. I don't want to thwart their intentions, but I do want to populate the Smart List's field.

Any suggestions?

Thanks very much for your insightful reply!

[SanfordWhiteman]

Well, Step 7 is the one that sets the current comment to null. Here's the thing: if you delete that step, you cure the problem... BUT if they are using form prefill anywhere and are expecting that field to come up empty, it no longer will. The way to kill both birds is to create yet another field like `Last Single Comment`.

[Jim_DiModica]

OK. If I'm following correctly:
1) Create new custom field: Last Single Comment
2) Change name of form's comment field to Last Single Comment
3) Edit Smart Filter's view to include Last Single Comment

Thanks again.

[SanfordWhiteman]

No, I think the form's comment field should still be CommentCapture.

You should copy that field's value into LastSingleComment and into AllCommentHistory.

Then blank out CommentCapture.

[Jim_DiModica]

Thanks, Sanford.
I Follow your logic, and have attempted to add the flow step, however I think my assembly is a little off.
Can you point me in the right direction?

Thanks again!

[SanfordWhiteman · Accepted solution]

You want:

Comment History | New Value: {{system.Date}} {{lead.Comment Capture}} etc...

LastSingleComment | New Value: {{lead.Comment Capture }}

Comment Capture | New Value: NULL