Create a Brand Assets Manager

Day 27 of 100DaysofNoCode

Max Haining
|
38 steps
|
4 minutes

Baserow

Sign into your dashboard at [Baserow.](https://baserow.io/?utm_source=newsletter&utm_medium=email&utm_campaign=100daysofnocode)

Click "**Create new**".

Select "**From template**".

Search and select the "**Brand Assets Manager**" template (within Content Marketing).

Click "**Use this template**".

Click "**Brand Assets Manager**" on your dashboard once the template has loaded (this might take a minute or so).

On the left-hand side of the page you'll see all the tables that are included within this database. Take a moment to scroll through the tables and look at all the various fields and how they're configured.\ \ This is a great brand asset database template, but let's say that we also want to add a table that includes all of our brand *templates* in one place. That's what you're going to do next!\ \ Click '**+ Create table**'.

Name this table '**Template'** and click "**Add table**".

By default, this table includes three fields. \ \ Edit the last field in the table so that is shows the date the template was last update.\ \ Click the button to open the field settings.

Click "**Edit field**"

Change the name of the field to '**Date Updated**'.\ \ Now **click the drop-down menu for the field format.**

Select the '**Date**' format.

Click "**Save**".

Now we're going to change the second field in the table to show the person that created the template.\ \ This is where you can see how relational database functionality works. \ \ You're going to connect this field to the 'Creator' table that already exists within the database.\ \ **Select the field settings menu.**

Click "**Edit field**".

Change the field name to '**Creator**'.\ \ Click the drop-down menu for the field types.

Click "**Link to table**".

Click the drop-down menu and select '**Creators**' as the table to link to.

Click "**Save**".

Now you're going to configure the first field in this table to include unique brand templates.\ \ Select the field settings menu for the first field.

Click "**Edit field**".

Call this field '**Template**'.\ \ Select the drop-down menu for field types.

Select '**File**'.

Click "**Save**".

Now enter some dummy information into this table so you can see how it works.\ \ First, you'll notice that when you click inside the 'Template' field, you're prompted to upload a file.\ \ Upload a dummy file from your device (you can use anything as this is just for demonstration purposes, and you can delete it later).

Select your file.

Click "**Upload**".

You'll see that your brand template can now be accessed directly from this table.

Now it's time to see the power of relational databases. \ \ In the 'Creator' field, click the button to assign a creator to this template.

The pop-up window that appears will now show the '**Creators**' table in your database. \ \ Select any of the creators.

You'll see that you've now linked one table to another in your database via the '**Creator**' field.

Now complete this row of data by selecting a date for the 'Date Updated' field.

Repeat steps 25-32 to enter two more rows of dummy data. This is just so that you can get a feel for how this might work in the real world.\ \ You should end up with something that looks like this.

Another way to get a feel for how the relational database works is by clicking into a '**Creator**' record.

Scroll down and you'll see that the record for the creator has now also been updated with the templates that you've assigned to them.

Finally, select the '**Creators**' table within your database.

Scroll right, and you'll find a new field has been added within the 'Creator' table for '**Templates**'. This is because of the previous you link you made between your 'Templates' table and your 'Creators' table!

Congrats, that wraps up today's lesson.\ \ You've built a brand asset manager AND learned about relational databases in the process.