Database assisted allocation problems


#1

You have by far the best database offering IMO. However, what I really need to justify the move away from a spreadsheet is the ability to use data from one database along with some calculations to try and solve an allocation problem.

Eg. I have a set of assets that have various characteristics. I get a request for an asset of a particular type. With a spreadsheet on Google Sheets I can select that request and my assets get scored according to their suitability for this particular request. Then display that list and choose from it to allocate an asset.

An ability to do that within Airtable or via an easily linked platform would be essential to any spreadsheet replacement database.

Thanks!