Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

1 Base or 3 bases for restaurant

Solved
Jump to Solution
113 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello

Can someone give me an advice?
Sorry, but my english is not great to explain everything as I want.

For a restaurant, I have recipes, with ingredients, and they came for vendors.

What is best? 3 bases linked, or just 1 base with everyting?

The 3 bases, that look logical to me, are: recipes, inventory, and vendors.

  • recipes, with photo and calcs to estimate costs
  • inventory, to track ingredients costs from different vendors, quantities in stock, and reorders
  • vendors, where I can see their ingredients, with their contacts, and track the payments

Ingredients is the only thing that must equal in all the 3 bases.

But I never did any base, so maybe I’m thinking wrong.

Thanks in advance

1 Solution

Accepted Solutions

Hi @frank_laureano ,

Welcome to Airtable Community !

You’re English is good enough no worries :slightly_smiling_face:

The idea of 1 base or 3 bases all depends on the amount of data you have. I always recommend 1 base for everything. But if you think you will have more than 50K records (assuming you are on the Pro plan) then I would recommend 2 bases (not 3). One for recipes and inventory, one for Vendors (that you will sync to the other base)

See Solution in Thread

2 Replies 2

Hi @frank_laureano ,

Welcome to Airtable Community !

You’re English is good enough no worries :slightly_smiling_face:

The idea of 1 base or 3 bases all depends on the amount of data you have. I always recommend 1 base for everything. But if you think you will have more than 50K records (assuming you are on the Pro plan) then I would recommend 2 bases (not 3). One for recipes and inventory, one for Vendors (that you will sync to the other base)

Thanks

So I will try 1 base.
Time to study how to do that!