Automations

Hi there.I am trying to create a voting system in airtable. Basically, I am hosting an awards show kind of thing (think oscars kinda structure) where people are nominated for awards, and judges vote on the nominees. There are 2 rounds: round 1, each judge in each award catagory individually rates each nominee by a set of 5 criteria; round 2, all the judges from every award get together and vote which of the top 3 from each award should win the award. I am currently finishing up round 1, and am running into a few issues. The issue that I would like to address here is about a "Power Point" or "Je Ne Sais Quoi" point that each judge is able to give 1 nominee per award (its basically there so that if a judge thinks one nominee deserves an extra point they can give it to them). The issue is that as my base is set up right now, a judge can add this Power Point to multiple nominees. Ideally I would like to make it so that if a judge decides to add the power point to anot

I'm trying to use this feature of passing the name of the user logged in to the record when a new record is created and it is just not working and for the life of me can not figure out why, clearly I'm missing something. 

How to create a checkbox inside a field Send Email. Need steps.

I have an automation set up that sends an email (through gmail) based off a row.I want to send this with an attachment where the attachment is the same for all users or it is provided as a lookup field based off a value.i.e Option 1: Send all users the same attachmentOption 2: Depending on the value of a field send one of 3 attachments However it seems that with the gmail automation we can only send attachments from an attachment field in the row. So I can't just choose the attachment or point it to a lookup field.Are there any workarounds for this? I've considered Zapier/SendGrid as alternatives but would prefer not to.

Hi allany ideas how to solve this problem?can this be doen with the automation or do i need someone to write me script?night shifts should be split per day, if the time span is over the midnight insert a new row with the working times (Hours) on the next day ... or something like that?  Thx!  

hello every one.Now i am having few risks.My risk iswhen the record is updated or created in wordpress table, that data have to sent to airtable sync.help me please.thank you for any help

I am working on two tables of independent data: Tables A and B. The common denominator for each table is that they have a date value that I and other team members need to track.I've been able to create an automation where every time a new value on Table A or B is created, a new record on Table C is also created -basically copied- with values from A or B that are relevant for all those accessing Table C.Where I'm getting stuck is when I update anything on Tables A and B, I'd also like to automatically update the data on Table C, specifically dates but every now and then other values. This would be a simple fix with link to record if I wasn't pulling data from two separate sources, and I can't seem to find how to set up the right automation I need. This is where I am:Trigger: When any relevant value on Table A is updated,Action: Update Record on Table C <-- What record ID shou

Having a strange issue where my automation script reports successful and appears correct, but doesn't actually do anything. It's a fairly simple when record is created update the record fields from an API call.I've attached the script below, fairly new to Airtable and JS, although not to coding in general.Any help is appreciated!  let table = base.getTable('Cards'); let inputConfig = input.config(); let apiResponse = await fetch('https://api.pokemontcg.io/v2/cards/' + inputConfig.updateId); let info = await apiResponse.json(); let setAll = [ info.set ]; let setImg = [ setAll.images ]; let imgAll = [ info.images ]; let tcg = [ info.tcgplayer ]; let cm = [ info.cardmarket ]; let recordToUpdate = inputConfig.cardId; await table.updateRecordAsync(recordToUpdate,{ 'Name': info.name, 'Supertype': info.supertype, 'Types': info.types, 'Set Name': setAll.name, 'Series': setAll.series, 'Set Symbol': setImg.symbol,

Hello everyone!I'm new here, really could use some help. 🙂I would like to create multiple linked records in an easier or automatically way.I'm building a holiday calendar, the image below shows an example of what I seek. I need to fill in the city and the person's name (approximately 15 dates per city and 30 names), but without manually filling in the data.I already have another table with all the dates and names per city in linked records, but couldn't find an easier way to organize and load this information into this new table.Any tips?Thanks!

Hello, does anyone know if it is possible within the use of Airtable with Zapier or even just Airtable to create an automation where the automation will search for a number of different pre-defined strings and count every record where it exists, then write to a table to record the count for various timeframes like day, week, month, year? If not exactly that, can be a more simplified version. As long as I can define certain strings I am searching for and have it count and record for a given time period - day, week, month, etc.Request Details contains large text and for any record , Request Details could contain one or more of the string matches I am looking for. Would it be better to create an automation which searches Request Details field for the string matches I am looking for then create a linked record for every string match before accomplishing the original ask?For example: I have a field called Request Details. I want to be able to search for certain st

Forgive my ignorance but I am new to using automations and cannot for the life of me figure out what's going wrong.I am trying to set up an automation to do 2 things:send an emailupdate a recordThe trigger and email portions test fine, but I can't get the Update a Record action to work.It seems to me that it must be something within the Field I want to update - I am trying to have it mark a checkbox once an email has been sent.Any advice appreciated!

I have created a form for team members to submit their "updates on contacts" in our Airtable Database. The field updating actually removes previous content from the field and then updates to the new field submission. What I would like to do is have the automation "add" the new submission to the content that is already in the field. How can I do that?For example, we have a Notes field with previous notes already entered. We would like to keep these old notes but add the new notes to the column when the team member submits the form.

Hi alli'm struggling with an automation and i have done my fare share of research before i decided to create this post. i have a table to track multiple account if the bank matches the books.  Here are my fields: Account, Date last matched, Status My goal is that when the date of the last matched is TODAY the status should be UP-TO-DATEIf the date of last matched is YESTERDAY the status should be UP TO YESTERDAYand so on, see attached screenshot.I have tried different automations but i couldn't find something that would work.Here are some of the stuff that i tried.  

Hi all!I'm trying to build an automation that's very similar to something like the automations found in platforms like Asana, Monday.com, etc. but I'm getting errors and can't figure out why. I'm sure it's very simple, but I need help!I'd like to set something up where if someone changes the status of a single dropdown from ANY record in a table, that it will update the status of another single dropdown from that same record.EXAMPLE: We're creating a content calendar for our social clients. If we have records for POST A, POST B, and POST C, I want it so if someone changes a single dropdown labeled "Copy Workflow" to "Copy Approved" that in POST A, that it updates the status of another single dropdown in POST A labeled "Copy Status" to "Approved" automatically.While I fully understand that I can create an automation dedication to POST A, there's going to be a LOT of different records (or posts in our case) being made constantly. I can't be making new autom

Hello, As the image uploaded in Airtable returns the URL of the image, I want to convert the contents of the URL(image) to base64, btoa() converts the URL to base64 but not the content of the URL (Actual Image), I want the uploaded Image in base64 format. Is there anyway to do this inside automation script? Thank you

Afternoon,I've had 2 ideas recently whilst building a lot of automations. Please do say if they already exist and I've missed them.When creating an, "Update record" action, please auto-fill the "Record ID" with Trigger item's record id if it's from the same table as you're updating.1. Every time I'm building an automation, if I'm updating a record on the same table as the trigger, the Record ID, is the trigger item's Record ID. Could AT autofill that Record ID token? Or maybe, a quick function link underneath the input box, "Use trigger record's Record ID" which fills the box when pressed.2. Is there a shortcut key to access the dynamic variables in a field, please? Often I'm filling in a Field in the automation type some words, but have to move to my mouse to press the plus button and access the data key explorer.Instead, maybe like how a

How to add SMTP inside AirTable as there is a checkbox Send Email?

I’m currently working on a fairly large base and I was wondering if there is any way I can link it to Tableau, reason being I would like to visualise the data while I’m cleaning/enhancing it. I know I can download a csv - but I’m wondering if there is any way I can link directly or automate this so when I add a new record or alter data I can see the impact in Tableau.

Hey, we are currently experiencing the issue that a automation changed the way it works. The Find Records Automation used to just fail if it searched for a empty field now it gives us back the maximum Amount of Records it can find(100).These are also not empty in the field that is searched for. Is this a intentional change or just a bug? 

Hello everybody,I am very new to AirTable. English is not my native language.I created an external form with Fillout, which is connected to my AirTable base.When I use the block ‘multiple choice questions’ in Fillout, I have 2 options I am aware of :-Connect it to a ‘single-line text’ field-Connect it to a ‘single-select’ field The first option works great, however the second one, which is the one I’d like to use to get the advantage of the colors, brings up the following problem :Whenever somebody fills out the ‘other’ option in the Fillout Form, it creates a new single-select option in my table, which is great, BUT, at the same time, the form is automatically updated and the new option is now available to new users looking at the Form, which in the end can be a problem if people write a lot of nonsense.On the

Hi all!Please tell me, is it possible to change the rights in the interface on a specific entry after the automation has been triggered?I want to do the following:1) I have a Kanban board - an interface in which, when opening one of the records, you can change the status, date, etc.Is it possible to prohibit changing the status or date of this record when a certain status is reached (for example, done) without restricting others?2) I would like certain fields in posts to be edited only by the record author (the record author creates the post via a form)?Thank you in advance and wish you a good productive week!

I have a tab within a table, the tab is called PTO. the PTO tab has two different views I am working between for this automation. The PTO tab as a whole is populated from forms that are submitted containing requests for time off from employees. This form contains fields for [start date] and [end date] and is intended to capture both single and mult-day requests off. The first automation sends an actionable slack message for approval, which is working correctly. The second automation I am trying to set-up is intended to send a message to a slack channel each day that there is an employee out of office, listing which employee is out of office. (Bonus points for this only running Monday-Friday, even if the dates fall on the weekend).My first attempt at the automation was setting up the second view of the same tab, which would be filtered to only show records based on conditions, but I wasn't able to find a way for the records to populate if the request required more dyn

Hello,I have a Database that includes a table of Users and a Table of inventory (Computers , Monitors, Docking stations and so on).All of our inventory is mapped by serial number.When I give the user a device I assign it to the Air table.I want to have the option to see the assigned history by user or by device.That means if I have a user name Tom, and I gave him on 01/12/2023 a laptop: Lenovo Thinkpad , S/N:ABCD123, and I took it back on 15/01/2024.Let's say I have the record of this computer. Through that record I want to be able to view the computer assigned History- that means when it was assigned and when it was unassigned. And also the opposite way, through the user record to be able to see which devices were assigned or unassigned to the user.

Hello and thanks in advance.  I have form submissions coming into Airtable via a Zap from Gravity Forms.  The problematic field is Location which contains lat, lng, and address. I need lat and lng in separate fields in airtable.  This is an example of the imported data: {"location":{"lng":-122.38418565202375,"lat":47.653449368341484},"address":"Magnolia Connector Trail, Seattle, WA 98199, United States"}I need to wind up with 122.38418565202375 and 47.653449368341484 in separate fields. I've created 2 new columns in my table with the names lng and lat and installed the scripting extension. What do I do next?  Also I would like to process all the existing records at once and then process all new entries one by one manually when they come in.Thank you so much! 

Hi,I am trying to set a date field value to today's date, when another value for that record is updated. e.g. when status changes to X, set date field to today's date. I am simply looking for UK date format e.g. 23/01/2024 Does anyone have any ideas? Thank you in advance. Thanks,O