I’m searching for ideas how to implement some behavior.
The scenario: I would like to post some of my tweets again at regular interval. Thus I want to create a Tweet scheduler (ex: 1 Tweet per Day) with Airtable and Zapier.
The Data: I already have created the Zapier logic to save the tweets (with some particular hashtags) into an Airtable Table. This list already has something like 40 items and steadily grows each time I tweet with those hashtags.
The logic: Let’s say I have 2 Tweets in my Airtable Table. On the first day, I would like Zapier to pick the first tweet and tweet it. The next day I’d like Zapier to take the second tweet and tweet it.
On the 3rd day, if the table still contains 2 tweets, I’d like Zapier to start again with the first tweet and continue. If I added a 3rd Tweet to the Table, the logic should retweet that 3rd tweet, and then on the next day start anew.
The problem: how to find the next tweet to post?
My first idea was to have a “LastPostedDate” column with the date at which the tweet was posted last. Then I could sort the View by “LastPostedDate”, pick the first item and update that field to the current day. Unfortunately, the sorting is not automatically applied by Airtable yet (see: Allow views to auto-sort). That means: when I update the date, the row doesn’t automatically jump to the “bottom”, I have to sort it out manually, which is a no-go.
The next idea is to keep a row index in Zapier and increment it manually each time I tweet something. This requires a lot more logic on my end, particularly to handle the “out of bounds” index case.
The question: Is there a magic feature I don’t know about that would be very handy in this case? Do you have any other idea how to implement this?
Thanks a lot!