Nov 07, 2024 01:14 PM
Hello all--
I run a content company and we have many different types of content and about 1,000 individual pieces of content. I would like to create an AI field that would provide recommended or related content by reading in the table the segment title and description. When I've tried it, it recommends ideas for new content related to that title or description, not related content within the table which is what I want. I've tried asking it to read cells using the {} brackets, but it still just suggests content ideas unrelated to what's in the table. Any suggestions? Thanks in advance!
Nov 07, 2024 01:45 PM
Nov 07, 2024 07:42 PM
Note: I think this is possible but it'd take a lot if credits
Hmm, I think the field can only grab data from that record? To do what you need I think I'd try:
1. Create a new table called "Summaries" and link it to your main table
2. Link all the records from your main table to a single record in "Summaries"
3. In your main table, create a checkbox field called "Look for related content"
4. In your main table, create a formula field that concatenates the Segment Title and Descripton
5. In "Summaries", create:
- Lookup field for the formula field mentioned in step 4
- Lookup field for the formula field mentioned in step 4, but with a conditonal to only display if the "Look for related content" checkbox is marked
You should now have one field that displays all the Titles + Descriptions of the records in your main table, and a field that displays only the Title + Description of the content you're working on
And you can then feed the AI field these two fields, does that make sense? I think this would be a super expensive thing to do though as Airtable AI credits are charged by the characters you're sending it, and if you're sending it 1000 titles + descriptions that'd be a lot of characters
From the docs: If you wanted to summarize a transcript from a 30-minute call that contained about 20,000 characters, it would require ten times as many credits, or 100 credits.
Assuming the credits thing is an issue I'd try just pasting all the titles + descriptions into Chat / Claude / program of your choice directly instead