Ask the Community

Hello, I would like to write a script that will move this project from “Active Projects” table to “Completed Projects” table when the status is changed to “Completed”. Can anyone help? Thanks!  

Bonjour, Je cherche désespérément à créer une automatisation dans ma base sans succès et sans réellement en comprendre la raison. J’ai une table Détails Facture qui intègre les lignes de factures de mes partenaires. Cette table a un lien avec un ma table Prix (qui regroupe tous mes produits). Je précise que les deux tables sont liés par un code produit interne. J’aimerais que lorsqu’une nouvelle ligne est créée dans ma base Détails Facture, le prix renseigné soit comparé avec le prix renseigné dans ma base Prix. Si le prix est inférieur, j’aimerais que la base Prix soit mise à jour avec le nouveau prix. Sinon, un email m’est envoyé (l’automatisation pour cette dernière étape est ok).Dans la base Détails Facture, j’ai crée une view avec un tri sur un champ de Sélection si ce champ est renseigné en “Attente de validation”. Dans l’automatisation que j’ai crée un trigger : Quand une entrée est crée dans la vue… Ici je remonte bien mes lignes “En

A common use case I encounter in Airtable is comparing the state of my data today to a prior state.Here’s an example:I have a table of people and the business units (BUs) they bill their time to Due to reorgs, this info changes frequently I’m trying to get a quick view that lets me compare currently billing to prior stateFor example: Person BU as of today BU as of date xx/xx/xx 1 BU 1 BU 2 2 BU 1 BU 1 3 BU 3 BU 4 4 BU 4 BU 1  Perhaps this is an example of a poorly designed database (we didn’t anticipate so many org changes), and I know I can retrieve a snapshot and do a manual compare.IT would amazing if I could take the field “BU as of today”, duplica

I need to work with 2,500 - 3,000 records for a 6-Mo/1-Yr project. Once the records are loaded there will be no need to ADD primary records; maybe a few variables in associated tables. Only one ‘Seat’ is needed; no team collaboration. When the project concludes if I change the Base to the Free plan what will happen to the records over the 1’000 limit?

 Hello everybody I have been working on some AirTable Automation scripts and I figured people might need some help on working with Dates and Times using Javascript on the platform so I am here to share with the community a little guide on both working with AirTable records with Dates along with how to convert them over to JSONs and access/modify them. I specifically cover how to get Ordinal values from the day of the month along with getting the name of the month from the numeric value of the month! Setting Up Your ScriptThe first thing you will want to do is click the Automation Tab → Create your Trigger → under actions  create an action that says “Run a script”.Creating The Script AutomationNext you will

Hello - I saw a post about viewing all place my base is syncing too  - but there was no answer and the thread is closed now.Situation: We have multiple bases that are connected via synced columns. Data moves through the operations workflow. We would like to be able to visualize the system and any dependencies. I’m trying to generate or create something similar to the Base Schema extension but across multiple bases. Anyone know a way to do this? Thanks

I have created a base that I want to use as a central dataset (People, Office, BU, CoDEs, Disciplines).I am syncing the People table into another base (feedback base) and linking to it. I can successfully pull through the Name field, but I cannot get Office or CoDE-related data to come through correctly.When I link a record, I only see the Name, and lookups for Office / CoDE fields return blank.SetupSource base (dataset)People table:Name (primary, single line text) Office (linked record → Office table) BU (lookup → Office → BU for Office) Office List (lookup → Office → Office) CoDE Lead (linked record → CoDEs) CoDEs List (lookup → CoDE Lead → Codes) Other fields (emails, etc.)Office table:Office (single line text) BU for Office (single line text) People (linked to People)

Hi,I have an automation that ultimately triggers from checkbox field being checked. The checkbox is normally checked as the result of another automation, but I need to let users re-run the automation manually.I thought I could place an Update record button and let it toggle the checkbox, i.e. first uncheck the box, then check it anew.Unfortunately it doesn’t seem to work, it doesn’t seem to do anything. Here’s an image of how my setup. Any ideas how to configure a button so that it unchecks and the checks a checkbox?Rgds,Björn

Hi, Everyone!As per earlier announcement Airtable said “Large views load faster with previews”, which is great for views. BUT, we could need that function in interfaces as well as my team is heavily complaining about loading times when a project became more then 25k records, for example. Kai @ CPLI 

Background:I’m keeping records of applicants in my Airtable base. I wanted the applicants to be able to review the information I entered into Airtable and make any changes to them if needed. I already created the form and a separate table to do so, and I created a link (in a formula field) to their own pre-filled form using the Airtable extension. I also already created the automation to update any changes made with their pre-filled form. All of that works great but only when you click or copy and paste directly from the link in the Airtable formula field. Problem:I wanted to set up an automation that would send an email based on a trigger field to these applicants with their pre-filled form and confirm their info. I tested it out with a fake applicant record but the link in the email is not showing any of the pre-filled fields when you copy and paste (for some reason its also not showing the link fully underlined). I’ve attached a photo of what the pre-f

I am trying to open Airtable in Chrome but when I enter a url into a browser and hit return, the screen turns white and my Airtable is tab at the top of browser spins as though it was loading.  Then nothing happens.  The same url works on my colleagues computers no problem (by way of trouble shooting, my internet is working fine, OS and browser is up to date and running most recent version, I cleared my cache and browsing history, disabled all extensions).  I can get it to load in Safari but I want to use Chrome (I’ve set up some extensions and automations in Chrome and don’t want to leave this browser).  Not sure what to do!  

how can we get data from API in Airtable? below is the sample API curl -X GET "https://apiv2.shiprocket.in/v1/external/courier/track/shipment/1559017361980" -H "accept: application/json" is it possible ?

I am looking for a front-end developer to build the public website for Single Use Connect, a B2B platform serving the biopharmaceutical industry.The site has already been fully designed — we have production-ready HTML, CSS and JavaScript, along with SVG logo files and a defined brand system (Libre Baskerville / IBM Plex Sans, a navy and teal colour palette). Your role is to take this existing code and turn it into a live, hosted website.What we need:— Ability to implement clean AirTable data base— Experience deploying softr App— Custom domain configuration (singleuseconnect.com)- A user access management— Basic SEO setup (meta tags, Open Graph, sitemap)— Mobile responsiveness review and polishThis is a focused, well-scoped project — the design is done and the code is largely written. We are looking for someone who can take it across the finish line cleanly and professionally, not reinvent it.Expected timeline: 2–3 wee

Hello,My name is Luke Rosencrans and I operate Chain Reaction Motorcycle School.I am looking to work with an experienced AI automation specialist or small team to build a comprehensive AI-driven operations system that can automate a large portion of my business workflow, including communication with customers, scheduling, payments, enrollment tracking, and administrative tasks across multiple platforms.The goal is to create a centralized system that acts like a digital front office and significantly reduce the amount of manual administrative work currently required to operate the business.I already have many message templates created that can be used to communicate with students, including templates for:• scheduling confirmations• follow-ups• payment reminders• enrollment instructions• class preparation instructions• frequently asked questions• links directing students to the correct signup pages on the website

Hi all, Im trying to build a timeline and all the surrounding forms to manage the factory bays and mechanics on airtable.I’m wondering if there’s any way to colour mask (possibly the background) the weekends as well as masking off the day-offs of the mecanics.  Is there a way to do this on airtable or possibly on extentions? Thanks for your attention.

Hello! I have an automation that runs once a week (so scheduled time trigger) that generates a list of names, email addresses, and tasks based on certain conditions (so Find Records action). I need this email to be sent to the addresses in that list. How can I get this information into the To field?I was able to do this with a “record updated” trigger, but I need it to be a scheduled email.

I am trying to build a system for a one-man business so the owner will be the only user.  While I’m building at least, how do I restrict the owner from being able to edit anything other than what has been allowed in Interfaces?

Hi everyone,I’d like to know if, on the Business plan, there is any way for a user on the Free plan to update or modify a field in a base without incurring additional charges.Is this possible through automations or any other workaround?Thanks in advance!

Current Table Current Interface ViewCurrent “Start Tracking” button AutomationCurrent “Stop Tracking button Automation step two … unsuccessfulThis is my current table, interface and automation set up to try and create a time tracking interface. I am stuck on the “Stop Tracking” button automation. I can’t seem to be able to update the

I have a base with a single table that I’ve published as a library. I went to add that to another base and noticed that there’s a description that I had previously given to the library base, but now I can’t figure out where that description lives. I need to be able to update that text. Is someone able to tell me where that info lives? Slightly longer description of the text I need to edit:In the new base, I click on the plus sign to add another table, and under the ‘Add from data library’ I click on ‘View more...’  Then I see a few cards with the bases I’ve added to the library, and they each have a brief description that was obviously written by me. 

Hi everyone,I am looking to connect with 3 other committed No-Code builders who are serious about turning their skills into a business but want a "team" to practice with first.I’m currently at the Beginner/Intermediate level. While I feel confident visualising workflows and fairly confident building them in Airtable, I still feel that ‘imposter syndrome’ when it comes to the logistics of client delivery - managing permissions, handling live updates, and ensuring I don't break a production base.  And I also still have a lot to learn on the technical side. The Proposal: I’d like to form a small, consistent collaborative group where we can build a portfolio project together in both Airtable and SmartSuite.My suggested structure for the group (open to discussion!):The "Mock Client" Approach: Instead of just building in a vacuum, we could buddy

How do you think web data analysis will change the way companies make decisions in the next few years?

HelloI am a relatively new user of AirtableI am interested in using it to manage my life and work using the 12 week year approachI downloaded a base from the community for thisI am trying to understand how I can use this base week in and week out without having to copy and paste tasks repeatedly? Thanks

With all the new features within the last 2 year sure there is a better way for clients to update their own records. Although it works it is still clunky and would be great to streamline this process.  Context: I have been using fill out, where I send clients their unique URL and they fill info like dietary restrictions and it auto-populates/updates their row in Airtable. Is there a way to do it natively inside Airtable?Is there a simple way to say, like if they don’t fill the information in 5 days it sends them a reminder? Thanks everyone,Sonia

The precision of this error is completely useless…Google reported an error while processing this action: An error occurred while creating the Google DocIt happens +/- 10% of the time, always the same error, on different automation workflows.When I rerun, it passes every time, and doesn’t waste space to tell me it passed because it passed. I read it could be that it gets triggered while not all fields are filled, so I changed the trigger condition to “is not empty” for each of the relevant fields. I’m now out of clue, frustrated by this error description.On this community, I see other having “Mail service not enabled” or “Calendar usage limits exceeded” or “You’ve temporarily hit Google’s rate limit” Those are useful.But to report me an error for the reason that an error occurred.First time I see this.