Other Questions

We have a series of event registration forms listed on our web site, with URLs that prefill a particular field and hide it from the user. These links all broke today. Help!For example, this link (which is live on our site) stopped working today:https://airtable.com/appOQfoS4FjmyZPko/shr3lPQDrY1VTx0Ba?prefill_Events=STEM%20Helping%20Students%20Learn&hide_Events=trueBut removing the prefill_Events and hide_Events workarounds leaves us with a form that does:https://airtable.com/appOQfoS4FjmyZPko/shr3lPQDrY1VTx0BaAny ideas about why this stopped working today? We have been using this prefill URL syntax for months without an issue.

Does anyone know what the max field limit is for each table in each base? Thanks.

I am trying to get a specific folder ID from Google Drive through an Airtable script based on information from a newly created record. I think I am supposed to get access to my Google Drive by connecting to it via API. I’ve built and published a web app using Google Apps Script but I’m unclear how to connect the platforms together. What are the general steps to send data from Airtable to the web app so it can take that information, process it and send back a response to update a record?

Oh hello there! I am working with a team that is developing a base to capture competitor profiles. Within the base we have an organizational overview tab, contacts tab, program information tab, and a SWOT Analysis tab where we'd like to fill out the data on the competitors' strengths (from a drop down), weaknesses (from a drop down), opportunities (from a drop down), and threats (from a drop down) (among a few other things unnecessary to mention). What I'd like to do is have a matrix template that will pull in those selected drop down items and look something like the below for each organization/competitor. Would the matrix or page design extension be best for this? Might there be a better tool? I have some serious beef with the page design view and how limited it is - or perhaps in my case, just not intuitive enough to be impactful. Any ideas would be incredibly welcome. Thank you!

Are there plans in the product roadmap to make the web clipper extension available for other browser than Chrome? If yes, then when ? I’m mostly interested in that being available in Firefox as I’m seriously considering to switch back from Chrome to Firefox. By the way, the web clipper tool is a great feature that helps users to quickly and conveniently add new records in a table in a comprehensive way. Thanks a lot for it ! Best regards, Younes

We create QR codes pretty frequently in our marketing collateral and it's not infrequent that we find out after something has been printed/distributed that we need to revise the URL it's point to for whatever reason.   I know there are a few services out there to generate a QR code. Is there a way to manage the associated URL though so if we need to redirect it at some point, we can?   

Hi, We’ve developped the Ubiqod platform to manage QR codes to interact with business processes. Here is a tutorial on how to use QR code to track working time in a Airtable base via Zapier. What do you think about a native integration between Ubiqod and Airtable? Would it be useful? Do not hesitate to give us your feedbacks!

Hello everyone,I am using AT for events.When I sell a ticket to my event it creates a record of the attendee.Afterwards I would like attendees to be able to fill a form with further details about their profile (eg. dietary restrictions) and whatever they fill gets updated in the same record.Currently I have 2 options:1. Attendee select their email from the form (lookup formula) so it stays in the same record but I don't want all attendees to have access to everyone's email2. I can use a 3rd party like Fillout form that creates a link but currently it is very glitchy.Are there any other options without using a third party?Thanks in advanced!

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 new t

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.- Field Ordering: Struggling with ordering the fields correctly according

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.- These images are automatically uploaded to Airtable in an attachment f

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-i-change-the-primary-field-in-my-table#changing-the-primary-field-type) discussing how to change a primary field and it notes that "We do not currently support replacing the p

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 Washington - 1 Cooper - 2 Cooper - 3 Lincoln

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 to another

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.