Other Questions

I'm creating an airtable base to store member information of a makerspace. We store basic info like name, address, email and phone number. We also take their state id and record the number, in the event they do something bad like steal from our makerspace or other types of bad behavior. Note, we've never had to use this information, but oftentimes knowing that we have it is a good deterrent (I'm not going to argue that point here).My concern is that some might worry about PII on this database and the risk of identity theft. I know airtable uses encryption going back and forth (according to my googles), but how safe is that really?  I will need to defend us doing this as some of my board members are super sensitive to any risk. Also, I suppose it might be able to be encrypted on the table, if we have a way to unjumble it later.  And.... I realize that the other stuff, name, address etc is also PII, but apparently the ID is what is freaking some of the people out.Thoughts?

I am looking to make a reviews website, like a business directory with reviews. Is something like this possible in airtable for each listing?

When I click in the field to link a record, a panel pops up showing all the records from the other table that I can search through. It also previews some relevant fields for each record on the little card. How does AirTable choose which fields are shown here? As you can see in my attached image, there are 4 fields being previewed. I would like to show a different field called “Category”, instead of the “Framecount” field.

Hello, On an airtable registration form that has a required field for DOB, some users have made error on their years of birth (for example 2023 instead of 2003) . Then they submit it and it fills the table with wrong data without them being aware of it. Is there a way that I can set the minimum date of birth to 01/01/2007 for example, so that the forms can alert the user that the date is incorrect at the time of form submission ? If not, which other way is possible ?

Hi, I am looking into options or workarounds to check if a value of a record exists in database before submitting a form. Is there a third party software or tool that is compatible with Airtable to do this? or is there any workaround with an automation to submit the form and check if record exists. If it does not exist, open again the form and show an error message to fill out a correct email. I would appreciate any suggestions.Thank you.

Really excited about the new permissions for the interfaces :raised_hands: Now maybe I am just not seeing the option, but is there any way to add a simple password protect for viewing the interface? Like we have for sharing specific views? Thanks!

Over the course of a project we will be conducting a series of feedback surveys, each with the same questions, but after different events. I plan on storing responses to each survey in its own table within a base. Is there a way to duplicate the form to different tables? I will need to do some minor updates (e.g., changing the introductory text), but the questions would be the same.

Hey Community!!Not a real actual current use case, but thought I'd spice-up the community a bit to kick-off the year! I can think of different workarounds for the following edge case, all of which could theoretically work (although not ideal) however I'd love to get to know your thoughts for it as the same logic and issue applies for other use cases.E.g. think of music concert tickets with initial stock of two (2) tickets.If Buyer A, Buyer B, and Buyer C all open the form at the same time (or before any submission occurs), they will all see availability of 2 tickets.Even if Buyer A purchases 1 ticket, available tickets shown on Buyer B and Buyer C's screen will still show 2 (unless they refresh the form and therefore retrieve new updated data from Airtable).This will not be an issue if Buyer B purchases 1 ticket immediately after -as there is still one ticket left.However, by the time Buyer C wants to make the purchase, the form still shows 2 tickets are available, however there is act

I am starting to think this isn’t an option in Airtable, but am hoping someone out there knows how to do this. I found one other support question on it and no response. I have a table showing the grants given out to grad students. Each grant gets a unique entry identified by the grad student recipient’s name. Some grad students get these more than once in separate semesters. I have a view sorted by group (the recipient’s name) and can see the number each student received, but there is not a count for the number of groups. Is there a way to count this other than manually or am I SOL? I tried to think of a way to run a formula or something else to do this, but cannot seem to figure it out.

We're annotating and marking up alot of images on a daily basis for manufacturing (arrows, dotted lines and text). This was typically done in Excel docs and then the excel doc would get exported as pdf and sent to manufacturers.We've now tried to move all this onto Airtable. We're using documint to export the documents from airtbale and illustrator to annotate the images.However our team that deals with marking up the images is about to "lose the will to live" as they say it takes too long to first download the images to their harddrive. Then open the image in illustrator, then make the annotations. Save them as jpg and then upload into Airtable. And if anything needs to be ammended they'll have to the whole thing over again (as it's fairly technical the annotations often has to be reviewed and amended by a technical team). Our problem is we can't annotate directly in Airtable as we need to use marked up images layed out in printed documents.We've spend a good amount to time integ

I have a table with an Attachment field holding a PowerPoint  PPTX file.Is there any way (in an Interface or another) I can Drag and drop that file into another (Windows) application? Just adding the file to an Interface doesn't seem to allow drag and drop.Specifically, I need to drag the file into Canva - Create a Design (Upload). Thanks!

Hello- Does anyone know if this could work in Airtable? markuphero.com File & Image Annotation Library & Developer API by Markup Hero Easily integrate visual image annotations for your users directly in your web app with Markup Hero's annotation library and developer API. I am really struggling trying to find a way to annotate on PDF’s in Airtable. Scott

Hi,I use Sling (getsling.com) to schedule crew for my events. I use Airtable to document all other information about the events. I would love if there was a way to sync my shifts from Sling to their respective events in Airtable. That way I would be able to see who is scheduled for that event and what positions they are scheduled for without having to log in to sling. Does any have any experience linking Sling with Airtable? Is it possible with a third party like Zapier or Make? If anyone has any guidance on this that would be greatly appreciated! 

I use Airtable for something related to website data. I have a table which is a list of pages/URLs from a website, which was extracted from Google Analytics. The key is the URL/page but it also contains data such as the volume of page views and other statistics about the page. In an ideal world I want this table to update automatically, so e.g. the data is always about the most recent month. I know there is a zapier integration but I can’t get my head around it, mainly because what happens if someone creates a new page in the source data i.e I am not just updating records based on changes to the data in Sheets, I need to also populate new records. Is this multiple Zapier integrations??

I'm looking for a way to share a calendar subscription link (e.g. iCal subscription) of a filtered view.  Currently my Calendar view subscription shows all calendar events for all users - I'd like to have a customised link that's unique to each user (i.e. using their username / email address field taken from the table) so that they can only see their own events and not those of all users.Any suggestions of solutions for making that work, please?

I'm creating an office Desk Reservation system and I want to take the next step to make it even more user friendly by adding a unique QR Code to each Desk, so employees can walk up to the desk, scan the QR Code, and have the Desk Registration Form open with the Desk Number from the QR code they scanned Prefilled.I'm currently stuck on how to get the QR code's information to Prefill data in a single Form...and I dont want to make a Form for Each desk, that would be silly.Any help would be greatly appreciated

I've been searching for solutions for hours for this. My perfect worldEvent staff open an attendance tracking form. They select the event and class that's about to start. The walk around the room and scan the QR codes (could be barcode as well) on all attendee badges. Each scan adds that attendee (already an existing record in Airtable - that's where the QR code will come from) as a linked record to that event/class record. They add everyone in the room, and submit the form with everyone linked. Potential workaroundsMaybe directly linking multiple records into one field with QR codes isn't possible. If not, maybe there are ideas for how to do one of the following instead:Create an entire record when a QR code is scanned, and then collate that info later. But I would want to somehow link both the attendee and the class in that one scan, so if the QR codes are on attendee badges, I'm back to the same problem of how to include all those scans under one class umbrella.Airtable's

Hey team! We use forms a lot on our team. I would love to have QR code for each form along with the generated link.

https://solidbackup.app/ Just happened to come across this when looking for some updates on how to download images in bulk in Airtable. This looks quite interesting but I can’t buy it from my Apple App store. It looks only available in the US Apple app store? Any experience?

Hi everyone, I’m a pretty new Airtable user, so sorry if this question doesn’t use all the proper terminology. In short, I’m creating an automated appointment system for my organization. I am using a form to collect user information and create records that track scheduled appointments. Users select their preferred timeslot from a list of available appointment times (achieved by using a linked record field limited to an “Open Timeslots” view in a different table dedicated to tracking availability). The issue I’ve run across is that I only want users to be able to select ONE appoint time, but the linked record field allows for multiple appointment times to be selected. Is there a way to limit users to one selection with a linked record field? If not, any ideas on how something similar could be achieved? More details: I’m working with two main tables: Availability and Scheduling The availability table contains appointment slot records, the primary field is a date field with the date and s

Hi all, Im trying to display all relevant information needed in calendar view for a job by altering the primary field accordingly: However I do not want this information showed in form view when my customers are selecting their job from the list of created records: Ideally I would like to have just the job number and the year (12 / 2018) on show to the customer. Can anyone suggest a solution to this? Thanks in advance :slightly_smiling_face:

Hello, I've been experiencing some issues with Airtable the past few days and thought the community might further insight into what's happening.Essentially, my base has been loading very slowly and when trying to select a linked record it often times out. When editing other fields (text, date etc.) it sometimes shows the error below. This has also been happening to my colleague, who is on a different network and uses a separate account. The issue happens intermittently but it's causing big disruptions to our workflow, especially when we need to re-enter data because it didn't save before forced to refresh.We've recently integrated our Airtable base with Glide and have also been adding quite a few extra fields (some auto populated and formula-based) as we develop a new website and also sync data across that.I'm wondering if the amount of new fields (particularly those that are auto-generated or automatically updated frequently), are causing our base have these issues. Whilst our base is

Hi Airtable Community, I have an Airtable base for Health & Safety for an event. I have an Airtable form which is populating data in a table called "Declarations" (these come from a subset of our stakeholders). I have a second table called "Inductions", which is being populated via an integration with a Jotform form. This second base includes a broader set of data, but critically everyone who completes the Declaration form also needs to complete the Induction form.I want to create a third table which summarises who has completed which of these forms, using email and/or company name as the common field. I'd also like to check this data and link it against other lists in other bases (eg Volunteers, Suppliers), using their contacts to sync data. I am still something of an Airtable rookie, without coding skills, so looking for an explanation that is accessible please - i want to learn a solution, so i can use it across my Airtables. Thanks!

Hi everyone,I have a scenario in Airtable where I want to dynamically control the visibility of form fields based on boolean values from another table. I’m proficient in Python, SQL, and JavaScript/Vue3.js, but I'm struggling to implement this logic directly within Airtable's environment.I want to use these boolean values from the Analysis table to control the visibility of form fields in the Application table. The challenge is that Airtable forms seem to be bound to a single record and don't directly allow dynamic visibility control across tables.Can I use JavaScript or Airtable scripting to dynamically control field visibility in a form based on boolean values from a linked table (Analysis)?Alternatively, would it be easier to restructure the process by splitting the form into multiple steps (e.g., first upload the PDF, then show the relevant fields based on boolean values in the next form)?Any help, pointers, or examples would be greatly appreciated!Thanks in advance!Best regards,Ni

Every week I add about a dozen fields to my base that are the same field type (and only updated to the current date). (The group each week includes the same field types in the group, however, they are not all the same field type, make sense?) For example, Revenue x/x/xx (dollar, integer), Date created x/x/xx (date field), new accounts x/x/xx (number, integer), …etc Is there a way I can do this in a batch as opposed to creating each new field?