Some clients may interest in having the last comemnt (and maybe the last comment date) as fields on the parent entity (ex: Lead).
Formula is a great place to do this, you also can use Workflow from the paid extension Advanced Pack.
TLDR;
ifThen(
parentType == 'Lead' && type == 'Post',
record\update(parentType, parentId, 'lastComment', post);
);
Important:
"Note" is not customisable by default, so you need to make it customisable to be able to write Formula, check my answer here to get information about how to allow formula on Note entity:
Formula is a great place to do this, you also can use Workflow from the paid extension Advanced Pack.
TLDR;
ifThen(
parentType == 'Lead' && type == 'Post',
record\update(parentType, parentId, 'lastComment', post);
);
Important:
"Note" is not customisable by default, so you need to make it customisable to be able to write Formula, check my answer here to get information about how to allow formula on Note entity:
Comment