Ask the Community

Hey Everyone,  I'm a bit frustrated because of the following: Is it just me, or is tooooo hard to get a hold of someone on the email?? I've been trying to get an answer on the support email for almost 2 weeks now, all I get is an automated response, and that's about it. If anyone can suggest a way to get help faster, would be much appreciated!

Hello! I am trying to format my data in a very specific way and require underscores between the text. I know when using a Lookup and formula there are challenges because the Lookup format is not a string and the commas within the field do not actually exist. I tried converting the field to a string and using a substitute formula but that just removed the commas and spaces from the field. Current Lookup Format: pa, nv, flSubstitute Format: panvflDesired Format: pa_nv_flDoes anyone know if there is a formula to add underscores to a lookup field that contains multiple options?Thank you in advance and I appreciate any support in solving this!

Hi there Airtable Gurus,We have four bases in our Airtable workspace:Base A: This is a new base connected to our legacy software, which automatically adds order numbers into Base A. We want to link this base to our existing Bases B, C, and D using the primary field (order number) from Base A.We would like the primary field (order number) from Base A to be selectable + within Bases B, C, and D within Airtable and via forms to ensure clear linkage and consistency to orders. These separate bases (B, C, and D) need to connect and relate back to Base A.Currently, I have tried having Base A synced with tabs in Bases B, C, and D. We want the connected information from Bases B, C, and D to be integrated into Base A through linked fields. While I have this information working through my synced table tabs within Base A, these extra linked fields are not appearing in the original Bases B, C, and D.Having this integration will allow our

Hi,1. How can I create default value to an attachment field?2. I'm trying to create automation that every scheduled time 2 fields in the table will be updated to certain status.The trigger is working but i get an error of "Received invalid inputs."Can anyone help me with this?Attached image that show the automation:  

Hello,We're an edtech startup for high school students.In addition to the in-app exams and quizzes, we also run offline exams in Telegram groups to mimic school exams (around 3 times a week).We send out a pdf to a group chat, and then each student solves the exam by hand, and then takes a picture and sends it back to us. Our teachers then give each student a grade and reply to that student. This is important because we want to see the steps in their solutions.These offline test scores need to saved so we can achieve the following:- Keep track of each student's scores over the school year- We send out report cards based on these scores- Check if a student doesn't have a score recorded, so we can check if they didn't do the assignment (assuming it wasn't an error on our side)- Keep track of when our teachers submit a score (to ensure timely responses)Right now this is all done on sheets.We were thinking of using Air

I'm trying to filter my extract by the bank that the user select, but i'm always getting null.What am i doing wrong?const extract = await Extract.selectRecordsAsync({    fields: ["Name", "Data", "Valor", "Bank"]}).then(query => query.records)let bank = await input.recordAsync(

Hi there,I dont understand the difference between 2 formulas : IF( AND( {Startdatum Leverancier (rol repowered)} != BLANK(), {Einddatum leverancier (rol repowered)} = BLANK() ), "OT", IF( AND( {Startdatum Leverancier (rol repowered)} = BLANK(), {Einddatum leverancier (rol repowered)} = BLANK() ), "", "BT" ) ) This formula does  NOT work as intended and ALWAYS shows OT regardless of the 2 fields content (empty or filled). I need to add that these fields are date fields.  IF( {Startdatum Leverancier (rol repowered)} = BLANK(), "", IF( {Einddatum leverancier (rol repowered)} = BLANK(), "OT", "BT" ) ) This one DOES work as intended. Although I fixed the issue my curiousity is getting the better of me what I did wrong in the first bit of code. Anybody

Hi!I have formula field for duration of a lunch break (datetime difference between lunch strat and lunch end). It gives me duration in minutes. Now I'm wondering if there is a way to sum this time?Thanks

Begun playing around with interfaces on Airtable. Is there a way to integrate a map view onto an individual record? You can see an example below that would make sense.

Hey I just wanted to ask if I can install extensions for free as a developer is there any privilege to those who are extension developer 

Trying to automate our UPC code generation (not the barcode image). We have our company prefix, and I know how to do the check sum. What I can’t figure out in AT is to process the current numbers already used/assigned in our block, and see what is the first missing number in the sequence. So we should have 10K numbers in our block, 00000 - 99999. We have used random numbers in past, all done manually. I would like to do this automatically in future by looking at that above sequence, removing anything that has been used, and then using the lowest number possible to start auto assigning SKU’s to projects moving forward. If this needs to be a script, can it be run by a button and/or an automation triggered by conditions?

I am using Airtable to manage a sales pipeline. I have created a sales dashboard using interfaces which reads across all opportunities. I want to be able to create quarterly and monthly reports by duplicating this dashboard and then filtering the records it reads to a specific date range.I can't seem to find the option for filtering a dashboard at the global level - does it exist?

HI - I can’t seem to find the import or add button on the app? Is this not supported yet? I am working on an iPad Pro with app 

Hi everyone!I'm trying to organize my sales data in my Airtable base.I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.Now I want to run automatic calculations on the data. To give an example: if sales for a particular product are decreasing for a few days in a row I want to make this visible in Airtable, or automatically send an email as a warning. Now the problem is that if you create calculations to do this you do that for the existing columns, but every day I'm adding a new column to the table, so than the calculation won't include the newest data.Does anyone know how to deal with this?

Hi Airtable team!Not sure if this is the right place for reporting bugs.I'm also aware that the features being released are all still a work in progress.I have a Kanban interface that is sorted by a date field. It works great on desktop, but not on mobile. On mobile, the records are still sorted alphabetically. I also like the feature on desktop where we're able to hide empty stacks which also has not translated over to mobile yet.I also wouldn't mind if the mobile Kanban looked the same as desktop and we just had to scroll to the right to see more stacks.Again, if improving some of the mobile experience is something already being worked on, that's great! Just wanted to bring attention to the "sorting bug" specifically.

Hi,I'd like to insert the error message into a field, so I used try catch with both of them updating a variable, which I then used to update the field. Weird; it only updated on success, not on error. Can anyone help? let config = input.config(); const recordId = config.recordid; let tabletable = config.tabletable; let table = base.getTable(tabletable); let query = await table.selectRecordsAsync({ fields: ["Error"] }); let err; try { await table.updateRecordAsync(recordId, { "Eat": "Cheese" // no such field }) err = "Code executed successfully"; } catch (error) { err = error.message; } finally { console.log(err); await table.updateRecordAsync(recordId, { "Error": err } ); } console.log("Updated a record!");  CONSOLE.LOG "Could not find a field with name or ID "Eat"." ERROR Error: Could not find a field with name or ID "Eat". at main on line 16As

Odd one, but I've noticed it a couple of times in the last week, so I wonder if it's a quirk of a new update.Basically I have a Status dropdown with a default option applied, called PlannedOne view that has some filters, including "If {dropdown} = ARCHIVE: Amendment"There is no grouping for the dropdown options in this view.Yet, when I create a new record it defaults to ARCHIVE: Amendment.This is how the filters are setup. Anyone know why this is? It's very frustrating. Is this a bug?

Hi everyone!I'm building appointment base for volleyball and two different objects. I want to set available appointments in one field but I don't want to add them manually because there is a lot of them. Is there any change that I can add them with automation? Otherwise I have to pick every single one of them on calendar and also pick a time.Thanks for your help.

Hi there! I am trying to create a form that will allow someone to book a specific desk for a specific period of time. I would like to be able to automate the form to A) Remove a desk as an option if it's already been booked during a specific time period and B) Add it back as an available option after the specific time period has ended. Example:  We have desk ABC and desk DEF available. Person 1 goes to the form and books desk ABC from May 10-12. Person 2 goes to the form looking to book a desk from May 10-12: desk ABC will not be an option because it's already been booked during that time period so they book the available desk DEF. Person 3 goes to the form to book a desk for May 13 and both desk ABC and desk DEF are once again available for booking.  I am stuck on how to get this set up via a condition or formula and any help would be appreciated! 

Hello!Anyone have an idea as to why my line graph is a bunch of scribbles? I want to chart number of applicants to specific majors overtime from term to term. The terms are in the correct chronological order on the x-axis, but for some reason the lines start in random terms and jump to other random terms.Thank you for any help!  

We are implementing time tracking fields in multiple bases and need to calculate the total amount of time between two date fields (in days, hours & minutes) but also excluding weekends and possibly holidays. I've tried the following but the calculations are returning errors. WORKDAY_DIFF( {To In Studio},{To Color Correction},    'days') & " days " &MOD(WORKDAY_DIFF({To In Studio},{To Color Correction},        'hours'),  &nbs

Hey allBeen working with the new Dashboard option and so far I have had a positive experience. One thing that I seem to have lost is the ability to link to a sidesheet record detail like I can in other Interface page.For example, I have an interface page that is just a list and I am able to open a detail sidesheet from that interface page using a URL like this:  https://airtable.com/apptXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX/recXXXXXXXXXXXXXX?tableId=tblXXXXXXXXXXXXXX  Which is great, I can hand out that link and people will go to the interface page and the sidesheet opens for the record.It looks like I am unable to do that with the new Dashboard page. Is that correct? Or is there another way to do that?Cheers! 

I have a table of projects. Associated with each project is multiple teams and multiple quarters. Both the quarters and teams fields are sourced from linked records.I would like automation (or script) to create related projects in another table, one per multiselect field combination. I've tried creating a script with ChatGPT, but no luck. I also so some other solutions in the community that were similar, but not quite the same as my situation. Any suggestions? 

Today our team were all stopped from being able to create Tasks on our Active Cases. This is done via a Linked Field. When trying to create a new Task, all the team received the error message "You are not permitted to perform this operation". A few details below if they're helpful:All the team have Editor level access. I have Creator and only I and the Base Owner are still able to create Tasks as normalThe Team exclusively access our Airtable database via InterfacesAll Team members have permissions to create and edit on both tables and these have been triple-checked. They have all been happily creating Tasks since the start of June with no problems and no settings have changed.All users access our Airtable base via the Google Chrome browser on PC. They have all tried refreshing and clearing their cache without effect. No other Linked Field relationships are affected. I have tried creating a copy of the Ta

Is there any way that I can print (to PDF) my fully weekly calendar view on one page? I’ve tried just doing File-Print, then landscape mode and shrinking to fit to one page, but it only shows me four days out of seven. What I’m trying to achieve is that I have been speaking with AT about getting at least a read-only Calendar week view in the iOS app, but until that happens, I’d like to have a PDF that I could then add to my digital planner and mark up by hand and consult when I’m on my iPad (desktop mode on iPad is clunky). Thank you.