Ask the Community

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":

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-

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 Wa

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

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 Par

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

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

I've created a pivot table in a dashboard interface and I'm trying to summarize cost for projects. Each record is a deliverable which has a corresponding "Brief" that it's tagged to. Each deliverable also has a cost associated with it. Both "Brief" and "Cost" fields are lookups from another table.The pivot table:Rows: BriefColumns: Deliverable TypeSummarize by: FieldField: CostSummary type: SumUnfortunately, the pivot table just shows up completely empty. I created the same pivot table as an extension and that worked perfectly. I can't seem to figure this one out.Also, the Cost field is set as "currency" in the lookup table, if that's important.

Hi everyone ! 🙂 I'm running into an automation puzzle and would love to have a little help.Take a look at the picture attached. I have a list of clients (column A) and each of these clients are linked to their account manager(s) (column D). Other columns are various infos about each client (status or region - columns B and C - I've kept these as examples).I want to send a weekly reminder, by email, to each account manager, with all the clients they have to reach out to this week (according to a filter on which the view is based - Priority Status (not shown)). Things would then go like this : Charles receives an email with a list of every bar for which they are account manager, so everything from line 93 to line 108Ines receives an email with the 2 bars for which they are account manager, so only lines 100 and 109(and so on, for every account manager)I'd love to be able to do this without adding a new t

Hello,I am new to Airtable. I am trying to do one automation which is as follows.I have a table named "(OMS) Invoices" having 2 newly added columns which I want to use for this automation.First Column name is "Generate Invoice" which is a button with following configurationSecond Column name is "Invoice PDF" which is an attachment.Manually when the button in "Generate Invoice" is clicked it loads an extension "Invoice" and performs the action as mention in button configuration "Open in Page Designer". This populates all necessary values in invoice PDF from airtable table "(OMS) Invoices".What I want to automate is, whenever "Status" is chang