How to create a dynamic website using data from your spreadsheet

A step-by-step guide on how to start with Tabledo

If you like to see a video tutorial we have recorded it http://tabledo.com/video-tutorial.

1. As a start point go to a signup page https://app.tabledo.com/auth/signup and create an account.

2. Now you can create your first website. Name it and get a subdomain — yourwebsite.tabledo.com. You will be able to connect your own domain later.

A step-by-step guide on how to start with Tabledo

 

3. Choose a template for the website.

A step-by-step guide on how to start with Tabledo

 

4. At this step, you need to connect your data from a spreadsheet. In the beta version, Tabledo can be connected to Fieldbook only. It’s a service to create simple databases, as easily as spreadsheets. We picked this service, because of awesome features like images and file attachments, simple API etc.

 

5. If you already use Fieldbook, skip this point. If it’s new for you take a look at the introduction video and screenshots we made. After the signup, you will be able to import your spreadsheet into Fieldbook, or you can start from scratch. Take a look at a database we made with the service to create Fastnomad project https://fieldbook.com/books/58b091f0e9f98d0300230abe. Feel free to copy or create your own structure.

A step-by-step guide on how to start with Tabledo

A step-by-step guide on how to start with Tabledo

 

6. OK, Fieldbook is connected. Choose a book and a list with data you want to use for the website. You can reconnect and change it later.

A step-by-step guide on how to start with Tabledo

 

7. Welcome to the screen when you can play with your data!

A step-by-step guide on how to start with Tabledo

 

8. Take a look at a group of buttons. You can use them to «Publish» or «Preview» your website, to «Edit Fieldbook» connection and «Sync data».

A step-by-step guide on how to start with Tabledo

 

9. Let’s edit the template. As we use a «2 column template with images» we need to choose an images column first.

A step-by-step guide on how to start with Tabledo

 

10. Now we can add fields to show data in. There are four types of the field:

  • «title» to show H1 title;
  • «many objects» to combine data from different columns into one row;
  • «button» to show a button link;
  • «link» to show a text link;
  • more types of the field coming soon.

A step-by-step guide on how to start with Tabledo

A step-by-step guide on how to start with Tabledo

 

11. Now hit «Publish» and «Preview» the website you made. Here is a link to my project http://fastnomad.tabledo.com.

12. Let’s get back to the app. There is an «About» tab where you can add a page to the website.

A step-by-step guide on how to start with Tabledo

 

13. There is also a «Settings» tab where you can:

  • write a «Title» to the website;
  • write a «Description»;
  • add a «Google Analytics ID» to track visitors;
  • add a «MailChimp form action URL» to show a subscription form. Read how to get it;
  • choose «Items order» to show items from your database: «Ascending» or «Descending»;
  • place custom code to «Header» or «Footer» of your website;
  • choose a «Color sheme».

A step-by-step guide on how to start with Tabledo

 

14. Save everything by hitting «Publish» button and «Preview» again.

15. The last important thing you might be interested in is «Sync data» functionality. When you edit or add data in Fieldbook, go to Tabledo and hit «Sync data» button to update everything on the website.

That’s all for now. Drop me a line at vas@tabledo.com if you need any help or want to share your feedback.