Automations

HII've got my slack automation working really well for notification, but the link to access the record goes to the last VIEW in the Table I use or the person used in Airtable I can't seem to get it to go to a specific view that has only specific fields showing for that record.How can I make this work so the reviewer doesn't have to go through all the fields that are not relevant to their task. 

Hi Community 🙂Is it possible to make an Automation - send Slack message if 'anything changes anywhere in the whole base', not just in one Table? Or I have to make Automation for every Table separately?Thank you all

Hi there, would like to get help on the followingI would like to create an "I'm interested" button and redirect to WhatsApp. However the text message I wish to customise it according to the field they selected above. This is the link format I used: "https://wa.me/60392128545?text=Hi%20Chup,%20I'm%20interested%20in%20licensing%20for%20the%20location%20of%2"{Location Name}" Error: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text. I would like my viewers to hit the button and send a WhatsApp message of "Hi Chup, I'm interested in licensing for the location of [Location Name Field]

In an email automation, I am trying to populate the "From" and "reply to" fields from a user card (see attached screenshot). However, when I preview the message, both fields are blank even though the field has a user card that is associated with both a name and an email. Is it possible to populate the "from" and "reply to" fields in this way?

Hello - Is it possible to add a signature card image (see attached) from my computer to an email in an automation? 

I am trying to create an automated email with inserted % fields. However the percentage is not showing up correctly.For example, the % for the record is 55.50% and it is showing as 0.55% in the email.I've attached screenshots of the Automation Email, Email Preview and the actual Record. Thanks!

Hello, I'm trying to create a new record in my base every time a new row is added to a google sheet. However, when I try to configure the Automation I don't have the option to select the fields I want to add (Title, Brand, Supplier, Cost) but instead it shows me "Product" and "Detail" that are in the headers in first row of the google sheet.Any way to solve for this?Thanks! ProductDetails TitleBrandSupplierCostPantsXTBD$4.00ShirtTXYZ$5.00

Hey Y'all!I'm struggling to figure out how to do the following and would love some help!I've built a base that tracks registered and onboarded people in a "People" table. "Registered" and "Onboarded" are options in a single select field. The end result of what I'm trying to build is a simple graph that has day on the X axis and a record count on the Y axis. I want to have daily snapshots of total number of registered and onboarded people as my Y Axis. I want to automate this somehow. I think I should make a new table with dates as the primary field and then one field that is the total registered people for the day and another field that is total onboarded people for the day.But how can I automate this so I don't have to check and update daily?I figured automation would work, but the options are so limited with a time as a trigger.I'm thinking I might need a script that runs daily?Can someone help me out here? Thank you!-Taylor

I have a time tracker table and a time tracker rollup table.I have a Formula in the Time Tracker Table which Concatenate({Department},"-",{Week #},"-",{Employee}).So the output becomes: Logistics-35-John DoeIn this Time Tracker table, I have a Duration time based on a (Start Date/Time) and (End Date/Time). I have two automations.- 1. When a new record is created take Formula Column and enter the output into the Linked Column cell.- 2. When a record is edited take Formula Column and enter the output into the Linked Column cell.The process that occured, was that an employee uses a form and enters their department, time, and start/end time. When the record is created the formula then creates the data entry (e.g.: Logistics-35-John Doe). The automation would then take the formula and enter it into the linked cell. The linked cell would then populate the linked cell which was a single row (Logistics-35-John Doe).Lastly I had a rollup to aggregate the linked cell duration time. So

Hello. I have data that is in 2 separate sheets on my Airtable and the common reference is the vendor ID.I want to link the column Vendor ID on the Data Page to get information available on the Cost Center Information page when I click on the Vendor ID in the Data Page.On the Cost Center Information page there are multiple cost centers for a single vendor ID in many cases.I tried to link the Vendor ID column to Cost Center Information page but it is only picking up the first line having a cost center.Can I get some help on how I can do this?

I set up an actionable message so that when copy needs to be reviewed my client can either approve or reject the design. But when they go to submit their answer, Airtable requires them to log in to AT to answer. My client has no use for AT it is purely my workflow system.Id there a way to get around this issue or does AT need to make an update?

I am running an automation that:reads a set of logics from a tablefor each logic (repeat for each > logics list) executes a script that does some calculationsI want to add a trigger that in the final "repeat for each" loop, a script updates a record in a table so that I know that the whole automation has been executed and can trigger the next one. I can write a script and input the length of the logics list but I am not sure how I can keep track of the current loop number (through a counter or variable?).

Hello! I'm trying to create a button in a table that when I press it, moves the whole record to another table within the same base and, AFTER THAT, deletes the record from the original base. I'm using an API Token. Also, both tables have exactly the same columns, in the same order.However, I'm stuck with how to retrieve the record ID of the row where the button pressed is.Could someone help out with the script? This is what I have so far: // Airtable's API token and base information const API_TOKEN = 'aaaaaaaaaaaaaaaaaaaaaaaa'; const BASE_ID = 'appaaaaaaaaaaaaaaa'; const SOURCE_TABLE_NAME = 'Table1'; const DESTINATION_TABLE_NAME = 'Table2'; // Get the current record ID using input.recordAsync input.recordAsync('Select a record to move and delete').then((record) => { const recordId = record.id; moveAndDeleteRecord(recordId); }); // Function to move and delete a record async function moveAndDeleteRecord(recordId) { try { // Step 1: Get the record data co

What can cause an Automation to trigger that is not shown in the revision history,  the automation does not use a view, just watches 3 fields that as far as I can see are not changing.Any pointers on what to look for appreciated.Note that the revision history on the left is for the record that triggered the Automation on the right.Paul  

I have a new automation that is supposed to send an email every week to show the status of each persons projects. In my test "run as configured" the emails send successfully with no issues. But in practice when they try to fire at the scheduled time it fails with the error message "The email was rejected by the mail provider". We have several Airtable automations running daily and Gmail doesn't "reject" any of those. I cant understand whats different about this one or why it works in the test run but not in reality.

So, I have created a booking system exactly like this How to make a simple booking system with Airtable! - YouTube , but I want to make an automation whenever the form is submitted, it will create a new event on Outlook. The problem is, the video doesn't show how can I automatically get the meeting end date & time, so I have a trouble at the automation configuration, since I have tried many several ways like doing formula to add on the date but it keeps giving me error, I have done various things as well but the automation does not show the meeting end date and time, instead they give me the options for length, value or record ID which does not make sense at all.Any idea on how I can approach this to work? I need it asap... if it's possible 😞 

Hi, My script below functions to auto generate meeting time slot dates for my team. However, the time generated does not reflect the time zone I hoped for, i.e., Australia/Perth, UTC+8. In my data view, my "Time Slot" column is a "Date" set up as below.Could anyone help me to identify what needs to be amended in my script?Greatly appreciate any help here.Thanks,Eve

Hello! Is there a way to create a notification (using the color function) highlighting an expiration date in my Airtable to alert me five months before an asset expires?

I tried copying a script from the extensions section and using it in a script for an automation.Safe to say it did not work and gave me multiple errors.What would be the easiest way to transfer the code from one to another? @kuovonne Script:let config = input.config({title: '📎 Convert attachments to URLs',description: 'Output comma-separated URLs for all attachments and write to another field for each record. Can be used for sending URLs to third-party integration services.',items: [input.config.table('Links and Tools', {label: 'Links and Tools',description: 'Select a table with records that have attachments you want URLs for',}),input.config.field('Attachment', {label: 'Attachment field from the selected table',parentTable: 'Links and Tools',description: 'Select the attachment field from the table above you want URLs for'}),input.config.view('Grid view', {label: 'View from the selected table',parentTable: 'Links and Tools',}),input.config.field('Attachment URL', {lab

Hello, greetings to all!I am looking for a solution for my table, I hope you can help me.I need to create a button with a Script, and this button should change a single select and in turn fill a text field.It is for an inventory, I need to know the item where it is located, with the single select I have the different warehouses, and the text box is a comment about its location.Do you think this is possible?I am very new to airtable, I started using it a month ago.I try to create a great Workspare to present to my superiors and request an upgrade and thus be able to work the entire company with this wonderful APP.Thank you very much in advance

Hi,I need some help auto creating weekly calendar entries a few weeks in advance.Currently my automation is set to create 8 calendar entries every Sunday, which shows on a Calendar view for one of my tables. For instance, if my automation ran on 9/3, it would create 8 entries on 9/3.Ideally, what I would like for my automation to do is to create the calendar entries 2-4 weeks in advance so if my automation ran on 9/3, it would create the entries for 9/10 and 9/17. Thanks in advance for any help!

HelloI have an automation in grid mode (so I can select records). I want to create a Google Sheet of those records.How do I Find Records based on those selected? The google sheets bit I can do.

TLDR: I'm trying to mark employees as "OOO" if they are OOO for 3 or more days of the week (vs if they are only OOO for 1-2 days of the week they still show up as available). I have a system set up where I have created an "open space" record for every week and previously I had it set up so if the employee was OOO for any part of the week (even if it was just one day) the open space record will show up in red as "unavailable". But I want to adjust that to only showing up as unavailable if they are gone for more than 3 days of the week.I have created fields in my table that shows all the days of each record,  so for the Open Space records it lists out all 5 days of the week vs for any OOO records it lists out all of the OOO days.I'm looking for a formula that compares the two. When the person is only OOO for one day, the formula below works great (as you see for my 12/1/2023 example) IF(FIND({[Prototype] Daily Dates 🧮 🏳️}, {[Prototype] Daily OOO 🧮 &#127987

I am not sure what I am doing wrong. When I use the script I have written on the scripting extension I get the desired output, however when I put that same script into an automation, the output is all wrong.Is there something I am missing?

Hi AT Community,For a project I am doing resesarch on record templates. I was wondering if Airtable has any limitations on how many new records can be created at once when using a task template table to insert new tasks once a project has entered a table with certain column conditions.So, there is a project table where a new record will be created with certain columns. A combination of columns will set of an automation that will trigger the creation of new records in a task table, based on a task template. I currently have 90 tasks related to a certain project label, which need to bo copied from the task template table to the task table (the projects are pretty standardized regarding tasks). Is this possible in Airtable, or are there any limitations on how many records can be created at once through an automation?Looking forward to your reply, thanks in advance.Regards,Arjen