Ask the Community

Dear community,I have two tables, one called Supply and one called Demand, full of engineering information. There could be several Supply records that match the properties of Demand records.I am looking to create a formula in the Demand table that returns the cell 'Specific Material' from the Supply table records, for each Demand record, via IF AND OR conditions.I don't know whether this is possible, and below is my attempt referring to the Supply table via 'Supply.' then the Supply field name. The Demand fields referenced all show as purple, indicating that they are correctly identified, but the Supply fields are all still black.The conditions are all AND except for Supply.X material colour, which could be a match to either Translucent Colour or X Material colour in the Demand table. One of these should match as the last AND condition being met.Could anyone help me solve this via formula? I'd prefer a formula solution to a suggestion to use Lookup

I have a mysterious issue I have a field with this formula: IF(language_assessment_label="English",0,IF(SEARCH(TRIM(language_assessment_label),""&assessor_accredited_languages)=0,1,0)) It works very well in Airtable. However, when the automation transfers the column's values to a Google sheet,

I would like to parse a date string of "2023-02-10", with no time information, into a specific timezone (Europe/Malta). We use daylight savings, so right now, 2023-02-10 00:00 Malta time would be 2023-02-09 22:00 GMT.  For this reason, I cannot specifically add a timezone of +2 because this will chagne to +1 later in October. I noticed DATETIME_PARSE() takes a locale as the 3rd parameter. However, this does not seem to be documented at all in the formula reference. I've tried using values like "Europe/Malta", which works in SET_TIMEZONE(), but doesn't do anything.  I've also experimented with SET_TIMEZONE(), but that seems the other way round, to convert an existing Airtable date with a particular timezone.Basically, what I would like is something where for example could parse "2023-02-10" into the Malta timezone. 

I'm currently in Seoul, South Korea. I'm working with a partner based in NYC. I'm looking to set the timezone of specific fields to EDT as this team needs to automate workflows for the upcoming [tomorrow]'s day's work. I failed to post this last night but at a little after 11p last night (9/5), I was seeing the attached date and time for EDT. It incorrectly reads 9/4/23, 8PM instead of 9/5, approximately 10a. Is there a big or some sort of rigid schedule that the timezone function calculates against? Is it not real time? I need to figure this out ASAP. Please advise. Thank you

Hi--I am looking to create an ecommerce site using Squarespace. I have an airtable base where each record represents a product I want to sell on the website. I was able to create a frame where you can view the airtable base from the website, however, I want each record to be an individual product you can buy on the squaretable website. Any ideas on how to do this?

I need some help trying to write a conditional formula...The idea is IF any cell in column 1 is duplicative/match entry, then look at corresponding column 2 cells and merge merge into corresponding column 3.Is if A2 and A45 match look at/merge B2 and B45 into C2 and C45Is something like this possible?

Hi community,It seems there is no possibility to delete comments made on records by other users.I am the base manager (owner), and would appreciate the possibility to remove comments made by others without asking each person to delete their own comments. Some of them, furthermore, are not on the team anymore (no more access to base).Any way to work around this limitation? Wouldn't it be useful to make base owners able to delete other collaborators' comments?Thanks for your consideration

Hi, I am currently developing the check in and check out for a laundry and I generated their dashboard so they can see the result of their operation per day.As a context for the issue I have the following.Each service order has an entry date and an exit date, as well as an amount that you were able to leave at the time you left your service or pay at the end.The issue I have is that it is not possible for me to do the sum of the inputs with the total of the outputs (total ingresos).The result that should be in this field when I see the information at grid level is added, but when I put the field that has this data, it only gives me the income part.I have already tried to put conditions in the number so that it can bring me all the informati

Heard back from support again today, and it’s not good news.They apologized for being the bearer of bad news, but apparently the decision to only give us three weeks to change to the new plans was a deliberate one.  They made it sound like they had attempted to get the product team to change their mind on this (which makes this feel like a rather disjointed company) but in the end, the product team decided to tell us all to take our multi-source syncs and API calls and shove them right up our asses.Here’s the thing I don’t get: in my case, the biggest issue we have is the lack of multi-source syncing.  Support basically said, “well, just sync multiple tables and use linked records, you fking dummie.”  But like, that obviously doesn’t result in any less syncs running on the backend (or reduced compute cost

I found this formula on the Airtable Developers Page // change these names to pick a view:let table = base.getTable('Invoices');let view = table.getView('Grid view'); let result = await view

I get it - really I do, if you want all your records in a table to be referred to as something else.But I want to just fix mine to go back to being 'records' instead of 'events'

BASE 1Project RecordsPrimary Field is a formula from (2) other fields BASE 2Issues ListEach linked to projects (synced tab into the base) ISSUEWant to see a list of records from Base 2 within Base 1 when looking at the linked recordSynced issues tab is appearing, but linked PROJECT is appearing as single line text no the linked field Question #1:  Would dual-sync solve my problem?Question #2: Any other ideas?  

Is it possible to “pin” groups even when they’re empty? I am creating a table and I wanted to group tasks by “Completed” and “In Progress” tasks. However, I’m wondering if it’s possible to keep the “Completed” group visible along with the “In Progress” group even if all the tasks are still in progress. Would that be possible? Thank you!

I am trying to have different items use different formula code, specifically to modify locks codes that will be different based on date from users and the limitations of each lock. I set up a list of locks and wrote and tested formulas that check for deficiencies in the lock codes that are created from the users phone numbers. An example is if the lock code starts with a "0", the lock with not accept the code. So there is code that looks for a "0" and replaces it with a "1". So if the users code was "0234" the code will change it to.. "1234". IF({Code},IF(LEFT({Code},1)=0,CONCATENATE(1,RIGHT({Code},3)),{Code}),ROUND((VALUE(DATETIME_FORMAT(CREATED_TIME(), '0.smh'))*(9999-1001))+1001,0))Also if for some reason there is no code present, a random code is generated.This code has been tested and lives in a text column in another table, my hope was to use a look up to use this formula code when it applies.  

Hi all,I can't keep my work partner from accidentally adding options to our single select fields. He forgets they are single select fields and just types in his value—often misspelling them. Is there a way to prevent this? One that doesn't depend on me somehow managing to finally get him to remember? I sure hope so. TIA for your thoughts!

I have this IF Statement Formula:   IF(  {UNH Facilities}= "UNH Facilities - GH Cleared",    "🟣",     IF({UNH Facilities}= "UNH Facilities - Supplying Items",      "🟠") ) but I want to add one more piece that returns both an orange and purple circle if {UNH Facilities} has both ""UNH Facilities - GH Cleared" and "UNH&

I'm creating an extension that will create a table and display a response for the user. I want to be able to color some cells depending on the response they get (true/false). Is there a way to do that? Coding? 

Hi everyone, here's what I'm trying to do. This is a base used to track enrolment in classes.Column 1 (linked values): Enrolment HistoryColumn 2 (linked values): Classes - Current EnrolmentI want an automation that will run every day and add any linked values in "current enrolment" to the list of values in "enrolment history", **without** overwriting it.Here's how I've tried to set it up, but as you can see it doesn't work:  

I am trying to copy a series of tasks that have dependencies on the previous task, our projects have a set workflow and we are planning this workflow Airtable using the gantt view. We want to be able to set up our workflows up for each project from a template with all the dependencies and rough timeframes pre set up but we are running into a problem with how to achieve this. At present when we copy tasks, the dependencies copy also but link to the original tasks in the table, we want to find a way to create a duplicate of the task list and programme with all the dependencies linking to the new set of information, not the original tasks. Can anyone help me find a solution to this? Our workflows have lots of complex relationships and currently we have to set this up from scratch each time linking all the dependencies manually. We are really just looking to have a gantt chart template that we can use as a starting point for our projects. Any help you can give me would be much appreciat

Last year I designed a School Newsletter system. One of the columns is the Newsletter Banner which changes for every campaign. It's a png image. I am using Airtable, Softr and MAkeLast school year, I was able to get the image URL. The output from MAke was giving me all I needed including the direct URL. Here the info I got for an image for example:Cover ImageArrayid attRZ6NuuEIBthpMQwidth 1380height 690url https://v5.airtableusercontent.com/v1/20/20/1693879200000/MVzlf5EfMgHm1KCztb4uiA/YQ-c86PccvtHjdv9VUR1v49KxX4BS5xJD4iXuZcVSV25PY2uq3dNQfs0_2sRsLsEQZqZ1r9gbLwfp4lzTPWcE83i19ubgZCM-

Hi all,How can I take the first attachment from a list of attachments and place it in another attachment field? Is there any solution that does not require scripting or integrating Zapier/Make? Cheers

HelloMy company builds complex machines with many parts. A lot of these parts, I need to buy and keep track of delivery dates and whether or not the item has been deliverd.What is the best way to set up an airtable to show all the delivery dates for all items across all my projects?If possible in one interface?Lets say I have three projects running. I need to be able to quickly manually add products to any of these projects and see all delivery dates in one calender so I have an overview. But I also need to see each project seperatly Do I create seperate tables for all these projects? (this may lead to many tables)Best practises here?

Hi All,I'm working with an Interface displaying crew scheduling data and have hit a roadblock.Current Setup:I have a button in the Interface.When clicked, it triggers an Automation that identifies crew with new/updated schedules.It then emails these crew members a grid of their updated schedules.Desired Feature:I've been asked to make the emailing department-specific. In other words, when the button is pressed, emails should be sent only to crew members from selected departments.Challenge:I thought about adding filters to the Interface to narrow down which records are to be emailed. However, from my understanding, Airtable automations allow only one record to be passed via a button click. This would mean sending each record individually with every button press.An alternative I considered was creating an Interface form. The user could define their para

Back in 2020, during the throes of the COVID-19 pandemic, Airtable decided to launch a relief program for organizations that were helping with relief efforts, providing a free Pro account. I applied for our organization and we were accepted. When I asked how long we would have the benefit, I was told by the staff that contacted me that there would be "no time limit". But last week I received the following email:We’ve made some updates to our Airtable plans and will be rolling the changes out over the next few weeks. As a part of these plan changes, our Pro plan is becoming the Team plan, built for teams creating custom applications to support their shared workflows.You are currently on a free Pro plan as a part of our COVID relief program, which we put in place in 2020 to help businesses stay connected through the changes brought on by the COVID-19 p

My automation runs when a form is submitted. This form includes two pre-filled fields: Asset Name and URL Location that are located in the Assets tableThe form resides in the Updates table, and when the form is submitted, whatever value has been added to the URL Location on the form successfully updates that value in the URL Location field in the Assets table.Now, I want to modify the automation so that when the form is submitted, it will also update the Asset Name field in the Assets table. But I am unable to fiddle with the pre-filled Asset Name value in the form, like I can with the URL Location value. I think this is because the Asset Name field in the Assets table is the primary field. I can easily change the name directly in the table itself but can't figure out how to do this through the form.Any ideas are most welcome.