Ask the Community

The bases I create are labeled “External” (even after accepting my Organization's invite) and lack the same functionality as bases created by the Big Boss. Are there currently settings that ensure bases created by users within the organization are internal (and benefit from the functionality associated with our price plan)? Would changing my permissions level from “Creator” to “Owner” make a difference? I guess I’m confused that a user can belong to an organization, yet the bases they create do not. Put another way, in practice, every user other than the Big Boss is individually on the “free” plan and creates only stripped-down “External” bases. I'm told we're in the process of migrating from Teams to Business. Will that remedy this? It doesn't make sense to me that only one person has full functionality, regardless of number of use

Hello! I’m trying to make a templated onboarding document that we can easily update with information fed from Airtable. Here’s the direct use case (Integrations are generally off the table in a corporate security setting): Hire Roster (lives in Airtable, holds new hire data) Microsoft Word/GDoc/OneNote (whatever!) that is complete with specific fields waiting to be fed new hire data, will serve as new hires’ onboarding document. Is there a way to automate the process of filling out a document without manually doing it?

Hi community I have the following question. I’d appreciate any idea how to active it.  I'm organizing my data for AI analysis and need it to be both structured and easy to interpret.To achieve this, I'm grouping the data by a key variable — in my case, Persona. This approach is working well and displays the information mostly as intended.However, one thing is missing: I would like to include a summary row (e.g., a SUM or total row) directly below each Persona group to aggregate key metrics (such as totals, averages, etc.).My question:Is there a way to automatically add a SUM row beneath each grouped Persona to display aggregated metrics for that specific group? 

I have an excel file that we currently filter by 3 to 4 fields to come up with a price for an item for vehicles. We filter by Year, Make, Model, and then for certain products, we also end up filtering by other parametes, but I’ll use size as an example. I am trying to create a form where instead of having to exit and go to the excel sheet, a person could potentially do the following: Select year → this should provide the filter for the next question and only return Brands for those years When they select a make, it should filter the next question to only show models for the selected brand. When they select model, if there are 2 models, it should bring up the size field for the next question, if there is only one model, it should bring up the ID for that specific model in the next question. After it brings up the correct ID for that model, it should show the only price option for that ID. I know I can import an excel file,

Hi there, If I have data that is pulled in from another file and in one column it is showing this - Project department (John Smith)How do I grab the (John Smith) part and let it populate into the column next to it?  Adding to that once I have the names do these names need to be added to the base in order for them to view their assigned things in an interface? Many thanks 

Hi, I’m trying to build an event management board. Some of my events are recurring, but the current date data type does not allow multiple ones. Do you have a best practice for it? One way I’m thinking about making a separate date table, and link the event with the dates. But the calendar view looks odd for this date table, as it use dates as the primary id and does not allow me to display big event name on it. Also, I don’t know how to filter the ‘date’ data based on conditions in the event table.  i.e. if I want to only show the dates where the event has been confirmed.  Wonder if you have better options? And if yes, please show me!! If not, how to make my current date table better looking?

Is there a way to customize airtable form based on the user. I have a dropdown box that is selected by the person, then it shows the applicable questions based on the drop down. Is there a way to autofill in the dropdown based on the user filling in the form.  I need to keep all of the questions in one form for convenience. What would be the best way of doing this.  The reason I need to do this is because each person is required to fill out a form each month, selecting a name then shows what forms a person has not completed yet. Thank you 

Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", "✅ Good to Quote","❌On Hold - Do not Quote"))We are hoping to then enable the On hold note to propagate through to an extension we use to send quotes onto clients There is a field with single text which we use to fill out the client and then a options single select for on hold/good

Is it possible to have 3 kinds of fields in gallery view on a shared link? To clarify I want - 1- The fields displayed on the card 2- The fields you can see when clicking on the card, that aren’t displayed in the card view. 3- Fields that can not be seen unless you are the owner (i.e. me) and logged in. I’m using Airtable for a coin collection and want to have a field for price paid, but I don’t want that to be public knowledge, yet I want to make my page publicly accessible for research purposes.

What happened to PageDesigner?!?!?! I have been using the same extension for three years to print a two-page per record document. The page is set to be the size equivalent of two, portrait 8.5x11 pages. All of a sudden, yesterday, I opened up the Extension that holds my document and the entire second page was missing. The fields were there, but the white background was missing. I reset the page size to accommodate the length of a two page document. All appeared to be well, but when I went to print it, it only prints the second page of one record in the view. Any insights would be greatly appreciated

Ideally what I’d like is for the “page designer” block to have the ability to share its output automatically with different recipients who don’t have Airtable accounts themselves. I have a large base that is used to process reports that come in from forms. Each record is an individual report, which I can build into printable pdf using the page designer. But the only way to share these is to download each individual pdf and then send it by email. I would like to be able to automate this process, i.e. once a report is complete, the document generated by the page designer is automatically shared with a given recipient. Is this possible through Zapier, or any other platform? I’ve looked at a few google sheets add ons but I’m not sure they’re what I’m after. Thank you in advance for your advice! :slightly_smiling_face:

Hi all, We are a small real estate agency, using Airtable for our property database which is very nice. We face an issue and want to ask for solution, we need to create either 1) Listing or 2) Single property particular to our client from our property database, right now we only selected the properties we want to send to our clients and manually type it on Word, it is waste of time and easy to have typo. May I ask how to simply from from the selected properties in our database … e.g. selected 10 properties and then print the selected in a listing ? And also the option to print the selected to 10 individual single property particular? I found the built-in document creation app is not powerful to do that… any suggestion of app or service should we use ? Don’t mind to subscribe more service to do… Appreciate for the recommendation… Best, Tony

I followed this tutorial video to the letter (https://support.airtable.com/hc/en-us/articles/115013405168-Page-designer-app-overview) yet Page Designer won’t print/PDF multiple records on a page. My records are short — about one-eighth of a page per record — and I have 25 records. It’s ridiculous that my PDF is 25 pages. Can someone please help me stop the madness???

Hello I am building my invoice template in Page Designer. I was able to build my source table so I can see various tasks to bill to each client. My only isse is that table only show records that fit in the box and in 1 page. How do I format the table element so it show every records I want to show even if it takes multiple pages?

I have a question regarding the page designer extension. How to make the data fields automatically adapt to the amount of data to display and for the extension to create as many pages as necessary? I am setting up a contract. This contract contains a “travellers” paragraph. Under each traveler, page designer displays the information concerning him (package chosen, date of departure, date of return, details of flights, details of accommodation, etc.). The number of travelers naturally varies from one contract to another. There are contracts with 1 single traveler and others with 40 travellers. On page designer the reserved field does not adapt to the amount of data. In addition, we only have the right to 1 single page!! How to solve this problem? Thanks

Hi, Crazy question, but can’t seem to get this. Does the page designer only allow one form? I’ve created a form in the page designer. How do I create a second form, third, or fourth? Any help will be greatly appreciated :slightly_smiling_face: Thanks, Pat

Hello everyone,I've been working with Page Designer to create invoices that sometimes span more than a single A4 page due to the length of item lists. In tools like Excel, I've been able to manually manage page breaks and ensure that content flows smoothly from one page to the next. I'm facing challenges achieving this in Airtable's Page Designer.The challenge:When I have a list of items in an invoice that's very long, I need the content to seamlessly flow over multiple A4 pages, maintaining the same design format. This is something I could do in Excel by manually adjusting the beginning balance on a new page, but I'm struggling to replicate that here.Has anyone encountered a similar issue? If so, how did you address it? Are there any workarounds or best practices that you've found effective?I appreciate any insights or solutions you might have!Thanks in advance!Sasi

Heya everyone!So I noticed that on the Airtable update API endpoint they note about upserts:Airtable reserves the right to throttle upsert requests differently from the standard rate limit throttling policy.Intuitively, I’d assume that differently means that they’re more strict about it as they’d be doing comparisons on their end.Does anyone know whether upsert is throttled more aggressively than plain updates? I’d assume so but I thought I’d get it cleared up.Thanks!

Hello, I am new to Airtable and I am looking for a simple solution to this problem if possible. I am looking to be able to upload a PDF into Airtable (it would be 1 page). Once the PDF is uploaded, I would like to extract the title and put it in the name column next to the document in the same row automatically. I know there are software’s out there that can handle this type of thing like Parseur, but the documents might not all look exactly the same (or the titles might not always be in the same spot every time). Any assistance would be greatly appreciated! Thanks!

Hi all, Is it possible to prevent the creation of record under certain condition during form submission?Like upon button click, there will be a check against the database for certain condition and throw back error message. 

I have an object that I output from another script using the Output.Set(key: value) method. The value that I’m passing is an array of json objects. It seems that there are a lot of objects to transform the object but I would prefer to just pass the object to my script to iterate over the object and use dot notation to get the values that I would like.  I don’t see anything that just lets me keep the object as is and pass it through input.config only transforms or operations like length? Is there no way to pass an array or object??

I want to create forms to get reviews from some products I sell and for that I have created a Table which consists of the following fields:Product (linked to the corresponding "Product" record in the "Products" Table)Q1Q2...QnI want to be able to send form links with the "Product" field prefilled (using its RECORD_ID), so that the reviewer can easily know which product he/she is reviewing. However, I don't want the reviewer to able to change that value in the form and select by mistake any other "Product" record. How can disable the possibility of changing a prefilled value in a form?I have tried using the option "Limit record selection only in view" to another view, but it is not working.

Hello everyone, I hope you can help me! I am creating an product database for internal purposes. I have created a Softr interface and I want to have a customer chat bot to can answer basic queries such as “Does this product have x feature?” “What is the price of this product” etc… I have managed to create everything with the help of Chat GPT (I can’t code!) but once issue remains, when I try to trigger a database search, it constantly returns with “I can’t find this product”. I have searched the console, it says it cannot access the database because authentication is required and returns an error 401 or 403. I have checked the token, the database ID all and everything is correct, so I am a bit at loss! I am the owner of the database. Hope someone can assist with this, thanks in advance for any advice!

I have a base that is largely used for planning.I have a lot of automations. Often one action sets off a chain of 4-5 automations.Because I use this base for planning, records get deleted often as part of my workflow (i.e. I change my mind).An unfortunate, unexpected irritation with this is that reasonably often, an action will set off an automation > I delete the record before the automation is finished (these are usually simple automations "if Record A Field A = x, update Record B field A" - most are not long and convoluted).And so, I have a significant and frequent number of "failed automation: record not found" emails and notifications.Is there any way to prevent this happening?

What is a good website  to parse data from a pdf into airtable. For example if I wanted to parse info from a rental application (contact info, lease info) into airtable what is the best website to do this