Ask the Community

Hi,I set up an automation to create some events in an Airtable table in my Google Calendar (Google Calendar action). This was easy. But I can't figure out how to use the Google Calendar Update action to delete an entry.Since it in the automation says "Leaving selected fields blank will unset them", I tried to update the start/end times with empty fields, but that was impossible. After manually deleting any setting in the automation field, Airtable "repaired" them when I exited from the view.What is the trick?Rgds,Björn

Hi,Being European but from Nordics, I want to have our dates as d.m.yyyy. This is not a built-in format in Airtable. I have therefore used DATETIME_FORMAT(SET_TIMEZONE(date, 'Finland/Helsinki'), 'D.M.YYYY') in some places where user friendliness is more important than elsewhere.The problem is, dates formatted this way do not sort correctly in an interface. Here is an example image of that:'Is this a bug in Airtable, or am I doing something wrong?TIA,Björn 

I'm using an Airtable form for leads to fill in and want to count a form completion as a conversion in Google Ads.Is there a way to do this?I could use the action of someone landing on the 'thank you' page to trigger a conversion except the redirect to the thank you page after the Airtable form has been completed does not always seem to happen. Possibly because it takes too long and people have left the site whilst waiting for the thank you page to load.Anyone else tracking Airtable form completions as a lead or conversion and worked out a way to do this?

Hello hello!Just a quick question for any tips if anyone has experience integrating Airtable with Squarespace. We're a music education programme. In recent years, we've cleaned up our data and workflows with Airtable. Now, we're upgrading our website with Squarespace and would like to bring it to parity with our data.Specifically, we're looking into integrating our CRM on Airtable with the marketing tool on Squarespace. We'd love to use this as a tool for communicating with our Students and Families.We've used similar tools, MailChimp, Mailerlite, etc., and done these without integration with Airtable.The other things I'd likely look into are the member pages for students and ways for them to find their schedules and resources. All this data is organised on Airtable already!If anyone has experience with Squarespace and Airtable some tips would be appreciated!

Hi thereI have two tables I want to link.One is a table of organisations and the other is an excel file of data that belongs to one specific organisation. Both files are uploaded. (Later, there will be other tables to link to other specific organisations).I can use the + sign to set up a new field in the organisation table. I then select Link to a new record.This is supposed to bring me up the option to select which file I want to link to,.  But every time it brings me up the attached screen shot which doesn't allow me to select an existing file.I've tried it in firefox, chrome and edge with the same result every time.Help!! What am I doing wrong?PS I don't understand how the link is going to go to a specific organisation using this method, but maybe that's the next step I can't get to.Helen Gardnerhelen@thegardners.com.au

Been a long time since I've used Air Table. Having trouble recalling how Linked Tables work.I have two tables, one Table is a list of all checks with primary field being a check number. This is a list of EVERY check related to a bank account.I have another table, that has a smaller subgroup of the first table. These are checks that were entered into our accounting system.  The primary field for this table is also check number.What I need to do, is take the larger group and check to see if the record is in the smaller subgroup, and flag it.  Thus I will develop a list of all checks in Table 1 that are not in Table 2.So essentially, Take each check in Table one, look in table 2 and if that check number is there, flag it.This way I can create a list of checks I need to add to my accounting program.I am a bit embarassed as about 5 years ago I had a grip on all of this, but at my age I essentially have to relearn everything after that p

Hello,I am importing a csv file formatted: 390,390,390The table does this: 390 390 2 390 3It's including the number of 390 values in the import fileHow will I fix? 

How to export Table into MYSQL table file or CSV?Can be synced table from Google Sheet into MYSQL?

Hi everyone,I have two bases in Airtable: "Employees" and "Projects". Previously, I managed everything in a single base, but I decided to split the data for better clarity. Now, I want to fetch data from the "Employees" table in one base and automatically add it to the "Projects" table in another base using the API.In the "Projects" table, I have an "Employee" field where multiple employees can be assigned to a single project (e.g., Project 1 has Employee 1 and Employee 2). I'd like these employees to be displayed as a list.I already have an API token set up, but I'm not sure how to fetch the data and display it in the "Employee" field so that they can be added to a project. Could someone guide me on how to do this?Thanks for your help!

I have an Airtable backend and I’m looking to create a front-end solution where users can:1. Create Individual Accounts: Users should be able to sign up and log in securely.2. Create Favorite Lists: Users can create personalized favorite lists from items in my main Airtable list.3. Add Private Notes: Each user should have the ability to add private notes to items in their favorite lists, which should not be visible to other users.I’m seeking recommendations for low-code or no-code building tools that integrate well with Airtable to achieve this functionality efficiently. Any suggestions or best practices would be greatly appreciated!

What is your process for troubleshooting automations in complex bases that have information changing regularly?I have an error occurring with an automation that I am struggling to troubleshoot. I can't seem to replicate the error in my testing, which means I am not accounting for/considering an action happening when the base and relevant records are interacted with. I am struggling to identify the issue, as:1) Airtable doesn't instantly notify you of the issue (notifications take 5-45 minutes) - which is bizarre. In a base where there are likely many more interactions with the record in question by the time I realise the automation has failed, this makes it hard to walk back and figure out what conditions are creating the error.2) Record revision histories don't seem to be overly thorough:a) the log doesn't show where an automation fails,b) the revision history timestamps are recorded unhelpfully as "17 hours ago" etc - which make

Hello All,I run a real estate wholesale business and I'm looking to create a new table that will basically just tally all the calls we make every day. I would essentially like to be able to just click a button inside each record when a call attempt is made and have that data go to a new table, separated by date just so we can track daily calls.Any help would be greatly appreciated.

Hi, I help run a live event production company, mostly concerts and other performance events. I am trying to create a schedule for crewing my events. I want it to be organized by "Event" primarily, then "Position" (think stagehand, lighting, sound, etc) and then I would like to assign crew to each position. I have attached the Google Sheet I currently use for reference. I have already created my crew database as it's own table, as well as a table for events. I am brand new to Airtable so please explain as if I am a third grader. In addition to this, I would like to create a time sheet for each "Event", preferably auto-created when I create a new event, that auto fills with pay, position & crew member from the schedule, and I just have to input hours and then I can print that and send it to accounting. Any help is appreciated. Thank you!

I'm setting up a ranking and league system for our tennis club. The ranking should work according to the following rules:1 – Players in each division will be arranged in order of the number of matches they have won in the round. Win = 3 points, Loss = 1 point, Forfeited/Defaulted player = 0 points.2 – If 2 players finish with the same amount of wins, the higher position will go to the player who won the head to head match between those 2 players (if played).3 – If 3 or more players have the same amount of wins, or if 2 players have tied but have not played each other, then the positions of these players will be decided by the most matches played. If this decides 1 or more of the players positions, but still leaves 2 players equal, the positions of those 2 players will go back to the head to head result.I'm struggling with a way to automate ranking for Rule Number 2. Has anyone done something simil

Hi everyone! I'm trying to create a dashboard to visualize our project management data, and I'm having a little trouble with the charts. I have three tables in the base, and I'd like to select a record from a single table and show charts of the data in the fields for that particular record. But when I add a chart and make sure the source is the record picker, the field options are just the other two tables, not the fields in the table the record resides in.What am I doing wrong? 

Can someone explain how to save a table to a CSV file. I have done a search, but everything tells me to use the "save as csv file" in the dropdown for the table. I do not see that option for any of my tables. If anyone could help, I would appreciate it. Thank you.

Hi there, is it possible to have a column only show certain single select fields dependent on what the previous column select e.g. I want to only show items within a certain category not all the items in all the categorys.Column A = CategoriesColumn B = SubcategoriesI only want to show the subcategories within the category I select.TIACharlie

Hey guys!I have a schedule creating Record Template that only creates half of the schedule I need it to create. Here's a quick breakdown on the set-up:Tables:Job - Contains all job information, linked to Schedule. Where the template is applied. Schedule - Contains schedule phases, no manual dates. Linked to Jobs and Tasks. Tasks - Where the dates are actually entered (but not in the template). Linked to Schedule.Template info:Creates a series of Schedule phases and Tasks. There are 65 records it's supposed to create. It worked about a month ago perfectly fine. The Problem:Currently when I apply the template from an interface it only creates 32 of the records. There doesn't seem to be anything wrong with the template, everything is entered into it correctly. Has anyone else ran into this issue? Let me know if anyone knows whats going on and if there's a fix.Thanks!

For the plus or pro plan, how many creators or editors do you get? I see that you get Up to 5 creators or editors under the Free Plan.

I am currently trying to set up the Google Cloud Vision API via an extension in Airtable. When adding the API key, I am currently getting the following error:'Cloud Vision API is not enabled. Enable the API.'However, I have followed all the steps required for the API to work:1. Created a Google Cloud project 2. Set up billing 3. Enabled the Google Cloud Vision API, added it to my project and generated an API key.I am still getting the error message despite having disabled and enabled again, removed and re-added the extension and deleted and re-created an API key.I would be grateful for any additional suggestions regarding how I can add this extension.Many thanks,Jamie

Hey everyone.I am trying to use the script made by No Code Collab that is made to run as an extension with a button trigger and turn it into an automation that runs a script.I cannot figure how to pass the record to the script. I have set up my input variable but cannot find a way for the script to take it into account.in the screen shot you can see what I have tried without any successAny ideas ?Thanks !T

Hello,I have 3 tables which are linked to each other Customers Invoices https://airtable.com/app0jw4sAdW5VRy68/shrRhehmziVBIfiAG Budget vs. Costs https://airtable.com/app0jw4sAdW5VRy68/shrTYer8pWxDAuat6 The Invoices table is my catalyst. I have created an automation to update the linked record field in the Invoices as follows created a new formula field that generates the right text to go into that linked record field. an automation that triggers whenever a specific field in the Invoices table is updated &

Hello,I am trying to develop a maintenance tracking solution that deals with both dates and hours or miles due. I am attempting to configure airtable automations to send notifications as upcoming inspections become near.  I have figured out how to run a notification automation quite easily for those inspections required by a certain date. However I am still trying to determine how to configure the same type of automation with a trigger when the miles or hours reach a certain time. For example, if the next inspection is due at 1,234 miles, I want the automation to trigger when the current vehicle miles are within 5 miles of that number, or anytime that the current miles have exceeded the next due mileage.Thank you for your help.

HelloI am new to Airtable and I am trying to create dynamic calculations in a record in my calculations table that is updated every time when a new record is created through a form for another table called Non-Title I School Tours - Virtual. I used Rollup in the calculations table to sum multiple records in a field in the Non-Title I School Tours - Virtual table. The problem I am running into is that it is not summing up multiple records it is only showing the first record and none of the records after it. Any feedback would be helpful.

I am struggling with the proper set up for my base.I am a manager of an HOA, and we are in the process of tracking all construction projects in Airtable. Applications are submitted via form and records are created automatically upon submission.Where I'm stuck is how to track the progress of these projects. Each have a Phase, and each phase has critical tasks that need to be completed before we can approve advancing to the next phase. Ideally, once all tasks are completed for a phase, the record would be updated with the next phase (with corresponding subtasks), and so on until project completion. A check list with conditions, so to speak.I have tried various templates, but none behave in a way where I can monitor and update records according to project completeness. Appreciate any insight on how to best tackle this.