Maybe I’m over complicating this, but struggling to make something simple work.
Let’s say I have a table of fruits. The table has a Fruit Name, Fruit Status, Fruit Creation Date, Fruit ID. In this case, the data—or fruit—contains Apples, Orange, Banana.
My goal in this scenario is this: I want to use GPT to write about each fruit, but only once. So the goal would be to iterate through the table, grab a value, write about it, then set the Fruit Status column to True. For example, search the Fruit database, grab Banana (since it hasn’t been written about) write about bananas, set the Fruit Table > Bannana status to True so that its clear the Banana has been written about.
I can’t get this workflow to work. To begin, I use Tools > Set Variable named “Random Topic” to create a random number between 0 and 2. I use the value of Random Topic to search an Airtable record using Airtable > Search Records. In the Search Records module, I write a formula to return only values with the Random Topic Number. E.g., {Number}='Random Topic". I write about the record using GPT. I then update the record using Airtable > Update record to set its Status to true.
I think the simplest solution might be to change the Formula on the Airtable > Search records to not only return only the number of the random generator, but also insure the records status is false. I don’t know how to do this. Any help would be appreciated.