Other Questions

Hello Airtable Community,Is there capability within forms to capture ip addresses from those submitting the forms?  I would like to ensure that the form is being submitted by the persons intended and not forwarded or submitted twice.  How secure are the forms?

Hi Community, I’m wondering whether there is a need to add a Recaptcha to my forms that collect data from my website to my Airtable. I have form validation logic set up and the fields in the table accept a certain type of data only. Most of my forms use dropdowns except where a user is filling in their name etc. My frontend is built with Vue 3 and there is a package for recaptacha but then I will also need a backend to handle the secret key. Any advice would be great. Thanks, Sue

I have a base with a table that contains a large number of duplicates that need to be merged and their duplicates deleted. However, this table is synced to a large number of other tables and I don't have a direct line of sight on ALL of these tables. I'm concerned that when I merge and delete, this will break some portion of the linked records that exist in the tables that belong to other people. Do any of you know if the dedupe process can cause issues for others who are synced to the table where the dedupe occurs? 

Hello! I've downloaded the app on my iPhone. The first thing I see is the login section. I choose my email and they would send me an email with a 1-tap link. If I open the link on my phone it's says "Sorry, this link won't work on a phone or tablet. Please, open the confirmation link on a laptop or desktop computer to finish signing up". So that's exactly what I do, I go to my laptop and click on the link and it just opens the app normally but on the laptop, the app on my phone remains without logging in, and I can't use the app.

Is there a shortcut to switch to the next/previous table? Like Ctrl+ Page Up/Down in Excel?

I've been searching airtable forums off and on and yet I can't find a solution that clearly explains what I need to do to achieve my desired results.With the search extension, I have configured the extention to search all tables and sometimes it works fine and other times I get a spinning ball where the search never seems to conclude and fails to reverting anything, even when I search on a known preexisting record. I have tried closing and reopening my browser, closing and reopening airtable, opening airtable in a different browser. Sometimes it starts working again and sometimes nothing I do works until seemingly randomly it starts working again. Any solutions, Work arounds?PS: I have roughly 11,000 records, working via Mac OS and I truly need the global search feature to work (and suspect I might not be the only one experiencing this issue). 

Hi! I’m new with integromat coming from Zapier. I have one scenario (zap in Zapier) with the following workflow: Webhook > Find Airtable record >Find/create a Gdrive folder > Create a google doc from template > Update record in airtable > Upload file in gdrive using export link from google docs I’m trying to replicate the same workflow in integromat and I was able to accomplish until updating record in airtable but when it comes to uploading a file using an export link from google docs it churns out a file.html document and not a pdf file. Below are screenshots of my workflow in integromat. Looking for any guidance on how I can make this work?

I am currently using the page designer app and I am trying to export to PDF using print > save as PDF because I cannot find an actual export button. Unfortunately, when I open the PDF, it’s an absolute mess of formatting and cryptic symbols. Any advice on how to export to PDF correctly?

Trying to work through how I might accomplish this. We are using airtable to store some QC records which eventually have to be passed to an owner and would not be able to live in airtable forever. Table 1 would have the relevant "items" and then tables 2-5 for example would have different types of qc records related to the item(s) in table 1. Table 2 might be paint QC that is for a particular area (1-1 relationship to table 1) whereas table 3 might be a daily report that could cover activity for multiple locations (1-many relationship to table 1). Each record in tables 2-5 would have a PDF attachment of 1 or more pages.What I'm trying to think about doing is running a script/automation/something that would grab all of the PDF attachments, compile then together by report type, then create a table of contents and add hyperlinks in the PDF that match the linking structure in the base. So section 1 would have all the locations from table

Hi,I'm pretty new at managing users in Airtable. I have downgraded a number of user accounts from "Editor" to "Viewer." However, many of them have regained "Editor" status, within a day of the downgrade.Are users getting some kind of notification when I downgrade them?Are there likely mechanisms for the users to regain Editor status?Are there reasonable ways to control for the Editor status, so that our number of Editor (aka billable) users is manageable?Thanks, and have a good day,Joe Montibello

I have a gallery view of event participants embedded on our web site. On the card view, one particular field is followed by a big extra space - see right after the 'City, State' field in the screenshot here:This extra space does not appear when you click on the card to see the record detail:The only difference in the data is that the 'City, State' field is a formula, combining two fields with a comma. But, I don't know why that would display an extra line in the gallery card. Any ideas?

Hi All!Been looking around for a solution to be able to select multiple dates on a form.Knowing that a date field can't support selecting multiple dates I've created a table that has all the dates within the calendar year as records and then am using a linked record field to allow them to be added to the form.The challenge is it's a dropdown that I can only select 1 at a time. I was testing to see if holding CMD or SHFT or OPT might unlock a multiple select ability on the dropdown but no go.For another workflow I created an interface page that allowed checking a box next to desired records and an automation to update a targeted record with the selected POST the form being submitted and creating the target record but that would be clunky for this workflow.Any other suggestions?

I have created a List view with Nested Levels enabled.  The data displayed is good for the nested Field, but I need it to display the data in another area as well.Data.  I have a  Level build like this: Am creating a martial arts curriculum and need certain skills to show in the belts they are learned.  So there are base skills and then "series" that those skills are used in.  The base skill is learned in one belt, but put together in the "series" in the next belt.  By using this nesting I can nicely get the "Series" to show the nested skills under it:But as you see in the last column, those nested values need also to be shown under the Yellow belt, but do not currently.  Is there a simple way to get them to sh

It appears that I am not the sole individual encountering this perplexing issue, as evidenced by numerous prior discussions on the matter. Our organization has been utilizing Airtable for a duration exceeding four years, and we are eager to transition to the Enterprise tier to accommodate our growing capacity needs. Regrettably, my efforts in submitting the contact form on multiple occasions—at least four thus far—have yielded no response.I find myself perplexed, as I would readily invest resources into resolving this predicament, should the opportunity arise.Has anyone among you managed to successfully navigate this transition, or does it seem that Airtable is consistently unresponsive to inquiries of this nature? Your shared experiences would be invaluable.

I am looking for an analytics solution for tracking link clicks and counting attachment downloads from embedded airtable views. Is there a good solution out there for this already? I’m having trouble finding a good resource for this. I have several solutions but they’re rather labor intensive and I’m hoping this can just happen automatically after initial setup. User clicks external link from embedded airtable record on website> +1 count in analytics for that link click. I am about to go test this, but does anyone know if you can use a google events to track link clicks in airtable?

Is there any way to set an automatic log out from Bases? If users are using a base and forget to log out even if they close airtable that persons bases are open to anyone who opens Airtable again on that machine. If there was a way to set an automatic full log out after a period of inactivity this would ensure base privacy. Alternatively could the administrator of the base have the ability to log all users out if necessary.

I have been tasked with automating attendance tracking provided Webex meeting attendance data (which can be downloaded as a CSV). I understand I'd need a common key in order for the data to mesh, but I am struggling to understand how to get Webex and Airtable to talk with each other and update the airtable automatically. Any advice on making Webex and Airtable talk to each other would be welcome. 

We have a couple of public forms where we are collecting information from customers. (Registration for Ten Digit Long Code (10DLC) SMS/Text-Enabled Landline Telephone Numbers) Once they hit ‘Submit’ they no longer have access to the information. Often times they make mistakes or need to add updates. We would like to be able to generate a URL that we can email or text to the customer that would open the form with whatever is in that particular record (obviously protected by a GUID or something similar a-la shared google docs) Is it possible?

I’m using the from view for people to register for an upcoming round robin event! I’d like to lock submissions after we hit 12 responses. Is there a way or workaround to make this possible? If not, no worries. How can I “lock” it manually to prevent additional entries?

Hi everyone, I’m new to arrays and I think I’m missing something very obvious here but I thought I’d ask and see if someone could point it out to me. I have a base which has two relevant tables, Customer and Other Party. Each Customer could be related to one or more other parties and vice versa each Other Party could be related to one or more Customers. Each table uses the email address as the primary key. I’m trying to connect the two using data fed in from a Cognito form via Integromat. After the form submit trigger, I’ve got it iterating the customers, searching for the relevant Customer Record IDs and aggregating the Record IDs into a new array so the output is Array=Collection1(ID=rec…)/Collection2(ID=rec…). It’s correctly identifying the related customers and their Airtable record IDs, but the problem comes when I try to use that information when I’m creating the records on the Other Party table. There’s a field called “Linked Customer” and I’m

Currently, the record level revision history shows with the oldest on top. That view also puts newer comments at the end/bottom. If I want to see something recent I have to scroll all the way to the bottom. Is there any way to reverse that so that comments and revision history shows with the most recent at the top?

Hi, I’m starting with Airtable and I think it’s excellent. I try to move all my work with Googlesheet to Airtable, but there is a functionality that I can not find and that I miss. It is the Autocrat complement. With this add-on I automatically generate, with each new record, a pdf file that is also automatically sent instantly by mail to an account extracted from the registry itself. It is necessary for me in my work, and I wonder if it is possible to do this with Airtable and some additional complement, or if on the contrary I should forget about it. Thanks, and excellent work!

We are a Civil Contracting company and just started using airtable for some simple data tracking.  What we are trying to do is build a simple "app" that can house some forms for our drivers to fill out thru out the day, ie material load info and refueling info.I have built some forms that use a sharable link, it works but is cumbersome when there are several different forms for the drivers to use.  I was hoping to figure out a way to either set permissions in airtable so the driver can only view and utilize the forms or have an "app" that hosts the forms in one spot.  These are truck drivers and not all of them are tech friendly so I need to keep it as simple as possible.Thank you in advance for any ideas on how to tackle this issue.

Is there a way to put edit-checks or validations on a field? I’d like to restrict the range of numeric values that can be input to a numeric field.

I’m doing a deep software selection and i’ll evaulated a lot of other software like airtable, and i have to say that Airtable is what i can say the best in class if we consider the 90% of the use cases our company needs. What it seems to lack, but i cannot realize it clearly (it seems to me so fool) that its not possible to do data validation. Let’s say a simply use case: I want my collegues to fill in the hours spent on various task (not in real time with the time track app, but simply at end of the day or of the week). In airtable is simple: new grid, i add a column TIME SPENT of type INTERVAL and i’m lost? i can i force to insert only an x number 0 < x < 8 ? i dont want to let them fill in a WRONG record and with automations try to send email, rewrite numbers or other thing: simply to forbid a wrong insert if it does not respect the restriction rule. I’m not sure it is not possible, but i’ve invested a lot of days of study and i only found workarounds. It looks