Ask the Community

I've used this very helpful page to be able to export my tables out of air table and into Power Query, and from there into Excel: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportHowever, I'm having an issue that some seemingly random columns aren't being picked up by PowerQuery. I've done this with 5 tables, some have worked perfectly, some haven't. The columns that are missing are different types, sometimes check boxes, sometimes free text fields. I can't work out what the pattern might be, and therefore how I might fix it.I'm hoping someone might have come across the same issue in the past, and know exactly what I'm talking about and how to fix it. 

When using a timeline view for tasks, we know if you group by Project, it's a nice way of being able to view all Project tasks in a neat and concise way, side by side.Is there a way to order the Projects (vertically) by the earliest task?  At the moment the only options are alphabetically A-Z or Z-A.  This would help with schedulingAs a temporary measure I'm adding a number to the start of the project name to force the order I want but unsure if there's any other work around...Screen grab for context (sorry about the blanking out of info)  

Hello, I am trying to calculate the difference between two dates, excluding weekends. Datediff. However, weekend is Friday and Saturday at my company. Workday doesn’t help much since it assumes weekends are Saturdays and Sundays. Your help is highly appreciated.

Hi all, We are on the Pro plan, which seems to default duplicated views to personal even if they were originally collaborative. We mainly use Airtable for grid views, though I’m not sure that has anything to do with the issue. I have searched high and low for a setting or option to NOT do this, as we would prefer duplicated collaborative views to stay collaborative, and not have to manually change it each time. Any ideas?

Hi, I'm simply trying to subtract hours in one field from hours in another. I have a column with 'hours recorded' and one with 'hours billed'. They are both formatted as time units (hours). I just want to subtract one from the other in a new field. As an additional question is there a way to set the hour units to just hours, with no minutes, at the moment it's h:mm and I need to enter a 0 for minutes each time Thanks   

Do you ever wanted to query your airtable in SQL with no sync ? Now it is possible thanks to SQLify. Connect your airtable account, use SQL to query and create a PostgreSQL compatible DB. Would be happy to have your feedback, we are still in beta 🙂 

I'm trying to connect MS Power Automate to Airtable. A lot of info seems to be stale out there. I have this flow, which parses data. I found this step HTTP Webhook. I'm hoping to make this a trigger for an Airtable automation. However, when I run the flow, it gives me a bad request error at this step.Does anyone know if this is possible to set up like this?  

I am a student and currently working on digitalizing and automating the administration for a dance school. The Airtable base is already set up and in use. Now, I want to implement additional features and make adjustments. I am working within the same account that the dance school uses.How can I create a kind of development environment where I can experiment and test new features, while keeping the current Airtable base active and unchanged? I would like to implement individual features into the active base only after testing.Does anyone have a suggestion on how to proceed?

I'm trying to build an automation that uses a custom script to determine whether all necessary leads have been assigned to a record within the base. The teamsNeeded field (multiple select field type) determines the teams that need leads on the record. Each team then has a lead field (single select field type) where the lead is selected. If "Comms" and "KM" are selected in the teamsNeeded field then the "Comms Lead" and "KM Lead" field need to have a selection/not be empty.I have limited scripting experience but have been able to build the one below. The issue is that it is outputting 'All Leads Assigned' even when leads are missing. The console log for teamsNeeded shows that all teams are being captured - the log for the example with "Comms" and "KM" in the teamsNeeded field reads "teamsNeeded (2) ["Comms", "KM"].Is there something I am missing that is causing the output to always be 'All Leads Assigned' instead of 'Leads Missing' when leads are missing? 

Basically, I'm wondering how to change the fields shown in a linked record field dropdown/select menu.These fields below (Record ID, First, Middle) do little to help me distinguish among similar records.Note that this particular screenshot is of a linked field to a table that is synced in from another base. But my question stands generally, whether for a table«»table link or for a table«»synced table link—what's the best way to choose my own fields to display, if it's possible at all? 

Our company has an inventory of office supplies, which we track in a table called 'Inventory'. This has fields for item description, photo, quantity available, location, etc.We want to create a system to create "checkout orders" and select multiple items, similar to a shopping cart. We want to do this through interface pages.I know I'll need 2 other tables: 'Orders' (overall requests) and 'Order Items' (items requested in order).The question is how to create an interactive workflow to place items into your order.I'd like to have a List or Gallery starting page, which displays all the items in stock. I'd like to do something like a checkbox or button to add items to my order. (I imagine you'll need to create a new order first.)However, if I just make checkbox field on the 'Inventory' table (the master list), this is seen by all users - which prevents 2 users from "shopping" at once.Does anyone have a suggestion for making a good experience? I

Hello there, I was wondering if it is possible to search a whole workspace using the Airtable API. The reason I need this is below: I have 5 x bases full of LinkedIn profile IDs all with the identical base structure and column headers Using the API I want to search across all the 5 x bases to check if there are any matches I need the results returned in the output from the API request Many thanks, Karan

Hi all - I'm having a very strange issue with a Formula field. I've got a Status field (single select) that informs a Formula field. i.e. if the Status field says ABC, then make the Formula field say XYZ. It's working perfectly except for two outputs. Now here's where it gets weird: after extensive testing, the issue seems to be with the output string, not the input. If the Status is Booking Received, the Formula field should return "Booking received, waiting for pickup confirmation" but it returns a blank field. I also can't get it to return any results when I change the formula to return my name, the word Test, or gibberish lettering. But when I type one of the other results that is working for another status, it works! Meaning if I type "Decline" in to the formula in place of "Booking received, waiting for pickup" it returns Declined. So weird, right?? Why will it only return certain other existing outputs?

Hello! I have a calendar with both all day events and timed events and I am trying to display them both in an intuitive way. The problem is…because some of my records have start times, my date fields need to have times enabled…so I have to arbitrarily assign a start time to the record aka event. But then that stat time shows up on my calendar. I don’t want a start time on the calendar because it’s an all day event. Through a series of formulas, I can create calcualted fields which the calendar references so the events without a end date/time show up as date only and the ones with an end time show up with a time. However, because the calendar view is referenced formula fields, I cannot edit the event directly by dragging or clicking; I have to go into the record to edit the orignal date/time fields. Is there a way for airtable to correctly display all day events without a few complicated formula columns? So they can be editable? Thanks, Nathan

I want to use airtable to build the application form that people submit and goes directly into my base when applying for a job. This particular job has 100 questions, and we're expecting a relatively high number of submission. The application form itself has conditional formating "like if YES to question 17, then there's a 5 more questions on that for you". The questions are sometimes drop down, single line text, long text, multiple select, and single select. How is the best way to do this? The reason I'm thinking of using airtable is because I want to filter responses as much as possible.

Hi, When using an interface on iOS the purple Airtable header doesn't show, while on Android it does. How can I remove the purple Airtable header? Context: I've embedded the Interface in a mobile app. AndroidiOS 

Hello, I would like someone to help me. I have a date field that I want to change the format of in order to include it in an automation that sends an email informing about the appointment date. To format the date that appears in the email, I created a formula field and an automation so that the date (which is of the "date" field type) is converted into a more user-friendly format. However, when I link the email content with the formula field, it’s not retrieving the date. So, I created a new automation to transfer this date to a text field, but when I do that, the text field throws an error. I am attaching screenshots of everything. 

Hi All!Looking for a quick gut check on a build method...record templates vs task template table.Path 1I've built out the base this way task template (table C) and have it all structured,  tasks (table B), and a project (table A). So when a form is submitted it creating a record on (table A) an automation is triggered that reads the project type then finds the related tasks (table C) creates copies of them on (table B) and then links them to the project. This happens for each project created. Path 2I've built the same idea using the record template feature so when automation form is submitted to (table A) the automation is fired that looks to see what program type it is and then updates the record using a record template of the same name and adds new tasks to (table B) linked to the project. There's obviously a lift on the system to run the automation and do all the steps/com

Hi, we are an entertainment agency that needs to create a back end system which includesData base contacts that can be tagedTasks and task trackercreate template contracts that we can edit and send for signatureCalendersIf you can assist please let me know

Hi all I want to send out weekly email notifications to all my customers which shows only the records (orders) which relates to them (i.e. I dont want to show one customer someone elses orders and ) and where status of the order is NOT complete and ETD (date or formula) is on or before the last day of the current month.The records (orders) are found in my order line items table with the information (quantity dispatches, quantity remaining, ETD,  etc)I have a 'look up' customer email address field in this table so I would think this is how this could work? Note that my customers and suppliers both sit in the same table called 'Locations'I also want this to be in one automation (i.e. I dont want to create an automation per customer) so is there a way to send out to all customers? Any suggestions @TheTimeSavingCo @kuovonne ?Than

Hi all As per my screenshot below, I have a filter for orders with an ETD (estimated time departure) on or before the last day of the current month. On the first day of each month i currently manually update this. How can I set up an automation that occurs on the first day of each month that updates 'exact date' to the last day of each month? e.g. 30th sepertember today so 1st October should update filter with exact date to 31st October.@kuovonne @TheTimeSavingCo - let me know if you guys have any suggestions too please? Thank you!Thank you

Hi all I want to create a button within my interface that finds the PDF PO generated under my Orders table and send it out as an email only to the email address under a look up field.The PDF PO is in my orders table (as below)The email address I want to send this to is a lookup field in my orders table   Below are what the conditions will need to be (i.e. Can only send out once the PO is generated)@TheTimeSavingCo @kuovonne @ScottWorld - Appreciate any suggestions

I'm using the AirTable API with Powershell, to lookup records in AirTable where a column value contains a special character ('#')For example, I'm trying to filter on AirTable rows for a Color column that contains a '#'.Let's say the Color value is 'ABC#1'.      I have tried different combinations of double quotes and back-slashes, but nothing seems to work:Using the original color definition doesn't work....it generates an invalid formula error. But no matter what I do in the 2nd variable, I continue to get an invalid formula error.$OriginalColor =  'ABC#1'      $LookupColor = $Color.Replace('#',  '\#')$filter = "?filterByFormula=And({Division}='$Division',{Style}='$Style',{Color}='$LookupColor')"The error I get is: iwr : {"error":{"type":"INVALID_FILTER_BY_FORMULA","message":"The formula for

Hi -I'm trying to figure out the best way to display, in an interface, how many events are occurring on any given date, so I can calculate staff needs based on this count.Tables I am working with:Events (Events are made up a series of Sessions)Sessions (Sessions might be 2-3 in one day, and each one has date info, and is linked to an Event)Events overlap a lot, and a given day may have more than one Event occurring, so I want to have a way to look at any given date and see how many Events are occurring. Sessions need to be staffed by one or more people depending on what kind of Event, etc.I know how to group records in various ways in various grids and see the sum count by group, but I can't do anything with this number because it doesn't live in any field. Ideally, I would like to display this "Number of Events per Date" number in a pivot table style dashboard.Am I missing some really obvious way to do this?  Would appreciate shor

My base has a field formatted for URLs. When I use automation to send the URL for a given record, how do I make that reference a clickable link in the email? It looks like I should be able to do that with Markdown, but I haven’t figured out the details. Thanks in advance!