Ask the Community

I am using a formula to calculate a date in one field, and then trying to use another formula field to determine whether a contract is current, future, or expired using that date and another manually entered date field.  The field I'm using to determine if the range returns the wrong results if I use the calculated expiration date field, but if I use a manually entered field with that same date, the calculated range returns correctly.   ExpDate:DATETIME_FORMAT( DATEADD( DATEADD( LIC__EffDate, {Term (Mo)}, "months"),-1, 'DAYS'), 'M/DD/YYYY') ContractRange:IF(   ExpDate > TODAY(),   IF(   LIC__EffDate > TODAY(),    "Future",   "Current"),   "Expired"   ) ContractRange copy:IF(   LIC_ExpDate > TODAY(),   IF(   LIC__EffDate > TODAY(),    "Fut

Hello!I would like to tag some records based on the text content in a column (ie: if Title contains "Tour" tag Tours). Feels like it should be pretty straightforward but I can't figure out how? Thanks! For more context: I imported all of my team's events from Outlook and realized Airtable doesn't support the "Category" feature, so I want to add tags to these events so that we can break down the data. I figured I could probably do that based on title or other key words.  Thanks in advance!

Hi guys,We'd like to be able to import a list of around 30 items (BoM) at a time to a Cost Estimates table, create a single record in a Cost Centres table and link all the items in the BoM import to this Cost Centres record. The name of the Cost Centre record won't be known on import, so can't be specified in the importing csv. Each import should create a new Cost Centres record.I have tried playing around with automations but hit the issue of automations running in parallel and creating several Cost Centre records before the BoM records find them and start linking to them.I'm sure this can be done with a script but I'm hoping there's a way I can avoid that. If not, I'm happy to pursue that avenue and am open to some advice on how best to implement that.Thanks in advance for any suggestions!Josh

Hello helpful community,I have a primary table of People with PersonID as the key. I have 2 secondary tables, Notes and Assignments, where PersonID is a linked field. A user reads the Note, creates an Assignment, then marks the Note complete. I'm trying to create an automation where:Once a Note is marked complete,Find the Assignment with the corresponding Person, and Copy the content from a field in Notes to a field in Assignments.All goes well, I think, until the 3rd step. Here is Step 2, it yields the results I expect.Here is Step 3 where I get the "Invalid input" error message. How do I select the RecordID of the row we're iterating through in the Assignments table? I'm not sure what to select here:Added complication: Some people have 2 Assignments, and I'd like to copy the Notes field to both Assignments. Any help or guidance would be appreciated, thanks!

Is there a foolproof way to do this? I use CTRL-X and CTRL-V, but sometimes it works and sometimes it doesn't...and it may depend on whether the columns and views are arranged the same way between the source and target tables. 

After going to interfaces and choosing the grid option there is an option to hide and show certain fields.However, all the fields that you show can either be editable or non-editable. It would be a great and easy addition to choose individually which visible fields can be editable and which not. If this was possible, you could potentially build a fully functional portal instead of using additional tools like Softr, Miniextensions, etc. for it. 

Hello.Until today, I managed to insert a tidy parcel of HTML into my Gmail automation templates resulting in beautifully branded emails. But that hack has suddenly broken across two bases. Does anyone have any idea why and how to fix it? Thanks.Kate

Apologies if I don't use any of the correct terminology when explaining this problem. I have a form set up and I want the information in each field in that table (Table A) to populate fields in other tables. I have managed to make some of this work using a trigger that watches for new records being created in Table A and creating a new record in Table B with linked fields that end up creating records in Tables C through E. I was able to set up an automation in using a trigger that watches for new records being created in Table C which happens automatically because of the linked records in Table B that then finds records in Table D and updates records with empty fields with information from a field in Table C. That's as far as I got but I am two automations short from having all of this work as intended. I created another similar automation to populate an email address field in Table C with information from Table A using the same record creation trigger from the first automation I made

I am trying to build a table to calculate pricing. But, every column (which is its own product) has different price points under it, based on square footage. How can I set up a formula that will calculate each drop-down option (multiple selection), per column and total that up at the end? See screenshot for referenceFirst column is interior photos. There are four potential options in that field, so I need a formula that will calculate based on the selection I make in each column. And the same goes for every other one. 

Hi there, I think this question has been asked in other threads - but I didn’t find a straight answer to that. Is it possible to share an org chart app extension outside Airtable? I can’t find a way or workaround to do so - only downloading it as a pdf. It would be amazing to be able to have the same browsing experience (zoom in and out, collapse sections and so forth) but in a sharable link to be used somewhere else. PD: also adding a legend or some text would be nice too :slightly_smiling_face:

Can we PLEASE get a fix for this? I do a lot of data entry in Airtable, and it's very challenging to manage record changes with this setup. The Problem: If you're working in any grid view with a sort or filter applied, Airtable will often try to sort/filter the record currently being edited, before the entry is completed. If you add any text into a field, every character you add to the record will trigger the re-sort/re-filter, regardless of if you're still actively typing. Suggestion: It would be ideal if Airtable did not recognize a change to the record until the record is "de-selected" (when the user hits "enter", "tab", clicks away, etc.). It's very frustrating to have a cell I'm actively working on move within the view as I'm doing data entry. Additionally, this change will reduce processing load in Airtable, because it's not constantly trying to reorganize the data with every keystroke. It would be EVEN BETTER if there was a setting on the view level (in base) or i

Hi there. I am trying to write a formula ("Duration of Pending Repayment") that calculates how long an unpaid repayment is overdue.Essentially, it will be:If "Repayment Due Date" is not blankAnd "Repayment Received Date" is blankThen calculate Today-Repayment Due date. This part I got with DATETIME_DIFF(TODAY(),{Repayment Due Date},'days')I cannot figure out how to do the If/And with blanks, not blanks. Any ideas, wizards? 🤓 Thank you in advance!  PS - Here's how the formula currently reads:IF(AND(NOT({Repayment Due Date})),{Invoice Issue Date},DATETIME_DIFF(TODAY(),{Repayment Due Date},'days')) 

Hi,Hoping that someone might be able to help me with a formula question (I'm quite new to formulas and have been fumbling along until now, but have reached the limit of my knowledge!)...I have a table of payments that have been made, each with the payment date. These Payments are associated back to a project budget and are rolled up so that, at any point, you can see the total Actual spend to date. I've got this all working well.I am now trying to add in a new field in the Project table which shows total Actual spend as at the most recent quarter end - and I'm stuck! I've managed to write a formula in the Payments table which formats the payment date into the year and quarter (so turning 2022-02-04 into 2022-1) but I now want to work out how to pull this through to the Projects table. I know that I could build a series of fields in the Projects table that rolled up (respectively) all Payments in 2022-1 and then all Payments 2022-2 etc etc, but this doesn't feel very sustainable as

Hello!I'm using the API extensively in powersave to create and update records.New records is created via `POST` and the attachment array gets processed just fine.But then, when a record is updated via `PATCH` the previous attachment seem to get partially corrupted. They can still be opened and viewed in full size but none of the thumbnail are available.I tried to send back the attachments in various formats:{ id }{ id, fileName, url }{ id: fileName }It seems to happen in all cases.Is there any way I can prevent this? Thanks a lot! 

Hello! the view bar that is supposed to be at the top of the airtable page, in particular such options as “hide fields”, “filter”, “group”, “sort”, “color” etc do not appear on my airtable app when using on my laptop. Same time, option to customise fields with the same above mentioned functions (filter, sort, hide field etc) as well do not show along with the dropdown arrow which is usually located next to the field title and is the way to see list of the above functions. Is there any way how to restore those options/functions and get the view bar with all the fucntions? thanks a lot in advance for help!

Hi Everyone!I would just like some help or insight on the problem I'm having with an automation I'm currently trying to make.The automation is supposed to send an email to the user after creating 10 new individuals (like networks) on a table. I'm stuck on how to do it and I cannot fully grasp the resources on airtable help-center so i'm here to ask for additional help or advice 🙂any thing that can help me understand better  would be much appreciated!Thankyou!

Hello All,I have a base for an order management system where I created an interface (Record Review layout) to display received orders. I added a field for the order status, including options such as "Received," "Damaged," and "Not Received."I want the system to open a new form for adding extra details (Logs table), such as the order number, description, and other relevant details, whenever the user selects any status other than "Received." for individual records or is there any other way to do it without using the third party solution and script.If required any more details let me know in this thread.Thanks. 

I am using fixed for my rescheduling logic for date dependencies in my project management base. The primary reason I am using fixed is I need to be able to create buffers between dependent tasks (i.e. tasks with predecessors). Let's say task A is request a copy of bill from provider and task B is review bill.  I know that task A takes minimal time so I set it to start today and give it a duration of 1 day. Task B is also pretty straightforward and takes one day so I also set its duration for one day BUT it takes up to 30 days to receive a copy of the bill and it's out of our control so I want task b to start 30 days after task A ends. In the timeline view addressing this is pretty simple. I just define a buffer value for the dependency of task a and b.The challenge I am having is that when creating a project using a record template I can add the task A and B along with making task A a predecessor to task B thus enabling automatic calculation of task B's start date b

Hello,  I am trying to create a formula to put together a date we expect something to be completed.Date to Client is entered by my team and is the first part of the equation.Client Timing is pulled as a lookup field from another table dependent on each client as is based in days.  Formula I have is Dateadd({Date to Client}, {Client Timing}, "days").  This equation is taking the client date (ex 12/2/25) and always subtracting one (ex 12/1/25.Is there a different formula I should be using for this type of transaction?

Hi - first timer here!I have 2 tables in 1 base.  Table A contains info about Recipes I'm creating. Table B is where I schedule those recipes for newsletter publication. Recipe names are pulled from Table A into Table B by linking fields. There are 3 recipes per date, so 3 linked fields. So far so good.I want to have the newsletter date in Table B pulled into the corresponding recipe record in Table A. See attached illustration - what formula do I need to replace the question marks with dates?

Hi 🙂I am trying to set an automation that will update a specific field based on the information that is on another table. The field I want to update is called Relatorio as shown bellow.I want to bring a field from another table that has the same number as the fiel (Item LV) from this table.Here is the picture from the table I want to retrieve the content from.I want to compare the ITEM LV from the first table and compare it to the ITEM from the last table and update the field RELATORIO from the first table with the content found on RESSALVA from the second. So every time ITEM = ITEM LV it should the update.The first table should be completed with aaaa on the first line, ddddd on the second and eeee on the third line.I setup the automation like this but it finds no records.Tks for the help

How do I configure Stacked Bar charts? I can’t seem to find any option in the Chart properties in the Interface.

I have an automation that once an attachment field is not empty, it creates a new record in a different base with that attachment and a few other fields.Is there a way, that if the attachment field has more than 1 file, it will create a new record for each one of those files?

I have a table of transactions with a date, the date is formatted in dd/mm/yyyy.I want to import more transactions from a CSV, the CSV is also formatted in dd/mm/yyyy.Simple import right? Wrong!On the import mapping page, the CSV data is being picked up as mm/dd/yyyy even though nothing in my base is in that format. As a result it's confusing the dates and losing half of them.The only way I can make this work, is to change the date field to a single line text, import the data, then change it back to a date in dd/mm/yyyy.Am I missing something or is this a bug?Pics:My table:My CSV file:The import page:It's not even getting the month correct.Very frustrating   

I have a table in Airtable with two fields: "Child" and "Mother" (just an example to explain the structure easily). The "Mother" field is a linked record to the same table. Here’s a sample dataset:ChildMotherRaviSnehaKaviSnehaBalliPrernaMalliPrernaSnehaMotherPrernaMotherI want to add a new field, "Number of Children", that counts how many linked records (children) each mother has. The expected output should look like this:ChildMotherNumber of ChildrenRaviSneha0KaviSneha0BalliPrerna0MalliPrerna0SnehaMother2PrernaMother2I tried using a Rollup field with COUNTALL(values), but it counts each linked record separately instead of summing up the total number of children for each mother.How can I achieve this without creating another table? Any suggestions or workarounds would be greatly appreciated!