I'm looking for some inputs on how to organize the data efficiently. I'm building a multi-family building and have multiple different vendors like engineering reports, carpenters, drywallers etc.we have more than 20+ different types of vendors and for every trade, we try to get at least 3-5 quotes.
this is getting out of hands very quickly and we often times miss data from the emails with so many quotes to go through. I'm looking to put all of this data into airtable to sort out easily. for example, if someone asks me to compare all the quotes for a structural engineer, I should be able to tell quickly what i have received instead of going through all the emails.
would really appreciate if someone could point me to any existing templates or if anyone is already doing this.