Automations

(Thank you in advance! I swear I've tried everything I could find here and no luck)I'm running a (successful) Create New Record automation from a Synced table, so my teammates can use the source data to develop their own additional work (but not adjust the source data itself). Yes, it duplicates a record -- but it's the only way I can deliver the starter content and let them build on.Next step is to run an Update Record automation, so when:Source data record is updated, thenMatching created record is also updatedTrigger (successfully finding the updated records in Source data) & Actions ("received invalid inputs") screenshots attached.

I have an automation that triggers at midnight every night. It runs a Find Records on a table with a date field, looking for dates that match "Yesterday." Below is a screen cap of the trigger going off at the right time/day (7/15). It should have pulled a record made on 7/14 (which I have confirmed exists and matches all of the other requirements for the lookup). I'm worried that the record "created time" is in PDT but that the lookup automation is in GMT, and therefore is puling the wrong date? Timezones always feel hazardous to automate around, so any insight or best practices advice would be so helpful! Thank you! 

Hi all,This is my first time in the community so I am learning as I go forward 🙂I have 9 bases for 9 different countries that have their own data and interfaces. However, I want to have these 9 bases synced into one base which I did using the import from airtable and sync function. The problem is joining these 9 synced bases in one table. I tried scripts, I tried automation based on time to create new records (still facing major issues with this) and the main problem is when it comes to updating the info in the main table with the 9 synced bases. Since airtable creates its own records ID, I am not able to do the updates because whenever airtable creates an ID and then you copy it to another table the ID changes.Regarding the scripts, since we have info linked between tables, drop-down and check boxes in the tables the script is not able to do the required copy or update.Any idea how to work around this?Thank you for your help

We've been using the following script for about a year now with no issues // Get Input - Gets record ID of updated record can then get info like rid.uei let rid = input.config(); let apiKey = 'XXXXXXXXXXXXX'; // Make the request let ueiData = await fetch(`https://api.sam.gov/entity-information/v3/entities?api_key=${apiKey}&ueiSAM=${rid.uei}`); let ueiResults = await ueiData.json(); // Output the data for the next action output.set('ueiResults',ueiResults); For whatever reason it stopped working this week. When I put the URL directly into the browser it still returns the correct information. It's only when we try to pull the information from the script that we received the following error: Error: request to https://34.199.241.198/entity-information/v3/entities?api_key=XXXXXXXXXXXXX failed, reason: write EPROTO 80DCB8B1417F0000:error:0A000152:SSL routines:final_renegotiate:unsafe legacy renegotiation disabled:ssl/statem/extensions.c:893: at main on line 7 Any id

Thank you for considering to help me! Here's the process I'm trying to create:A new record is created via a form which will have a start and end date (i.e. 7/3-7/28)Based on the timeframe (above), I would like to set up an automation where additional new records are created (within the same table) for each week within that timeframe. (i.e. a new record with the dates 7/3-7/7; another record with the dates 7/10-7/14; another one for 7/17-7/21 and the last one for 7/24-7/28). There will be other fields that I'd like to copy from the original record as well. I'd like to avoid a script and just use formulas and automations, but am open to a script (although will need help writing one!) if that's the best/only option.Thank you!  

Hello guys,I'm trying to create an automation that:When a new record is created -> Compare "E-mail" field with existing records -> If true, do something.The issue I'm facing is that: The automation is comparing the email to the contact being created instead contacts already created and always return "True" obviously.I'm I doing something wrong? Or is there any way other way to achieve this? Thanks in advanced

I have a problem using Automation to create a link between records in two tables.I have Table A and Table B.  Table A has a link field (’Link-A-B’) to Table B.  Table A also has a Form to create a new record in its table.  The form requires user to choose an entry into the Link-A-B field.  If the user selects a particular choice for the value, then the Form exposes another field in A (‘New Option’) that the user is required to type a value into.  Upon submission of the Form in this case—with a non-empty value in the’ New Option’ field—  an automation is triggered to create a new record in table B, and to enter the value of ‘New Option’ in A into the primary field in the new record in B. All the above I have working just fine in my Automation so far.  But the next action that I want to subsequently have happen in my automation is to change the link value in the Link-A-B field in the new A record: From what the Form user had selected, To a link to

Hi, I have a list of people with different positions and locations. I would like to create groups of these records like: * All the people who work in Sales * All the people who are located in EuropeAnd I can give it different parameters and it will sort by the different groups. >> I don't want to create all the groups beforehand. Meaning, I don't want to give it a defined list in case there are job titles or cities that aren't in my list. << Can anyone suggest an automation tool to do this? 

I have one table "Companies" it is related to "Campaigns". When I send a Campaign to a Company I want to batch or else automatically link the Campaign to the company.I see that linked records are not part of the batch Update extension. Example:I create a view of Companies that's 100 records.I have a Campaign that's "Direct Mail Piece 1"I export that list and send mail to those companiesI want to show link these 100 Companies to the Direct Mail Piece 1 Campaign so I know which companies have received which marketing.How can I accomplish this?Thanks!

I have an automation that will email a specific person when a record enters a view. The view is looking for a status change. Once the status has been changed a field is populated with the user that changed the status. As part of my automation, I’d like the person who changed the status to be CC’d on the email that will be sent. How do I get the email of the AirTable user to auto-populate into an email field?

I need a field named START to gather data from other domains, including dates.Why is the game development date being removed?SWITCH("Stage," IF ("Stage"="READY FOR GAME DEVELOPMENT,"DATEADD("GAME DEVELOPMENT,"'', "DAYS,"If the stage is "READY FOR CREATIVE DESIGN," the date add is "READY FOR CREATIVE DESIGN," the date add is "READY FOR PRODUCTION," and the day is "DAYS."

I am trying to delete some records from a child table when the parent record is removed. To do so, I have created a view on the child table showing records where the parent link field is empty. On my automation, the trigger is set to be when a record enters that view, the automation fires.  The automation is firing but I get an unexpected permission related error I have not seen before. I am the workspace owner. I can manually delete rows in the UI. This seems simple....what am I doing wrong? I have other delete automations that are still working fine. Error: You are not permitted to perform this operation at main on line   Code is below let table = base.getTable("tablename")let inputConfig = input.config();let recordId = inputConfig['recordId']await table.deleteRecordAsync(recordId);

Is it possible to get the previous value of a field to compare to when you have an automation trigger because of an update? I am thinking the only way to do this is to hold the old value in a hidden field and then update the hidden field after you take care of whatever you needed to take care of. I think the only issue is a person can make multiple updates to a field before you ever finish the automation so your previous value will be out of date if an update occurs before your first script finishes.

I am trying to automate my airtable to send an email to me and my coworkers anytime someone updates or changes data in any part of the table. However, I want the email to specify what columns or what parts of the table were changed. Is this possible?

Hi All, I'm putting a Zap together and linking our recruitment ATS with Airtable. I'm adding job adverts that come from our ATS in to Airtable first, and then I can send to another platform via the Zap. I've run in to an issue that I hope Airtable will solve. Our ATS sends job adverts to 3 job boards, so when it comes from the ATS to Airtable, it enters the job advert record 3 times. So it's duplicated twice. Unfortunately the ATS record has a data field that has all 3 job board ID's together so I can't filter the record by just one job board.Is there a way I can mark the duplicates with a true/false or checkbox field using some form of automation? I can then filter them out in another view and use the view to pass on the information to another platform from Airtable via the Zap without any duplicates. I hope that makes sense! Any help would be much appreciated. 

I have an automation - on form submission I receive an email.One of the fields in this form is an attachment.  My automation works fine - I receive an email when someone fills out the form, but I am not to access the attachment of the form. It shows access denied

Hello,I am trying to figure out how to insert an image to Gmail: Send email automation.Image is stored in the attachment field and needs to be inserted into email text as an image, not as the URL.While it is easily done for images stored publicly (not inside Airtable) by using the format <img src="https://.......">, I can not understand from the Airtable Help articles how to do the same with the image stored in the Airtable field.Thank you in advance for any hint or advise.

Hi Everyone,Looking for some help with improving an automation that I've used to create a variable amount of records in a child table and link it to the parent table based on inputs in the parent table.  Here is the code that has worked. let parenttbl = base.getTable('ListInfo'); let childtbl = base.getTable('List'); let {parentRecord,newRecordCount} = input.config(); let linkField = childtbl.getField('ListName'); async function createChildrenLinkedRecords() { // Airtable limits batch operations to 50 records or fewer. let maxRecordsPerCall = 50; let newRecords = []; // Part 1: Prepare the new records for (let index = 0; index < newRecordCount; index += 1) { newRecords.push({ fields: { [linkField.id]: [{ id: parentRecord }], }, }); } // Part 2: Perform the record creation operations in batches while (newRecords.length > 0) { await childtbl.createRecordsAsync(newRe

Context Unable to create an automation in Airtable. The path is as follows: An update in the "Sleep" field of Table1 triggers a search for records in Table2 that share a common field (using the "Name" field as the link). The automation then uses a script to update the corresponding records in Table2 with the updated "Sleep" content from Table1 into the Table2 fields, that have the same name, "NewSleep."Automation Path Image Below:My script is producing an error "'recordtoUpdate' is declared but its value is never read.(6133)." I believe what this means is the script doesn't understand or have a value it interprets from Table1 "Sleep" and therefore cannot update the the field of "NewSleep" for the records that have the corresponding name. Script:let records = input.config().recordslet table1 = base.getTable("Table1");let table2 = base.getTable("Table2")let newsleep = table1.getField('Sleep')for (let record of records) {let recordtoUpdate = await table2.selectRecordAsync(record

 We're trying to sync a list of contacts in Airtable to my Apple iCloud Contacts using the Make app https://www.make.com/enWe still don't have it working. (although we may be "close" to getting it to work)Are there any other apps or platforms anyone might recommend? (as an alternative to Make?)Thanks!– Bruce

I have an automation that triggers when data in certain fields is updated and outputs it to the console log in JSON. However, I need to get this data into MS SQL via SFTP.What are my options to accomplish this requirement? Thanks in advance for your kindness and help rendered.

Hi there! I have a question about AirTable automations and photos. For our company, our team members fill out a form through AirTable every time they complete a job. There is an automation set up where the answers to the form are emailed to 2 email addresses - the team member who filled out the form, and then a company admin email account. One of the fields in the form is to upload a photo of the job. For a while, the photos were sent as attachments to the email, but that no longer works. Is there any way to either attach or include the photos that are uploaded to the form in the email that is automatically sent with the form answers? I have not been able to figure out a way yet! Thank you!!

GG ☀️New to the community and to Airtable automations After hitting a brick wall all morning - linking the records of '⭐️ Associates'  and '🤝 Clients'  so they update each other when 'Associate' and 'Client' are added to the same row of a field in 'Project ▸ TRACKING' - I now realise I have a new issue, automatically deleting records!i.e. when I delete Client X from Helen the fields remain linked.The current automationwhen Associate, and Client are not emptyupdate Associate table ⬇️   note: to make Record ID be valid I had to select Associate/Edit Token/and select ID 🤷‍♂Now, how do I go about reversing the process? Or is there simple version to this as I build out more relationships between tables with will become more and more complex &#x1f605In advance thank you 😇  

I have two Date fields. I need a third field that simply displays the date in the first field unless it's blank, then displays the date in the second field. Here is the formula I'm using: IF({Dev End} = '', {Deadline}, {Dev End}) The formatting options for both Date fields and the Formula field are the same:I'm having two problems. First, the output date in this new Formula field is coming back one day before where it should be. I assume I could just add a day to the result within the formula, but I'm not sure why this happens in the first place. I suspect they have to do with the Time Zone. If I display the time zone, I see GMT, but I can't seem to select my time zone (EDT) unless I also display the time. I'm not interested in the time.The second problem is that I'm not able to use the Formula field as the end date in a Gantt view. I received the following error: I assume this may also be because of the time zones.Can I globally set the base to use EDT rather than

Good afternoon! Tell me how to display the number of records from other tables in one table and then add them up