Other Questions

Hello, New to AirTable, we’re using it to run some data asset surveys. We are looking at a way to cross reference two tables like so: We have following tables: Data Assets Data Elements Data Processes Data Asset Survey Data Processes Survey Moreover: Data Asset Survey links multiple Data Elements per Data Assets. Data Processes Survey links Data Elements and Data Assets (source of data element) independently. Objective: We want to be able to check that Data Elements linked under a Data Process Survey record indeed exist for the Data Assets declared in the same record. This could be done: either by filtering input choices of Data Elements based on declared Data Asset, or vice versa, or by adding some extra column that will verify that the Data Element - Data Asset relationship indeed exists. Not sure if this is explained clearly. In other terms, if we associate A and B to record C, we need to check whether the A-B relationship already exists, to either limit input or to throw a wa

I have a spreadsheet containing rows of data, the unique identifier is email address in Column A. Most cells (in column A) have only 1 email address, but other cells have multiple email addresses, separated by a comma. In Google Sheets, I can use the SPLIT formula to take a cell with multiple email addresses, indicate that the comma is the delimitter, and Sheets will “split” the cell into multiple cells that contain 1 email address each. Example Formula: =SPLIT(A1,",") I’d like to know: instead of needing to split out data using Google Sheets formulas, can I import the raw data into AirTable, and use an AirTable feature (data type, app/block/ automation, etc.) to split the data into multiple records using the comma as a delimitter.

I have a ‘Payment receipt’ form I want my users to fill in to confirm they received the compensations I send them, and I need to keep a record of who completes this form. I have a user database table, and Payment receipts table (and form). When a user fills in their Payment receipt form, I’d like the corresponding ‘Payment receipt’ column in my users database table to get automatically populated. It seems like a simple thing to me, but I really can’t figure out how to set this up and if it’s even possible. I’m really new to Airtable and databases so it might be something really basic, sorry!

I am sure this is going to be the first of many questions as I build my clinic CRM/Visit and inventory manager. The first formula I’m looking for is providing my patients with a unique identifier. The autonumber or record ID isn’t appropriate. The unique reference/ID I was looking to contain the following: First and Last Initial Date of birth (ddmmyy) Incremental 3 digit number (001 So my record ID (Patient Record Number (PRN)) would be BB031200001 Any help is greatly received Bri

Hello Airtablers! I know that I will feel incredibly stupid when someone will explain why this is happening, but I can’t really figure it out. In my base I have a date column. I populated the first 2 cells and I would like Airtable to automatically populate the remaining cells with dates with the same interval as the first 2. When I try to use the fill handle it doesn’t do anything. I have tried with dates and numbers. I have tried creating a new base or adding tables to existing one. I select the cell, get the blue outline with the white box in the bottom right corner, hover over it and get the cross, then when I click and drag nothing moves but the cross. I found this post marked as solved but unfortunately there is no solution: https://community.airtable.com/t/fill-handle-not-working/35445/2 I could really use some help, thanks. Matteo

I would love to see the possibility of the web clipper being able to detect browser information and other capture data. I suspect that info is not possible with the current clipper capabilities. It would make a wonderful bug reporter, if combined with a related item on the wishlist Basic annotation for Web Clipper (the “visual comment” function is better than nothing, but it’s not actual annotation).

How can I integrate my airtable database with my website?

I have 236$ in referral credits applied to my working space but I got an email “Payment Failure” How I can solve this issue?

How should I set up the share/copy so I get referral credits when a new account is created? Note: I simply shared a copy with someone who opened a new account and I did not receive a referral credit - so there must be an additional step. Thank you.

Hi all, I’m struggling to get the correct data into Airtable. As a start a module gets data from an external website that goes through an Iterator. In the example below an Array has 6 Collections with each another Collection. I’m trying to get the 6 different values from “ns9:href” into 1 “Linked To” Column in 1 Record, but I’m not succeeding. I tried different solutions like using the “ns17:ZakelijkRechtRef” array and applying FLATTEN, JOIN, etc. formulas to it, using the same formulas on _attributes, but all give different errors like: "DataError Failed to map ‘0’: Function ‘flatten’ finished with error! ‘[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],1’ is not a valid array. " Or only 1 collection’s output is entered into Airtable, see example below. Can someone help me to solve the problem?

Hi all, Each day we do a CSV import to update our list of new jobs which works great via the CSV Import App but I am finding that since we are also working on the same database that we are importing to, when the following day’s import is done it will revert any changes made to the records that have been altered. We will usually do works, then click a checkbox to mark the record as completed and ready to go. I was wondering if there’s a way to do the CSV Import but have the function ignore any records where a checkbox/flag is present? So it’ll import any new records and update any records without the flag but if the record has been worked on and the checkbox has been checked it will skip over this record for importing?

How do I delete an attachment? Thanks. mw

Hi all, When grouping, Airtable automatically does this count, anybody know if we can pull this Count Value into a cell with like a Formula or something?

The attachments that have been uploaded as pdf files have been available for months. today when I looked at the file many are missing. I know this happened before and I am wondering if there is an update as to when this will be fixed.

I am getting “can’t embed due to provider site restrictions” when I am trying to embed my calendar view into google data studio. I’m correctly using the share link, not the iframe.

Hello!! I got a quick question. I recently created a form for HR purposes. It’s called an Employee Information Form where a new employee fills out needed information as well as uploads necessary documents. In addition to that, the new employee is requested to fill in contact information like LinkedIn links, email, and phone number. My questions is: If an employee fills this form and submits it, then in 2 months for example that same employee has bought a new phone number and would like to adjust this form, is that employee obliged to fill out a whole new form or is there a way to make it updatable for the person who initially fills this form? Thank you so much!

I have smaller teams within a larger department and would like to notify the whole team when an update to an entry is made. I have been tagging each collaborator in the comments but am wondering if I make a collaborator table and then attach all of those people to a team if I can then notify the entire team somehow? Any solutions would be greatly appreciated!

Hi, I am trying to create a gantt chart however having a small issue with the grouping. I want 6 stages to each roadmap feature I have and I have about 50 features. In the table I have a lookup field, where I select the feature and it will pull the ‘theme’ field through, so the table has all the information I need in it. When I use the gantt app and try to group on the theme field, it is only grouping up on the theme where the feature is the same. For example Table: Task name Feature(linked) Theme(lookup) Task1 Feature1 Theme1 Task2 Feature1 Theme1 Task3 Feature1 Theme1 Task4 Feature1 Theme1 Task5 Feature1 Theme1 Task6 Feature1 Theme1 Task1 Feature2 Theme2 Task2 Feature2 Theme2 Task3 Feature2 Theme2 Task4 Feature2 Theme2 Task5 Feature2 Theme2 Task6 Featu

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