Hey Claybot how can I take 14 objects (linkedin posts) and limit filter them to only the most recent 10 and then combine them into a single object?
To filter 14 LinkedIn post objects to the most recent 10 and combine them into a single object, you can use our "Find Recent Posts by User or Company" feature along with the "write to table" functionality. Here's how: 1. Use the "Find Recent Posts by User or Company" feature, providing the LinkedIn profile URL. 2. Set the "Number of Posts" parameter to 10. This will automatically return the 10 most recent posts. 3. Use the "write to table" feature to combine these 10 posts into a single object in your Clay table. Can you provide more details about the specific Clay table or workflow you're using for this task?
No I already have the posts in clay, I don;t need to find recent posts though
so two broad options
if you have a date field for posts then use formula to filter out older posts based on the date field
or write the posts to another table and filter there, then lookup in original table to use
Hey, do you have the table URL so I can take a closer look at your setup? In general, you’d use a formula to get the 10 most recent posts. Just sort by the key that holds the date—like "date"—and then limit the result to 10. To combine them into a single object, include that in the formula as well. Let me know if you want help writing it out.