Ask the Community

Hello, as of this morning, any PDFs that I attach via the Make integration will no longer open in a preview window, but instead tries to download a file without an extension.  This Make scenario has been running for months without issue, with hundreds of PDFs attached in the manner per day - all being able to open up in Airtable without an issue.  But as of this morning, nothing added today will open properly.  Any attachments added yesterday still open fine.  Any ideas what is happening here?Edit - apparently this is only happening on this specific Base.  If I run a Make scenario to add an attachment to a different Base - it attaches fine and opens normally.  But then if I change it to attach to my primary Base, the same download issue occurs.  I need to get it back to working normally on this primary Base.  This is what I have determined so far:1.  Only is affecting my primary base2. If I manually attached a PDF via airtable, it opens

New to AirtTable automation and surprised this hasn't been asked before, but I couldn't find anything in docs or here. I've got a repeating group set up using List of Records as the Input list. The list of records is only 8 rows long.For each record, I want to run a script. In that script I want to access one of the values from the record currently being iterated over. I was hoping this was passed through `input.config()`, but dumping that reveals only what I manually add as an Input variable.I had this in the script itself, using `selectRecordsAsync` and iterating over each record. However, the operation exceeded the 30second limit, so I thought a repeating group would be better.  thanks

Is anyone using the Resource Allocation Template, or is there a explainer video on how to use it? It looks awesome, but it's overwhelming. I'm not sure where to start. Regarding how to set up that whole process, I'm unsure how to even begin setting an amount of time required to complete a given task. We have a work order that comes in for a design task. It may take 8 hours... no problem, I can assess that and assign a time of 8 hours. But that job then comes in and out numerous times for varying degrees of revisions. Those revisits don't require 8 hours each, so I'm unclear how to best set the time duration so that it's properly allocated once the initial job goes out the door.Any insights on how to start using the amazing new Resource Allocation template is appreciated!!

Previously I have added PDF attachment via API call. This was done using presigned S3 url of a PDF and updating table's field with {"url": url, "filename": filename} whereas url has no ".pdf" in but filename bears the form of "xxx.pdf". These PDFs can be opened on iphone app through open with browser, where redirection would be opening a pdf. (Content-type GETing the link is application/pdf).From yesterday, uploads done the same way would get the right pdf file but with header Content-type: binary/octet-stream. On the phone the pdf failed at displaying and tried to download a file instead. My question is:i)  has anyone experienced specifying filename with .pdf now but not getting pdf back?ii) has anyone got a way way to fix this issue?This change is breaking existing business needs. Please advice at earliest convenience is possible. Many thanks! 

Hello y’all! I’m trying to run an automation on multiple linked records from one record, but it doesn’t work because the action expects one record id. Do you know a way to achieve this? My scenario is this: I have an invoice linked to multiple purchase records from another table I want to fill in a delivered date field on the invoice record and fill the purchase records dates using the automation. Why not use a lookup field? Because sometimes there are partial deliveries or the products are damaged and returned. These would be manually corrected then. All the best!

I am looking to set up a base to manage client onboarding and success.I'm fairly experienced with Airtable and I've built project management bases in the past with linked records and lookups but what I want to build this time has some unusual features and I'm scratching my head how I accomplish this. The use case is something like this:Each new client we bring on goes through an identical series of steps/tasksThese series of steps/tasks can be broken into "modules" such as 1) onboarding, 2) mid year review, and 3) year end review. Each new client added to the base can be enrolled into a module and have a set of records created for their instances of the corresponding tasks. The tasks will be have statuses To Do, In Progress, Done. These roll up into the module. When all the tasks in a module are complete, the module will be marked done.For each client I want to visualize: 1) Their list of tasks (grouped by module), 2) Their modules (with the status)Also want a global view of

Hi, I am trying to automate the process of creating available timeslot (15mins duration) for clients to book in appointments via an online form on Airtable. Could someone help out with a script that I can use to automate creating timeslot records for example, from 8:30am to 4:00pm between 4 September to 8 September?Thank you!Currently, I have set up the record manually like screenshot below. 

Hello,I'm pulling in purchase order data for my company, and have a "Vendor Management Team Partner" associated with each purchase order record.I'm also reconfiguring these POs in a separate table, such that the email address of the PO requester is the primary key.If a requester has multiple POs, they'll have multiple values in the VM Team Partner column, so I'm also adding a Rollup for unique values.I'm then automating the copying and pasting of the unique values in the Rollup field into a Linked field for the VM Team Partner's email info.However, in only some of records, the Link field will display a comma at the end of the values, whereas the Rollup field will not.How is this happening when there is no comma in the Lookup field? I now have to add values in my "VM Email" table for both "John Smith" and "John Smith," which is an unexpected nuisance.Can someone help me understand how this is happening and how to remedy?

Hello, as of this morning, any PDFs that I attach via the Make integration will no longer open in a preview window, but instead tries to download a file without an extension.  This Make scenario has been running for months without issue, with hundreds of PDFs attached in the manner per day - all being able to open up in Airtable without an issue.  But as of this morning, nothing added today will open properly.  Any attachments added yesterday still open fine.  Any ideas what is happening here?Edit - apparently this is only happening on this specific Base.  If I run a Make scenario to add an attachment to a different Base - it attaches fine and opens normally.  But then if I change it to attach to my primary Base, the same download issue occurs.  I need to get it back to working normally on this primary Base.  This is what I have determined so far:1.  Only is affecting my primary base2. If I manually attached a PDF via airtable, it opens

Is there a way to fetch just one record or take the first/last one from the returned list? In table A I have a record with an email. In table B, I also have records with their emails. I need to update A record with B attributes but they come from different sources and are not associated - they just have the same emails.

Two questions: Is there a way to say that a record cannot be created without certain fields being filled in? Some fields may be optional but some are absolutely mandatory. Is there a way to constrain the values that a field may contain? For example, you may want to limit a numeric field to values > 0 and less then 100 and reject a record whose field falls outside of those constraints Thanks in advance!

I’ve duplicated some tables and then afterwards renamed them. However, in lookup fields when selecting a table to lookup from the original name still shows up, which makes me have to guess which is the right one. Anyone experiencing this too and knows how to recache the table names or sth?

Hello! I have recently been building out an interface that has a few different pages within it such as Home, Event Details, Event Contacts, etc. The main purpose for this interface is to create a more user friendly and aesthetically pleasing method for myself and employees to input data to our master base of records. My company manages logistics for touring musical artists so each record in the base represents a single event. Therefore, each page within this interface represents a different slice of the overall information pertaining to each event. If I want to add flight information, there is a dedicated page for that, if I want to input hotel information, there is a dedicated page for that, and so on. Currently, as far as I am aware, the only way to pick which record the interface page is addressing would be to add a Record Picker element which can be used to pick the specific event from a drop down menu. So if I am on the Event Details page within my interface, I need to choose

Hi y'all - I think I've found a VERY dumb breach in Airtable that's leaking PII.  I've sent in an email and reached out via the help system, but I suspect these forums might be better monitored - could an Airtable rep please find a way to contact me for proof? If I can figure out a way to share an image w/o showing how the breach is happening, I'll update this thread and do so.

I’ve pulled lead capture form submissions into a base. But people have submitted forms multiple times, with the same info. How do I use email address to filter out duplicates?

Hello Airtable Community,I'm reaching out for guidance on setting up a more streamlined email management system within Airtable, in conjunction with Make.com, for my cold email agency. We've developed a unique setup that leverages individual IMAP connections for each client's email account, hosted on a private VPS server to handle volume. Our current process uses Make.com to capture all incoming emails, turning them into records within a master Airtable base. This base acts as a CRM, meticulously tracking interactions for each client.Our goal is to refine this system further by enabling direct email replies from within Airtable. Here's a breakdown of our needs and current setup:Integration Specifics: We use Postbox for email management with an IMAP connection for each client. Each client has a dedicated email account on our private VPS. We've successfully automated the capture of incoming emails to Airtable via Make.com. Now, we're looking to enhance this setup to allow for email repli

Hi,I hope you can help me, I've searched everywhere and I can't find an answer to my problem.I work for a training organization. I have a table with students. A table with training session dates. And a table with speakers.In the dates table, I make a link with the speakers (each speaker can participate on one or more dates)In the students table, I want to get the names of the speakers of each session, but in a deduplicated way (I want to use these names to print a certificate)But no matter what I do, I can't remove the duplicates in the names of the speakers.Airtable considers that the 2 or 3 speakers on that each training session date are different arrays.I tried the « arrayflatten » and « arrayjoin » fonctions (and a combination of these) but nothing works.Do you have any idea to ge me solve this ?Thanks in advance

I'm working on an automation that is triggered when a record is created.Here's how it works:I have a Fillout academy registration form with the action create a record on Airtable in the Sourcing table;When the user submits the form, a record is created in the Sourcing table and triggers the automation to perform the following actions:- Retrieve and check if the selected course exists;- Check whether a learner or candidate already exists, using the email address as the unique field in the Learner table;- If the candidate exists, we check if he/she has an existing sourcing, taking the existing candidate and the training course as parameters;- If the sourcing doesn't exist, I proceed with the relationship between the existing candidate and the course (thus updating the newly created sourcing by attaching the existing candidate);- If the candidate does not exist, I create the candidate in the Learner table and link it to the sourcing created in the Sourcing table;- If the candidate exists

Hey guys, Really new to Airtable and not an excel expert either. I have been trying to create a Master Catalog / Master SKU table which contains fields like SKU variations, Amazon ASIN, Category, sub-categories, landed costs etc. I have also assigned a Master SKU code as the Primary and this may overlap for some SKU variations. I want to create another table where I can import the Sales data in excel format, which carries the Amazon ASINs (not all of them populated in the Master SKU) and Units Sold. The excel may also contain other data that is not relevant to this exercise. Similarly, I would like to create more tables to upload sales data from other marketplaces (each has their unique marketplace product ids) as well. How do i get Airtable to recognise these ASINs (or other unique marketplace ids) & match them with the Master so that I can link the records ? Or do i have to key in each line of Sales Data as a New record in a New table and then individually link eac

I developed a table that looks up records from other tables in a base. My colleagues all say that they have never touched this table, yet revision history of multiple records in the Linked column say that they were "edited by pasting." I have searched AirTable FAQ and can't find that phrase anywhere. Has anyone else seen that with Linked & Lookup fields? Perhaps my colleagues just don't remember that they did this? When I add a new record and see it show up in the Linked table, it just shows that I edited it, not "by pasting."

I have a table that was transferred to me over a year ago and now I am the owner. I recently upgraded to the Team plan. I can input data into the template but now matter how I change my field permissions, when I try to delete a row is says: "this table is configured so nobody can delete records". How do I change this? If I am the owner shouldn't I be able to change this. Thank you for your help!

Hi! I want to be able to use something like the Forms feature to add multiple records in one go for non-licensed viewers, but the forms feature is limited to one record at a time and the editable shared view does not support copy and paste. For example: I have a Project name record I want to add (view #1) x number of tasks records linked to the project name (view #2) and x number of project collaborators records linked to the project name (view #3). Rather than submitting the form multiple times to add: Project name Task 1 description + link to project name Task 2 description + link to project name … etc Project collaborator 1 name + link to project name Project collaborator 2 name + link to project name … etc I want to be able to add this in one form. Is it possible with a scripting block/app or in a separate front-end interface?

Is there something wrong with Airtable today? Three of my customers reached out saying their Airtable automations stopped working. All issues needed to set another new personal access token. Aren't these supposed to not expire? If they expire, this is hugely problematic. This code needs to work reliably or Airtable can't reasonably be used for these integrations. I have to reach out to dozens of accounts now to see if their integrations are still working.

Hello. I have a form on my photo studio website that’s connected to a base where I collect and manage client data and bookings. When someone fills out the form an email is generated and sent to me via Airtable with the subject line… “Airtable forms: someone has responded to Photo/Film Booking Request” I’d like to change the subject to something shorter and more relevant like, “Your 08.02.18 Photo/Film Booking Request at (Studio Name)”. This way I can simply reply back to the person with a short, relevant email subject line with the original request email as the first message. Is changing the subject line possible in Airtable or do I need to use Zapier or some other integration? I noticed the SendGrid block, but have not had time to play with that. Thanks!! ~ G

I have many columns that use multiple select fields. However, there are times that they need an option called “Other” and the ability to type in a new option. This option should not be saved into the list of options. I can add another column and let them type in the option there, but since there are so many of these the table is getting quite bulky. Is there a way to have a custom field where you can display an option in multiple select but not add it into the list of options? Or is there another way to accomplish this? Thank you,