Ask the Community

Hopefully I’m posting this in the correct section. If not, please direct me to the correct one. I was going to post in the API section, but this seemed like a “broader” section to start with. I have setup AirTable to support a gaming group of which I’m the admin. The multiplayer game does not have any admin tools leaving us to develop our own solutions. Having done table design and DW/BI work in the past, I was able to build the table structure and views without any difficulty; once I learned how the table linking worked in Airtable. I’ve even been able to create and post the “forms” for users to input data and respond to events with their “bids”. The next logical step is to create the output I need. I’ve attempted to connect Excel to Airtable with little success. I can get the connection created, but I only get a single field of “Record” values. Total rows is correct, but I can’t see any of the fields. I’m familiar with ODBC, SQL, etc. but have no experience with JSON, Java or

Hi. What is the best way to export AirTable data for use in Microsoft Word’s Mail Merge tool, and have it updated in Word after making changes in AirTable?

Hi folks,Trying to create a column with one email address in, it's currently showing 3, any idea of a formula to remove two of the addresses so I can send an automation?

Hey guys, I’m fairly new to airtable, but i’ve read all the posts i could find on this topic, but still stuck. I have a list of clients and a list of vendors. some clients prefer only a subset of vendors - i define the preferred vendor relationship in my base design. I have a form that collects requests to engage a vendor for a quote. I want : Basic: Based on client selection to present only relevant vendors in the list. Advanced: I want to present relevant vendor based on vendor category in addition to the above what’s the best way to do this with the newly added functionality of logic on lookups / rollups etc? Thank you guys in advance!!!

Hello! How to link tables, but to include info in form of linked variants to choose from? Here is the deal. We sell cars. And need Airtable as a database to synch to our website. Our team members add cars to the database. The question is: How to make dropdowns in columns from linked tables, so they would “know” the previous column and provide an option to choose from a specific number of variants? Here is an example: We want to add a car. It has a lot variables, some of which are: “car maker”, “model” and “specification”. I would like to have a columns dedicated to each variable. But so if for example I choose “car maker” Mercedes-Benz, in the next “model” column I would get only Mercedes-Benz’s models, and after I choose, for example “S-class”, in the next column, “specifications” I would only be able to choose from that model’s specifications? How can I achieve that? Spent too much time trying to solve that problem Thank you!

Hi! Mailed support and didnt get a reply. So Im trying here instead. I understand one can have a conditional dropdown that adds all the values from a linked table. But what if I want to select between the values? Lets say I have TABs called “Company” “Office” and “Employee”. Now I would want to add an Office to an employee - but only the offices linked to a specific company. How would one do that? Im guessing using IF statements - but would it work for string values? Regards, Vincent

Helllo, New to the Airtable platform. I am wondering if this is possible. I am developing a manufacturing schedule and in the schedule you have a Phase and multiple (different) steps in each phase. Ideally I would like a (2) drop-downs side by side and the second one becomes dependent on what you chose in the first. So if i Choose Phase 3 the second column would only show steps associated with Phase 3 not all the others. Thanks

Requires Linked SingleSelect/MultiSelect Dropdown, which can be restricted on the basis of any criteria. In particular I need Dropdowns, which offer a subset of choices based on the result of another dropdown/field. For example, I would like to have a drop-down “LAND”, which gets the data from a separate table (LAND, REGION). The table would then look like this: COUNTRY, REGION Switzerland, Aarau Switzerland, Bern Switzerland, Zurich Germany, Baden-Württemberg Germany, Lower Saxony Germany, Saarland France, Aquitaine France, Brittany France, Poitou-Charentes …, … A second dropdown “REGION” should then only show the regions matching the selected country. Then the second dropdown should only show “Aquitaine”, “Bretage” and “Poitou-Charentes” when I select “France” as the LAND. If I look up in the forums, this is probably a very popular wish for a long time. Is something like this available now and if so, how does it work?

We review a variety of documents for client. Such as bylaws, legal governance documents, and financial statements. Currently I have a base and a form set up. The form allows a client to submit the documents they would like to have reviewed and provide their client information. Once that is submitted the base is populated with the documents broken down by category, the clients name and contact, and a unique ID for the batch of documents. At this point we vet the documents to confirm they are the right ones start to extract the information that we need. Data can be in the form of select phrases within a set of bylaws, critical dates of documents expiring or when they were registered, and the financial details of a document. Once this is done we create a summary of our findings and present it back to the client. This is largely done manually at this point with a few automations. We want to start fully automating this process and use Airtable to store our data. But we are struggl

Does anyone have any suggestions or input they would like to offer to help me decide the best way to organize my companies new lobby base? The project is tied to a sign in form (AirTable Form) for anyone coming into our lobby to sign in to.This includes people coming in for appointments, dropping off documents, picking up documents, questions, status inquiries, speaking to a manager (escalated needs), and all the above.We have multiple different departments in our company, so I have been thinking that we have two multi-select fields.1. PURPOSE OF VISIT:- Dropping off documents- Picking up documents- status inquiry- OTHER- scheduled meeting1. REASON(S):  why the person is here today.  And that can be a long list. Even though we have different departments in our company, there is a lot of overlap in terms of the services we provide and often there is a necessary need for multiple departments providing assistance in tandem with one client. My main concerns are how

Hello Airtable Community.  I've reached my wits end and so has chatGPT 🙂  I am using the following scripting code in an Automation to extract some data from the record that triggered the automation and insert into an external API.  Most of it is working as expected until the very end of the first function where I keep getting   CONSOLE.ERROR "Error processing Airtable update:" "Unexpected end of JSON input"  I've tried lots of logs to understand the input and everything appears in order to me.  JSON is coming back fine in each of the "console.logs" indicated in the code here.  An example here:What could be causing this error?  Source code below:  // Function to escape HTML characters function escapeHtml(input) { return input.replace(/</g, "<").replace(/>/g, ">"); } // Airtable Script to trigger on "Terpene Tags" field update // Airtable Base ID and Table Name const AIRTABLE_BASE_ID =

Airtable, Please consider adding tabs/pages to the Record review area. There are workflows were you do not want to be scrolling up and down. Tabs would allow “pages” for other fields, text descriptions, etc. This would be similar to using the Description app. Thanks, Jonathan

I am hoping someone can help answer this basic question.We have a survey where our athletes answer using a ranting system. I want to take the rating once in airtable and assign it a number value. 1 star = 1, 2 stars = 2, 3 stars = 3, 4 stars = 4, and 5 stars =5 so I can total.Is this an easy thing to do or do I need to get the data into a number before it hits airtable?

Hi everyone, I need to have a “Filter” column that is pulling date values from 3-4 different columns and selecting the one that is the most recent. So if we have 3/10/2021, 3/10/2022 and 3/10/2023, the date that populates the “Filter” column is 3/10/2023. It’s not always consistent which column will have the most updated date. Is that possible to write a formula for? Update: MAX () doesn’t seem to work for anything other than Number fields. Desired outcome is to look at multiple Date column values, pull latest date value or if all the values are the same, output the same value.

I've got a handful of companies that had meetings taking place on various dates.  I want to filter out those companies who did not meet on both 07/17/2023 and 12/05/2023.  For example, if Company A met only on 07/17/2023, it would not be shown.  If Company B met on 07/17/2023, 09/26/2023, and 12/05/2023, only the July and December meeting dates would be shown.  If Company C met on 07/17/2023 and 12/05/2023 only, that record would be shown as-is.  I've attached a file as an example.  Thank you!

hi all,I am new in Airtable, and cannot find an ideal solution after searching for few hours.-------------My Question-------------- I have a table[Clients] with field[Email]. And another 2 tables are described below:- Table [Sales] : Sales list indicates which sales is responsible for which clients. The common field between [Sales] and [Clients] is [Email]- Table [Table Number]: to indicate which table those clients are assigned to sit in dinner time. The common field between [Table Number] and [Clients] is [Email]I want to add lookup fields from [Sales] and [Table Number] to integrate all the information(ex. sales, table number) of a client in  [Clients]. How can I achieve it?--------------------------- Since the limitation is one column can only link to one another table, I'm stuck here. Hopefully someone could help, thanks in advance!

I need read-only users to be able to click a button and delete a record. I am just about to start learning JS (how many people are saying that now Airtable Scripting exists!) but currently have no coding knowledge! Can anyone help with a script I can run on a button being clicked to delete the relevant record? Thanks in advance!

I am creating a mapping from record_ids to view name. IIRC there is no better way to to do this than list all records in each view and then create this mapping. To reduce the traffic, I would like to return no fields, when I am traversing each view. However this doesn't seem to be possible as of right now. Would it be possible to add this option to API ?

Hi everyone! I'm trying to tackle an issue that I'm not sure I can solve with Airtable, but hoping to alongside Zapier integrations. I want to randomize monthly meetings across our staff, volunteers, and board. Not everyone is willing to use Slack, where I could just install an app integration, so I'm hoping to automate monthly emails through Airtable. I have a list of about 30 people in our CRM, so what I need to do is create a formula/automation that randomly pairs those people together on a monthly basis. Does anyone know if and how I could do this in Airtable? I would love for this to just run in the background, rather than me having to manually do this every month. Thank you!

Hello! When attempting to edit an app, I enter https://localhost:9000 into the Edit app dialog box, and I’m getting the following message: As well, I run into this screen when going directly to https://localhost:9000 in Chrome: This did not occur previously. I’m not sure what happened but I don’t know what I’m supposed to enable. There doesn’t appear to be an allow-insecure-localhost flag when I go chrome://flags/#allow-insecure-localhost. Any idea what might be causing this?

Hi, I am trying to populate in a cell, "Urgent" when a project is coming up on its {Due Date} within 7 days of today AND the cell that has my completed date, {Date Filed} is Empty. If {Date Filed} is Not Empty, i'd like it to populate "Completed". If {Due Date} is over 7 days away and {Date Filed} is Empty, i'd like it to populate "Pending".Any assistance is appreciated. Thanks! 

Add static Google Maps to attachments based on addresses in a table. Source Code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGE

I have some interfaces where list views are grouped by client name.  I would like a "collapse all" or "expand all" function so that in those interfaces, it is possible to quickly expand all the lists or collapse them and then go one-by-one.  The only "global" controls that I see are filter and sort.  Are there others, or some way to do "collapse all" and "expand all" elsewhere?  Thanks.

Greetings. My automation receives a webhook from a form. In subsequent steps, I'm unable to reference the field values: it's gray, and hovering displays the error "Cannot assign list of collection of complex types to collection of complex types."How can I reference these values, or at least reference the raw JSON in a scripting step?

Has anyone succeeded in merging Airtable data with InDesign CC layouts/style-sheets? :nerd_face: We’d love to be able to leverage online datasets to populate nicely designed layouts for PDF export. This export will be done both locally, as final artwork files for professional print; and hopefully… automatically. We’d :sparkling_heart: LURV :sparkling_heart: to be able to generate PDFs, in the cloud, using real-deal layouts, that can then be relayed/ingested via other integrated services like Dropbox, Slack, email, etc. How would you build an Airtable-InDesign CC-Google Cloud Print-Slack/Email stack? THANX YALL! :dancer: A.