Automations

Hello, I’ve created an automation to add records to a shared calendar. Everything seemed ok when I was testing it with dummy data on a test table, and indeed when I cut and paste the actual data back in to the real table, to recreate the records (about 100 of them) again, the automation also worked correctly, inputting the Outlook calendar Event ID onto every record bar the one on the top row (no worries, can live with that). However, since then, when adding new records, either manually, through a test form, or through Stacker (as intended), the automation fails to add the Event ID into the correct field, and thus fails to write it to the Outlook calendar. I’ve tried changing the trigger from “When record is created” to “When record enters view” and still no difference. I have no idea where I’m going wrong now… Have I hit a daily automation limit or something? Any pointers would be much appreciated; my app is riding on this last thing! Many thanks, Matt

Is there a way to set up a repeating email alert that is sent every day or every week as long as a record in a Base is not corrected by the collaborator? Drew

Hi everyone! We have started using Airtable for teaching and I’d like to have a mechanism that sends students their grades automatically each week. Each record would have information like the following in a table called ‘Grades’: ID: 1, Name: Anna, Email: abc@def.com, Grade HW1: 1, Grade HW2: 0. ID: 2, Name: Ben, Email: def@ghi.com, Grade HW1: 1, Grade HW2: 1. I want to send out an email each Monday to each student individually (they are for data protection reasons not allowed to see each others grades) that looks like this: Hi [Name], These are your current grades: HW1: [Grade HW1] HW2: [Grade HW2] Best, Ann What is the easiest way to do this? I have tried the “Find records” action in an automation with the “Send email” action but this gives me all field values instead of just those of a single row. I have started to look into scripts but I’ve only started to learn Javascript and am a bit lost. I’d appreciate any input! Thank you in advance, Ann P.S. An alternative solution could

I am trying to generate my table responses in a google sheet however I am finding when I submit a new entry it sometimes enters twice on sheets and when i go to edit an entry, it will add a new entry as opposed to altering the initial one. Any help on sorting this out will be appreciated!

I’m trying to set up an automation that will send a link to a teams channel, but the Markdown isn’t rendering in the message: Am I doing something wrong? Is this a known issue? Thanks for your help! Joel

I seem to be missing something simple, hopefully someone can help me out! I have an automation I am setting up. To put it simply, the automation should do: If 24 hours have passed since the last change (Based on “Last Submitted Change”, a last modified by field) Clear out the “Change Type” field (A single select dropdown field) The automation seems to work in test runs. However, in actual execution, it fails every time. I have entries where the last submitted change was made two weeks ago but nothing happens. Can someone either offer some insight as to what I’m doing wrong, or help me figure out how to set the automation up so that it functions?

I am trying to set up an event capacity automation (under when a record matches condition). Basically, for a set number of activities (Activities table), I have created individual events. One of the fields in this table is the set capacity number for the event (capacity number). Another field on the table is a linked field of the total number of registrants from the RSVP table on the base (Total RSVPs count). I have another field on the Activities table that is a single-select Open or Closed, which when toggled to open will allow that activity to be viewed on our embedded gallery of available activities for which to register. I want to set up an automation that triggers the Open/Closed field to be set to ‘Closed’ once the total RSVP number is equal to (or reached) the Capacity number field. In the automation configuration, I am able to select the Activities table, but I’d like to add the condition that WHEN → “RSVPs” (total count of RSVPs from RSVP table) = “Capacity” (maximum capacit

Hi Al! I use airtable to manage tasks for contractors, where they all have different preferences in how to be notified on work when we need it. I found a way to integrate Twilio for SMS, but did not find it available as an automation. Any ideas on best ways to automate sending texts to those that prefer it? What I am finding is it is giving me the option to send a text, but it send a text to everyone, where I just want it based on the new/updated record. Any ideas or insights would be helpful!

Hi, I need to set (yearly) reminders based on dates from a particular field. So, let’s say - I have “Hire Date” field that’s different for each employee, and I want to be email reminded each year on that particular date (let’s say hire date is 03/03/2021, so I want to be reminded tomorrow on 03/03/2022) to (e.g.) renew the contract. Also, is possible to be reminded X days before that particular date? Thank you

Hi, i have two forms named form A and form B in two different pages and on airtable when the webhook is received, i need to run a script to check whether the data is coming is either form A or form B( either by form name or by hidden field). Am new into this and am not able to run the script functionality using this. am confused about data fetching. Could anyone please help how to update script code to check conditionally which form is submitted when a webhook is received?

Trying to change a status on an item by an automation. Specifically; If 30 days has passed since last edit → Change status. Can someone please help?

I’ve read the community for how to get the harder-to-read date cleaned up for automation with emails that include that field. I made a new column that formats the date/time to MM/DD/YYY and it populates fine in the table. However, the emails show nothing of that date and just has the space blank in the email. Here’s the formula I have to set the date format: Any suggestions?

I want to write a script that copies the value from one field to another field in the same record. Trigger and condition are already set up. But I don’t get the script done. Automation trigger: When record enters view. (Done) Automation condition: When field ‘Album_curated’ is empty (Done) Action: Run script that does: Copy value from field ‘Created’ to field ‘Album_curated’

I have a table of records of my published works containing a Multiple Select column with the formats of those books. What I need is an automation that will create records in another table with the options from that format Multiple Selection column that are not selected. So if my multiple selections are ebook, paperback, and audio and I only select ebook, I want to automatically create a record that lists the audio and then a record that lists paperback to use as a task list. I’d appreciate any ideas because I’m stumped.

hi all, hoping someone can help me. When I create a new automation for when a form is submitted, I want it to update the states to Requested on the new record it creates. But after I configure the trigger details and test it, it connects somehow to an existing record, instead of a new one. So whenever someone fills out the form, it updates the same record over and over. Can someone let me know how to disconnect the form submission from the record? I want it to update the newly entered records instead. thanks so much!

How do i automate a PO number imported from excel , so that it automatically copies the same po number and links records cell ,

Hi Airtable! I wondered if you can take a quick look at these Integromat screenshots, regarding a basic update in Airtable? I have records with images from origin base, that I just want to add images only, to destination base. Watch records base ”Copy 3…” (origin base), to: “All records…” (destination base) The destination will have the records, but no images, so I just want to update the existing record, with an image. I created a view in the origin base, all images and the destination base, no images. Is this a good way to use views? Also, are my filters correct? I have attached some screenshots. I also have screenshots of the output from the modules. Mary

I have two separate tables… contact list (table A) and an interaction log (table B). I’m trying to get a ‘date’ field from table B to be auto populated to the respective contact name in Table A. I have it already set up to link the table B record to a field in table A, but I need the date added to a separate field so that I can use the calendar view… I was able to create the automation – when a record is created in Table B, the action is set to create record in table A. but I don’t want to create a new record in table A (just need it to update a record) HELP PLEASE

Hello Guys ! I’ve set up this script founded on this forum ! My goal is to input the company logo automatically when the user puts the website url. The problem is, when the website’s url isn’t recognized, the automation keeps running and running and consumes all the automations :frowning: What can I add to my script to stop the automation run after a minute for example (meaning that the website isn’t recognized) ? Here is the script : console.log(Hello, ${base.name}!); let table = base.getTable(‘Expériences’); let query = await table.selectRecordsAsync(); for (let record of query.records) { // if the attachment field is empty if(record.getCellValue(‘Logo’) == null && record.getCellValue(‘Site internet’) != null) { let recordId = await table.updateRecordAsync(record, { ‘Logo’: [ { url: ‘https://logo.clearbit.com/’+record.getCellValue('Site internet’)} ] }) } } Thank for the help Agathe

I was wondering if there is a way to autogenerate QR codes in Airtable? I know that there are apps that can generate multiple QR Codes, but you have to manually run them. Is there a way to make it so once you type in a link in one column, then in another column a QR code will automatically generate. I know this can be done in other 3rd party apps, but is there a free way to do this without a 3rd party app? I know that in Google Sheets, I can use a formula like this to automatically generate a QR Code in Column B from the URL that is in Column A: =image(“https://chart.googleapis.com/chart?cht=qr&chs=150x150&chl=”&A2) How can I adapt something like this to Airtable? Any help would be greatly appreciated! Thanks!

Hello! I have a list of podcasts for which I would like to import new episode records into a separate table. I have RSS feed URL’s for each podcast, and those are updated regularly when new episodes are released. I’ve run this through Zapier’s ‘New item in multiple feeds’ Zap, though you have to manually input each RSS URL and are limited to 10 feeds per Zap (I’ve got hundreds of pods). This can be tedious if you have a lot of podcasts. I would love to find a way to reference the RSS field automatically and import new items. I’ve heard that webhooks could help, but I’m not that familiar with how they work. I’d appreciate any input! Chris

It’s surprising to me that when you’re building a custom automation and want Airtable to update a picklist field as part of the automation, the automation builder doesn’t show the existing values in the picklist of the selected field. Seems odd that a native automation builder isn’t sophisticated enough to pull underlying values once the field is selected. Any thoughts on why this happens / more elegant solutions than just going back to the linked field and directly copying the picklist option text exactly?

How can I configure an automation to only run (or complete given n steps) if it hasn’t run within t hours or minutes? I have a couple automations that watch for various sporadic updates to tables in my base. On occasion, these updates happen close together and trigger more actions than needed by the users of the base.

I have an EVENTS table with an EVENT Date, I am trying to use automation to create a record in a Related TASK table that uses 1 week before the event Date as the Task Due Date, I thought perhaps I could use the EVENT Date-7 but that didn’t work. I don’t know what to put in the Task Due Date field in the Create Record automation. Any help would be appreciated.

I have a grid view “FIRE TASKS” that is SHOW RECORDS where Start Time is Within (2) The Next Number of Days I have automation that is WHEN Record enters view “FIRE TASKS” Update Record to Change Priority to “HIGHEST” Moving forward this works with all tasks, but when multiple tasks enter the view simultaneously, only the first record is updated. I’ve now set it up so that when the record has been updated it leaves the “FIRE TASKS” view. That seems to work? Unless to records enter view at the same time? Driving me nuts. How do I fix this?