Ask the Community

In the left view column I have created forms. I also see that at the top of the page there is a row of links; Data, Automation, Interface, Forms. My question is should the forms created in View be duplicated in Forms or are they separate functions?Thank you if you can help.

My team recently inherited responsibly for the admin of an 850 seat Airtable enterprise license.We’re not an IT team; we’re just enthusiastic end users of Airtable, so we’re new to being admins.My question: is it possible to determine who gave out an editor license?When I go into the admin panel and hover over someone who was just upgraded, I get messages like:“[user name] was Editor on base [base name] on [date]” “[user name] was Creator on base [base name] on [date]” “[user name] made edits to workspace [workspace name] on [date]Is this telling me their last activity in Airtable?Is there a way to figure out who gave out the editor license they’re using?Thanks

I'm getting a pop-up saying "This form was upgraded" when I edit one of my forms.  I've tried both options it gives me, but I can't get the message to stop popping up.  It's unclear what to do.

i keep getting ‘Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.‘This error from n8n. any idea how to fix it?

I hope someone can help with this please  Connecting from n8n and I’ve created a personal access token and entered it into the Credential to connect with field, Below is the scopes and access permissions I’ve checked that the Base name and tables are correct  I’m not sure what I’m missing here , will be grateful if someone can assist

I'm creating an athlete database. I want to create a column that shows where an athlete ranks, for various metrics, relative to everyone else. For example, let's say someone is 6'9" tall and that puts the athlete in the top 2% of all the athletes in the database. How can I calculate that for that athlete (and every other athlete)? Is that possible?

I have a button and I would like to attach an automation task to it. Is there a way to do that, I see that you can attach a script for a URL but not an automation.

Hello - We are creating a way to track social media posts for our clients. Clients will ask us to make a certain number of social media posts on their behalf, we then want to keep track of how many social media posts have been made and how many are still required for each client contract. Here are the two tables we have created Social Media Posts Created - Airtable - Content overview Social Media Contracts (requests) - Airtable - All content and requests I’m new to Airtable, so this may be a simple formula, but any help would be appreciated.

I’m calling the API (https://api.airtable.com/v0/:baseId/:tableId/:viewId) to get the records from a table, using a view.  There are ~1000 records in the table and about ~200 that are displayed by the view.I’ve noticed that the first time that I call the method that calls the API can take about 10-20 to complete.  Subsequent calls are subsecond.Is this a characteristic of API itself?  Perhaps it caches the dataset after the first call.What, if anything, can I do to prevent this behavior?This is the service layer’s method:export const getTrainees = async () => { console.log('AirtableService.getTrainees()') const TABLE_ID = 'YYY'; const VIEW_ID = 'XXX'; const fields = ['Full Name']; const params = new URLSearchParams({ view: VIEW_ID }); fields.forEach(field => params.append('fields[]', field)); const url = `${AIRTABLE_BASE_URL}/${BASE_ID}/${TABLE_ID}?${params.toString()}`; let allRecords = []; let offset = undefined; do { const pageUrl = offset ? `${url}&offset=$

How would I create an automation that whenever a record is created it should generate a PDF from my page designer extension, and place it in an attachment field - in that record.

when i use the interface (not editing pages, but actually use the interface) it is really slowi have around 3 bases and interfaces that are my company main bases and we use them dailythey are slow, to load up a list of records (10-20 records, filtered from a 5K records table) takes 4-5 seconds, this make my work lagalso, search by one term is slowmoving between interface pages is slow, each page take at least 3 seconds to load not to mention the mobile app… is it fixable? is it just the way it is?

Hey guys, I'm kinda new to Airtable and I would love if anybody would have 15 minutes to help me. 

Why can't I edit the title of some fields in a form? I can edit some of the field titles and not others.

Hi everyone,I’m looking to develop an Airtable extension that relies on some wasm library loaded by the extension script, and some Web Workers started asynchronously on user request (NOT background or service workers, just plain WebWorkers). The wasm scripts are loaded using standard `WebAssembly.instantiateStreaming` API. Does anyone know if there are any surprising sandboxing limitations imposed by Airtable extension architecture for this?

I would like to populate a linked filed with the lookup field coming from different table. How do I automate this

Hi all! I am wondering how one might create fully dynamic filtering of linked records in a single field in a conditional form in Softr.My boss had designed a database for a client with separate fields for different linked records for different user attributes. For example, we had a user attributes table that spanned age range, income, demographics, etc. To make each option in these categories show up only for specific fields, he disaggregated them into their own fields on a user, allowing an individual to use Softr and make selections exclusive to the attribute type. For example, salary ranges would only show up in the income field, racial information on demographics, etc.Now, we want to move all the attributes into one field and filter by the attribute type, so have all the options in one field and have it look into the linked record to filter by category. 30-40k (category: income level) next to Asian American (category: demographics) next to Works in service category: job experience)

I’m trying to work out if I can create an automation to do multiple tasks or if they all have to be separate (which might max out my allowance)…I have a table which tracks my book contracts. Each contract may have up to 5 titles on it and each title could be produced in up to 6 editions.  I’d like an automation that creates a record in my edition table for each planned edition…So,Test title 1 HardbackTest tile 1 PaperbacketcI can get this to work if each automation is separate but feel like there should be a way to group it somehow. However, at the moment when I try to create a chain it comes up as ‘otherwise’ so it doesn’t run the paperback if there is a hardback. What am I missing? 

Hey Airtable fam,I'm trying to build a deal flow CRM in Airtable, and I'm looking for a way to automatically pull investor data from Pitchbook into my base. I'm currently doing it manually but it drains my time.I'm wondering if anyone has found a good way to automate this process. I've been looking at a tool called the Pitchbook Investors Scraper on Apify, which seems like it could work, but I'm curious if there are any other solutions out there.I'd love to hear how you're using Airtable to manage your deal flow and any tips you have for automating the data entry process. Thanks!

I’ve built a database of grants and funding opportunities, and a survey that asks users the questions to determine their eligibility for the various grants. I have a table that lists the grants and how the various questions have to be answered to determine eligibility. I’d like to create a table that populates which grants a survey respondent is eligible for when a survey response is submitted. How would I go about doing that? My first thought is that it would be a formula, ie if Survey Q1=X, Survey Q2= Y and Survey Q3 = Z, Awesome Grant = Eligible, Awesome Grant = Not Eligible. But Airtable doesn’t allow formulas across tables. Then I thought an automation, or a junction table, but neither of these seem to be the answer when I dig deeper. So, rather than struggle for another couple of days, help?

Hi everyone,What are the recommended best practices for sharing complex Airtable bases with multiple stakeholders while maintaining data integrity, permission control, and performance—especially when using linked records and automations?Thanks in advance.

After extensive searching, I’ve confirmed that rollup functions do not support finding the mode of the values in the rollup field. I can’t be the only person who has come across this need, so I’d love to know what methods are available without using a 3rd party app. I’m not opposed to an automation, but would rather it be as simple and without the need for scripting if possible.

I would love to sync Airtable and ChatGPT w/ the new integration but I can’t find any details on security for this and how data is used. Any one able to give insight?

I have list of keywords and URLs. I want script, once in a month, go through those URLs and find if that keyword is still on that URL. Based on result, update field with the status, Exist / DoesNotExist I want to track my backlinks for SEO purpose, they are still live or removed. Any ideas?

Hi Dear Communauty, Facing a small challenge with my apps actually i need to create a recipe directly but i have to do it into 2 steps as I have diffrents tables and really dont know how to solve itif somebody can help to fix it i will more than happy Thanks 

I am going around and around a lot on this problem and still trying to fin. d the right way to go.I have a table of invoices. The invoices are numbered sequentially. Right now I have to enter each invoice number by hand after checking a summary table I made that lists the latest invoice number used +1 from a formula.I would like to have the “latest number used +1” inserted into the invoice number field of the new invoice being created. I imagine that it I not as hard was I am making it. I will tell you that I am TERRIBLE at automations. I find them unintuitive and frustrating. It’s probably me.But I am guessing that an automation is what I need..So invoice table is “Invoices: House” and summary table is “Invoice: Next invoice Number”. The summary invoice numbers in the “Invoice: Next invoice Number” table are in a rollup field and the Invoice Numbers in the “Invoices: House” field is a numbers field if that matters.Any help is appreciated.Best, Scott