Ask the Community

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?

Hi everyone, New to Airtable but love it so far, and am hoping to have the following question answered. I am creating a project / task tracker for my team, ultimately going to create an interface which would have the following hierarchy:Project > Tasks > Subtasks. I know I only have 3 levels so I'm trying to display the DRI name under the Subtask table in order for me to group it correctly. I created the correct tables which are linked properly (I think). Here is my question: How can I mirror the DRI in my Project table to auto-populate in my task and subtask tables? This will help me group my views properly. Thank you

I suspect this is a super easy thing to do, but I have been googling for over an hour now and all attempt to make this script function is seemingly failing. const { recordId } = input.config(); const table = base.getTable('tbliyrxpGU6tkQgG7'); let record = await table.selectRecordAsync(recordId); let user = record.getCellValue("Requestor (Airtable)"); console.log(user) await table.updateRecordAsync(recordId, { "Requestor (AT)": { id: user }}); Requestor (Airtable) is a Lookup Field that is pulling in a User.Requestor (AT) is a (Single) User field.The console log shows that 'user' is indeed an object that has id, email, name. But no matter how I try to pass the user onto the actual user field, it won't take it. "Cannot accept the provided value."

Hi there,I’m using the Interface timeline view to display lots of events that happen over a 2-week period in October 2024. However, for some reason the total date range visible in the timeline view is 1st Feb24 until 20th Jan25 – which means the horizontal scrollbar is tiny, and very difficult to use. I have to scroll very carefully left and right to find my 2 week period. Does anyone know what defines the date range please ? And more importantly, does anyone know how to change it ? I want ONLY my two week period to be viewable, with no ability to scroll to dates before or after. All thoughts gratefully received, thank you !

Hi all,Struggling with this one and I'm not sure if it's even possible.I have a table that works out total cost of a product, total cost of a product inc fees on Etsy total cost of a product inc fees on shopify.Etsy fees are always higher than shopify, so it makes things slightly easier.I currently set the retail price manually and then it shows fees, profit margin for shopify and etsy separately.What I'd like to be able to do is suggest a retail price for etsy, based on matching the profit margin of shopify. The fees of Etsy are higher so I can't just add the profit margin difference to the retail.I do have individual columns for each fee type if that helps?Here are my columns I currently have - Total CostRetailEtsy Transaction FeeEtsy Processing FeeEtsy Operating FeeTotal Etsy FeesTotal Cost with Etsy FeesEtsy Profit (£)Etsy Profit Margin (%)Shopify FeeTotal Cost with Shopify FeesShopify Profit (£)Shopify Profit Margin (%)I'm assuming I'd need to do something like work out the %

Anyone know how to fix this. Is it because airtable is unable to extract data from a formula field to update a date field. 

Problem Description: In the Airtable automation configuration, the "Find records" step successfully found matching employer records, but in the "Update record" step, the error "Received invalid inputs" is still displayed. We have confirmed that the "Record ID" and "Fields" are using the correct output values from the "Find records" step, but the issue persists.