Ask the Community

HelloI have a requirement where I want to create a Unique Customer ID based on their name and an incremented numberFor example:I add a new customer "XYZ (North)" and want to generate the Customer ID XYZ001Then I add another New customer "XYZ (South)" and want to generate the Customer ID XYZ002ID would just increment for each 3 character prefix.  I have no problem with having another table to trank the highest used number for XYZ if needed Fields would be "Customer Name" and "Customer ID"TIAMike

It's past May 17th and I still don't have the left navigation UI referenced in the help article "Getting started with Airtable Interface Designer." I'm missing the "add element" button. Anyone else with this issue?

Currently, formula fields support numeric, date and text output only. Are there any plans to extend formula field to work with other types of output (such as the single select field)? A bit of context: I have 3 single select fields (let’s call them A, B, and C) which represent the status of a task. Statuses may have one of the following options: Todo, Doing, Paused, and Done. For example, given some task, it could have the A field as Doing, B as Paused, and C as Todo. With that in mind, I’d like to have a field D that automatically selects its value based on fields A, B, and C. Let’s say D is a formula field that does some least common denominator logic to figure its value out. The problem I’m facing is that the output type of D is text, and I’d like it to be a single select field’s value type. Also, is there a dedicated place to ask Ai

Hey, there! 🤗I have a column named "Time" that has the time a test was taken based on military time.  I'm trying to get the the column "Time of Day" to be able to populate automatically either "morning," "afternoon," or "evening."I believe I need an IF statement.If score time is:0-11:59: morning12-16:59: afternoon16:59-24:00: eveningMy formatting is probably way off 🤣 I am very new at formulas.  This was based off my research in other forums.Thanks! Here's what I tried: IF( {Risk Score} < 0, "error, value too low", IF( {Time} < 12:00, "morning", IF( {Time} < 17:00, "afternoon", IF( {Time} <= 24:00, "evening", IF( {Time} > 24:00, "error, value too high" ) ) ) ) )

Hi all, I’m trying to use an IF formula to convert “Y” and “N” text strings into Single Selects titled “Upgraded” and “Not Upgraded”. Here’s the Airtable document: https://airtable.com/invite/l?inviteId=inv2cn0Kk8vSLJcdj&inviteToken=65adac3e71ede9340db2d2c9d4fc5897 I have a formula for converting the Y or N into a text string, but cannot find a way to – or any documentation for – converting them into Single Selects. I need something that will automate this process; it can’t be done manually. New records will be added continuously to the Airtable. Any help you can offer will be much appreciated. Thanks

Many times we wish to have a single select or multi select field automatically choose an output based on other fields. Automations are useful for this, but are limited and become convoluted as a separate module, especially when you have many of these use cases in one table.It would be very useful to have a single select or multi select field with an inbuilt formula box, where the select output could be determined by the formula. You could then introduce another option to lock formula mapping (ie no ability to edit), or freeze mapping, where an Auto value output would generate unless the field was manually overwritten.The workaround at present is to create three Fields, 1 select field for manual input, 1 formula field for automated input and one last official formula field to take the most relevant of the two previous outputs. This generates clunky database design, similar to when there was no today() function.

Hi, I have a Single Select field that has the options “This week”, “This month”, “This quarter”. I’d like these to be automatically chosen and updated based on a Date field. The purpose of this is to use a Matrix block to display records by a “Event Type” Single Select on the Y axis and in relative date categories “This week” etc on the X axis. Is this possible, or can anyone suggest a better solution?

I created an "upgraded" form and gave users commenter access to the base and workspace. However, when they try to upload a file (images to be specific), they get an "invalid permissions" error. Is there a setting that I am missing? I tried out this setup with the old forms and it seemed to work. 

I appreciate your help!I have one main table of English learners who register for classes - name, contact info, etc. Let's call is the Main Student table.There are two other tables that get data related to each student. (One table gets data from Stripe if the student is able to pay anything. Another table shows teacher comments about the student from the prior year.)In the past, we set up links between the tables. Then, for each student, we manually linked the individual records and had "lookup" fields for the fee & comments in the main Student table. But we had 750 learners register with us last year!How can we automate this? I'm thinking that an automation would need to:1. Find matches between the Main Student table and the other tables (based on one or more of name / email / phone)2. Update the record on the Main Student table with the data for that student in the other tables.I have searched for examples (found one relevant on

We have a retail chain with 150 stores.  I have a workflow where the stores complete a form to give feedback on the quality of a product.  In my base the forms are submitted into one table (Feedback).  The Feedback table is linked to a table called Stores that is a list of all 150 stores will their detail. It is also linked to the Product table that is a list of all the products.I am trying to create visibility for the team that will show them which stores have not yet submitted their feedback per product.  I tried to do this in the Stores table as all 150 stores are listed there.  The problem is that the lookup to the product field will contain multiple products per store.  And as soon as I filter on Product I only see the stores who have submitted feedback - I want to see the ones who have not yet submitted feedback.Any ideas of how I can achieve this? 

Hello everyone,I currently have two tables, one for Plants (industrial power/chemical plants) and one for Events (scheduled maintenance outages). Each Plant has a unique Plant ID that is also listed on each Event with multiple Events for each Plant. Is there a way to automatically link each Event to its respective Plant based on matching the Plant ID in each record? In other words, is there an automation that exists or can be created that looks at the Plant ID on the record in the Plant table and the Event table, recognizes that field as identical on both, then links the two records? Thank you!KCVellichor

Many thanks for considering my request.I have a Table A. I chose the "When a record is updated" option in the Automation trigger with multiple field selections, and the Next step is Scriptwriting, In the script, I need to track which field has been updated recently (i.e. which updated field triggers this automation).Eg: Table AField 1 | Field 2 | Field 3 | Field 4These four fields are selected in the "When a record is updated" option of the Automation trigger.If Field 1 has been updated recently, we need to track that Field 1 has been updated recently.If Field 2 is updated recently, we need to track that Field 2 is updated recently.Based on the Field update I have to write logic.

Hi AT CommunityI have a Google Sheet which has cell values (text/currency) which I would like to bring into Airtable. Along with those values I need the user to answer some questions. I would like to prefill form fields with the cell values from the Google Sheet, hide the fields, leaving visible only the questions which I need answering. Any suggestions on how I could go about this please? It needs to be a one step from Google Sheet to Form. I have looked into prefilling a Google Form from Google Sheet, this then populates Google Sheet (form response Google Sheet), when a row is added it creates a record in Airtable Base. I don't think you can hide Google form fields which isn't a huge problem, but not my preference. Any other thoughts or suggestions. THANK YOU.

Hi,I have a field with created dates. I would like to be able to create a chart that shows this data, grouping by the month of the created date. However I want the year to be irrelevant. For example, March 2024 and March 2022 to be shown in the same group within the chart.I have created a new field with a formula to show the month only which works perfectly. But then when I create a chart on the interface, they are in alphabetical order and not date order which is not want we want.Can't think of a way to make the chart display the months in date order, or another way for this all to work. Any help is appreciated!

I have a base that allows my constituent departments to submit requests for communication/outreach production. Each department has an individually tailored interface so that the fields are customized to what they need and use regularly with departmental communications. This allows me to maintain all requests in a centralized location, but also keep and track long term comms. planning separated by department.I need to be able to utilize the "user" field in each interface so that records can be assigned to one or more individuals. However, each unit should only have the ability to view and assign users that have access to that specific interface. Right now, it shows all users who have access to the entire base. It even displays deactivated users. Further customization of user settings, groupings, access, etc., would be even better, but this basic setting is a must for our needs. If anyone has any insight on how to make this happen, we'd be so appreciative! 

Has anyone noticed changes in how automations are functioning? I used to be able to update linked record fields with record IDs from previous steps, but now they all come out as comma-separated strings. See attached pics:  

Sorry that this question looks a little like a written math problem, but:We are tracking employee requested PTO via Airtable.When an employee uses their PTO, they can request to pull from a group of 5 temps to cover their shifts.We'd like for employees to be able to see a list of dates that still have temps available before they put in their PTO requests.What I can seem to do is group by date of time off requested, and it shows me the total count for how many times a specific date has a request for a temp. (See below - 1 person requested a temp on 3/14, while 4 people requested a temp on 3/15.)Or, I can have a calendar view, stripped of personal information, that shows how many requests have been made of a specific day. (See below.)

const Airtable = require('airtable'); const airtable = new Airtable({apiKey: 'patMH--changed--FEQXBB4',}); // Replace with your Airtable base IDconst baseId = 'appM0aa--changed--DFmhzwJv6w'; // Replace with the table name you want to accessconst tableName = 'home_first';airtable.base(baseId)(tableName).select(

const Airtable = require('airtable'); const airtable = new Airtable({apiKey: 'patMH--changed--FEQXBB4',}); // Replace with your Airtable base IDconst baseId = 'appM0aa--changed--DFmhzwJv6w'; // Replace with the table name you want to accessconst tableName = 'home_first';airtable.base(baseId)(tableName).select(

Hello community,I'm trying to make use of an automated email that inserts a file name and a google drive url every time a document with a particular naming convention is added to my google drive.  I generate the airtable record using a make.com integration, and then the email fires in the native airtable "Gmail:send email" function.  (I suppose I could try to take this automation to make.com instead, but I'm hoping my use case is simple enough that I can just keep it in airtable for now).The problem I am coming across is that my file names have underscores in them, and my google drive URLs sometimes have characters that seem to cut off the complete URL.What happens when the file name has _filename_ in it, is that airtable removes the underscores and turns filename into italics.  I've tried using the "escape markdown" tag (see here: https://su

Hello Everyone,I want to copy the whole Table including Column Names (headers), is that possible ?I don't want to type by hand all column names each time I copy/paste the whole table in a spreadsheet for example.Thank you for your help

Hello:New to Airtable and new to the forum here...Looking for a solution to combine records in my field {Component], for every change in records in my fields {Location ID} and {Room}.  For example, in the attached image I would want to combine WF218, W361824, RF9624 3/4, W3330, and so on to B18, in a new field.  This is to correspond with {Location ID} 1-3-302 and with {Room} A Acc Kitchen.  For the next combined field, the result would be ADA SB30, for location 1-3-302 and room A Acc Bathroom.  I would like to accomplish with a formula, but I understand I may need to create a new linked table.  I am attaching 2 views; one is grouped and one is a straight view, for clarity.  Thanks so much!!  

How do you keep track time spend on a given task ? I’d love a ChromeExtension to start/Stop a timer on a given list of task (aka an AirTable View) I don’t know if for a given Task it is better to Start / Stop a Duration field on a kind of Task row Start / Stop a tracker that will have a reference to a Task (to say I work on that Monday, Tuesday and Friday) Anyway : all Pomodoro “like” are bazooka with non sens paid subscription … third party app SaaS, etc … AirTable WebClipper is not very handy AirTable TimeTracker use Dashboard (I find dashboard not very usefull for many reason) Any Idea before I code my own extension quick and dirty ? The cleanest solution (for me) would be something like WebClipper but to edit existing items and not only add new ones. So I would be able to quickly update task of a view for instance.

 // Ottieni i parametri di input let config = input.config(); let recordCRM_id = config.recordCRM_id let ruolo = config.ruolo; let pagamenti = config.pagamenti; let minorenne = config.minorenne; // -nocheck let baseID = 'IDBASE'; // ID della base LabOratorium let tableID = 'IDTABLE'; // ID della tabella in cui si trova il record da aggiornare let recordID = recordCRM_id; // ID del record da aggiornare let personalAccessToken = 'TOKEN'; // Il tuo Personal Access Token di Airtable // Funzione per calcolare la formula function calculateFormula(ruolo, pagamenti, minorenne) { let result = ""; if (ruolo) { result += "Loreto24_" + ruolo; } if (ruolo && pagamenti.includes("Acconto")) { result += ", Loreto24_Acconto"; } else if (pagamenti.includes("Acconto")) { result += "Loreto24_Acconto"; } if ((ruolo || pagamenti.includes("Acconto")) && minorenne === "SI") { result += ", Loreto24_Minorenne";

Hi, Table A, B, and C. Table B fields are linked with Table A and Table C. I'm trying to run automation. Whenever a new record is added, I will filter the records from Table A and Table C based on the condition. Then I need to create a record in Table B by linking the data from Table A and Table C. Now I can filter the records from Table A and Table C using the Find Records action. but not able to run a nested repeating loop. I can do only one repeating loop.