Ask the Community

I have 2 Airtbale Bases.One of my Airtables is importing a view from the other. The sync is 1 way and I see the data change as it is updated on the other base.I have some automation setup that looks for updates on specific fields.I noticed a load of automation shad not run, logged into Airtable with the data import and suddenly all the automations ran.Is this the expected behaviour? Is there a way to make sure the autoamtions run even if no-one logs in for a few days?Thanks

Hiya, I am fairly new to Airtable and have been tasked with setting up our CRM for the charity (HUGE JOB!) So... we have to get our dogs weighed roughly every month, but I need to be able to compare current weight with previous weight and how much the weight has either gone up or down. What I would like is when I come to enter a new current weight (in the {Current Weight kg} & {CW Date}(which is automatic date), the data that is already in those fields move to the {Previous weight} column and {PW Date} column (currently I am copying and pasting the data from current columns to previous columns before I enter the new current weight which is not ideal!.I then would like to merge my two formula columns {Difference} & {Difference in weight} into one formula so that all it basically shows is the weight difference and either a colorful up arrow or a down arrow emoji.... (oh and have the blank fields remain blank (not saying up!!) Can anyone help me do this?@Ben_Young1 

Hi,Is it possible to create 2 different forms on airtable ? 2 forms that would not be connected?thank you

Hello, new to Air Table but experienced with programming and sheets etc., I am just trying to just show a date field on a form and have it default to the current date, i was reading a bunch of different answers but it is not very clear how to do this.  I looked into prefill_DATE=today() on URL, and also looked into automation but I didn't see how to do this.  Also looked into formula field but I don't see an option for formula field.Also want to be able to save date and time into a database field, how is this possible? Someone mentioned adding a Creation Time field but that didn't work either...

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 fields.I had this working nicely in E

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, for some reason ALL the values are added as 1's, I repeat ALL the values are added as 1's. Even if the value is 0 (zero) in Airtable when it gets to the Google sheet it becomes 1.  I have a lot of other formulas which do not have the automation issue. 

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 information but I can't figure out how to do it.Any help is welcome. Thanks for your help

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 costs) so really, the only reason to make us change it all up in two weeks now is, I guess, spite?Airtable really did just tell us all to get fked.  There isn’t a whole

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.selectRecordsAsync({fields: ['Amount']});let runningTotal = 0;for (let record of result.records) {// change the field names here to adapt this script to your baserunningTotal += record.getCellValue('Amount');await table.updateRecordAsync(record, {'Running total': runningTotal,});}Has anyone used this? It's not working for me.  

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.  I have the lock code associate with a given rental property, the reservation

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 Facilities - Supplying Items". The field it is pulling from is multiple select, don't know if that matters.

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 appreciated.

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-zkXqbZZWe62Kj4to6smie7OgNoCYtR1/R2GSVwMl15JtAUZwwkiFZtojS7v9k5mNoXtyjNzTPe8filename Screen Shot 2023-09-04 at 1.28.37 PM.pngsize 1823578type image/pngthumbnailsCollectionCover URL: https://dl.airtable.com/.attachments/17e18deee342553e8fc829a4c1bd564b/10bf5441/ScreenShot2023-09-04at1.28.37PM.pngThe COVER URL was all I needed and using Make I was able to create an HTML email including the banner using the Cover

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