Hello all, I’m new to the Make community and looking forward to automating several things. I’m currently using Airtable to create a fluid social media schedule and would like Make use the “Airtable; Search Records” module to find the currently due post and send it to the designated social channel. I understand that Airtable setup is key in this, so I have a view dedicated to posts that need scheduling. In here are various fields like “Post Date/Time”, “Media”, “Caption” and “Platform”. I also went through the hassle, thanks to a YT video on setting this up, of creating a “Date/Time String” formula field that pulls data from the Post Date field.
Currently, I have the Airtable Search Records module sorting and bundling properly, but my first filter isn’t functioning. The filter condition is my “DateTimeString” field, the Operator is set to Datetime and “Equal to” followed by “formatDate(now;YYYY-MM-DD hh:mm A)”. This date/time string matches the one in Airtable, but nothing is coming through. I’ve also tried setting the Operator to “Datetime/Equal to” with the “Now” variable, but still nothing is happening.
Any help would be greatly appreciated in figuring this out, as I still have to figure out how to filter images/videos to Instagram and/or Facebook… Thank you in advance.