Ask the Community

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 Airtable.Do you think this is something that can be achieved? I didn't find

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("Escolha um banco: ", Banks)const extractByBank = extract.filter(ext => ext.getCellValue("Bank") == [bank])

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 ideas? 

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 you can see, err was properly logged. But the record was not upd

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'),    24) & " hours " &MOD(WORKDAY_DIFF(         {To In Studio},{To Color Correction},        'minutes'    ),    60) & " minutes" We have the following implemented and working, but weekends are not excluded

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 Tasks table, but this did not change the error result. I found a similar p

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.

Hello community,In October, Coupler.io discontinued its free tier and increase the entry level tier from $24 to 64/mth.For my mini projects that is quite pricey and I'm looking for an alternative that can:One-way sync from Airtable to Google Sheets (new, updated, deleted records).Bulk update several hundred records in a view/sheet at a time.Scheduled sync, for example daily at 9 am.I found two alternatives:Data Fetcher seems to offer better value in both the Starter and Pro plan.WhaleSync is higher priced, but has two-way sync plus dabase storage.Are there any other options the commmunity can recommend? Thanks!

Hey everyoneTrying to use Slack's Action messages to give myself 3 options to update a record's status. Everything works great, except when I click a status update button I get "You do not have access to this Airtable record, or it has been deleted." as an error in Slack.Within Airtable, I get "The user who responded does not have permission to edit this record, or the record has been deleted.Learn how to fix common issuesStep run a few seconds ago"My account is the owner of the workspace. I use the same email on both. The test comes back with the button value I clicked, and a User ID. I'm guessing somehow m

I want to link specific words (like "Click here") in one of my tables to a cell in another table in the same database. "Copying the Cell URL" does work... for those who have an Airtable account. I need "the public" to be able to follow that link from the webpage where I have this table embedded.I've been researching this for hours and can't find anything. What am I missing? 

Hi, I am generating a URL by concatenating a URL string and then the Airtable record ID. Between my URL string and that ID, there is always a byte mark like “%EF%BB%BF” added (for example, when using the URL in an email automation). Any way to remove that since the URL leads to a 404 otherwise?