Automations

Hello!I am trying to create a master calendar from the different bases I've created in my workspace. I began with creating a master calendar base and syncing up the other bases table to this base. I created an automation that when a new record gets created in one of those synced base a new record gets created in the master calendar table. Now I'm running into the issue that when a record is updated in one of the bases it doesn't update in the master calendar. I'm at a roadblock and have been trying to figure this out for a while now. I'm also trying to see that when I link to a record it doesn't link to the synced base record but the actual record in the other base. I've attached screenshots of my base and automations. I'd love to hear any feedback or suggestions, it would be much appreciated!  Thank you in advance!! 

Hello everyoneI've been on Airtable for a while now and I've never had to do anything complicated, but I have a really epic task, as for me. I'd ask the community to help me and not to scold me too much for stupid questions).I have three tables: Docs, Lines and Items. Docs can have few lines. Line have one item and number field "quantity". Pressing new "Copy doc" button must copy the Doc record and create new lines, which have the same items and quantities, as they appears in the source doc. Theese new lines must be linked to the new doc.Is there any chance to do it without coding? Is there any chance to do it at all? 🙂 It must be..

I have a table that I use to calculate expenses for a specific project. I would like the SUM of one of the columns to automate/sync/roll up/whatever?? to another record/field that is located in a different BASE (for invoicing purposes). Can this be done? Thank you!

Hello Everyone,I would like to use Airtable to share order status with my teammates. Because the finished date or customers' requests often change, I need all members to follow up on the newest changed content.Though I can know when each project is changed by sorting the last modified time/date, it's still confusing because I cannot tell what contents are changed immediately. Sometimes it's an estimated finish date, sometimes it's the price, customer request, order number, etc.Is there any formula or tricks that help to create a view that sorts the data by the last changed date and at the same time, be able to see what columns are changed and old&new values? 

I have three tables: PROJECTS, ASSETS and PLACEMENTSIn both ASSETS and PLACEMENTS there is a field that links to PROJECTS, with the possibility of linking to multiple projects. They are called asset_projects and placement_projects respectively.I need any project added to or removed from asset_projects to be added or removed from asset_placements, but not the other way around. This is, adding or removing projects from placement_projects shall not affect asset_projects, resulting in an unidirectional synch between the two fields.I was wondering if there is a way to do that which does not involve the need to use a script and if a script needs to be used, I was wondering if anyone has ever created a similar script that I could recycle.Thank you  

E.g. I want an automation be triggered every Monday OR over webhook. 

Hello,I wish to carry out the following project:I have a table in Airtable named "Contenants" and another named "Collecte effectuée" ("Completed Collection" in English). In the "Contenants" table, all values are unique (there are no duplicates). I want to create an automation with the following trigger: when the "Collecte validée" ("Collection validated" in English) checkbox in the "Collecte effectuée" table is checked, it triggers a script. This script should allow me to filter the records in the "Contenants" table by only taking those whose "Numéro de collecte" ("Collection number" in English) cell value is equal to that of the "Numéro de collecte" cell of the "Collecte effectuée" table that I previously retrieved via an "input" variable.For all the records thus retrieved in the "Contenants" table, it will filter them according to the value in the "Statut" column ("Disponible" (Available), "Déposé" (Deposited), or "Collecté" (Collected)) in the "Contenants" table. For each status, th

My automation runs every Monday. It failed -> I made some edits. I want to trigger it manually. How do I do it?Re-running previously failed automation from the "history" seems to trigger an old version that fails. Thanks. 

I am currently working with a typeform that is used to gather information on families that want to register on our platform.This information dives straight into my Airtable, and I would like to use the learnings from these inputs to feed an LLM model on chatgpt in order to automatically generate a description of these families based on their answers and have it standardised (as you know people are usually very lazy when it comes to writing text in a survey). I would like to have this data come back to the airtable but I am not really sure how to structure it. I was wondering whether anyone would be able to help 

Hi guys,I'm looking to use Slack + Airtable + Chat GPT to do the following:When a post is written in a travel slack channel in natural language, e.g. John Johnson writes "I will be in Genoa with Steve Marshall on 23rd/24th Feb and travel to Singapore on the 26th to 4th March."That is sent to airtable (easy enough) but as structured data. Where Chat GPT is acting as the tool for structuring the data into columns such as "Location" "Date" "Client" "Other people visiting (that isn't the author)". I just wondered if anyone had any ideas how I might be able to do that? Thanks! 

Hi all, I'm looking to create a simple automation that sends an email when a project moves from one status (4.0) to another (5.0). I have people assigned to the project with a profile that includes their name and email (along with other info). I want the person assigned to that project to receive the email notification, however I'm not sure how to get the automation to find the email, as it is only finding the persons name at the moment. I'm new to Airtable and coding so I'm sure there's a semi-easy fix that I just don't know! Thanks!

i'm using Softr to build out a small GPT tool. At this point the user logs in and then they fill in the prompts to get GPT to do it's thing.The logged in users email does not show up in the corresponding airtable. How can I sync / automate it so that everytime that user submits the form, their email will show up in the airtable against the users form and answer.The reason I want to do this as it will allow my to use permission features on the user being only able to see their results. The image shows emails that were populated when they signed up (I know messy...), as well as when i made the user add their email in the form (not ideal) and I don't want this.  

Hello,I am running into a wall.I am trying to create an "update" automation.The Goal: When I update a single field inside a record I want the automation to update a corresponding field in another record. My Trigger - When a record is updatedRecord to watch "Current PM"Watch for updates in the field "Yearly Amount". My Action -  Update Record Update Record in table " PM Monthly Flow"Record ID - I have chosen "Record ID"Fields to be updated - "$Yearly Sum"I want the "Yearly amount" field in the "Current PM' record to update the "$Yearly Sum" field in the "PM Flow" record.It fails every time......... Help  My Action  

Morning everyone, I have a couple of questions about this solution posted by @Adam_TheTimeSavingCo (Thanks Adam, it works really well!): Create records from multiple select field choices Question 1: Is there a way to populate a field in the new table using data from the multi select? Using the example base linked in the topic above, I would like the 2nd table to look like this after running: Question 2: Is there a similar function for linked records? I have done the below manually, but the initial table would like this, and then would have the same output on table two: Thanks, Jordan

Hi Everyone. I 'm having trouble with an Automation (Scheduled Time, Find Records, Create Records) that will find all the records in a group (e.g. Group is “Week 36”), copy those records and create them into the next week’s Group. This in theory is simple and I can get it to almost work. It can find all the records I want it to. But… When it creates the records into the next week group it adds them all to a single record. Even if that linked record field is set to off for “allow linking to multiple records”. I just need it to add a distinct record for each copied record in that new week, not jam them all into one record.

I'm evaluating Airtable and so far think it seems very well made. But I'm having trouble determining if I can do what I want to do. I feel like it is a fairly straightforward need but can't find the path. One note, I don't write any sort of code so it would need to be some sort of built in feature/process. I know I can do this by creating a alternate view, but I want to control access to the Volunteers base such that not all users who can see/edit the Members base can also see the Volunteers info.So, I want to have one base called "All Club Members" that everyone can view/edit, with basic member info, and another called "Volunteers" with only a few users able to view/edit, where there would be deeper member info. In the All Members base I want a checkmark field such that if it is checked their record is automatically synced to the Volunteer base. Once synced to the Volunteers base, I'd want that record to have more columns than it had in the All Members base so I could add the addition

Hi All! I have an automation set up so that when conditions are met (i.e I select a certain label from a single select menu), the an email is sent out the the attendees that were assigned to that meeting.The problem is that it is only grabbing the first email in the email field and not sending to all the attendees. Is there a quick fix for this?Table has a Row for each meeting with fields for:Meeting nametimeroomAttendees (pulls from the stakeholder table and contains multiple people)Email (pulls email from the stakeholder table based on the Attendees. Data looks like: name@email.com, anothername@email.com, thirdname@email.com)Automation:Action Type: Send an EmailConfiguration: TO= Look upfield: "Email"   Token="Value"In the Table the Email Field shows:  name@email.com, anothername@email.com, thirdname@email.comIn the automation preview it shows only: name@email.comEmail is sent to only name@email.com Open to any ideas- Am I just missing a toggle

Hello.I created an app which sends a user.id to airtable to identify each user. However as of no it is not possible to send the username as well as the user.id.Is there a possibility to update a record with the correct name that matches the user.id? Which automation can I use?Thx 🙂

Hi,I have a question about the "Link to another record" function. Is it possible to automate this so that all entries from another table can be automatically pulled in without having to add them individually? Preferably with an optional if statement to pull only certain entries.Would be nice to have this but don't know if its possible (I'm new to Airtable)Thanks!

Hi all,The data from the table below is from another table using Automation:Once the status of a request ID is updated, then the update time of each status will be automatically recorded in this table.Is there any way to calculate the time difference between each of the statuses and then update the field "Duration"?I've tried putting the update time of each status in different fields(Image 2), but still failed at getting the duration.(Image 1) (Image 2)   

I am trying to use the URL to attachments script to download all the images from an URL column that has all the images urls but some are downloaded and others aren't. After trying to create a simple download attachment from link, I've noticed that the ones that are on a CDN are not downloaded and return :"Error fetching URL metadata" Can I resolve this somehow or is there another method ? Thanks.

Hello,Was curious if it was possible to set an automation to basically trigger an email if inventory is based on a % of x being low, rather than an exact number?QTY = < %So if I have 1000 labels, and I'm running low, and already utilized 50% of that, I'm sent an alert. Is that possible? I may have overlooked the automations, but I couldn't figure out how to submit a "%" in the conditions for "QTY" rather than an exact number.Thanks for all the help!

Hello brilliant people! I have views of Airtable image libraries that are embedded within an internal site, which my Designers share between teams. Designers can also add to these libraries by submitting an Airtable form. I want them to have the option to replace and ultimately “archive” duplicate images, without then needing to jump into the Airtable base.So, I added the following to the intake form:Which looks like this in the Airtable Base:This is what I want to happen.. but I can’t get the automation to work.Here's what my automations look like:Also, is there a way that I can change the preview in this dropdown (within the Airtable form) to include image thumbnails? Thanks so much! 🙏

Hi guys,Hope you are well.I am trying to create an automation where I can get a notification when a record has not been updated for x amount of time.Is this something I can do in Airtable? I need to keep a list of items up to date, and I am not sure if this is something I can do.Hope it makes sense,Thanks,TS

Hi all,I have a script in automation set to run "When record matches conditions" when a specific field value = Empty.The script is designed to Fill in the blanks from the last record field with value and dragdown the value until last row or until the field value is not equal Empty. let mytable = base.getTable("table name");let query = await mytable.selectRecordsAsync();let previous = "";for (let record of query.records) {    let current = record.getCellValue("field name");    if (current) {        previous = current;     } else {        await mytable.updateRecordAsync(record, {"field name": previous})     }}The script runs successfully every time in Extension, unfortunately in Auto