Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 14,327 Topics
  • 39,784 Replies
10000 Topics
R
Robert11New Participant
posted in Other Questions
How do I add an option to a column?

I am trying to add a new option to a certain column. I use my airtable as a form to collect applications from users, but I need to update the “Session” of what they are applying for. I can’t see to add a new session that would indicate that they are applying for the next era. The only possible data that can go in this column are “Session 1” and Session 2," while I want there to be “Session 3.” The “Customizing the field type” (can’t post links here) guide might help me, but it shows menu functionality that I don’t see to have. Any ideas?

398
CristianCG
T
Tim_StuartNew Participant
posted in Other Questions
Filter Linked Record in Airtable Forms

Hello Everyone, I was wondering if you can help me with something I have been working on. I currently have 3 tables in one base. One table has different names of clients (Table 1). The other table has the names of projects they are attached to with a record ID through a formula (Table 2). In Table 1, I have a linked record column to link each client to a project and there is a lookup column as well that shows the record ID of the project. Finally the 3rd table is used to store data from a form. In the form, I want to be able to have a linked record (select a client from Table 1), but I want to filter the options in the form under the linked record, so when filling out the form for one project, only clients linked to the project will show up as an option, so this could be a filter by the recordID of the project if that makes sense. Views will not work for my use because Airtable does not have a way to dynamically filter the view by different record ID's without creating a new form/view

92
CristianCG
D
Daniel_Farina1Participating Frequently
posted in Other Questions
Add "Updated Timestamp" for rows returned via an API call

Would it be possible to add the “updated time” to the API response for each row returned? This is quite necessary specially when building synchronization applications. By knowing the last time a row was updated, we can either trigger a call to synchronize it or skip it completely. This would decrease the load on Airtable’s side by a lot. Currently developers are forced to just update every single record on Airtable every x hours because there is no way to know whether a record was updated or not. I can force updates on specific records by adding my own timestamp every time I synchronize but that still requires a manual process. Thanks

11
G
P
Pedro_BBQNew Participant
posted in Other Questions
I cannot download an attachment as a PDF on gmail

I would like to send a single record to an external email address. In that single record there is a field where you can attach a document. However, when I send the single record to the external email, the user cannot open the attached pdf because it is in a weird format. Also, when you view it in email it is super blurry and bad quality. The only option I have is to upload that attachment from gmail to my drive and see it as a png (meaning, if the PDF has multiple pages you can only see the first one). The goal is for the external email user to be able to download the PDF I attached to the airtable record. Thoughts? Thanks!

02
P
W
wootiKnown Participant
posted in Other Questions
Comments in Interfaces not working properly

I've got an Interface that an employee 'Sam' has Editor access to. I have creator access. When I @ mention Sam, he doesn't get a notification and I receive a message saying "Some users weren't notified because they don't have access to this task." The record being commented on is in a table with add/delete permissions set to 'Editors and above'. Is this a bug?

23
S
K
kylenicolefNew Participant
posted in Other Questions
Workshop and Evaluation Management System Inquiry

We are working on a system to track workshops and evaluations effectively. Below are the key requirements and questions we need assistance with: Subcontractor Logins and Interface: Can we create a solo interface for each subcontractor where they can access their specific data? Additionally, we need a combined interface for all subcontractors for overall reporting. Workshop Tracking: Each subcontractor needs to track how many workshops they have completed against their target (e.g., a target of 15 workshops, showing progress such as 7 out of 15). Data source: Workshop location. Evaluation Tracking: Evaluations should be directly linked to their respective workshops. The system should provide a dashboard combining all evaluations, showing: Total ratings (national level). Ratings per region. Ratings per subcontractor. Can the dashboard also track attendance and display just the total count of attendees? Activity Records: Create a form and grid view for tracking activities. Add a reminder

03
TheTimeSavingCo
JeffJohnVol
JeffJohnVolInspiring
posted in Other Questions
Concerns about storing drivers license information in airtable?

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?

11
TheTimeSavingCo
R
Robert7467New Participant
posted in Other Questions
Star Ratings with Review field

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

53
H
E
Eric_KaplinNew Participant
posted in Other Questions
Choosing which fields to preview when selecting records to link

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.

76
H
S
SolyInspiring
asked in Other Questions
How to check for errors in forms before they can be submitted ?

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 ?

50
H
I
Israel_GarzaNew Participant
asked in Other Questions
Check if a record exists on database before submitting a form

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.

220
H
D
Deborah11New Participant
asked in Other Questions
Password Protect Interface?

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!

450
B
L
liszanteNew Participant
asked in Other Questions
Way to duplicate a feedback form with different tables for different events?

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.

10
Kenneth_Raghuna
Mike_AutomaticN
Mike_AutomaticNBrainy
asked in Other Questions
Best practices for working with forms handling items subject to stock?

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 a

10
ScottWorld
K
Kristina_BeeverKnown Participant
posted in Other Questions
Count number of groups when in group view

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.

2010
NLOIA
Kim_Trager1
Kim_Trager1Inspiring
posted in Other Questions
Does anyone know of an image markup tool integrating with Airtable?

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 integra

22
Kim_Trager1
N
NigelbNew Participant
asked in Other Questions
Drag & Drop

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!

50
N
Scott_Gardner1
Scott_Gardner1Known Participant
posted in Other Questions
Developer API, Annotation on PDF (Markup Hero)

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

12
Kim_Trager1
Z
ZLEVYNew Participant
posted in Other Questions
Sling Integration/Sync

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!

01
Mike_AutomaticN
J
Jonny_LongdenNew Participant
asked in Other Questions
Sync data with Google Sheets

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??

3310
matthew_b
F
farky85New Participant
posted in Other Questions
Customised Calendar Subscription

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?

01
Kenneth_Raghuna
Z
zLowNew Participant
asked in Other Questions
Use QR Code to Prefill a Form

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

110
H
C
cgreavesInspiring
asked in Other Questions
Add multiple QR code scans as linked records

I've been searching for solutions for hours for this. My perfect world Event 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 workarounds Maybe 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 barcod

220
H
M
Megan_SackettNew Participant
posted in Other Questions
QR Code for Forms

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.

122
H
I
itoldusoandsoInspiring
posted in Other Questions
Solid Backup - Airtable local backup tool - Anybody heard of it?

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?

05
M

Most helpful members this week

Badge winners

Show all badges
Terms & Conditions