Ask the Community

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

Hello, I’m new to Airtable, (trying to help a friend build an efficient solution) and I’m looking for some advice. We have a form with a rather large multi-select field. Users must enter their name, date and select any number of options from the multiselect field. The information comes into the table in the way you would expect: But in order for it to work with my friend’s processes (and existing tables) they need a way to break the record up (ideally on form submission) into multiple records: I found a way to do it with automations. I created an automation for each Option to check to see if that option has been selected, and then create a new re

Howdy good people!Hoping someone can advise with a product code lookup scenario. Our team sells training subscriptions. New subscribers submit airtable forms to notify of catalog onboarding. Each subscription is tied to a certain product (9 product types currently). Product name auto-populates in a multi-select 'Product' field upon form submission in an 'Offline Subs' table. Each product has a set unique code stored in another table (Product Codes). We need to auto lookup and match the product name with corresponding product code and auto populate this in a 'product code' field in the 'Offline Subs' table (see attached). Playing around with lookup fields and can't see an automation option, imagining that this will require a script to achieve?I don't have any coding/scripting experience so hoping someone can share a similar successful script or use case experience. Any assistance greatly appreciated. 🙂

It is possible to use a wireless barcode scanner attached to an iPad to enter data into an Airtable. I need to do an inventory of over 17,000 items and want to scan the barcode of each item into a table. It would be much faster if I could just scan the item - record is created - and it advances to create the next record. Much like you can do with a scanner an Excel. I know I could just use Excel and then import it into a table in my base but I was just curious. Using the camera to scan each barcode would not be and option due to time. Thanks Brian