Ask the Community

I am trying to create an automation that updates a record when certain conditions are met:Let's say I am evaluating my retail inventory and want to identify inventory boxes requiring certain follow up tasks: I created a Box Flags field to aggregate a few different record fields into 2 flags: boxes that need to be replaced, and boxes that need their contents separated. I have created an automation to update records for the first flag, but am struggling with the conditions for the second. I only want the "separate contents" flag on boxes with more than one field value. "Has any of" retrieves all boxes, "has all of" requires a tedious number of conditions to capture every combo of values, "is exactly" and "is/is not empty" don't apply. In other apps I've worked in, I could write a condition like Box Contents contains A,B,C,D,E AND (Box Contents is not equal to A OR Box Contents is not equal to B OR...) to filter out the single value records, but I can't seem to wrangle thes

I want to create a users table. This will be tied to the users who have access. I already have a projects table which i can easily assign owners via the people who have access to the base, similar with tasks connected to those projects (this works fine), my problem is i cant create a table of team members who are on the base using the information from who has access to the base and then group by owners to show what projects they own.I have done this in a hacky way but it seems it doesn't update when i add new projects so thinking if there's other ways of doing this

Hi,I've been using the new airtable form builder.In order to identify different form users, I created a Form Source field to be pre-filled with the user type, and created a custom link. When the field Form Source is visible, there is no problem - the right data is pre-filled in the field. But when I hide the field in the form settings, the data is not populated. I remember this working great in form view previously, not sure why it is not working using form builder. Any solutions?

HelloI am trying to use Vega-lite extension for my data set in Airtable and I used existing JSON specification as a basis. Here is the JSON that I used (https://vega.github.io/vega-lite/examples/waterfall_chart.html)What would be the reason why the numbers on the bars won't show in my case? Here is how it should look like:In my case it looks like this:  

I've already seen several other posts about this so I assume I am not alone. We have been using Airtable for 4+ years and we simply want to switch to Enterprise to add capacity. I've submitted the contact form at least 4 times now. I would happily throw money at the problem if only they would let me.Has anyone successfully been able to do this or is everyone seemingly ignored by Airtable?

Hello All,I am new to Airtable custom extension development and I am trying to build a custom extension for testing purpose.My qurey is that can we route from one component to another component using react router? And if yes can someone give me demo code for it using any three components,

Hello,So I basically have a table for candidates and a table for job adverts. I have a make.com automation set up that when a candidate applies to one of my job adverts it automatically feeds them into my candidates airtable and will also create a new record in my job advert table if one doesn't already exist (first person who applies for the job). I am running this for 3 different offices each with its own make.com scenario to distinguish which office they are applying for. It will automatically feed the candidate into the candidate table and adds the correct office field that it is linked to.Where I am having the issue is I also want it to update the job advert office field automatically. It seems that it cannot be done within a make.com module. I was wondering how I can set up an automation so that when a job record is created it will find the candidates record that triggered the creation of that job advert and grab the office that candidate is linked to and automatically feed

Hi all,I'm working on a project and I need to Combine Table A from Base 1 with Table B in Base 2 to create one table, Table C.I've already linked the two original tables to be in the one base, but I can't figure out how I can automatically combine the two.Thanks in advance!

Hi there - I schedule shipments to be picked up on specific dates from specific sites at specific times, and I need a way to identify if I've scheduled any shipments to be picked up on the same date/site/time to make sure I'm not double booking a site. I've created a formula in my Shipments table that concatenates the three fields:IF(  AND({Load Date}, {Site Abbrev.}, {Load Time}),  DATETIME_FORMAT({Load Date}, "MM/DD/YY") & "_" &  {Site Abbrev.} & "_" &  {Load Time},  "") And I've created a Rollup in my Sites table using ARRAYJOIN(values, ", "). All that seems to be working just fine. But the formula I've created to identify any duplicates in the Rollup field always returns No Duplicates even if there are duplicates.  IF(  LEN(ARRAYJOIN({DEV | Load Date, Load Site, Load Ti

Im trying to use a field related to another table, the field is a date datatype which is in local format (DD/MM/YYYY) but the lookup tries to use another data forma (MM/DD/YYYY) so its not retrieving properly.Fecha de Facturación and Fecha (from another table) are both in local format But the datatype link from one table to the other search in another format so it fails...anyone who has passed through this problem?  

I'm trying to create a simple contact database of names.  When I have several names that happen to be related (ie of the same family), I'd like to link each of them to each other to show those relationships.  I can create a link to other people in the same table ("People") for example John Doe is related to Jane Doe, but when I go to Jane Doe, I don't see the relationship to John Doe.  It doesn't seem to be two-way.  Am I missing something?

If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.I currently have the formula (see below), but its marking everything in FY 2024. instead of in the appropriate next quarter. I know I am missing a small tweak, but cannot figure it out! 'Q' & IF(ROUNDUP(MONTH({Program Start Date})/3, 0) = 5,1,ROUNDUP(MONTH({Program Start Date})/3, 0)) &" - FY" & IF(ROUNDUP(MONTH({Program Start Date})/3, 0) = 5,25,24) 

Hi there, I am hoping that someone will be able to help me with this interesting little problem. I have a table as a "reference table" which allows me to set fees globally across the base so if a fee for tables goes up I can change it across all records. That same table contains other fees such as fee for square footage used elsewhere.In the table "Bookings", the second table, where the reference field is then used, I would like the ability to auto pull through the value field based on the lookup value. Example below. In "Reference Table" the fee for tables is 12.00 In the "Booking Table" I have the link value as the Reference Field "Table Fee" and the lookup value of "Value"All of this works fine but in the Reference Field, I would like that to be able to populated with the "Table Fee" so that the value pulls through also. Is there a way to do this?The option for pre selecting a value that appears in other fields is not available in a linked field.Thanks in advance

I am trying to sort by the Week # of the year that an entry is assigned on my base. Its sorted by year, then by week - so 2024, week 1 through 52, etc.However, for anything this week up until the 31st, its showing up as the 1st week of Dec 2024 (which confuses me as you would think it'd be 1st week of 2025?). I would like that to show up as the last week of Dec 2024 (week 52) or even Week 1 2025.Formula is:WEEKNUM((Assigned), "Monday") It is pulling data from the "Assigned" column, which is listed in the format: 12/30/24 11:00amThanks!

Hello community, how would you go about exporting a table or even base's field names and IDs? In an ideal case, I would sync on intervals a sorted list of all fields and their properties, similar to how it's shown under manage fields. Thanks!

Hi again,Is there a way for you to have data from a field "written" to that field and fixed for those changes elsewhere will not affect the result in this field in the future?An example of this might be;A fee in one table is designed to be updated in future years, and that field is referred to in other locations. Once that booking has been confirmed and paid, I want to be able to "fix that price" for that booking so that if the lookup value in the first table changes in future, that the confirmed bookings either do not change or, that a field has been updated which then remains at the agreed price.I hope that makes sense? Thanks S

Hello everyone!I need help with a formula that computes two fields as {field 1}/{field 2}.However, the base is new for my team, and we're working to input backdated data, so some records that use these fields are 0 (zero), at the moment. The formula field that computes the two fields is used on current data, and we'd love to eliminate the infinity returns so as not to interrupt the SUMs we use in other areas of our work.I've played around with several iterations of the formula and solved one to lose another 🤪 The current formula I'm using to keep us sane in the interim is:IF({KGM 500 Total Attendance}>0,{KGM 500 Total Attendance}/{KGM 500 Total Capacity}) Attached is a screen shot of the fields in the base for reference. As we work to gather missing data, Total Attendance may be inputed first or second to Total Capacity. When the missing data is entered, both fields will have a number greater than 0, I want the Formula Field to compute {KGM 500 Total Attendance}/{KGM

HelloI would like to build a base where I have tables with planned income, planned cost and summary table that reflects incomes and costs on monthly basis.My question is, if it is possible to take bank balance as a basis for the calculation and calculate Bank balance +income - cost for each record so that the basis for each calculation would be the result of previous row? For clarity, here is how I would like it to work:I have seen some similar questions here as well, but I am not sure if they would work for this use case as well.Thank you in advance.  

Im new to airtable and make.com so forgive me if this is a elementary question...I setup an automation that has a Stripe webhook to monitor for payments and then update a record when there is a payment but I cant get it to update the record. It can find the record no problem but when it gets to the update module it gives me an error.Bellow is the log and setup of the update module. What am I doing wrong?Thanks in advance!   

I need to automatically trigger a script that makes use of `Field.updateOptionsAsync`to add options to my single-select field. I first wrote this as an automation script so I could easily set up a trigger, but saw this API is only allowed in scripting extensions. So then, I wrote it as a script extension and couldn't figure out how to automatically trigger it to run. So then I found out about block-cli and released the extension to my base because I misunderstood that `block run --remote` does not run the extension remotely, leaving me with 2 extensions that do the exact same thing. So:Is it possible to run extensions remotely / trigger them to run automatically? How so if it is?Can we get the ability to use `updateOptionsAsync` in an automation script?Is there yet another way to achieve what I am trying to do? 

First using airtable but profecient in Python, SQL and some JavaScript/Vue3.js for house needs. I dont consider this a "complex problem", but havent been able to crack it in Airtable env. only.I have a scenario where i want to dynamically control form field visibility based on "boolean" values from another table. I am aware that form defaults to communicate with one record at a time given the table it belongs to.I have a table named "application" and another "analysis" and fieldsnames are generally the same. once "application" has a PDF file attached, analysis makes a "lookup" and a python script executes 16 rather complex regex patterns and saves the output as boolean values, could be "1 or 0", "yes or no" and "ja or nej".From the analysis output, the idea is/was to use these booleans as a condition to manage visibility and nothing else. Because, as you can see in the bool_update_flow.png attachment, the users are to upload specific images.If it is, can i utilize a JavaScript in order

Hello!I am wanting to add a DATEADD formula to my base to set deadlines for different tasks based on a hiring date. I've done this in a previous base, but have since lost access. Can someone help me with the formula I need? For reference, some of the formulas I need help with are:Task: Email for photo, new hire survey, and short bio of new hire (-7 days before Hire Date)Task: Assign desk space for new hire (-3 days before Hire Date)Task: Give Uniform (on Hire Date)Task: Collect how to contact employee while OOO (1 day after Hire Date) This is my current formula:IF({Task} = "Email for photo, new hire survey, and short bio of new hire", DATEADD({Hire Date}, -7, 'DAYS'))When I add another {task} = ..... , it changes the format of the first deadline from a date to T00:000:00.OOOZ and then the next task's deadline just shows up as "true." When I reopen the formula, it looks like it changes itself from IF({Task} = "Email for photo, new h

Hi Airtable Community...I'm new here!I two tables:- Table One:  with user name, email, phone, and an attachment (file pdf).- Table Two:  with new client information once a form is submitted which will create a new record (name, email, organization, and phone)I want to send an automated when a new record is created in Table two and to attach a file from Table One (column is called attachment)When I click on the + to Add an attachment: Base Structure --> I can only insert date and time value, which seems to not be correct.Can anyone assist. If this was posted before - I apologize, and point me in the correct direction.Desert1211

Hello. I’m working on importing record or data from Airtable to Salesforce. I created a custom automation in Airtable that runs when the button is pressed. However, the data is not being updated in Salesforce as expected for each table.

Hello!I would like to create a field that shows when (date and time) a record (task) has been marked as "Done". Here is what I have so far: How do I create a formula and/or automation to do this? TIA!