May 17, 2023 01:56 AM
I want to build a content plan for social media according to dates.
I have several tables for each platform:
3. Tik Tok
4. Email marketing.
In each such table I have the topic (story, post, etc.), the upload date, the content itself and status.
I also want to have a master table that will actually contain date, status, comments and also contain a Facebook, Instagram, Tiktok and email marketing column (linked columns).
I want the main column in the master to be the date and actually when I write a certain date it knew to pull me to my linked columns what needs to be uploaded each day according to each platform.
For example, I will choose the date 05/18/2023 - it will automatically fill in the Facebook column what needs to be uploaded that day, in the Instagram column what needs to be uploaded that day, etc.
I tried to automate it but I'm completely lost 😞
In addition, I want to create an automation that will know that if the tasks of that day have been marked "DONE" through a table of each platform - it will also know to mark me the status of that date in a master table where all the tasks are "DONE" in "DONE" automatically.
I really appreciate the help!
May 17, 2023 02:07 AM
The best way to do this would be to NOT have separate tables. Combine everything into ONE table and use different VIEWS to separate by platform.
I discuss VIEWS at length in my Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/
May 17, 2023 03:09 AM
can't i build it like that?
i want to have each table for a platform and one master table
May 17, 2023 03:11 AM
sorry for the language
here it is update in English -
May 17, 2023 03:42 AM
Okay, so I tried to put everything in the same table and divided it according to different VIEWS, but as you can see, it splits the dates for me if on a certain day I have both a post that I need to upload and a story/release for example.
May 21, 2023 09:00 AM
The generally way this is designed is that you have a date column separate from the Primary field. The Primary field would likely be a formula that is a combo of Social Media Account+Post Type+Date. The field with the Date would likely be a simple date field. You could then create a calendar view that shows everything on that date.
Alternatively, you could keep all the Social Media accounts on one tab but create a separate Dates table. You would turn the date tab above into a linked record field. I think that's similar to what you were trying to do in the beginning? If so, it's still best to combine all the Social Media tabs into one table that you could link to.
May 23, 2023 07:32 AM
To create your content plan, you can start by setting up a master table with columns for date, status, comments, and different platforms like Facebook, Instagram, TikTok, and email marketing. Linking the columns will allow you to pull the relevant information automatically. For each specific date, you can use formulas or functions to populate the corresponding content in the linked columns. This way, when you choose a date like 05/18/2023, it will show you what needs to be uploaded on Facebook, Instagram, TikTok, and email marketing for that day. If you're looking to boost your engagement, you might want to consider getting cheap TikTok likes. Remember, take it step by step, and don't hesitate to ask for help along the way.