Unique part number database

Baserow Help
,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

I am trying to recreate a part number database that was in Filemaker.

We have a two digit module code which consists of 30 modules, a single digit code to track if it is a part or assembly, a two digit code identifying the year it was created and then a 4 digit number that increases by one for each part number created.

When the year changes the 4 digit code would reset and go back to 0000

I have figured out how to create each of the items and concat them together to get what I want. The two areas I cannot figure out is how to increment the 4 digit Number code each time I take a new part number with the module code I am using and then reset it when the year changes.

Any suggestions would be helpful.

Please attach screenshots or videos if they help illustrate your question.

2025-09-02_10-49-02.png
2025-09-02_10-49-02.png1934×1382 294 KB

2

Hi @gtrzcianka, welcome to the community!

Unfortunately, Baserow just can’t do this well right now. The formula system can’t count other rows or automatically update counters. So you end up needing complicated workarounds with multiple tables or manual work or outside tools like n8n/Zapier/Make.

We are working on adding our own native automation features that should fix this problem but that won’t be ready for a few months.

I know this isn’t the answer you were hoping for. What you’re trying to do is totally reasonable and should be built into the system. Hopefully we can fulfill this use case soon!

3

Is this possible now with Baserow 2.0?