Spare parts stock database with app - is it doable?

Baserow Help
1

Hi there,

This looks exciting - thank you to the people who make this for us all to benefit from!

I am thinking of installing this on PikaPods, and I’d like to create a few databases for stock parts we use at work, like one for electrical, another for plumbing, etc.

I’d also like for there to be some sort of front end so that our engineers can scan a barcode / QR or enter manually when parts are used / replenished and (in an ideal world), notifications sent when items are low in stock.

Maybe I am asking too much here, but is this do-able? I am happy to learn but just looking for something that will get me up and running a bit quicker than learning php and MySQL!

Thanks, guys!
Nick.

2

Hey @spa_nick, you definitely can build a database with Baserow to keep track of your stock items. Here’s an example of the Car Dealership Inventory database we have: Car Dealership Inventory.

You can also build a frontend using Baserow’s new Application Builder, but we don’t have support for barcodes or QR codes yet. Maybe you, @frederikdc, have built something similar before and have a good workaround?

For this, you will need to use an automation tool like n8n.

Hope it helps!

1 Like
3

Hi Olga,

This is great news and thank you very much for getting back to me. The QR/barcode thing would be a nice option but the main things I need are the database and front end.

I think I’ll just install Baserow and dive in, since I am a learn-by-doing type!

Thanks once again for your very helpful post and I’m sure I’ll be posting lots more here.

All the best,
Nick.

1 Like
4

Yes, in the very first template I’ve created for Baserow :slight_smile:

It is about Equipment Management and there is a button in the Assets table that automatically generates a QR code for each item.

The QR code is generated by referring to https://api.qrserver.com/v1/create-qr-code/?data=[enter your data]&size=[enter your size like 100x100].

You can store this URL in your database and use that same URL of the source of an image element in the App builder.

1 Like
5

I think you’ll be very impressed with Baserow and how easy it makes developing tooling like what you’re after and the community here is usually very good at resolving any issues you may have along the way!

1 Like
6

Thanks, @frederikdc, this looks extremely useful!

I’d like to add this to my database, so how would I best do that please?

All the best,
Nick.

7

Very impressed so far and especially with the community here that seems very friendly and extremely helpful, yourself included!

All the best,
Nick.

8

You can add a formula field that uses the concat() function to concatenate multiple parts of static and dynamic text. For example: if the unique code of a part is in a field named Code, the formula looks like this:
concat('http://api.qrserver.com/v1/create-qr-code/?data=',field('Code'),'&size=100x100')

You can refer to the generated url from the app builder, but you also can make it clickable from within the database by wrapping your existing formula with the tourl() function.
tourl(concat('http://api.qrserver.com/v1/create-qr-code/?data=',field('Code'),'&size=100x100'))

9

Hello @frederikdc,

Many thanks for this very helpful explanation.

So, in your Equipment Management template you linked to earlier, I can see by inspecting the formula that you’re using the Barcode as the unique number with which to generate your QR from.

So, without the barcodes at hand or for items without barcodes, can I use something similar to, say, =RANDBETWEEN(1,6) as you would in a spreadsheet to add a random number in this field? Or maybe you have a better idea? (EDIT: maybe a UUID?)

Thank you for helping me to get something together that works!

@olgatrykush, I took a look at the Application builder last night and I was blown away! It looks amazing and I even created my first couple of pages :slight_smile:

All the best,
Nick.

1 Like
10

Sure, you can create an UUID field that assign a unique code to each item in your inventory. And refer to that field when constructing the bar code.

1 Like