Table of Contents
Do not index
Do not index
In this lesson you’re going to learn how to create a database that can be used to build a 100DaysofNoCode journal.
You’ll create a database, learn how to edit fields in this database, and you’ll create a form that’ll make daily journal entries a breeze.
Let’s build! 🤓
Task for the day 📝
🧱 Project: How to build a simple journal database with no-code
⏲️ Estimated time: 30 minutes
🛠️ Tools: Baserow
Context building 🏔
Being able to track and visualise the progress you make on the 100DaysOfNoCode challenge can be super helpful for keeping your motivation high and giving you a place to store your thoughts, ideas and reflections as you work your way through the challenge.
That's why in this lesson you’re going to create your very own digital journal!
Not only should the exercise of creating a journal be useful for your journey, but in this lesson you’ll start to get hands-on with databases.
Understanding how no-code database platforms such as Baserow work is a fantastic digital skill to have in your arsenal. Databases are fundamental to the operation of so many of the platforms, tools and integrations that we use daily.
Though database terminology differs slightly depending on the platform you're using, the fundamental benefits and ways in which databases operate are the same across all platforms.
This video from IBM details some of the benefits of databases and different types of databases that can be deployed: https://youtu.be/hRulZhTtUTg?si=jsan15OmjDGb9Usm
In this lesson you’ll learn…
- How to create a workspace and database in Baserow
- How to edit and add new database fields for your journal
- How to use forms to make your journal entries even more accessible
Let's prep 🥗
You don't need to understand database terminology to complete this lesson, but it might help to get familiar with the hierarchy of how databases are created and managed in Baserow before you get started:
Workspaces - this is where you can organise all of your work in Baserow at the highest level. For example, if you had two business that you were going to create databases for, it would be good practice to have seperate workspaces for these two businesses.
Database - a structured collection of data, organised within tables. In this lesson, we’ll just be working within one database.
Table - this is where your data is stored. Different types of data can be added to a table. The default view of data in Baserow is in a Grid, with rows and columns.
Fields - you can also think of these as columns within a table. They are useful for categorising the data you want to store. Fields can be customised so you that can store data in lots of different formats and view data in a range of useful ways.
🔥 Get ready to build!
To make your life easier when you build, it’s good to get some practical stuff out the way first. Follow these steps so you’re ready to build:
- Create an account with Baserow
Time to cook 👩🍳
Follow the steps below to build…
- Create your account with Baserow.
- Follow this step-by-step guide to create your journal.
That’s a wrap, we hope you found this lesson helpful!
- If you have any questions, feel free to reach out.
- Want to learn NoCode? Join #100DaysOfNoCode for free.
- Want to learn AI skills? Join #100DaysOfAI for free.
Written by
