Automations

Hi, I have a few separate tables, one with contacts where each contact is assigned to a group say A, B, C. I also have another list of messages which are sent to different combinations of people say a message is just sent to group A, another is sent to group B and C and so on. How can I create a new table which lists all the messages to be sent? Essentially where each row has the contact details + message to be sent to them so I can link this to the Twilio integration to send out? Thanks,

I’m having issues with formatting emails. Seems as if there is no way to remove the large spacing between every row. I’m sure I’m missing something. Any help is welcome, Thank you!

With the Webclipper itself, I have not had much success with grabbing an image from google images by mapping it through copying the selector. Regarding “why”, is beyond my current understanding, however, I assume it has to do with how many variables procedurally exist within a search engine like Google. I could be wrong which is why I am asking the community. I already have a formula that can build the URL that searches Google, but now I would like to find a way to scrape the first image off in order to populate my sheet. And preferably set up a button on each record that activates the webclipper for me, but hey. I’m a visionary, what can I say? Any insights or work arounds (even if not perfect) gratefully accepted! Thanks!

Here’s my use case. I have admin tables that I control and users have user tables that they can see their private CRM information on. No users should be able to see other users private CRM info, but the collects data and users can copy it into their own tables, thereby getting a headstart by the admin. Admin Tables: Properties (“PTable”) Admin Companies (“ACompanies”) Admin Contacts (“AContacts”) Users (“UTable”) User Tables: Users here can add additional fields the admin is not collecting, such as private phone numbers, emails, notes, etc User Companies (“UCompanies”) User Contacts (“UContacts”) On the Admin there is: ACompanies Table - Record 1 Name: Acme Corporation Properties: linked relationship to PTable to 123 Main St, and 456 Main St Contacts: linked relationship to AContacts table to Joe Smo, Jonny Smo, and Anna Smo

I have a Facebook automation that has stopped working after running fine for several months. When I re-tested each step, I noticed an issue with the Create post action. I was unable to test it even though it seems to be set up correctly (Screenshot 1). When I tried re-connecting the service I received an error message (Screenshot 2). Finally, I deleted it and tried creating a new one, but the Create post action is still generating the error. I realize this is probably a Facebook issue, but I’m curious if anyone else has run into it .

hey there, so I’ve set up an automation to combine typeform single attachments from several attachment fields to put into 1 field by mapping the url of the additional attachments. The automation tests fine, but in practice, I could only ever get 1 source field to 1 destination field. I could never get multiple source fields to 1 multiple attachment destination field. (I’ve tried different separators to no avail. The mapping seems like it should be easy to set up…) There’s the miniExtensions for doing this, but I was hoping for an alternative that doesn’t require their pricey subscription at $39/month for just this one automation. Thanks in advance!

Hello All, I am trying to create two separate automations for my table. One automation is for contacts that have confirmed they are the right people the automation needs to go to. The other automation is for people who have not confirmed they are the right point of contact yet. Some of these contacts are in communication and a point person hasn’t been confirmed yet. I was trying to set my automations to trigger when matching certain conditions, so I am having to use both ‘and’ and ‘or’ options under conditions. However, once I select “and” or “or” the rest of my conditions are automatically turned to whatever I choose first. In other words, I am unable to apply both “and” and “or” together when setting up conditions. I would love some guidance on resolving this.

Hi! I am not finding a similar topic, or the answer I need. I have about 20 fields that will be populated, then reviewed periodically. Each time they are reviewed, the values have the potential to be changed. If they are changed, someone else needs to review the changes. They do not need to review all of the other fields for a record. I thus need an easy way to call out the changed fields: If field “a” changed, show a big UPDATE! notification in field “a-update.” Previously, I’ve built out 20 formula fields to do this, but that required having field “a original,” field “a new” and then field “a-update (formula)” which was IF(“a original”!=“a new”, UPDATE!). The new table isn’t set up this way- we’re not always going to show the old version AND I really really don’t want to keep building out 20 formulas. What I’d love to do is an automation that populates field “a-update” with UPDATE!, and I’d like to do one automation that covers all of my fiel

Hey Airtable community, I am having trouble with this automation script that extracts images from URLs. The URL field name is Pictures URL and the new field is Pictures. But, it keep coming back with this error: Error: Field “fldzkNbXJlvQonpO3” cannot accept the provided value. at main on line 54 let submissionsTable = base.getTable(‘Linkedin profiles’); let urlField = submissionsTable.getField(‘Pictures URL’); let attachmentField = submissionsTable.getField(‘Pictures URL’); let submissionsQuery = await submissionsTable.selectRecordsAsync(); let updates = ; for (let record of submissionsQuery.records) { let url = record.getCellValue(urlField); let attachments = record.getCellValue(attachmentField); // If this record already has an attachment, skip it. if (attachments !== null) { continue; } // Otherwise, attach the image at the URL. updates.pus

Hi, Apologies for posting such a basic question but I’ve read and tried but just can’t figure this out. My requirement is simple. When a new record is created, I need to have an automation that sets a dropdown field to a value. The field is called “Review” and the value need to be set to ‘needs review’. Here is a screenshot of where I’ve got to so far but not sure what I’m meant to add in the fields section? Can someone help? Thanks

Hello all, Is there a way in automation to set the trigger based on a date in a field? I’m trying to set Airtable to send a message to Slack when a Date in a field is due. Thanks

I am using Airtable to schedule a lobby day with 115 legislators and 100 advocates. I currently have two tables, one for tracking the legislator meetings (“Meetings” table) and the other for tracking the advocates (“Advocates” table). There are multiple links between the two. For example, when I schedule a meeting with a legislator, I use a column that links to the Advocates table to add the attendees for that meeting. I wish to send two types of emails: Email 1 to the legislators including the following columns from Airtable: (a) time (b) meeting link (c) listing the advocate names (from second table via linked field) (d) attaching several documents (uploaded to Airtable) QUESTION 1: Last year I did this through sendgrid’s app and it went to spam for most of the offices. Is there a better way of doing this through integromat or sendgrid directly that is less likely to go to spam and actually attach

Hello everyone! How could I mimic an action of copying-pasting string value into the linked field with an automation script? Here is what I mean: Here I can easily copy the value of a string field “task 4” and paste it into linked field “Linked Tasks”. Actually, I paste into this field the property “name” of the object So, how could I reference this property in a script? await table.updateRecordAsync(rec, { "Linked Tasks": [{ name: rec.getCellValueAsString("Manually Entered Tasks") }] }) This assignment doesn’t work, but I stuck finding correct way. Any suggestion is much appreciated.

In our base, users can trigger an automation via a checkbox. When the box is checked, the automation creates a linked record in a different table and populates the fields with various text, form links, etc. The problem is if a user does the following we get duplicate linked records: checks the box…waits until the automation finishes unchecks the box rechecks the box, now for a second time How can we either prevent a duplicate linked record from being generated, can the automation check if a linked record exists before proceeding? Or is there a better trigger we can use that is one-directional, meaning it can only create the linked records once? I was able to do this with a button + scripting app, however they are not usable in Interfaces which is where we’re applying this functionality.

Hi! Is it possible to create an approval from the form → gallery view automation? we want to embed airtable gallery view in our website. people can submit a form but we want to review the submission first before adding it in the embedded gallery view. workflow should be something like this: submitted form → notify admin to review answers, disapprove/approve for the info to be added in the airtable gallery/grid view → to be added or not in the gallery/grid view, and to have a archive of disapproved submission** Thank you so much. appreciate your help!

Hi! I’ve just started using Airtable, and I had a question about using an automation to change something. Right now, I would like for my completion date field to change to the current date/time once the state field is changed to “done”, but the only trigger that is there in the automation menu would trigger regardless of what the state has changed to. Would there be a way to do this with automations or would I have to find an alternate way to execute this?

I want an email automation to scheduled for at Noon PST timezone. I am based in IST, so when I set up the automation it is set up for IST. How do I specify the timezone for the receiver’s timezone? I don’t see any setup in the automations config. Do I need to have a different field to just get that specific time?

Hello My automations fail, because it says that I don’t have the right billing plan. I only had run 4 tests, so even the in the free plan it should have worked. I upgraded to plus and I still get this error: Can somebody help me?

Thank you so very much for your kind help!! I’m hours deep into trying to figure this out and feel like I’m stranded on a raft in the middle of the ocean with no land in sight. Here’s my head-scratcher… In one base, we have 4 tables. The first 4 cells in every record are identical across all 4 tables. After that, the field types and data changes for the remainder of the record. (We do production, so it’s the same 4 product details for each record on every table, and the different tables break down tasks for the same product at its 4 different phases of development.) What I want to happen is that on the first table, when I enter new data in the first 4 cells, that same data is automated to magically appear on the next 3 tables. The reasons I’m going mildly nut

How do I get this stored somewhere else? either in a CSV or a base? We basically need this in a tabular format because it lists down the things we need for auditing cost and permission. collaborator current level of permission which base are they accessing I saw this article and yes I know there’s a view but this is just barely usable, we need a table format to audit and make filters. we need to create reports from it not a static view. Airtable Support

I have a table where I want an email per record to be sent when a record matches conditions. For example: Contact Email is NOT Blank and Check Box 1 is Checked and Check Box 2 is Checked and Contacted is Empty The Actions are: Send an Email and Update the record with a Check in the Empty. However, the automation only ran for the test record out of the 15 records matching the criteria.

I’m receiving a error requesting the page be refreshed whenever I try to “create a new record” from a Webhook. Refreshing the page does not fix the issue. Has only else experienced this and is there solve? Thanks!

I’m building a content marketing tracker and I’d like to be able to add an analytics and reporting status which automatically triggers 30 days after a piece of content is marked as published. What would be the best way to handle this in an automation?

Hello I am trying to find a way to assign the collaborator field in order - Like a TRUE round-robin We are currently running an automation where status is “Status A” and the Collaborator field is empty THEN - run this script (below) and update the record. const collaborators = [ {name: "Person 1"}, {name: "Person 2"}, {name: "Person 3"}, {name: "Person 4"}, {name: "Person 5"} ] const chosenOne = collaborators[Math.floor(Math.random() * collaborators.length)]; output.set("chosenOne", chosenOne.name) This automation runs randomly - I need an automation that will assign 1,2,3,4,5 in order and then repeat that order.

Hello Friends! Has anyone been able to use Airtable’s “native” Microsoft Teams Automation integration? I’m not sure if it is worth the time trying to get it to work. I tried about 18 months ago with no success and am considering looking at it again. I don’t see any evidence of anyone using it on the forums, but my searches aren’t nearly as advanced as Bill’s :stuck_out_tongue: Thank you for any thoughts! Paul Warren