Solved

Hello Airtable Community, I hope all is well! I am having trouble with creating a running total formula/script. In the first table called "General Monthly KPIs" there is a field linking to the "Transactions" table with the dates, month and year, and the amounts of each transaction. There is a rollup field in the General Monthly KPIs table that calculates the monthly burn of each month. How can I create a running total field? There are thousands of transactions, so the 1-to-1 and 1-to-many method will not be applicable.  I tried scripting, here is my script: Which resulted in an incorrect running total:Does anyone know how to create a running total?I hope you all have a great day!- Ella

Hello, I'm trying to return the date in a field based on the urgency selected in another field. For example, if the urgency is "As soon as possible" the date should return today's date which I'm able to get with TODAY() formula. However, I couldn't manage to get next week's date with TODAY() + 7 as I would do in Excel. What is the correct formula would be for that? Thank you! 

I have two tables as follows:Matters table:Matter(s)DescriptionClient NameLead SourceBills table:Client NameMatter(s)Total ($)Both of these tables are pulling from two different data sources. I need a way to combine them both into one table so that table 3 is as follows:Lead Source# Matter(s)Total ($)I believe the best way to do this is to create records, but I'm not sure. In addition to combining the data from two tables into one, I also need the data to stay consistent (i.e. Client Name on matters table and bills table combine into one data set on 3rd table so that Lead Source and Matters can be "associated" with them.)If anyone knows of a way to approach this, I would appreciate the help. I've been working on it for over a week.

Hi everyone,This is my first post to the airtable community forum so please excuse any rookie mistakes 🙂I'm having an issue with comparing two dates, I'm using the following formula...IF(IS_AFTER({Today's date},{Estimated Programme End Date}), "Yes", "No")Strangely, it seems for some records but not others.  Any ideas?Thanks, in advance, for your help.Kind regardsBenDATE COLUMN 1 FORMULA (Estimated Programme End Date)DATETIME_FORMAT(IF({Programme}="NQPC",DATEADD({Created Date},70,'days'),IF({Programme}="BTH/MIT",DATEADD({Created Date},42,'days'),{IM - programme end data (from Initiation Weekend)})),'DD/MM/YYYY') DATE COLUMN 2 FORMULA (Today’s date)DATETIME_FORMAT(TODAY(), 'DD/MM/YYYY')The comparison formula only works on occasion (row 1 doesnt work, row 2 and 3 do work, etc).  See screenshot below for sample output which shows the problem.  Take row 1 as an example of the is

I'm trying to find the average of a Ratings field for a product using a rollup.Based on the docs this should work: ROUND(AVERAGE(values), 2) However, I still only get whole numbers back. How can I see the result to two decimal places using a rollup?

Hi. I couldn't find any specific information related to this. We are currently looking into possible options to conver a Google-Sheets based system to something more thorough.  We want to make sure we do not hit any walls later on in the future, once the system starts to grow. For the Pro plan, there is a 100k automations limit per month.  If you perform automations outside of AirTable, using Make or Zapier, for example watching rows and then updating rows based on certain conditions - would these count towards AirTable automation limit? My intuition would tell me no, but I would prefer to be certain about this - as that way I know we always have a plan B if we hit the limit.

Hey, Is it possible to rate one record multiple times (1 collaborator to rate same recordmultiple times), and later on to show an average rating? And to do that with multiple collaborators? For example, restaurant review, Can I rate the same restaurant multiple times, and calculate the average rating for that particular restaurant? And that average rating to be a combination of multiple different ratings from multiple collaborators. I’m not quite sure how to do that… Thanks

I'd like to set up an automation to send an alert when two records have the same value in a date field.For example, Record A has a date of August 6.  Record B has a date of August 7.  Then the date of Record B changes to August 6 (same as Record A).Can someone please tell me if this is possible, and if so, how?

Morning! I'm having trouble getting Airtable to recognise the output of this formula as a date. It is basically saying "if it's in this city/country, you need to begin the project x,y or z number of months before the required by date". The last "otherwise" was "" but I've changed it to -999 so the none of the formula would spit out a string value, but that still doesn't seem to have worked. The {Client Required By Date} field is a date field in the same table and is date only (no time), so that shouldn't be an issue, I don't think. Formula below:  DATETIME_FORMAT( IF( OR( {Town/City} = "Glasgow", {Town/City} = "Edinburgh", {Town/City} = "London", {Town/City} = "Liverpool" ), DATEADD({Client Required By Date}, -7, "months"), IF( FIND({Country}, "United Kingdom,Spain,Portugal,Republic of Ireland,Poland"), IF( AND( {Country} = "United Kingdom", {Bed Spaces / Units (all)}> 500 )

Hi community!I have an airtable that tracks VFX shots as they come in from vendors.One sheet (delivery) tracks every shot as it comes in, including the same shot with a different version number due to fixes or changesOn a separate sheet (topsheet) I have a master list of all the VFX shots in the filmOn the delivery sheet, I link each record to the master vfx record on the topsheet. That way I can see every version of a VFX shot delivered and track commentsThe issue I have is that the producer likes to see a list of every shot that is either 'not started', 'has issues' and 'passed quality check'. The issue is, because multiple deliveries are linked to the master shot, the master shot can be both 'has issues' and 'passed quality check' as the old versions are linked. Is there a way to group the 'topsheet' so that one group is all shots 'not started', all shots that have issue but none that have passed qc, and a group that is any shot that has at least one 'passed qc'ThanksJames

I am trying to do a simple GET request using Airtable API in Postman to retrieve my records. But it's not working. I am a newbie here, any help is much appreciated.GET: https://api.airtable.com/v0/appkEdlvHkUVyG1QC/Sample%201?maxRecords=3Headers: "Authorization": Bearer Personal_Access_token

Hi I got help with this a little while ago and it was perfect but now I want to add to it and anything I try does not work.This is relating to an commissions payable per situation.IF(  {Booked By} = 2,  {Points Paid} * 0.04)The above works however I want to add more situations -IF booked by 0 points paid is 0.00 IF booked by 1 points paid is 0.03 ORIF booked by 2  points paid is 0.04 ORThanks in advance. 

Can I assume that the order of the record IDs returned by table.createRecordsAsync does match the order of the records to create in the function argument?

Hello everyone,I hope that you can help me with my problem.I tried to export a table in CSV, modify a column and then import it back to the same table with the updated column.However, all the columns that were hosting a link with another table are gone and I need to put them back one by one.Is it possible to import an excel or CSV file in Airtable that was originally from Airtable and has been slightly modified while keeping the links with other tables once imported? Thanks in advance!

I have an Airtable account and so does my client. When they invited me to collaborate on their account it led me into my own account. I can see the collaborators in that company here and can talk to them but now I don't know if what I am creating is in their account or mine. I also want to know if there is a way to toggle between accounts so I can be clear about where I am. 

I have an Automation that is triggered by the appearance (in a new form-generated record in Table-A, {T.A-Rec.1} ) as having a non-empty value in a field {T.A- Field.1’}.  This {T.A- Field.1} is a link to a record in Table-B.Record {T.A-Rec.1} ALSO has a link field {T.A-Field.2} containing a link, {Ref.C.Link}, to a record in Table C.I wish to update a record in Table C, the record referenced by {Ref.C.Link}.  The field in the referenced Table-C record that I want to update is {T.C-Field.3}, also a link field to Table-B.  The value that I want to put into the {T.C-Field.3} in the referenced Table-C record is that of {T.A- Field.1’}, the link to that same record in Table-B.In my Automation so far, I seem to get the trigger to work OK.   But when I try to configure an 'Update Record' Action to update the {T.C-Field.3} field in the referenced Table-C record I get very confused about specifying what record/field to update with which record/field value.  Nothing tes

I would like to have a number field that increments by one whenever the “most recent sale” date field is edited so we can sort products by the number of sales. How do I make an automation that does cellA+1 when another cellB is updated? edit: If anyone knows of a way to do this without a third field, I’d be obliged.

Hello. I am trying to create an automation or a script that updates a cell in a given table based on a unique identifier that can be matched to a unique identifier in another table. In my mind, I'm basically wanting to do a left join, except that I want to populate missing values in a column instead of just bringing the whole column in. So, more of a if x is null, x = value from column in another table mapped by a lookup value/unique ID.More detail about table structure:Table A: File NamesColumn A- Name [short text- is essentially file names, as in ThisDocumentName.docx]. Is populated through a Link to another record column from another table.Column B- Google Drive Link, missing some values [URL]Column C- Unique ID [short text- is essentially a cleaned version of Column A]Table B: Google Drive LinksColumn A- Name [short text- is essentially file names, as in ThisDocumentName.docx]Column B- Google Drive Links, complete [URL]Column C- Unique ID [short text- is essentially a cleaned versi

Hello the Airtable Community! I’m working on a series of Airtable interfaces to handle different aspects of projects. It’s a kind of top-down structure, with interfaces drilling down into linked records e.g. clients > projects > invoices. The typical interfaces structure looks like this: Client A (Interface I) – Project A (Interface II) — Invoice A (Interface III) Client B (Interface I) – Project B (Interface II) — Invoice B (Interface III) To navigate between interfaces in the same client / project context, I’m using record pickers. At the moment, I manually pick the relevant record with the record picker and copy the URL parameters generated by Airtable back to my Airtable base. With such hardcoded URL parameters, I can repeatedly achieve the navigation flow that I’m eventually aiming for. Is there a way to do this “properly” dynamic, with a native Airtable function (such as RECORD_ID()) or similar? Is there an existing documentation that I missed? Is it not yet possible and

Hello! I'm trying to write a script that I can run to populate a field in one table with a value that lives in another table. There are key values in both tables that match. I have worked in SAS and a little in Python for data analysis, but I am new to Javascript. I am thinking of Javascript as adding the element of time to scripting ("wait to do this-- I'll tell you more about it later!")A simplification of what I have:Table1FieldA- unique record ID- stringFieldB- column to receive info from Table 2- stringTable2Field1- unique record ID, matches Table1.FieldA-stringField2- column to populate Table1.FieldB - currently is 'link' field type but could be string if neededI tried to this via automation but it's not working. My guess is the long strings used as the lookup values are causing the problem, but I really don't know why it's not working, it's very hard to troubleshoot that any further.I'm pretty close with the script... kind of. I used another script and can get the lookup functio

Since the forms layout in the interface is so limited (no ability to add new records in a linked table, no options for lists, grids, etc...), I'm basically using the record details layout as a form for new records entry. The problem is that the solution isn't very elegant. My users have to add a record to a list, and then open the blank record to get into the details. Any idea how to implement a page that would act as a record details form without getting there from a list or grid?

I’m currently using nocodeapi.com to reduce the costs associated with my Make operations, but their app hasn’t been updated to the new API specifications yet.  Does anyone know of a similar app or service I could use?

Hi Community,I have a lot of tabs which are all green, however all these tabs consist of various process flow.I would like to assign different colors to the tab, may I ask how to change grid tabs to have multiple colors?Thank you! 

I have a date in CurDt and I want to add YrOffset to it and end up with a new date in a date format. YrOffset can be negative, positive or 0. I’m not sure how to do it.

Hello world, I’m new to airtable and to this community and I think that I need your help :pray: I have a integer field (called “votes”) that is set to 1 when a record is created. I have a checkbox field which is not filled by default. I created this automation : When record matches this criteria = Checkbox is filled Then I want to update the record’s field “votes” by adding 1 But as it’s a integer field I can only “Add a number” :confused: Can you advice me on what should I do please ? Thanks :slightly_smiling_face: