Solved

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

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 am fairly new to Airtable.  A couple of months developing. Have a few questions below.  Many thanks in advance for any guidance provided.Q1: Need to merge two bases - what is the way to go?  The chatbot mentioned scripts to bring data over and sharing the tables from one base to another.  I would like to merge the two into one Master one and not lose existing comments in any records, any history or scripting/automation in either.  Is there a way to do this? Q2: How do I see/query the backend table structure in Airtable via  SQL? Is that possible? is there a tool out there that can help with that?Q3: Any companies that offer Airtable development that I can chat with - looking for rapid development so need more Airtable engineers?

When I do a rollup to get the unique documents, it is correctly retrieving just the unique values - but while a lookup brings up the actual attachment documents, the rollup displays Airtable's Internal URL for the document.How do I then retrieve the document?   

I have a few currency fields that I am adding up in a simple formula field. I am then trying to display the output of that formula field within a text string I am building with another formula. However, I’m getting some strange decimals when showing the numbers.In an effort to troubleshoot this, I create a new blank Airtable base for testing and I’m getting the same result. For no apparent reason (to me), when I reference the total field in the string, it will sometimes add a ton of decimal spaces, like this: Here’s a link to my sample/testing base that is showing this issue: https://airtable.com/appqBYuTjL8QbhmF4/shrM4rk6GDRaJQ4QNMy formulas are pretty simple:Total of Amounts 1 & 2: {Amount 1} + {Amount 2}Display Total in a String: "The total of both amounts is $" & {Total of Amounts 1 & 2} & "." I can’t figure out what might be causing this, especially when I manipulate the Amount 1 and Amount 2 values to reach the same sum, the decimals somet

Hi, I’m trying to share a developped interface with other users in my organization, they receive the link by email by they are invited to login. For information i’m in the Pro panel with only one user. Can someone help me please. Regard’s Amine

Looking to create some kind of form / interface that allows the user to submit multiple records. For context, here is the use case:I'm creating an Ordering/Receiving Inventory Management base to use across staff at a Restaurant for order management. Person 1 does the ordering, they submit what they ordered. (ideally they'd be able to do it by distributor, so for Distributor 1 we ordered 7 cases of X, 2 cases of Y, etc.) This populates to a new table of sorts that Person 2 can reference when they do the receiving of said order. They'll see the 'Qty ordered', the 'Item Ordered', and the 'Distributor'. They theoretically can denote what was received (1 case of Y instead of 2 cases, etc.), as well as attach invoices for easy reference. Not necessarily set on the set up being a 'form' per se, although that makes the most sense to me. However I am getting stuck as I can't find anything about adding multiple records through a form, it seems the form set up is more specifically for fillin

Hi there, I'm on a business plan using interfaces as a ticketing system with multiple external parties. Each external party has an interface with a unique filter condition and are given read-only access. I want them to be able to view the comments too - is there any way I can do this? I've enabled record-level details such that when they click on each row, the individual record shows. however, it doesnt allow me to configure this record-level view with Comments/Activity feed element. All I'm seeing are the Fields, and two other options: Chart and Number. 

Hello,to simplfy my struggle with reporting in Airtable lets imagine this workflow:I have Employee, Projects, and Timelog tables where employees track the time spent on specific projects. Each employee has their own hourly rate.What I need to achieve is a monthly report for each employee that includes:All projects they worked on in the previous month (show them only if they worked on specific project at least for one hour)The total time spent on each projectThe total cost (calculated based on their hourly rate)apologize if this has been discussed before, but I couldn’t find a solution.I am could achieve this by Pivot table in the dashboard section, but I need to make automations based on this results (adding Payments and so...) Thank you

Hi, new Airtable’r, I searched around but couldn’t find answer to this! I’m surveying my customers about their opinions on products we’re considering developing. I have a base that contains a table with details about all the potential products, including a field I made customer ratings. I’d like to create a from that displays every product in the table, showing its image and description, and a place to collect their rating for that product. I’d like to be able to use that form to see customer’s average ratings of them. Is this possible? Thanks!

I have a [Anniversary] field and a field that calculates the next anniversary, so I get reminders and write a card for my volunteers. Here is my problem:The basic formula works fine when there is an anniversary in the field. When there isn't one, I get the #ERROR, which one would expect. I tried ISERROR(...) and IF(ISERROR...) to get it to show blank, but I can't get it to work. All the fields go blank, even if there is a date.Here is the working formula in the AV_Next field:DATETIME_PARSE(DAY(Anniversary) & "-" & MONTH(Anniversary) & "-" &(YEAR(TODAY()) + IF(DATETIME_FORMAT(Anniversary, "MMDD") > DATETIME_FORMAT(TODAY(), "MMDD"),0, 1)),"D-M-YYYY") When I tried this, it worked for showing blanks, but then the date formatting ignored all normalcy. I get this: 2025-07-20T00:00:00.000Z IF(ISERROR(DATETIME_PARSE(DAY(Anniversary) & "-" & MONTH(Anniversary) & "-" &(YEAR(TODAY()) + IF(DATETIME_FORMAT(Anniversary, "MMDD") > DATETIME_FORMAT(T

We have a couple of columns populated with emails and names, the rest of the AirTable base will be empty (I've attached a screenshot). What we'd need is to trigger the workflow in Make based on specific time trigger automation and I just don't know how to tell the workflow to start as the specific trigger time automation in AirTable doesn't allow me to use the recordID field. Would you be able to direct me to a solution if there's any or tell me how you'd accomplish that feat?

Hello,I have an issue with ISO8691 date format between Calendly and Airtable using Make.comMy workflow is Calendly (Watch Events) > Airtable (Create a Record)Calendly sends an object with a date field :Airtable configured this way in Make :And the field in the record is configured this way :Gets as input :But creates a record with :What can i do ? Seems that something is wrong but can't figure out where. 

Hi, I keep getting this new message in the automation script ide :Error: Request processing is disabled due to earlier failed requestIt seem like airtable does not want to rerty a fetch that previously failed even if the input parameters have changed. Anybody else is getting this?It's the first day that I saw this message and it's a bit combersome.

Hi !I struggle to import data from a bigquery table to another table in Airtable.My connections are fine, but I can’t manage to map the field between bigquery and airtable in Make. Any tutorial or idea ?I just want to import or upsert the data from bigquery to airtable. The fields are the same and ready in airtable.I've tried Skyvia but it make several errors when upserting...Thanks !

Hello,Our team has reduced available hours in the summer, and I'm trying to figure how to represent this when using the Utilization summary in Timeline view so that their Available Hours are reduced during a set start and end date. Thank you!

Hi there,We are attempting to create some sort of conversion tracking tool for our leads. The fields in our data table that are relevant for this are: Account Type (Lead, Customer, Rejected), and Source.There doesn't appear to be a way we can easily create a table, like in Excel, where we can simply name columns and create formulas in each cell.Here's the table we're attempting to recreate: The issue we're running into is we can't create the majority of the columns seen in this screenshot. Any ideas to help?

Hello--We're developing an Affiliate program where the affiliates offer a free month on our app. We're gathering new user data from Typeform forms that are automatically dropping in the information into different Airtable sheets as shown below.I'd like for all of the new users to then be put into another table that I can sort by start date, but I'm not sure how to do that.  Thanks in advance!

i created the sample project  the hello world when ever i visit https://localhost:9000  its gives me a whole project files in the browser instead of hello world any idea what it could be  ?im attaching the screen shot for referencewell im trying to create a custom extension

Is it possible to update a value in automations to update an entire table uniformly?For now I'm doing it in a script but it can run on 50 rows each time, so I made a loop but it takes over a minute each time

Hello All!New to Airtable but loving it so far!I created a CRM for my company, and also created several interfaces for employees to use the CRM. Everyone uses the interfaces on the Airtable mobile app on their iphone.One of the interfaces is a Referral Log, that allows users to add client referrals, comment, and keep track of them. Every employee has full access to this Referral Log interface, and can edit, create, etc.I have built everything to be seamless, and it is perfect so far - save for one issue:When a user comments on a Referral, or uses the @ symbol to add someone to the thread - they receive a notification that someone commented or mentioned them. This notification exists in the "notifications" menu in the apps base menus. However when you click into the notification a message appears "This page is not supported on mobile. Go to Desktop view." - the annoying part is you can easily just go to the record you were mentioned in and view the comment there, so the page is totally