Other Questions

I built a base for someone who asked a question here and for the life of me i dont know how to give it to them without potentially opening up all my other bases to this person. ive been trying to give it to them for 3 days and cant figure out how to get it to them with all the apps and automations and everything.

Thanks in advance for your help. I am stuck. We created a calendar of classes for a schedule and used a Single Line Text format for that field (which is our primary field). Now we wish to change the field to use a Multiple Select so that we can color coordinate and dump into a calendar. We wish for different classes to have different colors. We cannot figure out how this can be done. Can someone help?

We are getting double emails when someone submits the form. We get one email from Airtable Automations and another from Airtable How do I fix this?

Users have requested to be able to edit completed form entries before submitting

Is there a way to assign multiple tasks at one time? Right now, each task needs to be individually selected. I would like to assign a group of tasks at one time.

I have a website with many posts (articles). I need to assign contractors to do different tasks on each post. The list of different tasks that can be done on any given page are about 27. Often times, I need them to do the same 5-6 tasks from the task list. Right now, I am having to go into each record (webpage), bring up the linked cell “Tasks” and go through the lists of tasks and choose the 5-6 tasks that need to be done. It takes forever. Is there a way to assign a group of tasks in a single click? Instead of choosing each one from a list? I have gone through the help and can’t seem to find the answer. Maybe I am asking it wrong. Thank you!

Hi all. I manage a charity based community support service set up at the beginning of lockdown which has volunteers performing tasks for the isolated and housebound. This is coordinated by a group of coordinators working from their homes on a shift basis. I looking to set up a basic incident management system but to be honest I am struggling to know where to start. I am tech savvy but new to Airtable, is there a template that would be a good spring board for me to develop for our requirements. Thanks in advance for your assistance. Rod

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