Ask the Community

Bit of a messy title, I couldn’t think of a good way to phrase this question…I have a table that stores inventory items, each item can have one of three status’ “Available”, “Gifted” or “Sold”. I’m trying to create a view that only returns the name of an item where there are none with a status of Available. So for example the view shouldn’t return this item:But it should return this one Is this possible to achieve and if so, how?

Thanks in advance for posting your question! When someone provides an answer, **remember to mark their reply as the :white_check_mark: solution.**I have opened my app and it has reverted to a new installation. I cannot find my existing table. What can I do to retrieve my Old table?

I am reaching out here in desperation because the “contact support” feature in Airtable does not work at all in my workspace, across multiple browsers and devices. Firstly, my “Team” plan workspace has a base, and my base has a form. It is the only form present in the base.After the recent UI update, that form is not visible in the “Forms” tab on the top middle. The system pretends that my base doesn’t have any forms.However, I can still access the form via my bookmarked public link. Additionally, I can submit the form and it successfully will add a record to my base.I need to edit this form, but it is currently not possible to access the edit page of the form. Normally, I would reach out to Support about this. However, when I click the “?” icon on the bottom left and then select “Message Support”, it opens up a blank white rectangle on the bottom right of the screen that does nothing.I know from experience that this should be

I create a GDOC with MAKE I get fields from AIRTABLE and update the DOC I get the DOC link and put it in a URL field in the AIRTABLE record ALL IS OK till here I am trying to get the PDF export link and upload it to the attachment field in AIRTABLE, and it doesn’t work. I even tried a static PDF from DRIVE and it doesn’t work. Why?

I need to be able to print a form.  I have checked the user action “allow printing.”  I share a link with users and they do not see the three dots in the top right corner.  Printing using the browser print function is horrible. There should be a button to print the form or when you click the submit form button it should generate a pdf form that can be printed.

Hello,In an “Agent” table, there is a checkbox field called “Check.”I would like to be able to check all the boxes in this field at once for all the records displayed.I say “displayed” because sometimes there are filters based on certain criteria, and only the boxes for records that match the filter criteria should be checked.If you have any ideas on how to do this...Thank you.

I may be SOL but I am very new to Airtable and I’m wondering if there’s any way to delete a line of text containing a certain word within a record. Basically, I input records that all contain source information and the line of source info always begins with ‘Page’ - is there any way to delete that entire line from all records or am I stuck manually deleting it from every record? 

I have a billing issue and cannot seem to find any assistance. I paid for a year subscription and was billed a month later for almost the same amount. No one has contacted me when I filled out the form needing assistance and the chatbox is a joke. I have to answer to my organization for the cost spent and I cannot get a resolution to my issue. I need someone to contact me right away. I should not have been charged twice as the account was just paid for for an entire year. HELP!

Just started noticing this wavy line with a pointer end when viewing a list details. This is the only base with a list view so I’m not sure if it happens across Airtable. Any ideas what is causing it? It stays in the same position while scrolling the details pane.  

My script runs as an automation when the user clicks a button on an interface page.If the script fails, I log an error to the console, and I can find the error in the run history. But it would be nicer to display a message to the user if they are still on the interface page. Is that possible? Thanks!

Hello friends , iam a noob airtable user , i’m in charge of a table that recieves data from an api in json format , the output is all in one line , so when i try to extract a value from a key using regex it does not work (it shows error) unless i use a website or manually fix the indentations and beautify the json text . is there anyway to fix this issue using formulas or some extension that iam not aware of ? Thank you

Hello - I am using the amazing pre-filled form extension by @kuovonne to pull form data entered into one table that is then updated with a pre-filled form. The only issue I am having is the date field from the original entry is moved back by one day when the pre-filled form is created (and then updates a new record with the wrong date). I have tried looking at the time zone settings, but have had no luck. Is there any thought about where the fix might live? Thank you!

In the new form builder, can you modify the layout for more contrast (other group background colors)/larger text size like in the old one? The old one seemed to have more options to make it easier to read and follow. This current one does not seem to pass accessibility requirements as you can’t change the font and formatting of the questions and helper text as much.

I would like my formula to present the number formatted by grouping the thousand, like “100,000”, but it displays “100000”. I do not want to turn the number into text because I need the ordering. I think every formula should have a type. Is there a solution?

I’m new to Airtable, and trying to understand the big picture of what it can and cannot do when it comes to app building. We have a need to build an app that displays customer & internally submitted ideas, with a navigation (tree?) of Products & their categories to help filter results. I see we can allow non-paid users to submit ideas via a Form, see results as read only, and possibly interact with some additional Form / automation work arounds for things like voting and comments on other people’s ideas (hopefully without making it cumbersome to the user). I’ve experimented with Interfaces a bit to review what kinds of elements are available, and am exploring templates. Questions I still have: It is possible to have just an expandable tree of Products and their Categories in one element, that when selected filters a second list element? We would be starting with 30,000 records, and would need to filter down the view. The Record Picker ele

Does anyone have experience with integrating the SSO capability with Google Suite. Specifically I am wondering if the Google permissions override the Airtable permissions or is this integration just to allow users to use the same login for both services. Thank you in advance.

Hello- Is it possible to create an automation that sends attachments into a Google Drive account?

Hi, I’m new on using this product and we are trying to integrate this into our system. I managed to setup the api and make some requests however, during my testing in the list records api with `POST` method. I was trying to use this parameter `returnFieldsByFieldId` in the request body but got an error stating this..```{ "error": {      "type": "INVALID_REQUEST_UNKNOWN",      "message": "Invalid request: parameter validation failed. Check your request data."  }}```Mentioned parameter works with `GET` request. Tried a bunch of boolean equivalent for this parameter like-  1-  true-  True-  TRUEHoping someone can help. TIA.

Hi folks, I’ve searched and attempted to fix this on my own to no avail. Whether on my iPhone or iPad I cannot get the images I take within Airtable (using their camera inside the app) to save to my devices camera roll. I have toggled the app setting for this on and off multiple times in an effort to get it to work and my version of the app is the latest. Any ideas?

Dear Airtable Team,I have encountered some difficulty when working with tables that have many columns. Currently, to view the information on the far right, I can only use the mouse to drag the horizontal scrollbar at the bottom of the webpage. This method is inefficient and somewhat inconvenient.I would like to suggest considering improvements to the horizontal scrolling functionality, such as: Enabling horizontal scrolling of the table using the mouse wheel; Alternatively, implementing a canvas-like mode similar to Photoshop, where holding the spacebar and dragging with the left mouse button allows users to pan across the table smoothly. Such features would greatly enhance the convenience and efficiency of navigating wide tables. I hope you will consider and implement this suggestion.Thank you for your attention and support.Best regards,Kowal Tylerop6199@gmail.com

Hi Team,Need help to get this function running.I’m trying to build a formula that could work as linked field.So far, I managed to create the formula to combine the columns into “Product” column. However, I still need to copy past to the column “Products” to link to the Products table.Wondering if there is any way to create formula on linked field to make it all in one.Or at least, a script to create the links without need to copy past every time. 

trying to store latest revision on a HEADER record from multiple rows (each with an ascending revision) in the same table. The first row far right on HDR should be the max of 4 shown below. currently says 0.Have two views - HEADERS ONLY and REVS ONLY - so created a link to another record to use rollup.When there is a new revision in the REVS ONLY VIEW - I try to fire an automation that detects the new rev, and automatically copies the ME35 number into the field I use for the link…. argghhargghh…..does not want to work !!!! Ideas

Hello, I’ve been using Airtable for years, but haven’t looked at Interfaces since the last massive overhaul they got. I am building a revenue model that is based on several variables: estimated pax, estimated discounts, and tentative pricing. I would like to be able to play around with different inputs for each of my products (which would be the records), and compare outputs: gross revenue, profit margin, etc. It seems to me that we did this at my old company using the old Interfaces, but now I’m at a loss figuring out how to set this up. Basically my question is which of the Interface types should I select, and where/how do I configure fields to make them editable within the Interface?

I am trying to embed a domain restricted view and/or base onto a website. I've used a Google Site and Notion now and tried it with a view and a base. Chrome consistently works just as intended but Safari does not. In both cases, the embedded view/base loads a little cartoon plant and says I need to sign in. This is important because the cartoon plant is unique to embedding. That means that the embedded view/base recognizes that it's embedded in both Safari and Chrome. I then click sign-in, it opens a new tab, I sign in, and then it says I can close the tab and go back to the embedded view/base. I do that and nothing has changed for Safari or Chrome. The difference is I simply have to refresh Chrome and then it recognizes that it's authenticated, no problems. In Safari, I refresh and it looks exactly the same, still asking me to sign in as if I'm not already signed in. I'm pretty sure that this is a bug in Airtable that needs to be addressed and not something particular to my setup.

Hi, I need to extract text from multiple (thousands) of PDF files and load it to Airtable so that I can read that text by AT script, each portion of text for each file. Files are stored locally, and I wrote an uploader, which can, for example, for each loaded 200 files (file1, file2 etc…) create new table with 1 record per file. I can use bulk conversion by Acrobat (to doc, html or txt format) and upload those files in the same way. The question is - what format could be used to retrieve the text by AT script? For now I see that I need to write some node.js script (with pdfjs) that will retrieve the text, or remix some AT extension using API to upload text. Can it be done with less efforts? I didn’t consider, at least for now, using 3rd party tool subscriptions because I cannot tell for now how often it be used. maybe one time, maybe more and more, with the total of files up to hundred of thousands. Note: files are already OCR-processed and the