Other Questions

Thanks for your time! I’m building a service-booking solution. If I had just one service, this would be easy. But in my case, I have hundreds. The solution so far: There are three tables: Services, Time slots, and Bookings Services is related to both the time slots and bookings The booking table includes a form When I share the link to this form with users from my website, I am using URL parameters to pre-fill the name or ID of the Service. Thus, when the user submits the form, they create a new booking record, pre-linked to the service. Question In the booking form, how can I filter and display only the time slots related to each Service? Many thanks, Dean

Hi everyone, I’m stumped right now after several days of trying to figure this out. Posting to see if anyone has advice. I’m trying to figure out the best way that my project table can automatically create records in my contract table. Our project table lists out our projects, and one field is “awarded vendor”. Each project could have anywhere from 1 - 10 vendors, and we have to track the contract lifecycle of these. Once someone from our team types in an “awarded vendor”, I’d like a new record to be created in our contract table so that we can initiate work with finance and legal teams. I’ve tried this with automations and linked records & lookup fields, but haven’t exactly gotten the most simple or automatic results. Has anyone had to create something similar before? Any advice is greatly appreciated! Thanks!

I have a table with a list of employees.I have another table of projects and roles that the employee may be assigned to, for example in the project table we have a column for PM, Co-PM, Lead Analyst, Analyst 1, Analyst 2. I want to count the number of times each employee is assigned a role in the projects table. In Excel and Google it is a simple =COUNTIF(‘Project’!$P$2:$V$87,A1), where column A is the employee column in the employee table, but there is no COUNTIF function in Airtable… I have also noticed that for every link I have made to the employee table I get a column in the employee table called “Project” or “Project 2” or “Project 3” and each cell has the Project ID from the Project Table. I have tried to make a formula column called “Workload” and use the formula COUNT({Project},{Project 2},{Project 3},{Project 4},{Project 5},{Project 6},{Project 7}) However this returns 0, because the links are not numeric references they are text references.Using COUNTA just counts the num

I send out company surveys via airtable forms, and want a way to track completion amongst everyone at the company. For example, one of the fields on the form will be “Name”. I will have another table with everyone’s name listed out, and I would like to create a Checkbox field called “Completed?” that will automatically get checked when a form submission with that name is completed.

I am making a base for my fantasy hockey league. I have 2 tables Players & Schedule. Each game in the schedule has a game ID as well as date and teams playing. Inside the players table has the team they are on and all relevant stats. Is there a way to Link each drafted player to a game ID and then map out which days my players are playing on?

I’ve seen versions of this post, but not this specific issue, and I can’t ever get Airtable support to answer my help requests so putting it out there to see if anyone has a fix! In the “Next Renewal Date Calc” field, I want to add 90 days to the adjacent date in the “Current Period Start Date” field, but only if there is data in that record. Otherwise, I’d like the “Next Renewal Date Calc” field to be blank. However - it appears I’ve got one of two options. Don’t do an if / then statement, just do a date add formula in Next Renewal Date Calc, and then it shows an error in the records that don’t have an adjacent Current Period Start. However, it shows the date formatted for human eyeballs. Write an if / then statement, which returns data as expected, leaving dates only in the fields with an adjacent Current Period Start date. However, it changes the date to a very unfriendly format, and does not allow me to change the format (“Your result type is not a number or a date. Formatting

I have checked the table field for the rollup. All cells contain a number. Any idea what went wrong?! This is the table field that is used to rollup SUM(Values) This is the table where the rollup SUM(Values) occur

I have a big table (Main Table) with lots of linked records to various other tables, lookups etc. The Primary field of Main Table is Calculated. I made a new Table, added a secondary field, and tried to link it automatically by pasting in the 100 primary fields from Main Table. But only some records will link up, w lots of fields staying blank. Exact same result when I paste in as single line text, and then convert it to a linked field. I CAN however, link each field manually to the ones that wouldn’t automatically link. I tried looking for certain circumstances in the Main Table that were unique to those that wont link up automatically, and cannot find any trends. I have the highest permissions, and fields are not locked that I know of. Maybe some sub-field is locked that is causing the issue? A little unnerving because I am going to rely on some big linking operations to get each of my annual work cycle’s started. Thanks!!

I have a base that has about 50 fields that are connected and are used to calculate things. I would be super helpful to have something like a tree that shows the relationships between these cells. For now, I’m just trying to order them correctly from left to right, but every time I need to make a change that has an impact on multiple calculations, it takes a while, Anyone knows what I mean?

I am trying to ingest records that include formatted text from another database into Airtable. I have tried converting the formatted text to markdown and packaging it in XML so I could use the XML import app to add it to my base, but when I try to map the element containing the rich text to a column with rich text enabled, that column is not available in the picker. I hope that the API allows for creation of records with rich text, but - before I spend time writing the code to try to do this, I wanted to confirm 1) that I did not make some kind of error in the XML import app or in configuring the relevant column in my base that precluded that method from working and 2) that the API should allow for this functionality. I tried searching the documentation in the help center, but found nothing describing any limitations to or methods for importing rich text.

I am a newbie to Airtable. I want to generate a report from a base. The Page Designer app will only allow me to report one record at a time. How can I get multiple, filtered records to show on the report?

Hello guys, I’ve been using Airtable for 6 days now and my boss ask me to arrange the raw data that he gathered into Airtable(in grid view? The ones that is looks similar to excel) and there’re a whole bunch of columns that I have to scroll left and right in order to fill things up and it’s kinda slow me down. so, I’m not sure that the Airtable can zoom in-out in grid view? I want to see those columns as much as possible .thank you

Hi there - Is it possible to create a checklist in a form from a view? What would be the way to do this?

I have created a Base on my iPhone. It appears the same on my MacBook Pro. I created a second base in the same workspace on my Mac. It only appears there not on my iPhone. How can I get it to appear on both devices?

We’ve encounter an issue with one of our bases on airtable, the ‘over limits’ pop-up appeared next to our project name. We have a Free Plan, the record limits it says 1,200 records per base, but our total record used is 247 records. We’ve tried rearranging our columns but the ‘over limits’ pop-up still shows. Please let us know what we can do for the issue! Thanks!

I am new to Airtable, and am building a very simple database for a school to allow families to find the necessary books assigned to their students’ classes. I like the Gallery view for this, but when I set up a filter so that a parent can simply select the course from a drop-down menu, I am not given the option to select comparison values for that filter. The course names are controlled vocabulary, so I should be able to give the user an alpha list of courses to choose from. If this doesn’t work, then there’s no point! Thanks.

Okay, so what I am trying to do here is move a project from my “client projects” table into a “completed projects table”. I thought I could do this by creating a “single select” and when the single select “done” is selected, it would disappear from “client projects” and move into “completed projects”. However, I have been unable to make this happen. Any help is greatly appreciated! Thanks!

I am a lawyer and I use Airtable to analyze facts for litigation: i.e. I list all of the relevant facts (like a chronology), then link them with people, issues, etc. In the Airtable, I have a field listing the source for the fact. I use a “bates number” – a unique identifying number stamped on each page of a document in litigation. Most bates numbers look like this XYZ-ABC-000123456. Is there a way to have the computer take the bates number field from Airtable, find a document that has the same bates number as the filename of a pdf (e.g. XYZ-ABC-000123456.pdf), and add that file to the attachment filed of the record? I can point the tool to the particular folder that has all of the pdfs. Many thanks

Has anyone had issues with a base dissapearing?? I have a base that is suddenly not available anymore. Is there a history feature where you can see if a base has been deleted accidentally, and is there any way of recovering that base? Thanks!

Hello! At this point we are trying to create magic and we are in WAY over our heads… Heres our issue… We have all of our data structured in multitude of google sheets, and all of the data is in airtable… We also have a website that dynamically connects to airtable… We are tracking an esports league and 13 teams as of now, and need some things to track top 5 stats, player season and lifetime stats, as well as something easy to keep updated so we can eliminate sheets since the website connects better with airtable. We are willing to discuss hiring someone that is an expert and can make this happen… Leave your info below, but please be sure you understand what we are trying to track and display in a very clean way…

Hello, i have this error below, in my project in x.thunkable, when i regenarate key in my airtable account. " GraphQL error: Either you don’t have permission to read from this data source or it doesn’t exist. " I put my new key in the component “Airtable” in the tab property but my tables not yet synchronized. my contents in tables of bases in Airtable are OK.

Hi there! I’m fairly new to using airtable in my workplace. We track quit a bit of packages from various couriers - UPS, DHL, FedEx. Does anyone know if there is a way to easily link the tracking details from a specific courier’s website into a base so that parcel updates appear within a field? Thanks in advance!

I have a template set up in Page Designer in one base that took a lot of time to build out. We had to restore an old version (just a few days older, the template still existed) of the base as a new/separate base, but the app configuration didn’t transfer over. I don’t want to build it out from scratch on this new base, is there a way to transfer my Page Designer settings or copy them from the old base into the new base? Thanks in advance!

Hi! I’m trying to figure out the best way to organize my contracts and their extensions. For example: Company A has Contract Alpha and Contract Beta. Initially, Contract Alpha was to be complete on 1/30/2021, but Company A has chosen to extend their contract to end on 2/10/2021. The extension to the Alpha contract will have a different PO number, budget, etc. so they will have different ‘internal codes’ that we use to track the progress, deliverables, timeline, etc. What I’m looking for/trying to figure out: The best way to have the contract extensions be set up like a contract and subcontract(s) relationship so that they are ‘nested’ somewhat like this, but in Airtable form: Company A Alpha Contract Alpha contract extension 1 Alpha contract extension 2 Alpha contract extension 3 Beta Contract Beta contract extension 1 Beta contract extension 2 Ideally, the end result would probably be most beneficial if it were displayed using one of the apps (Gantt, maybe?). I’m at a loss

Good day all! New Airtable user here. I’m experimenting with Airtable Pro to gain some functionality over Google Calendar for planning complex jobs across multiple manufacturing departments within our facility. I’m using it as a glorified calendar and I’m trying to get over a couple hurdles I cannot figure out. I need to export about 12 different Google Calendars into Airtable, which I’m able to do by exporting each Calendar as an .ics file, and importing that file into Airtable. Here’s where I run into two MAJOR hurdles. I need to be sure I maintain the NAME of each Google Calendar as it’s imported into Airtable, into a field titled “Department”. For example, I have a Google Calendar named “Material Arrival”, and I have a department in the drop-down menu titled the same. However, when I import the .ics file, I do not get an option to map the Google Calendar’s name to any field. Nor do I seem to have an easy option to automatically set the Airtable field to say “Material Arrival” f