Ask the Community

Hello, Airtable community! I'm working on setting up a career path assessment tool within Airtable, designed to evaluate and suggest personalized career paths based on user responses. My aim is to have everything contained within Airtable, from data collection to scoring and recommendations. Objective:The goal of this tool is to automatically calculate scores based on assessment responses and use these scores to suggest appropriate career paths. This involves creating a streamlined and efficient form directly in Airtable for data entry.Current Setup:- Tables: I have tables set up for Questions, Responses, Roles, Skills, and Traits.- Form Creation: I am trying to create a form view in my Responses table to collect user inputs directly within Airtable. Issue:I am encountering difficulties in creating and configuring the form view:- Form Fields: Some of the fields do not appear as expected in the form view.- Field Ordering: Struggling with ordering the fields correctly according

Hi, I'd like to know if it's possible to get the ID of an interface's table from its page ID, or if there's any other way to get the ID of an Interface's lined data for the api from within the interface itself? In the DOM or anywhere else?Our team built an integration for Airtable that lets users run their own features from within the Airtable page. For it to work with interfaces we need the record + table id from the interface view/page, is there anyway to get it through the url or the html on the page.Thanks!Ohad.

Dear Community,I am writing to report an issue that I have encountered with the automatic upload of images to Airtable, which subsequently causes errors when attempting to upload these images to WordPress via an automated workflow. Here is a detailed account of the observations and steps taken to diagnose and troubleshoot the issue:Overview of the Issue:I have implemented an automated workflow using Make.com to generate images using OpenAI's DALL-E, store these images in Airtable, and then upload the images from Airtable to WordPress. However, I am encountering a persistent error when attempting to upload the images from Airtable to WordPress. The error message received is:```[500] Sorry, this file type is not permitted for security reasons. (error code: rest_upload_unknown_error)```Detailed Observations:1. Image Generation and Initial Upload:- Images are generated using OpenAI's DALL-E and are saved in PNG format.- These images are automatically uploaded to Airtable in an attachment f

Hi,I already have a working api tested by apifoxand it produced this code for me  var myHeaders = new Headers();myHeaders.append("User-Agent", "Apifox/1.0.0 (https://apifox.com)");myHeaders.append("Content-Type", "application/json");var raw = JSON.stringify({"name": "k1d","email": "1213@gmail.com"});var requestOptions = {method: 'POST',headers: myHeaders,body: raw,redirect: 'follow'};fetch("/global/i18n-user/register?sign={{sign}}&timestamp={{timestamp}}&appkey={{appkey}}&appuid={{appuid}}", requestOptions).then(response => response.text()).then(result => console.log(result)).catch(error => console.log('error', error)); now I don't know how to proceed**PS the sign={{sign}} part is a combination of timestamp={{timestamp}}&appkey={{appkey} encrypted with MD5 encryption, but I don't know how to make this encryption in Airtable Script, I'm fairly new to making an api myself as I generally just use make to handle this part but now I need to

Hello,I am working on a base that includes artists' names and a lot of them have diacritics in their first and last name. Is there a formula that I can use that could identify if there are diacritics used? It can be a simple True or False formula that I can then use a filter to isolate everyone with diacritics in their name. For First and Last name I am used simple Single line columns.A list of names is important because it is used for a remapping feature on our website, so the end result for airtable needs to be a filtered view of names. I appreciate any help you can provide with this. 

Is there a script/formula I can use to extract zip files as separate files and have them saved in another field?

I have a single line text field as a primary key “name” field. if it is blank when I save the record, I would like to automatically fill in the name as a concatenation of three other fields that are in the record. How can I do this?

Hi y'all,I am trying to figure out if there is a way to change my primary field when I am using data that is automatically integrated from a Google sheet. Basically, I have a Google Form folks fill out and the first question is what their name is. When they submit the form, a row is automatically created in a corresponding Google Sheet, and once that row is completed, a new entry is automatically created in AirTable. However, when the AirTable entry is made, the primary field is the time stamp from when the form is submitted, presumably because this is the first column in the Google Sheet. I was wondering if there is a way to change it so the primary field is the name (the first question that is filled out on the form) instead of the time stamp?I came across this article (https://support.airtable.com/docs/how-can-i-change-the-primary-field-in-my-table#changing-the-primary-field-type) discussing how to change a primary field and it notes that "We do not currently support replacing the p

HELLO! I have been wracking my brain trying to figure out how to make this seemingly easy function work and keep hitting dead ends. Basically, I have a list of schools we manage, and I need to assign a phase number to them as new projects are created. The problem is, they are not submitted in order, and we have about 230 schools. I need to be able to count how many times prior this school has had a project created so I can keep track of what phase number we are on. I have a sheet where all incoming projects are being submitted via Paperform, and another “Master” sheet with the school name linked to the incoming projects school name. Every possible option I’ve been able to come up with changes every answer within the column and I need each row to be “set”, if that makes sense. An example of how projects are submitted and what their phase number would be: School Phase Cooper - 1 Roosevelt - 1 Washington - 1 Cooper - 2 Cooper - 3 Lincoln

I want to create a tracking table for customer payment.Every month I check in the bank account who paid and mark in Excel.How can I create a table of all customers and mark for each customer whether he has paid or not?Is there an automation that can every month duplicate all my customers from the customers table to the payments table?Thanks.

Perhaps I’m missing it, but how do I generate random numbers? I am missing “randbetween” and “rnd” from Excel. Thanks for any and all help.

I’m curious if there are any plans to add conditionally shown fields to Interfaces, similar to what is possible in form view? For example, if you’re tracking network outages you might use one field to specify that the cause is a power outage, in which case you would want other fields to appear that let you specify when the power outage started and ended (so you can track UPS runtime when the power goes out, and site recovery time when it comes back.)

Hi - just getting into Airtable. I’ve got a spreadsheet with book details that includes authors in a field. I have them in inverted commas ie “Last Name, First Name”. This is so that I can then take the field and link to another record to create a field in an Author table where the authors appear as a record with “Last Name, First Name” in the field. However, once the spreadsheet gets into Airtable (whether pasting or importing) the inverted commas have vanished from sight and so when I link to another record each author creates two records, one with “Last Name” and one with “First Name”. Is there any workaround for this? I’ve seen the help page about preparing text but that requires adding inverted commas around every author in every record after importing which will be a massive task. The only solution I’ve come up with so far is to have authors as “Last Name/First Name” or “Last Name-First Name” in the spreadsheet as then there is no comma delimiter problem in linking to another

Most 2FA systems allow you to enter a code manually so you don't have to scan the QR code but there is no option for that in AirTable. My camera on my phone is currently broken and so I have no way I can set up 2FA with AirTable with my authentication app.Is there a button I am missing somewhere next to the QR code to get the key manually?

Is there anyone who has a script to unzip an attachment field into another attachment field. In other words in Attachment field 1 is a zip file, have a script unzip and put all attachments as separate files in Attachment field 2. The zip file is coming in from Jotform through a zap in Zapier.

Hi there,I'm creating a weekly digest email that pulls all records created from the past week and displays as a Grid of Records in the email.When a preview is generated within Airtable, the formatting is clean and the text for each entry doesn't wrap within the cell.However, when the email is sent out, text within in each cell wraps, making each row taller than a single line and isn't a consistent height. Several of the fields are linked records.How can this be adjusted so the Grid Records in the email appear more like the preview in Airtable (consistent, 1-line row heights with no text wrapping), rather than how they are appearing in the email currently?Preview within Airtable:How Grid Records Appear in Email: 

I’ve been trying to delete a published interface but can’t find where to delete it. I opened the interface and looked for a delete button but couldn’t find one. I exited the interface and went to my workspace to see all of the bases and interfaces I have, but I couldn’t find an option to delete it there. Thank you in advance.

Hello everyone,Me and my team are working on a database for my business, to be frank we're new to Airtable, and there's something we can't quite figure out. There's this one table that is for recapping all of our clients' consultation sessions. After each client consultation sessions, that session will get added to this table as a separate entry, and be given a specific Consultation ID. The goal is to make something like this:Consultation ID: EVA/COU/2024.06/000004-001The things that matter here are the field "Unique ID" which is 000004, and the three digit after the dash, which in the example is 001, which should signify the amount of sessions they have with us, 001 here meaning it was the client's first ever session.The field "Unique ID" is tied to the field "Participants" which is linked to a different table filled with details of our clients. Each Participant is assigned a Unique ID.If they have following sessions with us, then we would like the three digits after the dash be auto-

Hi, I'm playing with the interfaces and I have a question. Is there any way I can share an interface with a person that hasn't an Airtable account?I don't want to add them as collaborators, because they should see only that interface (not the base) and I don't want to ask them to create an Airtable account just to see my interface. My final goal is sharing the interface link with an automation through email. Is there any way? Thank you!

I'm getting a 422 error saying my column "Step" doesn't exists, but the column exists and I haven't touched it. When trying the module alone, it works. But when I run the automation and the strings are mapped, it doesn't  

Hi! I use Airtable for tv title tracking and I'm trying to see if it's possible to update a field ("Distribution Rights") when a separate field ("Distrbution Rights Details") is selected. Example listed below:When "EXPECTED: All Media Worldwide" is selected in the "Distribution Rights Details" field, populate "Distribution Rights" field as "Global Expected"Is this automation possible? If so, would it be possible to add additional options (when All Media Worldwide is selected, populate Global in Distribution Rights)?

Would someone from the custom extension review team be willing to pop in here and answer a question for me?  Would be greatly appreciated!I've been working on a single extension for 18 months and have a question about breaking one of the extension rules.  I would like to provide some context and see if a workaround could be found. Thank you!

This one is puzzling me. I have an automation that watches for a field to be updated, which then updates another field on the same record. It mostly seems to work as I need it to. However, I keep getting errors that the automation has failed as it "does not exist". It will successfully be triggered, but unable to update itself.Indeed, these records don't seem to exist. I expect they are deleted. However, I can't get the automation to fire by deleting a record.What could possibly be happening to the record between being the trigger and the update step?I haven't been able to "catch" this failing in action, as it doesn't have a noticable effect in use - I only see it when airtable emails me a notification. 

It is very frustrating to match up automations or API processes with data changes in a record's "activity" log with broad time information like "an hour ago" or "2 days ago." Please consider introducing fine-grained timestamps EVERYWHERE you log ANYTHING. As an Integrator née Software Developer, this is making me pull my hair out

Hi I have started another base. The main base is working fine and this base is for an add on registration service. I tried to create the form https://airtable.com/app6DqS2bqGtz03sG/pagZRFkh5bC0Ay4TK/formI have filled out the film and submitted it but it does not populate anything in the base. I also cant find the form when I go back to my work sheet.Please may I have some assistance