Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
Self-hosted
What do you need help with?
Hi, I’m setting up a database in Baserow to track filament inventory and usage history. The setup includes:
1. Filament Inventory (Main Table) - Each record represents a spool of filament.
2. Filament Used (Related Table) - Each record logs when filament is used, including the amount.
Since one inventory spool can have multiple usage records, I set up a Link to Table field to connect them. The issue is:
• When adding a usage record for a new spool, I see previously linked usage records from other inventory items, even though they should only be linked to their respective spool.
• I tried using “Limit selection to view,” but the dropdown doesn’t show my filtered view, or it doesn’t apply when selecting linked records.
Is there a way to enforce a true one-to-many relationship where each inventory record only shows its own related usage records and prevents incorrect links?
Any guidance would be appreciated! Thanks.
A question for a better understanding: in which table did you set up the Link to Table field? In the “Inventory” or the “Usage” Table?
And the behavior of “seeing previously records” relates to the pop up window of Baserow that appears when you add a new record within the Link to Table field - is that right?
The Base table is called inventory. The important fields for this discussion is the amount of filament remaining. So every time the filament is used, I would like to link to the table called “used”
And the used table I enter how much filament was used on this particular 3-D print. That value is then subtracted from the total which is stored back in the inventory base table
The problem is when I click on the link in the base table. It opens up the used table just fine, but it shows all of the records that are in the used table. Ideally, there should be a way to just display a simple data entry screen for the few fields just needed, but that’s may be asking for too much
The important part is, it should only display the rows that are associated with the base inventory record
I am the only one that’s probably going to be using this so I could be careful but if I screw up, then it messes up all of the inventory
I hope that makes more sense? It should be a one to many relationship, but it doesn’t look like I’m able to set that up using this app
Two ideas on that:
a) have you thought of the option to enter the ‘used’ data directly in the ‘used’ table (and not in the ‘inventory’)? There you have a fresh empty row to enter your data and you should see also a Link-to-table field (link to ‘Inventory’) and there you could link to the filament that you’ve used for that printing.
b) you could try to generate a “view” in the ‘used’-table that shows no record (let’s name it “empty”). Set up a filter to that view that results in no entries to be found. Back in the ‘Inventor’-table you can edit your link-to-table field to “view only” and select the “empty”-view. So that way the pop-up from Baserow shows no entries but the option to enter a new data (to the linked ‘used’ table).
I’m not a Baserow pro. But as far as I understood the Link-to-table field is always a many-to-many relation and you can’t change that. It often makes sense to have it that way but I understood for your use case this is more confusing but helpful.
a) I think this would be more prone to errors because I would be picking from a long list of records to link to. As it is now, I start on the record and from their progress to be used table, so the relationship is already created.
b) they don’t seem to have a way to specify a field. It does have a way to specify a view, but that doesn’t seem to do anything.
So I guess for now I’ll just muddle through it. I don’t have hundreds of records per day so it’s really no big deal. I guess I just have to be careful. I’m glad this is not for some end user because it would never work