Other Questions

How can I search globally in all tables ? No the existing search app doesnt work. See the image below. it only search in the records in current base not globally. Please guide me whats the possible solution to this. Screen Shot 2020-09-17 at 10.53.07 AM

Hello! I’ve just come across Airtable and was experimenting with it as an alternative to Google Sheets. My question is, if my application requires multiple databases, can string searches be performed across them? Thanks, B

Hi, I was wondering how does the 10 login badge work? Or is this effectively broken?

Hi everybody,How would you go about sending an image from an Airtable attachment field to an image field in a Webflow collection item.I have set up a scenario in Make using a webhook. Works great so far for all the text based fields, checkboxes, etc.But I can not figure out, how to pass on the required image URL, so I can map it in Make.Does anyone here have make scenarios with images running?Thank you for your help!

Hoping someone can help me.  I'm sorry if this is not in the correct section.  I'm new to this and not sure of what to call most things.   I'm a crafter and i'm trying to use Airtable to keep an inventory of my craft supplies.  I have imported data from a different system, and have titled the column that contains the URLs for the photos  as "Image" and defined it as URL.  However, i can't get the images to populate.  I wrote an email to airtable asking for help, and although i keep replying to emails saying they're busy, with i want to wait, it's been well over a month and i still don't have a response.  I have tried looking up on the internet in various places, and have found issues the same as mine.  However, the fixes they show apparently are from a different version of airtable than is currently available, as many of the screens they show have different options from what I see, and i have not been able to equate the old to the ne

Hi,Please allow users to download all attachment files in one click. We should not have to manually download every file individually.Thank you!Kerry

Hi all I’m curious to know if there is a way to use single select tool in web forms pulling from data from the grid indicating that a selection has already made. For example, if 10 people are signing up for 10 potluck dishes and one person has already signed up, the potluck options are reduced to nine in the forms. I guess this is considered conditional but not sure how it would work. Thanks

Hi,Not sure if title accurately matches my question. I have 2 tables linked by "Part Code":Table 1: Parts. Columns: Part CodeTable 2: Offers. Columns: Supplier Name, Part Code, PriceIn Table 1 I would like to add columns that automatically select the lowest Offer per Part Code. So Table 1 would have e.g. columns Part Code, Cheapest Supplier, Cheapest Price. Latter 2 automatically filled.Is this possible, if so, how? Any help appreciated!

Hello, Airtable community! I'm working on setting up a career path assessment tool within Airtable, designed to evaluate and suggest personalized career paths based on user responses. My aim is to have everything contained within Airtable, from data collection to scoring and recommendations. Objective:The goal of this tool is to automatically calculate scores based on assessment responses and use these scores to suggest appropriate career paths. This involves creating a streamlined and efficient form directly in Airtable for data entry.Current Setup:- Tables: I have tables set up for Questions, Responses, Roles, Skills, and Traits.- Form Creation: I am trying to create a form view in my Responses table to collect user inputs directly within Airtable. Issue:I am encountering difficulties in creating and configuring the form view:- Form Fields: Some of the fields do not appear as expected in the form view.

Dear Community,I am writing to report an issue that I have encountered with the automatic upload of images to Airtable, which subsequently causes errors when attempting to upload these images to WordPress via an automated workflow. Here is a detailed account of the observations and steps taken to diagnose and troubleshoot the issue:Overview of the Issue:I have implemented an automated workflow using Make.com to generate images using OpenAI's DALL-E, store these images in Airtable, and then upload the images from Airtable to WordPress. However, I am encountering a persistent error when attempting to upload the images from Airtable to WordPress. The error message received is:```[500] Sorry, this file type is not permitted for security reasons. (error code: rest_upload_unknown_error)```Detailed Observations:1. Image Generation and Initial Upload:- Images are generated using OpenAI's DALL-E and are saved in PNG format.- T

I have a single line text field as a primary key “name” field. if it is blank when I save the record, I would like to automatically fill in the name as a concatenation of three other fields that are in the record. How can I do this?

Hi y'all,I am trying to figure out if there is a way to change my primary field when I am using data that is automatically integrated from a Google sheet. Basically, I have a Google Form folks fill out and the first question is what their name is. When they submit the form, a row is automatically created in a corresponding Google Sheet, and once that row is completed, a new entry is automatically created in AirTable. However, when the AirTable entry is made, the primary field is the time stamp from when the form is submitted, presumably because this is the first column in the Google Sheet. I was wondering if there is a way to change it so the primary field is the name (the first question that is filled out on the form) instead of the time stamp?I came across this article (https://support.airtable.com/docs/how-can-

HELLO! I have been wracking my brain trying to figure out how to make this seemingly easy function work and keep hitting dead ends. Basically, I have a list of schools we manage, and I need to assign a phase number to them as new projects are created. The problem is, they are not submitted in order, and we have about 230 schools. I need to be able to count how many times prior this school has had a project created so I can keep track of what phase number we are on. I have a sheet where all incoming projects are being submitted via Paperform, and another “Master” sheet with the school name linked to the incoming projects school name. Every possible option I’ve been able to come up with changes every answer within the column and I need each row to be “set”, if that makes sense. An example of how projects are submitted and what their phase number would be: School Phase Cooper - 1 Roosevelt - 1 Wa

Perhaps I’m missing it, but how do I generate random numbers? I am missing “randbetween” and “rnd” from Excel. Thanks for any and all help.

Hi - just getting into Airtable. I’ve got a spreadsheet with book details that includes authors in a field. I have them in inverted commas ie “Last Name, First Name”. This is so that I can then take the field and link to another record to create a field in an Author table where the authors appear as a record with “Last Name, First Name” in the field. However, once the spreadsheet gets into Airtable (whether pasting or importing) the inverted commas have vanished from sight and so when I link to another record each author creates two records, one with “Last Name” and one with “First Name”. Is there any workaround for this? I’ve seen the help page about preparing text but that requires adding inverted commas around every author in every record after importing which will be a massive task. The only solution I’ve come up with so far is to have authors as “Last Name/First Name” or “Last Name-First Name” in the spreadsheet as then there is no comma delimiter problem in linking

Most 2FA systems allow you to enter a code manually so you don't have to scan the QR code but there is no option for that in AirTable. My camera on my phone is currently broken and so I have no way I can set up 2FA with AirTable with my authentication app.Is there a button I am missing somewhere next to the QR code to get the key manually?

It would be great if you could select or filter records by a pop up / embeddable calendar in interfaces.

Hi, I have an Interface with an attachment field and I'm adding small PDF's. These are sometimes multipage PDF's All good on PC but when opening via the Airtable App on Mobile, it only displays one page. Multiple pages can be viewed if download but not just by opening. Happens on multiple device (Android). Am I missing something ?CheersJason   

So I have PDFs that are standardized for our organization. Is there any solution to take records from airtable and insert the data in to my Form Fillable PDFs. Is this possible? I looked at a lot of the extensions currently and none of them, even talked to some of the extension sites and they don't have the ability to do what I need. 

Hi Airtable Community!I have a few legacy accounts with API keys attached that are currently paid licensed accounts. I'd like to convert these accounts to service accounts. Is there a way to do this?Thanks in advance for your help!

Hi everyone,I need to upload Adobe Acrobat Documents to my base.  They vary in size between 155-175 KB. '"This file is smaller than the allowed size of 1 B"Why am I getting this message?  Does anyone have a workaround?Thank you for your time and wisdom.  Much appreciated!S 

Hi everyone, I have a situation and I am not sure what I should be focusing on first. There are a few levels where the problem may be coming from.I use Airtable in Chrome. As I move from cell to cell and view to view, I am often pressing a button on my Stream Deck that pastes small amounts of text for me. However, recently if I have expanded a long-text Airtable cell (so the whole cell pops up for easier reading), if I hit the button on my stream deck it closes the cell and does not paste it. This is not an issue, however, if I double-click within the cell and work on it without expanding it to the larger view. This is also not an issue with general copying/pasting with a keyboard. This issue comes and goes. I am trying to figure out where I should *start* with all this. Where do you think?- Chrome- Airtable- Stream Deck hardware- The app within Stream deck that "pastes"Hopefully the question makes sense. If you have any ideas on

Hi!     I successfully synced JIRA to AirTable, with all fields appearing in AirTable correctly.     But, there is an exception:     I have a "Cascading Field" in JIRA called "Story Type", each option in the first field opens a new list in the second field.     The first field appears correctly in AirTable, but the second one no. The print below shows it better.      Is there a way to make the second field appears in AirTable?Thank you all in advance.Best regards.Nelson.

I'm watching the "introduction to interface designer" webinar on-demand but in the recording there is no "related content" section for me to find the template/base used in the webinar. Tried searching for it as well, but couldn't find it anywhere. Anyone got a link to that base? It's called Demo: Design Project Tracker.

Hi everyone. I am currently trying to create a checklist for a theatre production so we always remember to load everything in the van. However, although this works perfectly when I am on the computer version, I can tick the items as they are loaded, when I transfer to the mobile app it seems to become a laborious task because when I tick on the items, rather than check the item it takes me to the individual record. Does any one know if it is possible to just check and uncheck items in the mobile version? Thanks