Help

Re: Send a general message to base collaborators

1787 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Megan_Bishop
6 - Interface Innovator
6 - Interface Innovator

Is there a way to use AirTable to send notes/messages/notifications to collaborators at a macro base level? I don’t want to message a collaborator about a specific record. I want to message the collaborator to go in and look at several tables in the base.

5 Replies 5

You could do this with an Automation that has two steps. The first step would be a very simple Run a script action using the following code:

const collaborators = base.activeCollaborators
output.set("collaboratorEmails", collaborators.map(collaborator => collaborator.email))

The second step would be a Send an email step that uses the output from the script as the value for the “to” field.

This might be above my pay grade, so to speak. I went to the scripting app, and I tried copying and pasting in the code you put in, and this is what happened when I clicked run script.
Screen Shot 2021-06-16 at 4.08.14 PM

The idea was to send the email through an Automation which includes a Run a script action. This is not the same thing as the “Scripting” app, which will not connect to or affect an Automation.

Hmmm, ok that’s what I thought you meant at first. But when I open up the automation section, I see this, and I don’t see a place to enter a script as a trigger.
Screen Shot 2021-06-16 at 4.03.06 PM

Running a script wouldn’t be a trigger. I suppose I should have asked: “When do you want to send a note to your collaborators?”

^ The answer to your question would be the trigger. If there is no schedule about it, and you only want to send it every now again with no relation to changes to data in your base, then its possible select any trigger and run the Automation manually.