Backup Steem Posts in Airtable! #13

secret 13.png

When we invest hours writing posts for Steem, does it seem wise to take a minute to keep a copy of our work in case it is lost? Definitely! What is the easiest way to do that? Using Airtable to save each post into an entry on a spreadsheet is the fastest and most accessible way I know of to keep a copy of all my posts here!

I Love Airtable!


Thank you very much to my friend @jordanarsenault who invited me a few months ago to join online spreadsheet service Airtable which has made backing up everything I do, collaborating on posts, and syncing my work on multiple computers WAY easier than using Microsoft Excel! I already wrote a couple of posts about Airtable previously which you might enjoy if you want the long version:

  1. Best Microsoft Excel Alternative in 2017 is Airtable at https://steemit.com/technology/@jerrybanfield/best-microsoft-excel-alternative-in-2017-is-airtable.
  2. My YouTube Video to Steem Post Creation Process at https://steemit.com/tutorial/@jerrybanfield/my-youtube-video-to-steem-post-creation-process

This short post features just how I use Airtable to quickly back up every post I make here including this one! If you would like to join Airtable, would you please accept my invitation at https://airtable.com/invite/r/qGLfO5Yn because I get a $10 credit on my bill if you use my link?

Setup Spreadsheet


To backup posts, a very simple two step process makes it easy! First, format a spreadsheet in Airtable for Steem with the following columns with each row equaling a post!

  1. Name for the title of the post.
  2. Post for the text of the post.
  3. Tags for the tags on the post.
  4. Thumbnail or Images for either the first image or for all the images on a post.
  5. Link to the finished post.
  6. Date because this will allow for filtering all completed posts to make space to focus on new posts and ideas!

Here is what mine looks like grouped by date for me to easily browse! Note that I took the filter off to show all my posts. Normally I only see unpublished posts.

jerrybanfield airtable steem.jpg

Copy and Paste!


Before I make posts, I have everything copied and pasted into Airtable in case the post does not go through. While the browser correctly keeps a draft sometimes on days where DDOS attacks or missed blocks cause a lag in making a post or a failure for the post to go through, other times the browser wipes the entire post. Thankfully so far every Steem post I have written has either went through and/or been backed up prior to submission with Airtable and all I had to do was copy and paste it in and try again.

Learning Airtable


While it might seem a little painful to take the time to learn a new system instead of using Microsoft Word or Excel, what rocks about Airtable is the mobile app and availability on any device or computer! Want to write a post and have it ready for eSteem when on the road? Airtable makes it easy to copy and paste a post written on a desktop and delivered through eSteem! Have a great idea on the road but no time to write? Put the title into Airtable and then write the post at home!

Free!


Yes everything I just shared here is totally free! I used Airtable for months without needing to pay anything and finally just paid because I love it so much and want to give back along with having a longer revision history and bigger attachment size! I easily could keep using it free for years if I wanted to!

Since I started using Airtable I now have integrated what once was a very sloppy collaboration, recording keeping, and backup system into one smooth interface which I hope is useful for you to discover here!

Are Shorter Posts Better?


Do you prefer shorter posts along with the longer ones? My steemsecrets series of posts are generally shorter in response to requests to not always write a novel in every post! I hope this thirteenth Steem secret is easy to start using and helpful for avoiding any of the problems coming from not having each post backed up!

Love,
Jerry Banfield

Stay updated via email?

Shared on

PS: Would you please make a vote for jerrybanfield as a witness or set jerrybanfield as a proxy to handle all witness votes at https://steemit.com/~witnesses because as a top 20 witness I am pledging 80% of my earnings (~$200 a day) towards ads for Steem on Facebook and Google! Thank you to the 1361 accounts voting for me as a witness, the 718M VESTS assigned from users trusting me to make all witness votes by setting me as proxy, and @followbtcnews for making these .gif images!

Vote Jerry Banfield Steem Witness Rank 29

OR

Set JerryBanfield proxy

Sort:  

Got to do it. I lost this *post when I push it through and it was the DDOS attack. It was funny I didn't know why so I sent it through esteem. Better be safe than sorry.
Airtable here I come

Wow, this is epic😱I Was just checking out a YouTube video about bitcoins last Saturday(7-9-2017, I have also attached the video

This triggered my interests and went on searching about bitcoins and I found steemit.com.I thought of trying it and created an account in steemit . Today(10-9-2017) I got my account approved and started reading more about steemit and I can across a video that you made and gave a nice
explanation about steemit .I'm have also attached the time I'm watching right now where you said about commenting
and had to see it for myself! So I'm posting a comment on your recent video. Sorry, I hadn't read your post yet. I'll definitely read it once, I'm done watching the video.Thank you so much for the explanation.

Hey @jerrybanfield thanks I missed two time my post not properly posted due to congestion in network.
Thank you buddy.
Follow me @oodeyaa

@jerrybanfield, Yes backing things UP is so Important. I recently had my computer Hard Drive on my laptop go down after a little over 6 years. I did have a lot of it backed up to an external hard drive. Once again you reminded me Jerry why it is so important that we back things up. I actually have some Crypto Currencies that are in a MEW (My Ether Wallet) and if I take the time to go through my backup I am pretty sure I will find my Private Key to retrieve them or at least I hope so. Relax and Take it all One Day at a Time.........

Excelente postagem @jerrybanfield você sempre traz bons conteúdos com postagens incríveis parabéns

Backing up posts is a great idea.
I should do that.
What I would really like is an easy way to access the posts that I've already made on steemit.
Thanks for the suggestion.

Awesome idea, I make a copy in my PC but it's not so good idea for having lots of folders here just occupying space. This is an easy perfect way.
Gonna check out those videos carefully. Thanks for this.

I'm very interest with your post @jerrybanfield
Can I ask you officially to be the team re-post with using my language, Bahasa Indonesia?
I think it will be make benefit for you and of course for Indonesian Steemit Community

Its Nice Post Since No One Having Knowledge About It.
Thanks,

Backing up your post is very good idea. thanks buddy

Coin Marketplace

STEEM 0.19
TRX 0.13
JST 0.030
BTC 62811.99
ETH 3447.80
USDT 1.00
SBD 2.51