Ask the Community

 Hello, So Airtable has a script that allows importing a CSV file to update records, I am trying to use this script in an Automation but instead of uploading the CSV to the script, I need it to grab it from an attachment field. The Airtable Script: // Ask the user to import a CSV file containing a header row let csvFileResult = await input.fileAsync( 'Upload a CSV file', {allowedFileTypes: ['.csv'], hasHeaderRow: true} ); // The file importer will automatically parse contents for many file types, including CSV files let csvRows = csvFileResult.parsedContents; // Edit this to the name of a table in your base let table = base.getTable('Purchases'); let shouldContinue = await input.buttonsAsync( `Import ${csvRows.length} records from ${csvFileResult.file.name} into ${table.name}?`, [{label: 'Yes', variant: 'primary'}, 'No'] ) if (shouldContinue === 'Yes') { // Create new records from the CSV. // Edit these f

Hi community, I recently had to solve the situation where I needed to get URLs from hyperlinks stored in rich text formatted long text fields and put them in another long text field. Essentially, just showing the URL, not the hyperlinked text. I ended up adapting the "Convert attachments to URLs" script (posted by Alex Wolfe). I had found a post here, that used a regex expression but this seemed to only work for visible URLs. I never could get it to work for my use case. I'd love feedback on what I could have done differently/better as I'm sure I haven't thought of everything... or even may have just completely missed something obvious. Thanks!// Script settings - Click the gear icon for the Scripting app to surface these anytime // Surfaces options to select th

One of my team members is running into an issue where the default interface view is “edit mode”. Please advise. 

Hi everyone,I've noticed that in Airtable forms or when entering data into a Linked Record field, there’s currently no native way to copy and paste multiple records at once, or to select multiple records in a single action—other than selecting them one by one.I was wondering if anyone has found a workaround, automation, or clever trick to make this process easier. Any suggestions would be greatly appreciated!Thanks in advance for your help.

Hey guys,I am building out a record template that creates new records across multiple tables, however I have a table that only give me the options to "Link an existing record".I've tired making a template on a different table linked to the problem table and the issue is still there, no "Link to new record". Heres what it looks like (green is what I am looking for it to do, and red is how it's currently showing).Anyone have any ideas whats going on?  

hello i want to make symptom and medicine database. where i select multiple symptome and common medicine shows. i have done relationship, but how to get common answer of multiple symptoms medicine . plz guide

Hey! Wondering if anyone has any insight into this!I'm creating an automation between Make.com, Chat GPT and Airtable to automate part of my content creation process. I'm stumped in this automation and would love a hand! The make.com senario uses a webhook to grab an airtable record, sends the record data to Open AI for Chat GPT to make a completion then sends the completion back to the original airtable record.And it's all working, which is exciting!EXCEPT the chat GBT completion doesn't end up back in the airtable record. I'm not getting any error messages to troubleshoot though. Not from make, airtable or chat gpt so I'm not sure what or how to troubleshoot this.All I can see is that the scenario completes successfully but t

Hi all,Seeing lots of posts from 2021 and 2022 about an inability to print from Airtable. When I go to print either a record review interface, or from the page designer, the generated PDF is an absolute mess.A lot of the posts say Airtable are working on it, so hoping that in the 2 or 3 years that progress has been made, or a work around solution has been found?If not, is it fair to conclude that printing from Airtable requires an external app and to factor those costs in when assessing costs for Airtable?Thank you,Ryan

Howdy all, I promise I really have looked at exisitng topics but there is information overload. Ideally I would like ot use ODBC driver to connect to AT to Windows via ODBC driver, I found several but they are all expensive subscriptions.  It seems AT may have its own ODBC driver now??  But I can’t find it anywhere in the AT documentation. What is the best extension or method to use data from multiple tables within a base, fill in essentially form letters WITHOUT using the extensions that you have to put the information boxes on the template.   The data I have for the body of the “letters” is sometimes several pages and I can’t find an extension that doesn’t chop off the rest of the text once it goes beyond the bottom of the information box or window we placed in the page setup.  We are printing the letters to PDF. Any suggestions for something that would act as “mailmerge” or is an annual ODBC sub to CCData or Devart the best

Hi! Scope: New Hire Form Add New Hire DetailsUpdate New Hire DetailsDescription:Want to create a new hire form where new hires are able to fill out their details, and a copy of the form can be sent to them. The form should have an editable link (similar to Google Form edit response function), so that they are able to modify different parts of the fields.I've only seen prefill forms in usage of simple database, or for reservation purposes, not so much as complex as an employee database where multiple fields can be modified. Thanks so much!

When I copy and paste the name of linked records, they appear as they should in the proper order. When I view those linked records in a filtered view (organized by a person’s name), those linked records are now out of order. There are no Sort settings or anything unusual to alter the records on my end. To be clear, they appear in the correct order on the initial view, but not through the filtered view. 

What are the best no-code tools to create your own ai chatbot that can talk to your Airtable base? I want users to ask a question and ChatGPT (or Claude or other LLMs) will answer using my Airtable as a knowledge base. I heard there are tools such as Flowise that enable that. Any recommendations?

Hello Community, We have noticed the following error when sending automated emails: Although I have defined the customer as the recipient (with myself as the trigger in CC), the email is primarily sent to me and only to the customer in CC. Screenshots are attached. Do you have any idea what could be causing this?  

Hi,Is there a way that I can create an interface’s record detail page that auto populates the fields and their order, based on that corresponding grid/list? I’m familiar with the various layouts of the record detail pages that can be saved, duplicated, edited, etc. But it would be really helpful if a new record detail page could automatically be created based on that current grid and/or list view, without the builder having to create that new layout every time.Thanks for any tips! 

We've been relying on view naming conventions to monitor syncs, but is there is a reporting feature or another data-driven solution that lists all of the sync activity coming out of a base? - List of Views that are synced to another base.- List of Tables that contain a synced View.- List of external destination tables synced from a given source table. (this is currently possible for any single view through reviewing the sync settings, but looking for a consolidated view) The specific use case is consolidating bases that have been built by various users. One goal is to eliminate having multiple sync views coming out of one table, but also to develop a roadmap to optimize tables across all of the bases once we're in the same workspace.thanks! 

Hello! We use AirTable for our school roster. Usually, we use dedupe to merge multiple (usually 8-10) classes that each student is in, so that everything stays in just one record. Today I’ve encountered an error where AirTable thinks that two separate students need to be merged instead of each student with their classes. There are 2 records to be merged but AirTable is only showing “one record to be merged”. I am not sure why AirTable thinks these two students are the same record and cannot see that they both have at least 8 records each.I have encountered this before and have just refreshed the page. However, this does not seem to work. I do not see any error messages. 

Hi everyone,I’m exploring ways to use Airtable for managing and updating menu content. I run a site that lists different drink menus (https://brewmenuus.com/), and I’m curious if anyone here has tried structuring this type of data in Airtable.The challenge is keeping items organized with details like categories, nutrition info, and updates without it becoming messy. Do you suggest using linked tables, automations, or maybe a custom form setup for easier updates?Any suggestions or examples from your experience would be really helpful.

Hello, I apologize in advance, airtable is very new to me. I am coming from an MS Access world so trying to figure out the best approach to our setup.We currently have a spreadsheet with 10+ tabs.  Basic information (Contact) on one tab then the other 10 tabs relate to this contact tab.  Various relationships from Investment returns for various years and fees to budgeting.My thought is to create a base.  A table for the Contact information.  Then a table for each of the other (tabs).  I know I can link them using the link feature.But I’m thinking forward to any reporting or interfaces that I build.  To be able to report on the contact info from one table, the investment return from another and the budget from another how is this done?I’m used to using a primary key and joins in access to link these together.  In airtable do I have to link every table to each other and then create a table pulling various links in?  Seems like a crazy amount of work

Hi I’m having trouble figuring out how to properly set up a kanban.This is for contractor scheduling. I have the kaban connected to a table source called Repair Jobs. It’s then stacking fields by Assigned Contractor, with some visible fields, coloured and sorted by status. The purpose is to have an “empty” column where jobs can be dragged to contractor columns, and assigned to those contractors. I want to be able to have a drop down select for different days of the week, or a date picker. That way the admin can select “Monday”, see all the unassigned jobs, and fill up a contractors current day. In 80% of situations they would be looking at it in the context of “today”, but would also want to move forward in time to check future days. The problem with this one, is that if I use the drop down filters for “Mo

Hi All,I want to create a tennis league and publish it on my webstite which I created in Webflow. The database is to be dynamic, information will be added using a airtable form. There will be 16 players in the league and they will play each others. The goal is to get the current league table and ranking. On the page I want to display the results of all the players' matches (example - 6:2 3:6 7:5), the current position and the amount of points collected so far. Has anyone had a chance to do something similar? Thanks for any help and have a nice day 🙂

I have a form for my team that includes an attachment field for images. Every so often, someone uploads an unnecessarily large image and it triggers out-of-memory errors in my Pipedream workflows that run when the form is submitted.It would be wonderful if I could add limits to how big attachments can be. I see that this has been requested before and I’m assuming it’s still not possible, but if anyone has suggestions for how to deal with this issue, please let me know!  

HERE IS A TRANSMITTAL - TO 3 PEOPLE -AND WITH 2 DOCS….MATRIX AT THE BOTTOM GIVES THE COMBINATIONS OF PERSON (EMAIL AND NAME) AND DOCUMENT (URL AND POSSIBLY ATTACHMENT)WHAT I WOULD LIKE TO DO IS CLICK ON SOMETHING LIKE (INDIVIDUALLY) THE 2 X INDIVIDUAL ROWS FOR RECIPIENT…..SEND THAT PERSON AN EMAIL THAT CONTAINS EITHER OR BOTH, THE URL TO GET BACK TO THIS SCREEN (AND THEN WE HAVE TO PAY A LICENSE FOR THAT USER OF COURSE) SO THEY CAN UPDATE THEIR 2 ROWS IN MATRIX - OR - BETTER - SEND THE EMAIL WITH JUST THEIR TWO ROWS - WITH URL AND ATTACHMENT LINK - AND SOMEHOW A CHOICE OF APPROVE/REJECT/NOTED STATUS AGAINST EACH DOCUMENT THAT SOMEHOW COMES BACK TO THE MATRIX ROWS AND UPDATES THAT STATUS AGAINST THEIR NAME AND THE RIGHT DOCUMENT.- IS THAT POSSIBLE ? ANY BETTER IDEAS…..BEEN AROUND THE HOUSES WITH ZAPIER AND JUST COULD NOT MAKE HEADWAY SO AIR

I am writing documentation for a Base to help users who are new to Airtable and the app to use it. I would like to put a table of Icons and their field types in this document so that they can reference it to see what data type goes in it. Many of the people who are going to use this are retired and have no previous experience in this area. They will not think to pass the mouse over the icon to see what type of field it is or they will forget that they can do that.I have searched and have not come up with any sites that have the icons. Anyone have any ideas? Thanks, Scott

I have used SOFTR + AirTable to build a project management portal for my customers. The primary purpose of this portal is to have a common place for my customers to enter information that will be used in the video projects we build for them, so my customers must be able to login with a user (client) account. When onboarding a customer I need to create 3 records:The athlete record, which operates like the “company” record in a CRM The User account record which is a user in the softr platform The project record which is where the customer work will get done. It is linked to the athlete record and the user account record.The softr user table is sync’d/linked to a table in airtable called users.  Generally, I assume it is normal for the softr user accounts (clients) to be created using the softr studio interface. However, since I need to create ALL THREE records each time, I built an admin page in my softr app that contai

Hello AT community,I am seeking advice, general or specific, on achieving frictionless label printing for employees using our base.Our current setup is fully functional, but the process is clunky for users. We have Dymo LabelWriter 4XL's set up at various stations, and we have labels designed in Page Designer. Our receiving station, for example, has a Receiving Interface, and labels need to be created for everything we receive.To print a label, the user has to click a button in the grid element of the interface for the line just received, which redirects them to the record in the underlying base (already a bad situation), then click a button that takes them to page designer, then click 'print' 3 or 4 times to get a label to come out.My background is in warehouse distribution, where our purpose-built warehouse management software would simply print a label as soon as something is received, that is the level of functionality we want to mimic, or come close