Ask the Community

Hello, I am trying to get a field named “Statsig Url” in a table named Experiments (this is a field with the url type). (My intent is to get the record id based on the value of the Statsig Url field). A filter will be applied in the url. let table = base.getTable("Experiments");console.table( await table.selectRecordsAsync( {"fields" : ["Experiment Name", "StatSig Link"]}));console.table( await table.selectRecordsAsync( {"fields" : table.fields}));I have tried with different approaches (testing other fields...). Each time I only get the primary key. 

Dear All,how to set my personal access token account in n8n? make my workflow in n8n can use airtable as a memory for write new also update. Many thanks!Mad 

The client has access permission, so that he can enter and edit data, but he constantly accidentally adds values ​​to the field settings, every time he types a value that does not exist in the list that is set for selection, it automatically adds a new value.Something I do not want to happen

I am collecting grades for students, a few of the grade types have subcategories that need to be averaged (some of the nomenclature is strange as it’s being translated from another language). I need to calculate a “Values” score by averaging the “Honesty”, “Empathy”, “Lucidity”, Performance”, “Respect” scores. I’m trying to keep the table design very simple as we will need to eventually translate and teach non-English speakers how to use it.  Is there a way to calculate averages only for select rows, by student? (I would like to calculate a Values score and a Property Respect score by averaging the relevant subcomponents). I understand I can see it with a View, but I want to be able to calculate the actual number to put in a clean interface view. And if I need to collect this data monthly, are the columns I have for Month/Year the best way to do that, and we would just continue adding rows?   

Is there still no way to create reusable code in Automations?I see this thread from 2021, with 6k+ views, which seems to have no resolution (blockchaining is possible in Scripting Apps, but not Automations).  Someone must have solutions for this?  Copying/pasting seems prehistoric.

Cannot get this Switch to work and its very simple.  I have a field that has the year of the record stored as a number (ie 2025).  I can easily get this to work with these arguments as a singular IF, but I dont want to nest 5 Ifs. The below will not function, doesnt even give an error, wont even let me save it. Neither Claude nor chatgpt has any suggestions that make sense.  What am I missing?? SWITCH(INVOICE_YEAR, YEAR(TODAY()), "Current Year", YEAR(TODAY())-1, "Previous Year, YEAR(TODAY())-2, "Two Years Prior", YEAR(TODAY())-3, "Three Years Prior", "Older")For this record this works fine:  SWITCH(INVOICE_YEAR, 2025, "Current Year", 2024, "Previous Year", 2023, "Two Years Prior", 2022, "Three Years Prior", "Older") 

Hello! I am trying to set up a work request form, and am stuck on one part. I’m not sure whether I need to use formulas or automations, but I’ve scoured help videos and articles to no avail trying to find what I’m looking for. I would like to have a numerical Work Order ID (basically a consecutive numerical number) added to a record field as soon as the record is created. Ideally, I’d love for it to take this form (Year-####), as that’s the current system we use, but I’d settle for just a unique numerical number for each new record created. I’m sure this is simpler than I’m making it out to be, but any help would be appreciated. Thank you!

I've created a script that is attached to a view's button.In this script, I'm calling an API with remoteFetchAsync().  I need to supply basic authentication credentials, but btoa() and Buffer don't work in my script: const authorization = btoa(`${ credentials.username }:${ credentials.password }`)const authorization = Buffer.from(`${ credentials.username }:${ credentials.password }`).toString('base64')output.text(`authorization: ${authorization}`)Is there another option?Is TypeScript supported in a script that is triggered by a button?  If so, how do I enable it?FYI, the "Ask the community" link (https://community.airtable.com/c/developers/scripting) returns 404.

I’m trying to integrate SAP Business One (SAP B1) Service Layer API with Airtable scripting to fetch business partner data. The integration works perfectly in Postman and Python, but when I run the same API request inside an Airtable scripting block, I get the following error:401 - Invalid session or session already timeout. What I’ve Tried: Confirmed that it works in Postman and Python I can successfully authenticate and fetch data from SAP B1. Session ID is returned properly, and I manually add the ROUTEID. Using remoteFetchAsync() in Airtable Scripting I correctly pass Content-Type and Cookie headers. Even when I manually copy a working session ID from Postman, I still get a 401 Unauthorized error Has anyone successfully integrated SAP B1 with Airtable scripting? Could Airtable be modifying the request headers in a way that causes SAP B1 to reject it? Is there any alternative way to bypass CORS while using Airtable scripting? Any other troubleshooting step

Hello All! Thanks in advance for any help but I am stumped. I am trying to automate updating a multi-select field from a Linked Record Field, and after looking for help here I found this thread: I followed the guidelines here but I am running into an issue with a completely different field. When I test, I get this: I am not sure why it is trying to do anything with the photo field :(Long story short, I want when someone is added to this department on one table, for their profile to be updated as well, with the matching department name on the multi-select field. Here is the way I set the automation:TriggerAction 

Can anyone point out what i’m doing wrong here? The goal is to create a list from 30 different fields. Each field should be on a new line We want to skip any fields that are empty. E.g don’t add a newline for empty fields. The latest version of my nested IF formula looks like this. Any help greatly appreciated! IF ({filename_1}!=BLANK(),filename_1 & “\n”,IF ({filename_2}!=BLANK(),filename_2 & “\n”,IF ({filename_3}!=BLANK(),filename_3 & “\n”,IF ({filename_4}!=BLANK(),filename_4 & “\n”,IF ({filename_5}!=BLANK(),filename_5 & “\n”,IF ({filename_6}!=BLANK(),filename_6 & “\n”,IF ({filename_7}!=BLANK(),filename_7 & “\n”,IF ({filename_8}!=BLANK(),filename_8 & “\n”,IF ({filename_9}!=BLANK(),filename_9 & “\n”,IF ({filename_10}!=BLANK(),filename_10 & “\n”,IF ({filename_11}!=BLANK(),filename_11 & “\n”,IF ({filename_12}!=BLANK(),filename_12 & “\n”,IF ({filename_13}!=BLANK(),filename_13 & “\n”,IF ({filename_14}!=BLANK(),filename_14 & “\n”,IF ({

Hi! Very new to this process and Airtable, so I’m sorry if this is confusing/doesn’t have enough to go on, or uses the incorrect terminology. If anything needs clarification please just ask! I’m currently trying to build a scheduling base that will update itself with the next date that should be assigned in the process if the timeline deviates from the original schedule. I’ve managed to get most of it figured out, but I’m having trouble with two of my fields/formulas returning incorrect values. I keep overlooking it, so I’m wondering if someone else can help me or offer advice. The field my formulas are based on is: {Due Date} The formula fields (in order) that are made based on that are: {Article in Progress} {Outline Due} {Outline to Client Expected Date} {Draft Expected Start Date} The date fields (in order) that can update the formula process if the project goes off track are: {Internal Outline Delivered} {Outline Delivered to Client} The current process starts by using the due

Hi there, hoping someone can assist me. I need a formula that will note true/false based on an attachment field.For further context, this will be used in another formula that combines various fields into a link which goes to a custom Typeform. The fields from Airtable are set as hidden fields, but at the moment I'm having issues with the logic because it can't recognise if the data is true/false since the entire file name is showing. Having this terminology would be good so I can simplify the link and the Typeform logic.I tried working with the TRUE formula but couldn't get that to work.Let me know if you need more information. Any assistance would be appreciated.UPDATE - I've found a solution;IF( {Attachment Field}, "TRUE", "FALSE" ) 

Hello,I am in need of a formula that can calculate a duration of time for payroll for hourly employees. I have a column with Start Time and one with End Time using duration. I also have separate columns for both to capture AM or PM. I just can’t seem to get the formula correct and getting the correct duration. If I need to change my columns I am up to however it can work. I do have a date column to if that helps with the formula. Thanks in advance for the help.

I have the above time stamps. What I need to do is calculate the hours/minutes from 8AM to the Start Date 1, as well as End Date 1 to 5pm. How can I accomplish this? 

Hi - I'm absolutely stuck trying to achieve the results I want, and I'm hoping for some focused support. I have 3 Tables in my Base:- Vendors - which contains companies I contract work from.- Resources - which contains the individual resources that work at those companies, as well as their individual monthly rates. Resources are linked to Vendors.- Monthly Cost - contains a list of records for each month of the year (eg; January 2025, February 2025, March 2025, etc).  In Resources, I'm assigning Months, from the Monthly Cost table, for when I expect this resource to work. In Monthly Cost table, can see the assigned resources by month, and I created a Rollup field to show the Vendor names associated with the Resources that are assigned to the month. This is using ARRAYUNIQUE, so if I have 5 resources at one vendor, I don't get the vendor displayed once. I also have a Monthly Resource Cost Lookup field that will Look up the assigned Resource's Monthly Rate. The rates are displayed, separ

I’ve seen a lot of wild posts about this topic, but I was wondering if there was a a more simple and concise explanation for how to convert a field containing an integer in Unix Time, to a Date field. The Airtable knowledge base has incorrect information: https://support.airtable.com/v1/docs/converting-unix-epoch-time-to-current-date?highlight=unix%20time

I'm reaching out for your expertise. My sample table has three date fields: Joined, Separated, and Date Rejoined. It also has two formula fields: Prior # of Years from Joined date to Separated and Total Years. I need your helpto correct the formula for calculating the total years of membership.I am trying to calculate the total number of years they have been members. I can do that, but the problem is that when they join, separate, and rejoin, we don’t give them credit for the years they were gone/separated. Here is the formula I used for Total years. I’m sure my formula must be wrong for the “total years including prior years".     DATETIME_DIFF(TODAY(), {Joined},'days')/365 - {Prior # of Years from Joined date to Separated}But for members who have never separated, it gives me NaN for prior and total. Prior years' formula is:     DATETIME_DIFF(Separated, Joined,'days')/365Lastly, for members

I am working with two separate bases in Airtable and would like to use a Lookup field to retrieve data from a table in another base. Is there a native way to achieve this without relying on third-party integrations?Additionally, I need to link a specific cell from one table in a base to another table in a different base. Is there a built-in Airtable feature that allows this?I would appreciate any insights or best practices from those who have worked with similar requirements.

I assume there is not formula reference for this. Is there anyone with prebuilt formula that will identify when to use the s, ‘s, or es on a name? To comply with the standard English rules here: https://www.merriam-webster.com/grammar/what-happens-to-names-when-we-make-them-plural-or-possessiveI’m sure I could take 2+ hours figure it out, unless you by chance have it 😀

We have a list of names and dates, like so McClelland, David (1820 - 1899) We would like to separate the dates from the the name, so everything in parentheses would be extracted and moved to a new column. I know there must be some code for this, but I am not sure what it is. Help! Kevin 

Hi,Does anybody know why the comment section in Airtable interface is not loading/ working properly? This has been happening in multiple bases since a couple of weeks and I'm wondering if there is a fix for this bug.  Thanks!

I am trying to create an automation to tag Donors as recurring when they make a donation that has a recurrence of more than 1. One table has Donors, and the other has Donations and a field called “Recurrence Number.” I tried to set it up so that when a donation record enters the view “recurring” (because the donation has a recurrence number higher than 1) the Donor in the linked record field has a field updated to tag them as a “recurring donor.” But i keep getting the error “the record does not exist and am not sure why. 

Hello! I am trying to build a Base/Automation in Airtable to count how many times an event occurs in a week, and then add/subtract it. Essentially, to count how many times customers use the events that they paid for, and then subtract it from the events they have remaining. I set up a Pivot Table to do the count, but I am not sure how to set up the Table with the actual schedule in it, without have to create new fields/columns each week. Specifically, I am having trouble figuring out how to set this up in terms of the fields and columns. It’s the same time blocks each week, I’m just having trouble figuring out the skeleton of this table in the base… I looked through the Help and Templates section, but none of them seem to address this particular part of the scheduling process…  Any ideas/advice would be welcome, I’m sure this isn’t a unique use-case, I’m just having trouble with this one table… Thank You!

Hi everyone, We’re experiencing an issue with how linked records display in our Airtable base, and I’m hoping someone can help. Our setup includes two tables: Jobs and DS. Each job can be linked to one or more DS records. However, when we create a new job and link a DS record to it, the DS record doesn’t immediately appear—it remains hidden until we refresh the page. This makes our workflow a bit frustrating, as we have to manually refresh to see the newly linked records. Has anyone else encountered this issue? Any ideas on what might be causing it or how to fix it? I’ve attached a screenshot for reference. Appreciate any insights! Thanks in advance!