Comics database

I have started working on a comics database since i have a large collection of them. The books template doesn’t work for me since this is different from how comics work.

I made 4 tables
image

Comic = Comic
Uitgever = Publisher
Serie = Series (I think :grinning:)
Personages = Characters

Comic has the following structure

I have text fields for year, a unique id and remarks. I have also added a file field for adding an image of the front cover.

Uitgeverij has the following structure

Serie has the following structure

Personages has the following structure

The only formula i have used is this one
count(field(“Comic”))

It shows me in different tables, in how many comics the character appears, how many comics i have of a certain series, how many comics i have from a certain publisher.

When i am adding content it feels ok like i made it. Maybe some of you would have done it differently.

2 Likes

Hey @Peter! Nice, it seems that you have a large collection of comics :heart_eyes:
How many of them do you have in general?

It indeed works differently if you keep track of comics in comparison to books, so that’s right that you created your custom database. And thanks for sharing it here! We might have some comics enthusiasts in the community, and they can use your tables as references:)

2 Likes

I didn’t count them but i guess a couple of hundred at least. :grinning:

2 Likes

Whoa, that’s a lot! You can count them directly in Baserow using footer aggregations, for example:)

1 Like

You mean like this. Nice feature. Never used them until now.

image

image

2 Likes

Yeah, this feature is a bit hidden, we should make it more visible :sweat_smile:

2 Likes

Nice, Peter :raised_hands:

You’re right about book the book writing template being different from how you might archive/organize comics.

Gonna add this idea for future template releases. Thanks for the inspiration! :thought_balloon:

3 Likes