Ask the Community

Hi, I would like to create a fitness tracker for our climbing team. I periodically test our athletes (ie, vertical jump, shoulder strength, etc). I would like to track each athlete’s test scores/numbers, enter that information into airtable and have the ability to track each athlete’s improvement for each fitness test. One test is the vertical jump. I will need to test their standing reach and then standing jump. Ideally, I want to enter standing reach every so often (not every test) since the kids don’t grow that quickly. But I want to update standing jump every time we test. How do I enter standing reach into airtable and be able to retrieve that for future tests? I would like future tests to record standing jump but then reference standing reach in order to calculate vertical jump (ie, standing jump less standing reach). Thoughts?

I want to create a table in my send email automation because there are several features that I want to put in the email and formatting as a table makes it easy to understand. I tried creating a table using markdown and HTML but it isn't working.  

I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!

What’s the best way to create an automation with Airtable + Make/Zapier + ChatGPT + AI image generator (Midjourney, Leonardo AI, etc.)?  For example, enter a basic prompt in an Airtable base. Then, via Make it sends the prompt to ChatGPT, in which ChatGPT assesses the prompt and rewrites/improves it. The automation can stop there or go even further by then sending ChatGPT’s improved prompt and sending it to an AI image generator to instantly create that image?

The form that I have will only be used by internal folks and all the information populated will be on their record. We are running into an issue where it says that the “form was submitted by anonymous.” We’d like to track who submitted the form to see how many forms a person submitted in a given month. Is there a way we can have the name of the person who submitted the form? And is there a way for me to link form entries to that person’s record?

I have built a system where various tables for different Internal departments sync to a “target” table where an API takes the data and uses it in a Warehouse management system. The idea is to use this target table as a place where everything is put together, ideally without any human intervention.However now I've just read the following in the sync support section:Automatic syncs will eventually stop on bases that don't have any recent activity. To keep automatic syncs active make sure that some kind of action (i.e. create a record, update a record, create a new view, etc.) is being performed in the base on a regular basis by automations, humans, or a combination of the two. I wonder how that will affect my target table in the long run.Do new rows that are created via the sync count as 'created record' even though there is no human intervention in the target table? The use of this table is periodic, as the nature of my business is seasonal. So to avoid any sync to stop working, will a

Hello Everyone,I have observed that a limited number of my dropdown fields in the interface designer allow for the enabling or disabling of adding new options; currently, only about 40% have this feature enabled. How can I enable the feature to be available on all remaining dropdown fields?  

How do I collect email address of people who fill the form? Do they need to fill in the email field each time? Or can that be just noted from a logged in user?

I have a lot of documents that want to organize. Airtable only allows photos. It would be great to add a scan feature.

I have a table with contact information for people and business. I need to associate contacts (in the same table) with each other where appropriate. When I associate Sally with Joey (see screen shot), I'd like Joey to automatically be added as an associated contact for Sally.I'm having a hard time wrapping my head around how to automate this. Especially since I don't want to affect the Pizza Shop record in this case, I just need to locate the record that was just linked to (Sally) and enter the record that was updated (Joey) while also retaining any records the "linked to" record (Sally) already contained in the linked field (Pizza Shop). 

Hello guys! I work at a biotechnology company and we use bioreactors to produce fertilizers. My problem is the following: I have a database with two tables: Orders and Tasks One of the fields in the Projects table automatically calculates the number of fermentations (tasks) I have to run depending on the volume of fertilizer I need to produce. The calculation considers the total volume that must be made per order, the number of bioreactors I have available at the time of the order, and the production capacity of each bioreactor. Since the number of brews (tasks) is dynamic, I would like to automatically create a Task list for each order. For example, if I need to perform 17 fermentations (tasks) in a given order, I would like 17 new records to be created in the Tasks table and associated with the order. Thanks to anyone who can help!

I Need to update an Airtable record's "Status" and "Booking Options" fields (both are Single Select type). The Record ID for the update is passed into the Airtable node as part of its input JSON item (e.g., from a previous Set or Switch node).Airtable Node Configuration ("Update Record" operation):Resource: Record Operation: Update Mapping Column Mode: Map Each Column Manually Columns to match on: id ID (using to match) - Expression: {{$json.airtableRecordIdToUpdate}} (This expression correctly resolves to a valid Airtable Record ID string like "recUkSMINWTJgvPzw" when previewed in the expression editor with the correct input item). Values to Update: Status: (Hardcoded string, e.g., "In Progress - A - Needs Pickup location") Booking Options: (Hardcoded string, e.g., "A - Pickup/Drop") (Field names used here exactly match Airtable field names, case-sensitive).  The issue is when the node executes with the Record ID supplied by the expression {{$json.airtableRecordIdToUpdate}}, it fai

I just signed up for Twilio, including a A2- 10DLC registration. I tried to send a couple test from Airtable, but Twilio says Undeliverable because I’m not registered. Does it really take up to two weeks to have an A2p 10DLC registration approved? Is there anyway to send or test twilio in the meantime?

Hello folks, I am new to Airtable, any help is highly appreciated. I have different tables under the same base that tracks existing inventory and sales. I would like to create a third table that summarizes data for example I would like each row to represent a month and calculate profit/loss for that month but if I use rollup or formula fields it will apply the same formula into entire column which doens’t help my case. I need unique calculations to be carried for each row as each row will represent a month. 

I’m trying to create a form as follows; Based on the entry on one of the fields, I send out an API request with the field value. I get a result from the API and I show that in the form itself. Is this possible?

Hi,   I’m used to work with spreadsheets where you can refer to a cell in a previous row.And I know spreadsheets (data in rows) and database (data in records) can’t be compared.But I would like to build a project where I can see the evolution of a certain value.Here you have a simple table where the first column (datum = Dutch for date) is chronologically ordered and each value is unique.In the third column, I entered the difference between the current status and the status of the “previous month”  manually to show what I want.  Is there any possibility to get this done in Airtable?  With formulas in another extra table?

Is there a way I can share just a single record with an individual, via a customized link?  My nonprofit runs a program where people apply and then their application goes through various stages.  We have an Airtable form (as the application), which links to a base where each person’s application is displayed as a separate record.  We would like a way for people to automatically view the status of their application, so we are trying to see if there is a way to share their own record with them, but only their record-- not anyone else’s records in the base. Obviously, we could copy and paste their record and send it to them, but we often are contacted multiple times by people who are wanting to know about the status of their application as it moves through the phases, so we are curious whether we could create a custom link that we can send to people after they initially submit their application.  The idea would be that they can then return to the same link periodically to see updates in t

Hello everyone, I am trying to use Airtable to create a schedule interface for multiple people This is the thing that I would like to achieve. This is sort of a mix between a Genn Chart and the Calendar view, but Genn Chart doesn’t display hours… Any thought? Thank you in advance (!)

hello my friends Can i set a role for validation at entering data in a table ? i have a table that contains promo- codes for a marketing department. Every promo code assigned for a section in sales department. it shouldn’t assign in the table for two sections in sales sales department. is there a role to validate if a colleague is entering a code in the table for department A, a role that says ‘this code is already used for department B’ ? is it available rather than the team filter on duplicates to resolve after that ? thanks

I need a column to calculate the total days- formula being ENDDATE minus STARTDATE plus 1.  Any suggestions?  I can get the datetime_diff, but that is days between not total days.Thank you!! 

Hi everyoneI hope for your help to improve an existing script for automating tasks for projects. I have courses and classes where we always have repetitive tasks in order to organize the courses.In order to avoid creating always the same tasks, I created templates with tasks and a script that copies the standard tasks to the task sheet, and assigns them to the person that need to deal with them.For example: each course need a zoom link, a graphic and a registration page. By selecting the template, these three tasks get copied and assigned automatically.So far so good. Now I want to add dependencies of the tasks in the template, because some tasks should have the status on hold, until a pre-requisite task is completed.The names of the tasks will repeat themselves, and when copying the tasks from the template to the task sheet I don’t know how to assign the right dependent task.This is the template sheet:  Below is my script:// @ts-nocheck// Select project&n

Hi everyone, I have an automation, where the automation should copy a field whenever a new record is created. It should copy the data from Instance field to All Events field in the same table. However I get an error that says “Updating the record failed due to insufficient permissions.”. I made this automation as the owner of the base and I have absolutely no idea what or where is going wrong. Does anyone have any recommendations to solve this problem? Thank you in advance!

In my interface I can provide a Pie chart that will show the % of yes and no responses to a survey question.Each response, yes or no, is tied to a month value.  I want to see the % over time of the people that reported yes to display a trend chart month over month.  Example in Jan 42% reported Yes, in Feb 100% reported yes. This would be similar to my average satisfaction score month over month. How do I take the Yes/No answers and convert them into a % of the population in order to track month over month?

When I am downloading a .csv file from my base when opening the file in Microsoft Excel some of the data is missing/changed. The field that is having the issue is a linked field that lists numbers from an autonumber field. It seems that after 5 sets of 3 digit numbers the numbers just change to zeros. I have attached photos of the data from Airtable and what I am seeing in Excel.

Hi, I’m new to Airtable scripting and am just learning my way around through hit & trial. I don’t have any javascript experience either, but I’ve used python in the past. I’m trying to write an Airtable script that sends data to my Integromat webhook trigger. So far I’ve been gotten the following: // Webhook URL let webhook = 'https://hook.integromat.com/integromaturl'; // replace with actual integromat URL // Table to send data from let tableName = 'Master Client'; // Fields to bind and send let fieldsToSend = [ 'Client ID', 'Client Name', 'Email', 'Created Time', 'Last Modified' ] I guess I’m stuck with what to do after this. My intent is to use the Airtable automation such that when a new record is created in this table (Master Client), I want this script to run. But what do I need to add to my script so that Airtable sends the information in my ‘fieldsToSend’ variable to my ‘webhook’ variable. All I seem to have done in my script is to create and assign v