Jan 14, 2021 09:23 AM
I’m trying to figure out the best way to organize my contracts and their extensions.
Company A has Contract Alpha and Contract Beta.
Initially, Contract Alpha was to be complete on 1/30/2021, but Company A has chosen to extend their contract to end on 2/10/2021. The extension to the Alpha contract will have a different PO number, budget, etc. so they will have different ‘internal codes’ that we use to track the progress, deliverables, timeline, etc.
What I’m looking for/trying to figure out:
The best way to have the contract extensions be set up like a contract and subcontract(s) relationship so that they are ‘nested’ somewhat like this, but in Airtable form:
Ideally, the end result would probably be most beneficial if it were displayed using one of the apps (Gantt, maybe?).
I’m at a loss and would appreciate any suggestions/directions.
Jan 14, 2021 09:58 AM
So I imagine a 3-table setup being the best starting place for you:
Terms could be labeled with a “Type” as either “Original” or “Extension”.
This should be workable with the Gantt Chart, I think.
Here’s a quick and dirty example:
Jan 14, 2021 09:59 AM
Hi @Marisa_Pettit1 - suggestion for the base structure here is:
Something like this:
Your PO, budget details might, in fact, be against the contract period (although this depends upon how you set up your contracts)
Jan 14, 2021 10:01 AM
Haha! These two solutions are so close, it must be the right answer :winking_face:
Jan 14, 2021 10:01 AM
lol… glad to know I’m in good company with the way I approached this problem :winking_face:
Jan 14, 2021 10:18 AM
I’m thumbs-upping every message in this thread.
Jan 14, 2021 11:17 AM
Thank you so much! I’m about to try this out and will let you all know how it goes.
Jan 15, 2021 10:40 AM
So, I’ve made some progress, but I’m now thinking that maybe the Gantt app isn’t the best route to go. Thoughts?
I think in an ideal situation the outcome would be similar to the Org Chart maybe, so that the hierarchy is clearly evident. If I’m on the right track with that line of thinking, the original contract would be at the top and then the extensions of the contract would fall underneath. If so, then how should I set up the self-linking linked record field to make this manageable? Or do you have suggestions on a different/better approach?
Jan 15, 2021 11:09 AM
If you are wanting to carry on discussion about how best to structure your data, can you give more detail about what you want to see and why?
I ask because creating same-table references for contracts in order to use an Org Chart style hierarchy is a very different data structure than using the
Contract << Terms setup suggested by @JonathanBowen and myself.
It’s understandable that the Gantt chart app itself may not fit your needs, since it’s likely meant to be used with shorter time scales than, say, a year per “chunk”.
But I’m not sure exactly what your vision is for the functionality and who needs to view this data, for what purpose they need to view it, and what they need to be able to do with the data in addition to viewing it. That may make a difference in terms of what “App” might be the best choice, if any is needed at all. Often, just a good Grouping or nested Grouping in a Grid view is sufficient:
Can you give us more detail about what you need to see, how you want to input data, how you want to interact, or how you need others to see/interact with your base?