We have product information (food industry) in Airtable and often need to contact vendors to clarify information, get updates, etc. I want to be able to email a question to the vendor and allow them to answer in a way that will import to their base (each has their own base). It’s cumbersome keeping track of the status and answers doing this separately in Gmail. So far I’ve:
- Set up a pending/complete field so we can flag the records that need answers
- Created a “Question” field and an “Answer” field
- Determined a few other fields (such as product name, UPC, etc) that should be included in the email.
Is there a way that I can limit them to only editing the “Answer” field?
Is it better to create a table for this function in each base or to create an “Email Launcher” base and link it to all the vendor bases, (then be able to select the base we want to execute from)?
I don’t want to automate the sending of the emails, just to have a solid mechanism to handle the communications.
All suggestions appreciated!