I’m trying to do something seemingly simple, but can’t figure it out. I’m trying to setup a field that gives me the text of the most recent comment. I have this formula as a start:
Comments.Sort([Creation Date]).Last()
but I get a red error that says “Formula result type cannot be Comment”. I’m trying to be able to grab this text via Zapier to drop it as a comment into a Discord channel. Maybe formula is not the way to go, but I don’t see a way to grab the most recent comment via Zapier either.
The comment is an object that has a number of fields on it, such at the text, the author, the timestamp, etc. Whereas presumably whatever you are passing this into is expecting a string?