I’ll sure try to explain it better. By Planning I mean scheduling, this was a translation carelessness late last night as English is my second language :).
So this is a base where we create a schedule for a specific scenario that lasts for a specific period of time. Each “plan” contains numerous lines (between 5 and 50).
We have a few tables with various different datapoints that I use to pull together in the schedule table (planning table) and one of the tables has information on price for each item (pricing table), where each item is a part of a few different groups, that could be used to categorize them, each and every one (in the example above I used the categories size, color and decoration, for ease of explanation).
I’m trying to keep the example simple while what I’m trying to solve is fairly complex, hence the example of a tall, blue, decorated mug. The selections in this scheduling entry of tall, blue and decorated all come from different tables with further information each (they really need to be in different tables).
The pricing table has all the combinations available, as outlined in a simplified form above, but in the scheduling/planning table the selectors are decided upon at each time, yielding numerous different combinations for each “plan”.
I’m looking for a massive time-saver and error-relief for a project that yields at least 20,000 records/yr, where my staff of two have been entering the selectors and the prices manually in an excelsheet, pulling in information and data from different systems and information points each time.
It saves time if they don’t have to look up the price each time they make a selection and it really is an error relief in so many different ways, to have this db driven rather than manual excel driven.
I hope this better explains what I’m aiming for, as I really, really hope Airtable will help me solve this.