It sounds like you are using a script?  If so, use the console.log function to output your data and select the correct elements to return to your field.

Could you provide screenshots of your table with example data and automation setup please?

I am not using a script, just using the various options for formulas, lookups, and automations. See screen shots below. I have events in one table, and people in another. Basically I want to be able to send a slack message to when I have booked them for a shift (name entered in linked column called "confirmed" and then using last modified time, limited to those that were modified today). Limiting to "last" doesnt work because if I remove someone from the confirmed column, I dont want to send a message to the last person booked before that change was made. Thanks!