Ask the Community

I'm building a system for our staff where I need to be able to find colleagues of a given person for a given project in a particular building.Our structure in airtable is like this:We have four tables:BuildingsProjectsPositionsStaffThe buildings table simply serves to tie them together, being linked to from the projects table as a location.The project table serves to explain the project itself and gets linked to for the positions in that project, from the positions table. The positions table helps organize certain positions, like designer, or electrician, that may be organized before the staff for that particular position is chosen - which, of course, is then taken from the Staff table, holding all of the staff details.What I'm trying to achieve, is by a button press from the staff's profile in our interface, set a filter over a list element that matches that specific staffer's dates of starting and ending on th

I have a client base with tables for sales, onboarding, offboarding, interactions and I want to create a table for course completion.What would be the best practice for this table? I have 250 clients and I can't export the data from my course platform host so our VA will be manually entering the % completed for each client on a monthly basis. Would my primary file be the client and then I create a new record for each client each month and add the % of course completed as a number field?Is there a way to make creating new records super quick? 

Hi,I have set up a very simple automation. I've created a folder called "Leads Sent" and want any email that is placed there to trigger the creation of a record in my base called "Leads". It works a charm when i test it, both allowing AT to choose the data, and when I manually choose the data. When I turn on the automation and copy any email into the folder, nothing happens. The emails I put in there are a few months old, does that matter, and if so, can I tell the automation to pick any email, irrespective of date, that is new in that folder? Or is there another kink in the system that I am unaware of?I do not want to run this through a 3rd party integration, I want to use AT's own automation, so please stick with suggestions that will help solve that relationship, thanks. Thank you./Christopher 

When I use to copy a base via public share link, automations copied over as well. They were just turned off.Now when I do it, automations aren't copied. They're all gone.Am I doing something wrong? Was this removed?

The interface designer has an update button and delete record button. I wanted to create a button to duplicate record so some of the data need not be reentered. Any way to do it through the automation. I could not seem to get the automation to recognise the current field

Hello all! Would anyone know if it's possible to create a Slack > Airtable automation? I am looking to get data on how many times and when a client creates a message in Slack. 

Hi there, I have a repetitive formula field that I need to turn into a lookup / roll-up field in another table.Here is the formula field for reference. What are the steps I need to take to allow for this formula field to be a lookup field on another table?IF(AND(WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-25,'Days'),IF(AND(WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-18,'Days'),IF(AND(WEEKDAY({Go Live Date / Event Start

Hi!  Background info.... I have a number of clients whose information I have stored in an Airtable base.  This information pertains to their upcoming meetings and information for them to prepare for those meetings. Currently, I'm providing them with a 'share' link from specific views in the base so they can view their upcoming meetings on their computer and/or mobile device. While the information translates fairly well to mobile, I'd like for it to be a little easier to view.  Has anybody done this?  Does Airtable have any 'mobile app' capabilities? Hopefully that all makes sense!  TIA!

Hello Airtable community,I've been working on a project where users input data through a form, and the results are recorded in the base. I have set up a rollup field for each question to calculate the average of the results per field. Now, I want to create a graph in Interface Designer that displays all the columns along with their averages in a single graph and sorts them from highest to lowest average.I'm currently having a hard time achieving this, and I'm wondering if I'm approaching it the wrong way. Could anyone provide guidance or suggest a more effective approach to visualize this data in the Interface Designer?Thank you in advance for your assistance!https://airtable.com/appbYmoC5vgmEZJPx/shrZ7wAcVoE0AcfIA

Hello everyone, i'm creating an new Kanban record from a sync table of other base, the sync is ok and also the automation to create is ok, but it only works fine when the whole line is fullfiled at the time, if someone fullfill one cell each time it will create one record for each cell. The issue is that always return that the record does not exist. 

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.