I’m trying to automate social media post scheduling. To be clear, I'm not wanting something to post automatically on a date/time I set, I'm looking for automation to set that schedule.  I'm wanting to drop 10 image files at once into my automation process and have those images be scheduled to post once a day at about 6:00 p.m. EST daily. It's OK if we skip a day where there are no images in the queue. But if multiple images are in the automation queue, I want the automatic scheduling to look at the last scheduled post and schedule the next one for the following day.  I hope all this makes sense.  I've got most of this worked out between Airtable and Zapier.  Here is the process: 1. I drop an image into a selected folder in dropbox. 2. Zapier triggers on "new file in folder", creates a record in Airtable, creates a new folder, moves the file to that new folder, updates the Airtable record Status to "Waiting Text", and the Post Text Status to "Needed", and sends an email notifying me that the image needs text for the post.  When I add the Post Text to the Airtable record the following things happen: 1. Airtable automation updates the Post Text Status to "Complete" and the record Status to "Waiting Sked". I have the following fields in my table (also see attached screenshot): Status (with options: Waiting Text, Waiting Sked, Scheduled, and Posted) Post Text Status (with options: Needed, and Complete) Post Text (where the text for the post is actually placed) Last Modified based on the date/time Post Text was added Post Scheduled For (intended to auto fill with a date and time for the image & text to be posted) Post Scheduled (Yes/No) Date & Time Posted (autofills to the Date & Time the Ppost actually posted). I’d like a new post schedule to be based on two factors: Always at 6:00 p.m. EST on any day of the week. On a day after the last scheduled posts. My main problem has been automating the Post Scheduled For date and time. I just can't get it to work consistently.  I also attached a screenshot of the automation that I was working on. It does not have the fixed day/time functionality I want. It also would break if there was more than one record that were found in the 3rd step "Find Unscheduled Posts". So, if there is a post scheduled for Thursday at 6:00 p.m. EST, I want the next post to be scheduled on Friday at 6:00 p.m. EST. And I only want one post on that day and time, even if there are multiple records waiting to be scheduled & posted.  I'll be happy with this for now. While trying to work this out, I ran into a problem with multiple records updating together and causing Airtable automations for record updates to not work. But that may have something to do with the way I have it set up now.  I appreciate any help.    ... View more

Hello! I am working on a database for a nonprofit organization that includes a donor CRM and program data with volunteers, events, and more. See my attached Miro board for the proposed workspace structure with syncs. I'm looking specifically at the relationships between the Fundraising base, Contacts base, and Programs base in this use case. Here's my question: some donors are also volunteers and volunteers also make great prospective donors. Let's say that Donor A is a member of the Board. She donates $1,000 per year and also volunteers at 4 events each year. I want a single record of Donor A that shows both her donation history and volunteering history. At the same time, I want Fundraising and Programs to live in separate bases as they are each managed by different teams. My current idea is to create a sync from Fundraising to Contacts and another from Programs to Contacts. Then, in the Contacts base, I'll add a 'remove duplicates' extension and a staff member will review it monthly for duplicates. I also thought about creating two syncs from Contacts: one to Programs and one to Fundraising, but that would require staff members to enter new contacts in the Contacts base and then go to their respective bases to log a donation or volunteer event -- an extra step I'd like to avoid. But maybe that's the best solution? Thanks in advance for your help in thinking through this! ... View more

Instagram ads can be a great tool for dropshipping businesses. They offer a wide range of targeting options, allowing you to reach the right audience with the right message. Additionally, you can use Instagram's visual platform to create attractive and engaging ads that are sure to draw attention through pricing-calculator. Furthermore, Instagram ads are relatively affordable, making them an attractive option for dropshippers on a budget. With the right strategy and creative, dropshippers can leverage Instagram ads to generate more sales and increase their business’s overall success. ... View more

I need a way to integrate Facebook Ads + Airtable + pabbly . to get the image hash. for you to understand, every ad has an image, and this image has a hash code image, which is unique to it.. and it is a record of facebook itself. I need this to be able to replicate camapnhar easily. I found this code from this article, maybe it can help https://stackoverflow.com/questions/60424092/way-to-get-image-url-from-the-image-hash-id-of-a-facebook-ad ... View more