Nov 04, 2020 09:08 AM
Hi All,
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:
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!
TIA
Nov 09, 2020 08:04 AM
One of the ways to do this, is by sending them a URL for a form that allows them to update specific fields in a specific record in Airtable. You can do that with this extension that allows you to generate an ‘editing form’ for each record you have.
Nov 09, 2020 05:00 PM
Thanks, Moe.
I’ll take a deeper look tomorrow. It looks like you have quite a few solutions to offer.
Best,
Lynn