My company is trying to get our various departments to keep track of inventory via airtable. This is not inventory to be sold, but more things like office supplies, furniture, etc. that is stored and used within each department and can also be transferred and used by other departments. We are thinking of each department having their own base listing their inventory that then can be viewed by other departments so they can see how much of what item is available at any given time. I am wondering if there is a way to set it up so a user can see an item they want from another departments base, click on it, and then message the posting department directly via airtable? If so, would this require creating some type of code for each individual item listed on each department's base and become overly time consuming to set up? I messaged airtable but they basically said they could not answer this question and that I should ask the community. I am very new to this system and am not sure of many of the features it offers. Any help is appreciated. Thanks!
... View more