Ask the Community

Is it possible to create a custom view type based on an existing view type but modified?I would like to add columns with labels to the calendar single day view.  Is this possible?  

Hello,how can I calculate the weighted average? Example:[-4, 0, 2, 0] -> I get this values via a roolupI want the result to be -2 i.g.. Correct me please if I am wrong.I'm open to use multiple formulas. Best regardsJohannes 

Greetings,In an Airtable, In a single column, I want to be able to edit a single select drop-down menu for all the fields in that column at once. Or to select and edit several at once.Any suggestions, ideas, or information would be greatly appreciated.Thank you.

HI everyone,I am a beginner and am trying to connect airtable to make.com and chatbotbuilder.ai.I need to construct my API URL and I'm not understanding where I need to go to find it.I also need my API Key (Is this just the TOKEN ID?)I know these are very simple questions but thanks for any help in advance it is much appreciated! 

Hey there,I have gone through quite some posts about this topic in the community already, but none seems to solve my problem or maybe I just haven't fully understood how to solve it yet.I have a table "Product stock" and another table "Product catalogue". The product catalogue contains information how many products are in stock by checking via a link and lookup field to the stock table. The link between these table is the product code.However whenever the stock is updated (e.g we have a new product in stock) I have to manually copy the product code from a text column to the link-records field. I would like to automise this step. My approach here is the following:- Trigger: when a record is updated (product-stock)- Actions:Find records: in product catalogue, where product code isn't emptyUpdate records: in product catalogue: Record ID: from find records - selected the link field product-numberfields: link f

Currently when I sub to an iCal link that is several days long, it blocks out my entire calendar. I would like to have these appear as an “all day”event so I can still see the rest of my calendar. Typically a calendar program will put an all day event at the top of the day, vs literally creating a 24 hr event from 12am to 12am.

Hi all. I have the free version of Air Table and it says I have exceeded storage capacity, however I am still able to upload attachments. Anyone know why that might be? Thanks in advance. 

I have two tables,- table 1: list of course editions and other course edition information- table 2: list of states in which the course can be found, linked to table 1.I have set up the kanban display in table 1 based on the linked field in table 2, it only shows me the columns of the states for which there are courses that I display and not the states that are not currently assigned to any course.With the kanban based on a single select field type, I can also see columns that do not contain courses.Am I doing something wrong? Is there any way I can also see 'empty' columns based on a linked field?Thank you for your reply

We have a Start Date (Date field) and a Start Time (Duration Field).  I want to combine them together.The first formula I have does combine them, but not in the way that airtable calendar view recognizes it as a date/time field.Can you help me create a formula that will format it  properly (more like the "copy" field below, but showing the correct time. Currently I am using:DATETIME_FORMAT({Start Date},'M/D/YYYY')&' '&CONCATENATE(FLOOR({Start Time} / 3600)

Hi Airtable friends,I'm new to Airtable and really loving it. But currently stuck on something that seems simple. I'm looking for a way to automate my sales summary by country without having to predefine the countries in my Airtable base.I have a sales order table with detailed information, including the quantity of products sold and the country they were shipped to. I need to create a separate table that dynamically summarizes the total sales by country.Challenge:The "Total Sales by Country" table should update automatically as new sales data comes in.I cannot predetermine the countries since new orders may come from previously unlisted countries.Current Setup:My orders table includes fields for order number, customer name, quantity purchased, shipping city, shipping country, and product.I have created an example of what the summary table should look like with hardcoded dat

Hi,I have 2 tables. One is called Dues. It has a list of members who have paid their dues by year. Each row is a member and the year. The other table is called Meetings. I t has list of meetings by date and a multiselect field of members who attended the meetings. Each row is a meeting with date and members attending.I would like to count the number of meetings each member has attended in a rollup field in the Dues table to determine of they are eligible to vote. To vote you have to have paid your dues and attended more then 6 meetings for that year. So, filter for year and and number of meetings.The list of members comes from the members table that lists all the members.Can someone point me in the right direction. I cannot figure this out.Thanks, Scott

Without using forms, but within AirTable itself, is there any option to build anything like a flow chart, where selecting different options would show different fields to input data?For example let's assume I have an employees table. Each employee can either be employed directly or via a subcontractor - for each option I need to fill out different fields, and then for each one of them they can be in different departments, and for each department I want different fields filled out once again and so on.Is there any way to do that?

Hello Airtable community,I'm developping a custom extension for my base. I would like to put in background of the an image.I've tried with a stylesheet without success actually. Is there a way to do it ?Many thanks,PP

Hello,I've configured a Gmail automation to send emails to multiple recipients. However, it appears that each recipient can view the email addresses of all other recipients.I have selected the field "email; value," which contains several email addresses, in the "To" section.Is there a way to ensure that each recipient can only see their own email address and not those of others?Thank you!

I'm a novice Airtable user trying to help create a system for my wife. I've created a base with a couple of linked tables and some basic forms to enter data.  I've just created a form using the "New Forms" feature and want to take the url and use it on an iPad to allow her to "look up" customers. When I try to open it on  the iPad I get a message I need to check my email for a magic link which opens it up on my desktop. Is there no way to view these "new forms" on an iPad. The gap between what can be done on a Mac vs an iPad in the iOS app app or via the browser on the iPad is confusing. 

Hi all,Just asking for a kick in the right direction for a formula, extension/script and/or automation that'll put the PriceInput value from my Price List table into the Database1 table (whether it's displayed in the Lookup or thrown into the PriceOutput field) when the "Agency, Board Type, Size, Type" match.I can see the option's available to select the suitable record via manually selecting it in the linked cell (as pictured in attachment) but this is obviously the part I need automated when a new record gets put in or updated.Database1 : https://airtable.com/apprcSs2FuTW9JKPJ/shrX6iv9CyKfOFLN3Price List : https://airtable.com/apprcSs2FuTW9JKPJ/shrMo95QtDPC7n3HqGreatly appreciated in advance 🙏

Do you know how manufacturing facilities have a "days since last accident/injury/whatever" sign? I need to create something like that on a dashboard. I was hoping to be able to use the simple "summary" extension but I can't seem to figure out how to do it.I have a table that tracks events and their corresponding dates. Events happen almost every day. Every once in a while, there is a day that has 0 events. Each event also has a time duration (minutes). On days with no events at all, a record is still created (via automation) for charting purposes, and the field that shows the duration of the event will show 0. I'd like to be able to display the number of days since the date when there were no events. Example:DATEEVENT DURATION (MINUTES)5 days ago

Hello-I have created a field with single select options. Is it possible to create a link such that when an option is selected it will link to a new field with new sub categories? Example: Field= Clothing with  Single Select Options: Skirt, pants, suit., etc.  When "Skirt" is selected, I'd like a new subcategory further defining skirt to become available either to populate the same field or a new field ex:  mini, knee, maxi, long. Thank you.

Hello, I am trying to write an Airtable automation Script where I am trying to create a new record to an existing table that has 4 fieldsFriendly Name (String)Platform Name (String)Platform Type (Prefixed Value)Data (Self-reference Linked Records field) When I run this code where I am setting all the values except the "Data" field because I don't want the new record to be linked to any other record   const data = { "Friendly Name": d, "Platform Name": d, "Platform": {name: "Launch"}, } const record = await table.createRecordAsync(data) I keep getting the same error ERROR Error: Field "fldtUMUOntLLXvVx8" cannot accept the provided value. at <anonymous> on line 121 at <anonymous> on line 137 at main on line 43  where fldtUMUOntLLXv

Small charity here thank you for reading!  I am trying to make a sign up sheet for volunteers to sign up to wrap Christmas presents for children - that bits sorted.  But I need to sort parking for them. On the main base theres a linked column that pulls up there name and there car registrations so it pulls through for each hour which volunteers are in and in each hour slot it tells me what the number plates are.I am trying to hide those fields (again fine) and have a field for each day that shows all car number plates expected in the car park and ideally remove the ones that are there for multiple slots and just show them the once.Am I being silly what would I use to find this I swear I used to be able to do show it as a roll up or something but for the life of me I cannot work it out. Thanks in advance 

Hi all! I am reaching out in hope of finding a solution. So I work for a music instrument manufacturer where we track each job (all instrument specifics) in our airtable database. I am trying to find a way to have a price column that calculates as you toggle the different specs of each instrument. Any ideas or solutions here? Thanks ahead of time!

I'm creating an athlete database. I want to create a column that shows where an athlete ranks, for various metrics, relative to everyone else. For example, let's say someone is 6'9" tall and that puts the athlete in the top 2% of all the athletes in the database. How can I calculate that for that athlete (and every other athlete)? Is that possible?

I created PAT as followed in documentation and copied it's token but I can't use it.I do get an "Error 403" in Make when I use my PAT there and I also get "Invalid Personal Access Token" in Xano.I checked the documentation regarding it and it seems I don't understand how to use it since I only wanted to use the template as base here in airtable and use it's table in Xano as a test data.

Is it possible to exclude records that have a zero value from an average rollup?

I use Airtable to track and schedule vaccinations for the animals in my calf barn. Using the birthdate of the calf, I have formulas in the due date fields to calculate the appropriate date to give each vaccine to each animal. Then I have a field with a checkbox to indicate when that vaccination has been completed. I use the calendar view with this table to show me what I need to complete on any given day. This works well, but what I want to create is an automation that removes the item from the calendar view after I check it off as being completed in the grid view. I would even settle for the date of that item being changed to a date 6 months in the past or something, just as long as it doesn’t keep showing up and cluttering my current calendar. But most automations I have tried can’t alter a “calculated date”, which most of my fields are because they are all based on the birth date of the calf. I have been puzzling over this for a week now and am hoping someone out there has a pote