Ask the Community

Hi. Thank you in advance, I am wondering if there is a way to show numbers with thousand/comma separator if you combine it with a text in a formula field using concatenate. My Amount field is in currency format. Current Formula: CONCATENATE(Amount, " ", {asking-currency})Much appreciated.   

We have many projects that we want to export or save in an Excel file so we can import them into another platform we’re using. Is there an option to download all the project tabs at once into a single file, so we don’t have to manually download each tab separately?

An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pglCNX2zYBkDmW4gr  

I’m an event promotor. I’ve been using AT for a while to keep track of community member applications, event details, and general ticket sales. I want to get a better sense of real time income via sale so I’d like to update the base.Right now, I have 3 tables in the base:Member List - Record for each member with personal info Events - Record for each event (Party A, Party B, Party C, etc) Ticket Types - Record for each type of ticket (Full price, 25% off, 50% off, comped, etc)None of these include price of the ticket and I would like to start tracking that.Thinking the tables should be this, but I’m not sure:Member List - Same as above Events - Same as above, but add in pricing columns for different ticket types — Tier 1 = $90, Tier 2 = $100, Tier 3 = $110, etc. The pricing can change from event to event so the amounts cannot be a universal across all events. Discount Codes — This would be a conversion of the above Ticket Types table and apply an actual percentage off of the event — Ful

Hello,I work for a print company and want to send Airtable data through API to make what's called a JDF ticket which Esko’s Automation Engine can then use.Does anyone have any experience with this?Our main label database software does this, but I want to replace it with Airtable because it is heaps better. Thanks!

Hello,I'm experiencing a critical issue with my Airtable automation connected to Make that stopped working yesterday, and I urgently need assistance as this is putting a client contract at risk.The Problem: My automation was functioning perfectly until yesterday. Now, when triggered from my Interface button, I'm receiving this error from Make: The operation failed with an error.Error: Validation failed for 1 parameter(s).- Missing value of required parameter 'id'.My Setup: I'm using a script in my Airtable automation that sends data to Make via webhook:javascriptconst { recordID } = input.config();await fetch('https://hook.us2.make.com/2eto4rtkvo8js15rcg05e69ntn5vceqe', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ rid: recordID }) });The recordID input is mapped to "Airtable record ID" in the automation configuration. What I've Checked:I haven't changed anything in my automation, database, or Make scenario The script configuration appear

Hi! I’m trying to embed a calendar view, but the data view isn’t matching the embed view:Data view (the one I want): Embedded view (no bueno): Normally I’d just set the view in the embedded version, but this will be on a TV with a refresh/animation every half an hour, so that’s not really feasible. Any way to fix this? Thanks!

I created an interface with two pages, and one is not showing the information to the viewers. They are getting an error that says "Cannot access this data."Other details...There are two pages in the interface --- one is a list, and one is a record detail page that only allows them to see their own record.They are all able to see their own record, but the list won't show up. The "Users can see" is set to "Specific records" and has one condition on it (status field = active).When I preview the page as the viewers, I'm able to see everything.What am I missing?

Hi all, I have been struggling to figure out a way to solve this all day. I am wanting to track checked out laboratory media in an interface graph so that team members who create the media can see how much is being used per week. I’d like this to be automated for the previous week, but specifically Monday through Sunday of the previous week (so that you can check any day of the current week and the numbers would remain the same for the previous week). My plan for this was to set an automation trigger for early Monday morning, that then finds all records within the last 7 days (all checked out items have creation dates + times for the check-out record), and then marks them with a date for the previous week’s Monday, using the Update Record command (which would be found using a formula field consisting of DATEADD(NOW(), -7, 'days'), which will return the previous Monday (because the trigger to pull from this field is occurring Monday morning). The interface would then pull from values wi

Hi all, as of today CTRL-F is not opening a search bar within a grid on my interface page.  I use this feature maybe 100 times a day and its a big part of my workflow.I rebooted, signed in/out, tried a different web browser, no luck.  This is hugely disruptive and I’m not particularly interested in creating a new interface list page with the native search feature.  There are other elements on my original page that I reference ALL the time that won’t be visible with a dedicated list.  Anyone else run into this and find a solution?  I submitted a ticket with support and they’ll get back to me in 1 to 2 days….

Hello, Any experience with https://baserow.io/We are interested on features missed from Airtable, or viceversa, features missed from Baserow.And, also imporant any experience regarding migration from/to between those platforms, if any.

I know this has been raised before as a feature request but is there a way to add a default value to a date field through automations or some other mechanism other than pleading airtable to implement or a third party add-on? Thanks in advance

Hi everyone, I’m currently testing the ai field agent’s capabilities for automatized tagging of records, but I’ve come across a limitation that I seek to overcome with your help: No centralized tag management. When using the field agent for direct ai tagging, I have not found any option to provide tags in a centralized way, similar to how you can do with linked fields for human tagging. There is the ai recommendation option integrated into the linked record field, but this does only add a recommendation for human usage. Is there a way to have it both? The centralized tagging table and ai field agent tagging? I’m considering injecting an accumulated list, of all entries in my tag table, into the prompt of a simple text ai field agent and have it output it’s selection as a list, which hopefully could be linked via automatization features.

Hello the script I am pairing with my tables is not running a test and giving me feedback on whether it is completed or not.  It just started today as well.  I checked my account limits and have not exceeded them.  Can anyone advise on this issue?

Hello. Thanks for any help on this.Can someone point me to a similar procedure that does the following:After a record is updated:User clicks a button to send a text with information from the updated record A SMS text is sent with this information to a constant, static list of telephone numbers.I’ve looked up several things on Youtube related to this, but they always seem to be too simple for what I’m looking for or too complex.I do use Zapier.  I did create a trial Twilio account.  I don’t mind sending with my own phone, this will only be 4-5 texts per week to 2 or 3 people.Just pointing me to a similar process I think I’ll be able to sort it out.Thank you.

When using the Airtable JS SDK, it seems impossible to use the offset with select to do proper pagination. The type specifies `number` but any value I pass gives me an invalid value error. The web API uses a string offset that's returned from the request. Since this is TS, you can't use a string value with the SDK. Is it possible to paginate with the JS SDK?

Hi there,I'm facing this issue unfortunetly i checked on the community but none of the solutions work for me.This is the error: "type" Invalid_Offset_Value - The value of offset 100 is invalid.I'm trying to get 350 rows. I already did a first api call to get the first 100 rows, what i need is to continue with the second call.When i try this url https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome everything work fine, when i use the same URL adding the offset value, i get the error: https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=100What am i doing wrong? I can't work much on the code, i just can modify the URL. I've also tried to put the recordId instead of the "100" but i get the same reply. Hope you can help, thank you very much

Hi,I have two tables : “clients” and “registration form”. I want to be able to send a registration form to any client no mater if the client is already in my “clients” table or not. (I also have a course table). Lets say I ask for the clients email in the form. If the clients email is already present in my “Clients” table, I want to link the newly created “registration form” record to that specific client in the “Clients” table. If not, I want to create a new record in the “Clients” table with the new client info. Is it possible to achieve this with Airtable or with other tools like fillout? Thank you very much!

Hi everyone 👋I’m trying to find the best way for multiple users to import data (from XLS or CSV files) into the same base — ideally directly through an Interface rather than the Extensions panel.We’ve tried the CSV Import Extension, but: The import mapping doesn’t save across users. Even for the same user, it sometimes resets or forgets the previous mapping. There’s no way to create or reuse “import templates” for different file types or tables. What we’d really like is: A way for different users to upload a file (XLS or CSV) through an Interface form or button, Automatically import it into a target table using a consistent field mapping, And ideally store those mappings permanently (so no need to re-map each time). Is this possible to be done directly with airtbale? Has anyone found a good workaround or script/automation setup that achieves this?Would love to hear if there’s a best-practice approach — either native or via scripting/integration tools.

Hi, I am trying to create a PIM solution in Airtable. Anyone that have dos and donts? It should be a fullblown PIM solution with Productdata, translation funktions, images, stock updates from ERP…

Hi.  I´m facing a little problem here. I need to get an iframe from an interface to embed it on my wordpress site, but i realised Airtable is no longer allowing this. Is there anyway to achieve so??? Thanks in advance

let twoLettersToNumber = { "ah": 5, "ch": 8, "wh": 16, "tz": 18, "sh": 21, "ta": 22, "th": 22,};let lastLetterToNumber = { "m": 12, "p": 12,};let letterToNumber = { "a": 1, "b": 2, "c": 11, "d": 4, "e": 5, "f": 18, "g": 3, "h": 5, "i": 10, "j": 10, "k": 19, "l": 12, "m": 13, "n": 14, "o": 6, "p": 17, "q": 19, "r": 20, "s": 15, "t": 9, "u": 6, "v": 6, "w": 6, "x": 15, "y": 16, "z": 7,};/** * @param {string} token * @param {{ ah?: number; ch?: number; wh?: number; tz?: number; sh?: number; ta?: number; th?: number; a?: number; b?: number; c?: number; d?: number; e?: number; f?: number; g?: number; h?: number; i?: number; j?: number; k?: number; l?: number; m?: number; n?: number; o?: number; p?: number; q?: number; r?: number; s?: number; t?: number; u?: number; v?: number; w?: number; x?: number; y?: number; z?: number; }} dict * @param {number[]} arr */function tryInsert(token, dict

Hello.I am new to Airtable and I have a question concerning linking to another record. Is it possible to automate this process so that data from every record from a field (column) on the "source" table may be copied to a field on the "target" table? The data would need to be consecutive and ordered by the same ID number used on both tablesI found a JavaScript online that may work, unfortunately, 1) I have the free plan and scripting is not supported; and 2) my experience with JavaScript is limited. I added a third party add-in, however, the apparent complexity of the application may prove to be problematic.Any guidance would be appreciated.Thanks!

Hey, I'm getting a time limit error for the below script only for some records.  let table = base.getTable("Photos"); // Change "YourTableName" to your actual table namelet query = await table.selectRecordsAsync();// Object to hold the count of each Claim-Fault combinationlet counts = {};// First pass to count occurrencesfor (let record of query.records) {    let claimNumber = record.getCellValue("Claim Number");    let faultNumber = record.getCellValue("Fault No.");    let identifier = `${claimNumber}-${faultNumber}`;    if (counts[identifier]) {        counts[identifier].push(record.id);    

Hi All, I’m trying to run this automation script that works perfectly on my test base of ~10 records but throws this error when I move it to my real base with ~1100 records. Error: Script exceeded execution time limit of 30 seconds The below code is based on this tutorial here, tweaked slightly with recommendations I found in another similar question. Any help or ideas would be appreciated! Learn Airtable scripting #1: basics & removing duplicates with Giovanni Briggs - YouTube (from Automate All the Things channel) var table = base.getTable(“Table 1”); var query = await table.selectRecordsAsync ({ fields: ["Name" ] }); console.log(query); let duplicates = query.records.filter((record)=>{ return query.records.find((potentialDuplicate)=>{ return record.getCellValue("Name") === potentialDuplicate.getCellValue("Name") && record.id !== potentialDuplicate.id; }) }); console.log(duplicates); let updates = duplicates.map(update => { return { "id":update.id,