Other Questions

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?

Hey Everyone, I had a question about visualizing data that you recieve from form submissions. We are accepting applications for a program that requires a small team to access the entries and approve or deny. Currently I planned on having them look at the table and expand the view to read their information. This isn’t ideal as the modals are kind of narrow and from an experience its a little cumbersome. For anyone that has used google forms, when you are an admin you can basically look at each form submission in a way that it shows you a view of the acutal form, except with their answers filled in. This was just a more palatable way to look at each. Is there a way to do something like this in airtable? When people submit I get an email that has all of their filled in info laid out, a page like this in airtable would be perfect. I’m new to airtable so I apologize if there is a very obvious solution to this. Thank you!

Hi everyone, I'm wanting to improve upon the Extract Base Metadata script to include more features. Has anyone experimented with this?Ideally it would:Gather the metadata currently acquired by the Base Metadata Extract extension (listed below)Be capable of running automatically at regular intervals.Indicate if the field has been deleted.If the field is a linked record field to another table limited to a view, name that viewIndicate if the field is in use in an interfaceSHOULD: name those interfacesIf the field is a lookup from a linked record, name the originating recordSHOULD: link directly to that recordShow which interfaces the field shows up on and make updates when fields are removed or added to interfaces

I am very familiar with constructing a URL to go right to a record based on the record id. However, what I am looking to do is to go to a record based on a different unique identifier...their phone number for example.E.g.:https://airtable.com/appXXXXX/pagXXXXXXXX?tcd26=+15555555555Any ideas if this is possible?

Hi,We're currently using the "Scripting" extension on our Airtable base and we have several different scripts that need to be run on occasion. From what I can see, the "Scripting" extension is just a panel where you write or copy/paste scripts.My question would be: is there a way to save/store your custom scripts somewhere in Airtable? (maybe by using a different extension) - as opposed to saving them locally or somewhere else. Thank you,Cris

Hi! I have a table with companies and a table with contact persons in these companies. The company-table link to the person-table. I have a form in the company-table where companies can enter their data. How can I have them also enter data for contact-person and have that data populate the person-table? When I add the person-field into the form, I only get the possibility to search and pick from existing entries - not adding a new entry. Thanks for any help!

Is there a way to create a data entry form for entering records into a database? Trying to find a way to enter and update records more easily. Thank you.

I have a very large, dynamic number of opportunities with a dynamic number of positions available in each opportunity. I want to limit the number of Form submissions to the total number of slots, depending on the opportunity. When registration opens, it’s a mad rush because the spots are first-come first-served. The number of opportunities are too large to monitor manually, and I don't want to deal with the headache of an automated email that says, "sorry, please try again." Its a potential for too many unhappy customers.The Form is currently accessed through a button in an Interface, and I'm curious about the Record > Button: Rules > Visibility feature. Thinking I could hide the button to limit the access to the form (that's half of the challenge), but every time I click on the Visibility toggle, Airtable prompts me to upgrade without an explanation of how that would help. I've reached out to Support but haven't heard back. The rabbit hole took me to Fillout,