Ask the Community

This is a basic hack to sort a simple list of pre-determined roll-up values (e.g. 12 months) without a script or 3rd party automation.In the example below, month values from the Sub-items table are rolled up in Items table / Unsorted column.  Columns 'M1', 'M2', 'M3' use a REGEX_MATCH formula to check 'Unsorted' for the corresponding values.  The column 'Sorted' uses a series of IF statements to to join these together in the right order.  

We have a fleet of vehicles, with a entry_date and exit_date, we also categorise their type (passenger/commercial). I was hoping Airtable could graph (suspecting only line graph will work here) each month of the year (Jan 2023/Feb 2023/Mar 2023/etc) and the total count for passenger vehicles and commercial vehicles where the month of the year fell between the entry_date and exit_date. Has anyone done this before? Thanks for any help in advance!!

Hi, I am trying to design a scheduling tool for my business, and the timeline view is proving itself to be very handy. One think I can't quite work out is what 'precise' or 'expanded' does - in certain views. For example, if I have a morning and afternoon booking on the same day, when viewing the whole week, these display as 'full day bookings', and therefore take up two lines. I expected that 'precise' view would show these as two bookings on the same line (representing exactly the amount of time they take up), and 'expanded' to show as I've described, but that doesn't appear to be the case. I can't see why it wouldn't do that - as obviously the software can render records smaller - the month view demonstrates that. It would be great to see these bookings in a single line. Can anyone shed any light on whether this is designed behaviour, or something unusual in my setup?Thanks for the help,Richard 

Hello,I'm reaching out to inquire about a specific functionality within the Airtable API.I'm currently working on a project that involves duplicating a database template, including all of its tables, via the Airtable API. While I've explored the documentation and experimented with various endpoints, I haven't been able to find a straightforward solution for achieving this.Could anyone in the community kindly provide guidance or share if there's an API script available that facilitates the duplication of a database template along with all its tables? My goal is to automate this process as part of a larger project.Your insights, suggestions, or examples of how to achieve this would be immensely appreciated.Here's an example of the JSON script I've attempted to use:{"base_id": "YOUR_BASE_ID","new_name": "New_Base_Name","copy_tables": true,"workspace_id": "YOUR_WORKSPACE_ID"}Thank you all for your time and assistance!Best regards,

Hey Airtable! I'm looking for some complex scheduling help. I'm using Airtable to schedule a multi stage music festival, and we're hoping to have a formula that will look for scheduling conflicts for individual performers at specific times. I have an example of how we have the scheduling started attached. The main record name is the act, and then we've created different set times for different stages across the three days. There are also individual performers listed for each set, since some performers will be playing in multiple bands. So basically, I want the formula to be looking for scheduling conflicts for individual performers during specific windows of time. Is this possible? Do I need to be building the worlds longest IF/THEN formula? Appreciate any advice!

Hello,I'm reaching out for assistance with an issue I've encountered while trying to interact with the Airtable API. Despite following the documentation provided by Airtable and ensuring that I've granted the necessary permissions, I'm consistently receiving an error message.Here's the API request I'm making:curl -X POST "https://api.airtable.com/v0/meta/bases" \-H "Authorization: Bearer YOUR_TOKEN" \-H "Content-Type: application/json" \--data '{"name": "Apartment Hunting","tables": [{"description": "A to-do list of places to visit","fields": [{"description": "Name of the apartment","name": "Name","type": "singleLineText"},{"name": "Address","type": "singleLineText"},{"name": "Visited","options": {"color": "greenBright","icon": "check"},"type": "checkbox"}],"name": "Apartments"}],"workspaceId": "wspmhESAta6clCCwF"}'However, I'm consistently receiving the following error message:{"error": {"type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message": "Invalid permissions, or the requested

I connect all tokens and link and Rested post in account collectoin.but when I sent my test value I got this :"Select data to bind to the UI and/or use in another API request" Below is error message and this is is Jason body and then a test data. I am spending hours here. please help me      

Hey guys, I have a button in my Airtable that triggers a Zap in Zapier. I'm using this code: { "https://hooks.zapier.com/hooks/catch/14888220/30r6035/?recordID=" & RECORD_ID() }, but it's triggering the Zap twice. I'm also using multiple buttons, and it's not working as expected. Can you help me troubleshoot this?

Hi to all 🙂Maybe someone knows, is there a possibility to import archive Mbox files to Airtable?For every mail, new record in Airtable (sender, receiver, date, Subject, Content, Attachments, etc.)Thanks aheadRegards, Imelda

Hey amazing people 🙂 I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is my display result I would like to see "March 3rd, 2023" March 4th, 2023" "March 5th, 2023"It seems to pull in based on the order of my current Top view in the Table it is pulling from, but even swapping the View with the sort order I want didn't seem to change anything (And I don't want that view at the top anyway)Any ideas?

I have 2 tables with a many-to-many relationship...Companies companyName, companyCountries (linked to Countries table)Countries countryName, projectPhase, countryCompanies (linked to Companies table)The projectPhase is country level, for example...GB = "go live"JP = "phase 2"MY = "go live"US = "phase 2"1 company can have multiple countries, and so on the Companies level I've created a rollup using ARRAYUNIQUE(values) but I've run into a problem with a scenario like this...CompanyA is live in GB and JP and shows "go live, phase 2" CompanyB is live in JP and MY and shows "phase 2, go live"I've read a bunch of posts on this behaviour and how the rollup retains the sort order of the original linked source (in this case Countries), but my Countries table needs to be ordered as it is, and there's so much variation in my companies data that regardless of the ordering, I'm going to get these unsorted rollup values.  So when I group by my roll-up I'm getting a bunch of diffe

Hello everybody, at first I set one column in my table 1 so that I can link it to items of records from a different table 2 (via multi-linking to record). Then I wish to fill a different column in table 1 through rollup function with another matching item of the same records from table 2. Problem is, that the order inside the rollup column is automatically opposite to the order in the first column linking to the record. I would like to have the same order in both columns, but I cannot set anything about the order connected to the rollup function. Can anybody help, please?

Hello, I'm looking for a WordPress plugin that would allow this: For each new entry in an Airtable table, retrieve the images and text and insert them into a defined WordPress page (always the same, it would be to create an image and text library...)thank you.

Hi everyone,  I'm trying to be proactive with the the imminent change to the integration with Airtable. I've connect Zapier via the App Update (Presumably using OAuth) and connected Make with an OAuth connection.  However, I expected to see the connection appear in Airtable under the developers OAuth section but there is nothing. How would I manage and revoke these connections if I can't see themCheers all, Jason   

The new Interface feature allows you to filter a collaborator field by “current user” which is a great time saver. Anyone know if they will make this available in regular AirTable views? I really need it.

Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number of criteria where the score is >= 0Determines a max possible score based on the number of criteria scored (e.g., there are 10 criteria in a category but only 9 of them got scored the max possible score is 9*3=27 (9 criteria scored * highest possible score))Adds the values for each of the criteria scored to get the actual totalI'm able to use sum to get the total score but I'm not sure how to get the number of criteria scored without using countif which Airtable doesn't seem to have.Is there a way in AT to do what I'm trying to do? Any help is most welcomed. 

Suppose you have a series of records that include zip codes. There may be many of one zip code and a few of a bunch of others. How do I get a list of the frequency of these zip codes? So 14757 occurs 6 times and 14722 occurs 9 times and 20021 occurs 3 times, etc. I want to get a list of the zip codes by how often they occur and if possible a count of that frequency.Any thoughts would be greatly appreciated.Scott

I expect this is beyond what Airtable / 3rd party automations can do but if achievable this would be an absolute game changer for me. I would like to create three fields. Field 1 (Single Line Text) / Field 2 (Attachment) / Field 3 (Attachment).In Field 1 - I enter the name of an employee. In Filed 2 - I attach a multipage pdf. Then in Field 3 - I get the multipage pdf with the individuals name across it as a watermark.I've tried programs Zapier, CraftMyPDF, pypdf but hitting hurdles throughout. Any ideas are enormously welcome.     

So full disclosure I do not have a ton of experience scripting, but I have built quite a bit of stuff in office script with the assistance of chatgpt and a lot of follow-up questions/research to understand what CGPT did and why it did or did not work.Did the same here trying for my first scripting automation but I am kind of stuck on an issue early in the script. The intent is that whenever a record is created or updated, the script should grab ALL records in the table that have the same values in two fields as the new/updated record. IE if a record with training type "CPR" and employee "Steve" (both are linked record fields to other tables) is created or updated, then the script should retrieve ALL records in the table that have CPR and Steve in the respective fields. It should then look through those found matching records and find the one that has the maximum (most recent) date in the date field, and checkmark that record. If another record previously had the checkmark, that checkma

I have a Table, called Production Sheet, and each production "day" links to a master Batch sheet for that week. There can be many production days pulling from a single Batch Sheet in another table. I can link to the batch sheet just fine. What I would like to do is have the batch sheet show all of the linked production days, which would be separate entries in each of the production days. I thought this would be simple by running an automation, when a batch sheet is linked on the production sheet, by finding the batch sheet that matches that date, and adding that production sheet date to a field in the batch sheet. Of course, this would need to concurrently add to that field and not erase it, as multiple records would be added daily throughout the week. 

Apologies if this has been asked/answered but I couldn't find that thread - I really did look!I have some MAKE scenarios with many Airtable Modules, all linking to single Airtable BASE - itself having many Tables. But, I want to set up a clone of everything (All MAKE Scenarios duplicated and pointed/linked to newly duplicated Airtable BASE).I am using "Column IDs" in the Advanced section of all my Airtable Modules in MAKE. Why? It seems to offer a bit more flexibility for changing field names in Airtable, so they update automatically when referenced in MAKE. However, this seems to be working against me now - see below.Column IDs doesn't make any difference if I simply CHANGE an existing Airtable Module to connect/link-to the New Airtable base - the field mappings downstream break. Fine.But, I never give up, and I have the Developer Tools for Chrome, and it has this weird tool called Remap Source, which does what I want! But in order for it to work, I have to CLONE an existing Airtable

I'm building a PTO request workflow in Slack which adds a record to an Airtable. Airtable then automates some downstream steps which will post the PTO to a shared Google calendar etc. It was working fine. I wanted to make some modifications without messing with the original workflow so I duplicated the workflow itself as well as the Airtable. The Slack workflow duplicate allows me to choose that duplicated airtable (I added it to the integration in Airtable) but it simply won't work when I try to run the Slack workflow. Slack throws "The service used for this step isn't available" when I try to run it. I deleted the Slack integration in Airtable and re-created it with a request from Slack to no avail. I also tested deleting the copy of the table to see if the error changed, and it did- Slack would say "The user doesn't have permission to use this step." instead. A brand new airtable base from scratch works, but I don't want to re-create the existing one if I can avoid it. Any

I’m trying to figure out if AirTable can solve equations with unknown variables. For instance, a break-even analysis based on data in the table. (Revenue per unit ⨉ Units sold) − (Fixed costs + Cost per unit ⨉ Units sold) = 0 (200 ⨉ Units Sold) − (1000 + 100 ⨉ Units sold) = 0 Where Units sold is the unknown variable (“x”), and I would like to know the value of “x” where the equation returns 0 (break-even). A normal equation solver would give: (200x)−(1000+100x) = 0 x = 10 So, could I get “10” to display using an AirTable Formula? Thanks!!

Hi all,I have created an automation which takes an action based on whether a value (a list of dates, via a lookup field) contains today's date (via a formula field). Both are formatted to only include date and not time. However the action is not working because the value returned for the first step is [object Object], rather than an actual value (the list of dates). Any ideas? Thanks!

Hi,  I'd like to create a "Business Health Check" Dashboard, and I'm thinking Airtable might be a good way to do it,  but as a new user I'm not sure how to start. Basics:1. Dashboard view:   Show changes to each category over the past few months (line charts most likely)2. Form:    Owner would fill this out weekly with data for that week3. Data/Questions (this is where I'm not sure how to lay the data out for the questions, or to record it in a way that the charts could use it).  Question examples    - Time Period (Date 1 to Date 7 - usually a week - ie Mon-Sun)    - Booked for how many days out (likely do this as a number field:  1,2,3,4 .....     - How many new inquiries did you get from x source this week?  Number field    - How do you feel about business this week?  - Drop down selector - Not Good, Good, Indifferent      Doing the form so it captures the time period is