Automations

Hi!I want to send invite for event and I want to track who RSVP. How do I build base or connection? I am thinking weebhook. So every member gets email with the specific webhook (record id), but where (in which table) do I put it?These are my tables: Members/Events/SpeakersHow can i send email to every member with a link (webhook), that when the member click on "i am going" button in email, I can see the list of all who clicked either "i am going" or "i am not going".I already created webhook in make and I added it in AT and customeyed it with record ID.https://hook.eu2.make.com...' & "?Record=" & RECORD_ID()I put this field in Members table.Then I create automation:Trigger: if the date of event is 1 week before today - in table Events1st action is find records - in table Members (so that i can send emails to them)2nd action in send email with webhook. and here my problem accour. I can only select "list of "webhook") in the email, because webhook field is in the members table).

Hey All, I am stuck trying to change a ROLLUP % field into a string so that it can be displayed in an automated GoogleDoc. At the moment when I try to create a string it fails to display anything in GoogleDoc tests, just shows a blank space. In the automation plain I can select the field without a problem. The ROLLUP % I am trying to turn into a string is a summary of one of the criteria in our survey → the roll up field is called “CourseDesign%” IF(values, (AVERAGE(values) / 5)) My attempt at creating a string is: IF(LEN(CONCATENATE({CourseDesign%}))>0,CONCATENATE((ROUND({CourseDesign%}*100))&“%”)) Any assistance appreciated! Thanks :slightly_smiling_face:

I have a list of “Hire Days” in a table. Each record has a bunch of information including the assets being used on that hire day, the staff member and the Day (as in Date) of that hire day.  When a ‘new record’ is created, it want it to trigger an automation. The automation will be a script that compares the day and the asset of the new hire day record. If there is already a record with the same day AND same asset, I want the script to produce “Clash”, otherwise “No Clash”. Can anyone help me?

I think this is a new issue, but now when I try to return an array (as a list) from an Automation, the value is empty. If I convert it to a string, it returns the string value (see code and output below).The array looks ok in console.log(). It’s just a series of ID numbers.   

I'm building an inventory system and I want to link products across different categories. I tried using linked records, but I'm not sure it's the best approach. Does anyone have tips or alternatives?

i have been working on some new automations and i just ran into an issue that i haven’t seen before. existing automations that (i assumed) have been working fine are not displaying correctly. they are showing what looks to be a Record ID instead of the field. and when i try to edit the conditions, it errors out. i reached out to support, but who knows if i will hear back from them.any ideas? 

I have a situation just arise in the last hour. In Script, when I use the select control to get a field from a Find action, instead of returning the Field Name, it returns the Field ID. The selection process seems normal, and I see the field name and the value in the picker, but it returns the field ID instead, which does not work. It’s happening in several places. I’ve tried shutting down and opening again and creating a new automation, but I can no long select fields. Any thoughts?    

I am trying to set up an employee scheduling table. The table has links to my events table and to my employee table. The events have a "Start date" and "end date". Is there a way to create new records in the scheduling table pulled from events in the events table for each date in the start to end range? Ideally it would have all the event info in each day of the range. Employees are scheduled for full days so i wont need times, i would just like the ability to be able to add employees to each day of the event. Thank you for any help!

Since the updates Airtable has implemented in the last week or so, I am having an issue when trying to run certain automations.Mainly I notice this with my Generating PDF script automations (integrated with Documint).I will set to Generate and the automation used to take 10-15 sec at most to generate the Documint PDF and paste into my attachment field, then update any other fields. We have several of these set up across bases that all operate without errors.As you can see in the screenshot below, the automation is taking a long time to trigger and usually I see the below as ‘You edited this record in 2mins’ rather than ...min agoI’ve also been having an issue with running the automation again and again on the same record - for testing and adjustments, and the automation not running at all. In these cases automation history log will show (correctly) that it ran exactly the time I clicked the trigger, but the action doesn’t occur in the record or revision history.Maybe this is something

I have an Automation that updates a Multi-Select field in a different table. When the update occurs it over writes what is currently in that field. Each name has a different color. I want to augment, or add to the existing data in the Multi-Select field not over-write it. Not sure how to approach the problem within Automation. For Example, a field of user names, each name is in a color bubble separated with a space. Initially the field is updated with the name “John”. A second update to the field with the name of “Tom”. The resultI was expecting is : “John Tom”, or “John, Tom” each name in a different color bubble, but what I get is “Tom” and an empty color bubble. Any suggestions.

Hello, I copied a database from another account, it worked perfectly (almost), the forms followed well, but the automations did not follow... and that was the most important thing for me. Did I make a mistake?

Hello - I have a event data table ( nested in a event base) where I have list of potential events where my clients could participate. One of the column in the table is year column where I have a added a field agent to check the year the event is happening by routing the field agent to the event website cell.  So the field agent goes to the event website and check the year of the event and outputs that in the year column. I want the field agent to go back to the event website on a regular basis to keep checking for the year. Because the year column is connected to a secondary trigger automation where multiple field agents goes to the event website and collates the details about the event (Description, Target audience, topics discussed and others) For the year, when the field agent checks the website today, it might be still 2025 but tomorrow the website might have been to the subsequent year which is 2026.  So the question is is there a way to automate the regular event website checks. 

Hello, I've built my site and linked my forms from the backend and captured in AirTable perfectly. This forms contain data from buyers/sellers landlord/renters(property field), I want to know if Omni can assist me in creating a matching feature so I can link buy-sell or landlord-renter requests that come in with certain perimeters which then matches and creates a new set of data, that i can follow up with. Is this possible?

I wanted to find out from the Airtable Community - is anyone using Airtable to send *Scheduled* emails? If so, then I’d like to know how you do it, and how timely the emails are. Over the last couple of years, I remember hearing on these forums that Airtable doesn’t update very regularly… and that if I say send it at 5:00pm Airtable might send it at 4:45pm or 5:15pm, or even a day late. Is that still the case, or can I send scheduled emails that are sent at the correct time yet?  To be clear, for my use case, it doesn’t have to be exactly on the minute for me. I am at a nonprofit that’s just trying to simplify our systems to have a lower technical learning curve. It’s up to 150 emails a week for appointments. I want to simplify these workflows so I don’t have to use Make or Zapier to send *Scheduled* emails.  I would be glad to use Airtable AI (Omni or Field Agents) to do this as well, but first I wanted to check with the community to see about Scheduling specifically. TIA! ML 

I’m confused at why this is so difficult to figure out. I want a record created automatically once a month in a table via automation with start and due dates filled out. You can’t add formulas to automation fields so that’s a no go. My workaround is that I’ve created a ‘creation date’ field that is filled in by the automation’s ‘expected trigger time’. That create date field is then used to fill in a start date and due date formula field using the DATEADD function with some math. My problem with this method is that I’m not able to change dates independent of each other if I need some flexibility and the only way to adjust dates is by adjusting the ‘creation date’ date field. Having due dates populate based on the date the automation was fired off seems simple enough but I can’t really figure out the best way to do this. Any input would be great!

My AirTable implementation deals with scheduling and staffing of courses for a university. We have a table for Professors, a table for Courses, and a table for Offerings which marries the two together with each record representing a single staffed course-section that students will ultimately be able to register for.Of note: currently our professors do not have AirTable access. Having them create accounts is currently not an option, unfortunately. Additionally, our plan does not include AirTable Portals.When we initially link professors to offerings, we need to send emails to have the professor accept or decline the position. We currently intend to do this via a Fillout form that will allow them to edit a single select field with accept/decline as the options (the “Accepted?” field below). Our issue is with the fact that professors teach several offerings every term, so sending one email for every offering would be cumbersome. Instead, we want to find a way to send a single email to eac

Hello Airtable Community,If you’re looking for a way to integrate Airtable with Notion, I’ve created a beginner-friendly tutorial that walks you through syncing your Airtable data directly into Notion using an API-based approach.🔗 Step-by-step guide: Import Airtable data into Notion This Notion + Airtable integration tutorial covers: How to get your Airtable API token How to build a request URL to fetch your Airtable records How to sync data into your Notion database automatically It's perfect if you're trying to centralize your Airtable workflows in Notion without manual copy-pasting.Let me know if you have any questions. 

Hi Make.com was able to create this But I can not see on my side airtable What am I doing wrong why can I not see what that see when test?regards Linda 

My AirTable project deals with scheduling and staffing courses for a University. We have a table of Professors, a table of Courses, and a table of Offerings which marries the other two to create staffed course-sections students can ultimately eventually sign up for.Of note: our professors do not have AirTable access, and having them sign up is out of the question unfortunately. Additionally, we do not have AirTable Portals on our plan currently.When we assign professors their share of offerings to teach, we wish to send out a confirmation email where the professor can accept, decline, or comment on a specific offering they are assigned. This will likely be achieved using a Fillout form.Professors are assigned several offerings in a given term, so we do not wish to send them one email per offering they are linked to. Instead, we would like to send a single email that regards every offering they are attached to. This email should then have multiple links to the forms to accept/decline ea

Hello,having configured an actionable slack message, the error message marks that I don't have the permissions to edit the record when I click on the button.However, I have the impression that I have configured everything correctly.Maybe the screenshots can help...

How would I go about exporting multiple page designer layouts as images into an attachment field? -Could I use or create a script to do it? -Is there any free Airtable apps that allow this? I provide more visual context in the link below:

 Good day.  I’m looking to add or rather hard code the time 6:00am as shown int the automation field below: How might I go about doing this?  Currently it brings in the date, but it changes a bit.  For example it’s specified as 7/21/2025, however what it changes it to is 7/20/2025 5:00pm  Here’s the automation:Would there be some way to “tack” on the hard coded time 6am or would I have to create yet another field to do that?  Eventually this will be used in a Workato Recipe, and they’re more buggy. Thanks!

Hey all.I have a table that has a “status” or “level” for users.  The idea is to have the formula update an unique status/level with the year, e.g.,CONCATENATE(Select," - ",YEAR)SO what I’d need is Gold 2024, Gold 2025, and then when the year with a formulat: (YEAR(TODAY()) updates, we’ll have 2026 and so on.Unfortunately, with a formula right now, 2024 cannot be created.  Perhaps an Automation that updates this based on year(today()) ? Any ideas?

Hi all, I want to create a Table 1 with a list of tags and use it to create a matchmaking system that works across other tables.So whenever I add a tag to Table 1 it would automatically appear as a tag option in different multiselect columns in other tables. Is it possible? How can I use the same tag system across several columns? 

Hello,We are using the “Phone SlackID” field in Airtable and passing its value into the body of a message using the “Slack Send a message” action in an Automation to send mentions.In the “Phone SlackID” field, we’ve set each user’s display name in the format @last.first, and it has been working correctly for almost all users.However, after one staff member changed their display name, they no longer receive mentions. Specifically, @last.first now appears as plain text.Could you please advise us on how to resolve this issue?