Automations

I'm working with a Kanban view where we drag action items into Today/Tomorrow (single select) options. I'm currently assigning dates manually, but I'd like to automate this - so that when someone drags an item into the "today" pile, it automatically gets today's date. I don't think it should be a formula (because that would automatically change dates on items that have been done in the past), but I can't find a way to automatically assign a date dynamically (today's date) with an automation. (but there must be a way, right?)

I have created a script to delete  a record but it is giving me an error. Here is the code: console.log(`Hello, ${"300 Replens"}!`);let table = base.getTable("300 Replens")await table.deleteRecordAsync(input.config()['reckUma1c1NLjQADd']); Here is the log:CONSOLE.LOG"Hello, 300 Replens!"ERROR

Hi, I have a Make scenario setup, but it is not pulling through any data to Airtable. The Make scenario is attached and is very simple; it Watches for items in Podio and then Creates Records in Airtable. I have set up the link between accounts a few times to double-check that everything is working. I've continued to run the scenario, and it comes back with no errors or warnings, but when I refresh the Airtable page, no data is being pulled through. Any help would be greatly appreciated. 

I have two automations in question.  The last time they both ran successfully was September 26, 2023 at 4:43pm CDT, and now neither work as of today.I'm not sure if its some strange permissions thing or an internal limit? Or was there some sort of update that may have nullified some function that I was using?Both Automations concern making records, both revolve around the same main trigger (one actually waits to verify the first record is made before the second record is made).The first record automation just does not want to run it seems. as per the screen shot, it was working 2 days ago with no issues.When testing, first it said it lacked permissions, so I changed the receiving table's permissions to open.  Then it said it couldn't enter information into certain fields because it was a computed field (the table it would be making the reco

Hello, We are struggling to extract the first image of a column called "photos" then re-upload it in another column. We tried to do it by having a formula to extract the first attachment url (which is working) : (IF(BLANK(photos), "", MID(photos, FIND("(", photos) + 1, (FIND(")", photos) - 1) - (FIND("(", photos)))) Then, using the following automation to upload it in our target column "1st_photo" :=> WHEN a record match conditions "photos" isn't empty THEN update the column "1st_photo" using the url from the formula column as input. However, this automation isn't workingI guess the issue come from the attachment url. Do you have any idea to handle it ? Does it require a script ? Thank you very much ! 

Is it possible to create an Automation so an email send 2 days after record updated?

We're a real estate company looking to have Airtable Automations help us get client feedback on properties we present. Ideally, the process would look as follows: We add properties to an airtable base Once status is changed to "pending client feedback", an automated email sends the property information to the client. I'd love for that email to be able to solicit client feedback via button/checkbox/text field, for instance client received 123 Main St and did't like it they could have the option to "reject" (via button or form?) which would update the record in AirtableIf they liked the property, opt to "like" or "shortlist" the property which would update the record and trigger additional notifications to our team that the client wants to tour this site. 

I've seen great docs and help for this for MS Excel on Windows.. but MS has not released the Power Query Editor for Excel on Mac.  Has anyone successfully done this, using any hack or workaround? TIAGary Wong

Hello,I am stuck at automation and would highly appreciate help with the issue.I have the tables:Projects (linked to operations),Operations (linked to projects, stakeholders, products, accounts),Stakeholdersand Accounts. What I am trying to do:If you create a project, I want to create several rows in Operations table (with template) - one for revenue, several for fixed costs.But I want to input the Stakeholder and preferably product, when adding a new project.Scenario:1. Add project (project name, stakeholder)Projects Table:Project NameStakeholderTEST1X2. Template created one row for Revenue and several rows for fixed costs in Operations. What I want is to fill in the same stakeholder for Revenue ent

I am new to Airtable.  I have a base of speaking engagements.  I want to send an automated reminder to my boss when the engagement is 5, 3, and 1 day away.  I am able to get it to work the first time but I can't get it to know that the time is getting closer.   From what I read, DATETIME_DIFF used with NOW() doesn't update daily.  How to get this to work?

I have a base that I use for onboarding new users. New records are created via a fillout form. I want to create a linked record in my Agents & Staff table, as well as my phone directory table when a new record is created in onboarding. I know how to link to an existing record, but I am stuck on creating a new record and linking.

Hello you wonderful people! Small roadblock I've encountered that I am hoping someone can help with. I would like to use Airtable for our team to record meeting notes. When a new record is created in that table, it would be great to have some text pre-fill, much like in the manner default values can be assigned to some Field types. Since the default option (as far as I can tell) doesn't exist for Long Text Field type, I figured I would use an automation. I tried a simple test. I tried to get the automation to produce rich text entry, or even multiple linesEven using markdown, I was not able to get more than a single string of text to appear... ie it looks like this on my best efforts: **Action Items:** <br> * 1 <br> * 2 <br> * 3 The Goal is to have a

Hello, everyone,I'm trying to create a email off of the scheduled time trigger that gives the recipients a list of the current records in a view (aka for review). The records in the view have critical documents that I need in the email, but I am running into an issue where because I have to get the records from Find Records instead of triggering off of their appearance in the view, the attachments can't be added, even if I make the fields they would be in visible in the grid.If anyone has any recommendations, I would love to hear it as the individuals receiving these emails are not going to be active in the bases themselves.P.S. If anyone is curious, this is my current automation:Trigger: At Thursday at 11AM -> Find Records based on view (x) -> Send Email (Use grid with relevant information.) The grid contains the attachment fields relevant but always show as empty.

Hi everyone! I'm trying to create an automation that tracks data from two columns. We have a "planned publish date" and an "actual publish date." I'd like to have a way to track how frequently records are published within a week or so of the planned publish date. Is there a way to set up reporting in an interface for this? Or an automation that can compare the two dates and perform an action if they're within a certain timeframe to one another? I haven't tried writing my own script, but I'm open to that, as well as other suggestions. Thanks so much! 

Hello everybody ! I would like to set up an RFID card reader system for my fitness center that will be linked to a database. I would like to have the time when a customer scans their RFID card saved in the corresponding customer line and change his status from something like “Inactive” to “Active”. Can I do this with Airtable? I’m kind of a newbie :slightly_smiling_face: Thanks in advance !

Hi,I am looking for a way to make my 'Last Modified' column update when a look up field updates. I understand that this is not directly able to happen as it is not an editable field. But I was wondering if I could do this with automation? The look up field is a text box and could contain anything.

Hi all, I have automation setup to put notes in long text field when certain conditions met (and was proud of myself :winking_face: )…BUT when it triggers it removes and REPLACES any text that may already be there…just wanting to add additional text in that field…can that be done?

We have dozens of automations that I've built running in our paid plan. Troubleshooting an automation in a free plan, so I may be missing something obvious!- Automation Trigger - when form submitted. - Slack Action - send channel message with simple text with field data from the form. This was running for months with no issue, we edited the message field and the automation tests run successfully. we see the post appear in the correct slack channel BUT.. we can't get the Automation Toggle to stay on.  (It is on for one second, then reverts to off.)We're below the 100 automation limit for the Free plan, so not sure what else might be causing this.any suggestions?  

How do I update a record on a table, based on a record on another table that just got updated, it requires a record ID but the update record automation action only gives the record ID of the just updated record and not the ID of the target record

Hi and thank you for any help you can provide.I have created an automation so that when a record status is set (trigger = Pending), I get an email and Slack notification.I would like to know how to include record information in the notification. Right now, I'm just getting the message I typed in the Message field. Can I add record specifics there? I would like to see when the record was last modified, which in this case would be when it was set to Pending. I would also like to include other fields, such as the headline and writer.Thanks for your help.

I am creating an automation between airtable and slack, so when a record is created in a view in airtable it notifies a slack channel, and tags people based on another field - but I'm having a few issues!In the record we have today's date, the task type, details about the task, the scheduled date and the member of staff needing to be notified. If no staff member is mentioned, it notifies the channelI have the trigger set up as "When a record enters a view" and a delay totaling 116 seconds (multiple scripts one after another) with an action to find the record. In the run history this is complete, and it shows the fields and their content - however the slack notification is not including any of the fields in the message. Additionally, if 2 members of staff are tagged, it only actions the first one, then finishes the automation. Any help appreciated, some images attached

Hi there, I have several different views and I am getting the data pushed through Zapier. I need all the new leads to be showcased in the "new leads" view. Where can I set up rules so all leads will be here in 3-4 weeks or something like that? Thanks.

Hello everyone,I have a form from which i collect various data for my events. I am trying to create an automation to pull 2 parts of the form to put them in 2 new records in some other tables (Form -> Contact[table] and Company[table]).I was having no issue at all until I tried to pull the data of a single select field from my trigger record (the form) and use it as input for a single select field in the other table. It only gives me the possibility of choosing an option from the destination table an not from the trigger record. Also meaning, the blue button to choose which data to pull isn't appearing.Anybody had the same issue and/or have a solution for this subject matter ? I would really appreciate your help !Thank you all

Hello everyone,I need to insert the current date in a filed when a second field is updated (Yes or no) in the record updated.My need is that the first field is a "Date" because it could be modified inserting a different date in the case of any modification.I can not find any solution: automation with a button is too difficult for me (script) and automation does not the job for the record updating.Please can you help me? It seems so easy ... (I surely prefer Airtable but actually Spreadsheed does it in a minute). Best regards A. Borriero

Hi all,I am stumped on this, but I imagine it's something fairly straightforward.I want to run an automation that will copy data from one field (Copy-to-field) to another (Copy-from-field) but preserve the original data in the Copy-to-field.Note - the Copy-to-field is a look-up field.The trouble is, when the Copy-to-field contains data, it  is wiped by the new data from the Copy-from-field.I have tried adding the Copy-to-field as a data source in the Copy-to-field in the automation, along with the new data I want added but this throws up two problems:1. It combines the original data with the new data, rather than keeping them as separate entities as I need, which is important because this is a look up field (i.e. it creates a new combined record in the look-up table e.g. instead of 'Joe' and 'Bob' as two distinct entities, the entry jus