Automations

Hi! So I’m pretty new to Airtable but it seems awesome and I’ve achieved a lot, mostly through help found in this forum. This is the first time I’ve actually had to ask something because I’m really stuck. And I’m not sure what I’m trying to do is even possible, but be good to know either way! So my setup is all based around events, and I have the following key tables: Speakers Sessions A session has multiple speakers, and speakers can be associated to multiple sessions. All pretty simple so far. But here’s where the complication comes in. For big virtual events, commonly each speaker will be in their own Zoom room, which is then combined into a single stream (I won’t bore you too much with the tech). So normally we’ll have x10 Zoom URLs to be used for the whole event, with speakers assigned to a room for a session. e.g. 10-11am - Speaker XYZ - Zoom Room 3 It’s worth considering that a speaker may be in one room for one

I'm trying/hoping I can do this. I have an extension added to a table (SyncWith) but that needs to be manually triggered to run/update the sync. Ideally I'd like to create an automation to run once a day and trigger that extension, maybe with a custom script or something that can interact with it.Is such a thing possible with scripting? I'm still new to Airtable.

I have about 30 measurement fields, 15 in Imperial, and 15 in metric.I am trying to make it so that individuals can enter EITHER imperial OR metric, and an automation would magically convert and update other field.Is there a way to do this in a single automation?

I have a Base with below:Table A = CollectionsTable B = ProjectsTable C = Dept 1 Sub TasksTable D = Dept 2 Sub TasksTable E = Dept 3 Sub TasksTable F = Dept 4 Sub TasksWe create Projects and Collections, with Linked Records.When a Project is added, it then links to all the different table sub tasks. These are very different based on departmental needs, hence the different tables.I need to have a direct link between each sub task and their respective collections so that I can run High level meetings accessing each departments status/info in an Interface with ability to change data. This means an interface run from Table A with grid views inserted for each table A, B, C, D, E, FRight now it works if I use a Collection lookup field on each subtask table to monitor for changes, and then an automation that then updates a sub task to a new linked record field connecting to the collection any time th

Hello,Newbie here....  I am having an issue with syncing to an Outlook calendar. When I connect my Outlook account, I can see my calendars and calendars shared directly with me, however I cannot see a shared public calendar that my Outlook account is an owner of.  Am I missing something?  Is there another way to sync to shared calendars?Thank You!Chris

Hello,I am in automation and have selected a google account.  But when it comes to selecting google sheet, it wouldn't allow me to get to the login page.  I am stuck in the page shown.  I see a separate browser popup but closing immediately.  I have the pop up blocker off, also have allowed access to airtable for this google account.  Any tips would be appreciated. 

I'm in over my head.  I got ChatGPT to create this script for me, so ... I don't know if I've activated SkyNet or not.So I'm creating an automation, and I noticed that sometimes there are duplicate records, because the Webhook comes in and runs when a record is created and updated (so it creates a record for both).  I'm trying to create something to minimize this.Screenshot of automation: https://tinyurl.com/2q5a57jeWhen I try to update the record, I can't choose the record that the script outputs.

We need to create an automation for receiving products to assign Barcode to Refurbishment to Dispatch Automation through Airtable. We are a product refurbishment company. Need to share Data within teams 

Hi all, I'd appreciate a bit of help.I am trying to make a two product comparison page. I have all product specifications in one table like this: And I want to pull the specs data on this other "compare pages" table depending on which two products are picked:So if Product 1 is "iPhone 11" then it would pull the specs into this "Product 1 Specs HTML"from the first table. Same for product 2. Hopefully it makes sense.Is there an automation or formula that I can use to achieve this? Much appreciated! 

I have a task table with start date, due date, and completion date.  Each task is marked open, attempted, or done via a single select.  Working to create an automation that creates a copy of a task marked as "Attempted."  here's the flow of my automation: Trigger:  Record meets condition / condition is Status field is NOT open (aka, either Done or Attempted) Action:  Insert the value of a formula field into the completion date field.  The formula field is simply NOW(), so it will change every day and as we complete tasks, the completion date will change to the current date. Conditional Action:  If Status field equals "Attempted" Action:  Create new record with the following dynamically inserted fields: Task Description New Start Date New Due Date Assignee To calculate the new start and end dates, I have created two columns in the Task table with very similar form

When the automation send an e-mail, the "From name" field sometimes doesn´t work. Anytimes the from is correct in the received e-mail and sometimes the from field is noreply+automations@airtableemail.com The problem is very important because the recipiente doesn't know the sender. Thanks

Why am I no longer able to email customers automatically? This automation was working just fine before I had to update Zapier.  

Hello! Not sure what is happening, but I had automation that was working when a record was created. It was working just fine, but I had some Zapiere issues (I needed to update my plan). Updated my plan the zaps came through, but now the automation is no longer working. I even deleted the automation and rebuilt it. Still no dice. Does anyone know what gives? Cheers!

I have a script that takes the records in a table called "Runs" and creates a separate entry in a table called "Breakout" for each linked entry in the "Runners" field.  However, this script is currently only able to run manually, and if it's run multiple times, it creates duplicate entries.I'm looking to modify this script so it either runs automatically each time a record is inserted, or when it's run manually, it doesn't create duplicate entries.Here is the script:const sourcetable = base.getTable('Runs'); const desttable = base.getTable('Breakout'); const query=await sourcetable.selectRecordsAsync({fields:['Game','Runners']}); const converse=rec=>rec.getCellValue('Runners').map(x=>[rec.getCellValue('Game'),{id:x.id}]) const create=(el)=>({fields:{'Run':el[0], 'Participant':[el[1]]}}) const crt=query.records.flatMap(converse).map(create) while (crt.length) await desttable.createRecordsAsync(crt.splice(0,50)) Any

Hi, I am trying to create an automation where every Monday morning at 6am, all my multi select tags set as ‘Followed up on content’ are changed to ‘Need to follow up’, but without removing the other tags that are already set. I also need to create a button I can manually use that changes all ‘Need to follow up’ to ‘Followed up on content’, also without removing the other tags that are already set. Pretty new to airtable, so thanks for anyone that can help!

I'm running into a formatting issue when I try to update a text field by populating it with form responses.I have a form that collects a user's name, a text field for "Troubleshooting Notes," and a timestamp for when the form is submitted. An automation sends these results to a text field on another table. The automation has conditional actions to see if the destination text field is empty or not. If the field isn't empty, then it preserves the existing text, and just adds the new data below. I've attached screenshots of the automation actions.The automation works...mostly. However, if the destination text field is empty to begin with, then the automation adds three line breaks before pasting the form results. So, the text field looks empty unless you expand it and see the text hidden at the bottom. Does anyone know what is causing this formatting issue? It doesn't seem to happen if I remove the conditional statements, but those are necessary parts of my automation.

Hi everyone. I need help with some automations. I want to replicate my ClickUp Workflow in Airtable. New to airtable. Thanks!PS...Check the image attached

I have written the following script which attempts to check if a field has the value "Definition" and if so make selection on specific single selection fields on a random basis. The reason for this is that the values will be used in a series of image mockups.I am completely new to both airtable and scripting so have absolutely no idea why this script doesn't do anything, but also doesn't throw any errors. I also don't understand (despite being on the pro trial) why I can't seem to add scripting as an extension - it just says 0/10 added. However, when I go to the automation tab in the table, I can see the script I added (along with another one that works). base.getTable("Pre Mock Prod (YP-PP)"); let query = await table.selectRecordsAsync(); let records = query.records; for (let i = 0; i < records.length; i++) { let currentRecord = records[i]; let posterType = currentRecord.getCellValue("Poster Type"); if (posterType.name === "Definition") {

I am at a loss. This seems like it should be the easiest thing in the world. I am trying to write the TableID using a script to a field called "TableID". I have the variable value:var id = base.getTable("Target Activity").id;This returns the correct value. However, I can't figure out how to set the value to the field. Am I missing something?

I have a client who has submissions to an AT base via jotform that populate into a master 'customer' database. With the business, there are different approvals that occasionally happen that need to be noted. There are multiple events throughout the year, and the client is asking if there is a way to timestamp when they were approved, so that when they are approved, it updates the master database. Furthermore, they would like to be able to search the main database, and when they search for that customer, it will automatically show the approval, and the date of that approval.They would also like to be able to see all events that they have participated in. Now, to throw a wrench in it, they only have 2 events open each registration period, which uses a different jotform for each event, but they all currently populate to the main database. So, there are duplicate customer records with the same name, if they've registered for multiple events (in the main database). We would l

Hey there! I'm trying to have a Next Milestone field automatically update. In my Projects records I have a "Next Milestone" field that I would like to automatically update to the next milestone "Task" as we move through the project. I'm currently trying an automation like this:Trigger: When a record matches conditions if Task Due Date is after todayAction: Update record -Table: ProjectsRecord ID: Airtable Record IDFields: Next Milestone - Airtable Record IDIt's obviously not working but I'm hoping someone can help. Thanks in advanced!

Hi, I have the following task:I have two tables Orders and Inventory.I am loading an order from Amazon sellercentral in the Orders table. Each order has a column SKU (unique indicator of the sold product).The Products table stores the products that we sell with all the detailed information.Question: How to make the Orders table automatically pull URLs to the vendor's product page from the Product table, using the SKU as an indicator.In other words, for each new order, automatically fill URL in Order table (Supplier URL column) from Inventory table using SKU. 

Hi,I am working on a base pulls the information to page design, that we use to run meetings. Because of the way page design works, I had to create a field that links to the same record.What I am trying to do is to automate this part, where if a new record is created, it automatically self-links in the self-linked field.Would that be possible?ThanksAna

I am in the process of rolling out AT for Software Deployment Projects that I manage for about 6 different people.We have a Projects Table, Tasks Table and a Team Listing Table. When the tasks are created, we have to manually assign the Engineer to each task, when its always going to be the same engineer doing every task for that specific project. The Engineer is a linked field from the Team Listings field. Theres also a Rollup field that captures this information.I would also love to do the same for other fields as well, like a CRM Case number field that is the same for each task. I would also love the ability to click one button, and complete all subtasks (Long Text with RTF field formatted with checklist items)I have a script that was written for us during implementation that creates the tasks already, if that would be helpful.Thanks!Shawn 

Hi, I have an organizations table and a contacts table.Every time a contact gets updated with different organization name under the contacts table - I need the organizations table to update its synced field with the contacts name, but i need the automation to update the organization table with more than 1 contact record in the synced field, Is this possible?