Solved

So I'm tracking vehicles in my base(s), and I typically use a formula for my primary field for ease of search for my coworkers:  CONCATENATE("Branch #"," ",Location," ",Year," ",Make," ",Model," ",VIN) Ends up yielding something like Branch #123 2022 Ford F-150 1FTCR15X0TTA01050 This works really well for us, because we use that primary field in a wide variety of forms and other linked bases, so if someone doesn't know their vin, they can search by branch and narrow it down, etc. What I'm trying to get my head around is how to (if possible) reference a single selects selection in an IF statement re: that primary field?  An order to request a new vehicle adds a new line to the base, and as we process the order at that point we add in make, year, model, etc.  Until we do that the concatenate formula just returns "Branch #123" because the other fields are blank so its hard for folks to track their orders and see any inf

My base is a table copied from and synced to another source base. Is there a way to break the sync with the source base but still retain the data so that I may edit the table?

Hi there, I am so ashamed to ask this but I could not figure this one out by myself. I have 2 simple text values and an autonumber. I would like to create a formula where i can have these information but not completely. Ex:  1st vlaue is JOHN Second value is DOE and autonumber 333I would like to have  the result 33JODO Thank you for your help. 

Hi,I'm terrible at the formula stuff, but basically I have a Publish Date in my Airtable view for when a piece of content should be published. I want to add the Day of Week as well so we can clear see which post is which day, as well as the actual date (as some gets scheduled a bit further in advance)The formula I'm using to display the day is:  DATETIME_FORMAT({Publish Date},'dddd')All I need to do is display nothing if there is no publish date set

I have a column with the title 'Country', and I am trying to add a new formula column which identifies the Country and creates an entry for the Region automatically. I can get the first IF function to select one region, but when I try to add the second, it fails. Here is what I have for 3 (of the shorter regions) of the 8:IF(REGEX_MATCH({Country}&"", "Belize|Costa Rica|El Salvador|Guatemala|Honduras|Nicaragua|Panama"),"Central America")IF(REGEX_MATCH({Country}&"", "Canada|Greenland|Mexico|Saint Pierre and Miquelon|United States"),"North America")IF(REGEX_MATCH({Country}&"", "Argentina|Bolivia|Brazil|Chile|Colombia|Ecuador|Falkland Islands|French Guiana|Guyana|Paraguay|Peru|Suriname|Uruguay|Venezuela"),"South America")Thank you.

Hi everyone,I have an automation here that works perfectly fine when I add a new dataset into my grid view. Once I switch to a form to add a new dataset the automation doesn't work properly. The automation I duplicated starts but the value is wrong. With a single automation nothing at all happens.Not sure what it is. Maybe the trigger "when record is updated" vs "when record is created". I duplicated everything tried to keep everything the same, which is not really possible. There are some minor differences.Here is what I have:Trigger (when record is updated)Action (update record)  Here is the other automation the creates a wrong value:Trigger (when a record is created)Action (update record)

Hello! I am working with a formula that is computing a rate for each area that is being updated from a submissions tab; however, not every area has data yet, so Airtable assumes 0. This means that in the future records we get the output NaN as we are dividing by 0 at the moment. Is there a function or if statement that can be used to detect if there’s and NaN output, and if so, set it to 0? Thank you!

Is there a way to update manually a "Last modified by" or "Last modified time" field?We use a field to check who was the last person to update an ID field. But we sometime have to bulk update these fields for cleaning or managing the database and the "last modified by" is now entirely set to the creator/admin who made the update.- Is there a way to update manually these fields?- Is there an existing extension for this? or a script ?- Maybe there is a way to "impersonate" a user in order to set the needed values to those fields? (I tried this with the interface functionnality to see interface as another user, it did not work)Thank you very much !

I am trying to make a very simply patch request using an HTTP module in Make.com. However, I'm getting this and can't work out why: URLhttps://api.airtable.com/v0/appzYqJSdNkXvYunc/2023/recV9bgS8TBB1msd7Request content{ "fields": { "PDF Requested": true }, "typecast": true } ​Request compressed contentfalseMethodpatchHeadersArray1CollectionNameAuthorizationValueBearer keyoffNKf3BVBTr7w2CollectionNameContent-TypeValueapplication/jsonTimeoutemptyUse Mutual TLSfalsePasswordemptyUser nameemptyBody typerawContent typeapplication/jsonSerialize URLfalseShare cookies with other HTTP modulesfalseParse responsefalseFollow redirecttrueDisable serialization of multiple same query string keys as arraysfalseFollow all redirectfalseReject connections that are using unverified (self-signed) certificatestrueOUTPUT Bundle 1CollectionStatus code422HeadersArrayCookie headersArray1AWSALB=HA7u9TAS1egeTJzD1uCdgufpkjhpW35UNtWpX1KTXq9u9oPC38wYlXSfBC3Mg01aHUYv4vtXUve1qdnCPo31ECjur8aMfS0suXN21pwZR97jcg

Hi community,I have two table, the first one is a database synchronised with many other, fulfilled directly by stores themself and it is creating a product list. The second table is contact information about the stores.I would like to link phone, number and adress regarding the store concerned.In my screenshots, green circled data are synchronised, and the red circled one are thoose I want to import from the table "ENTREPRISE INFOS".So in "BDD ARTICLE" table, if Sync Source is "Magasin 1", I want to display information regarding "Magasin 1" in my "ENTREPRISE INFOS" table.I didn't find any way to do it, thanks a lot for your help 🙂

I have a warning that my file is over the limit of 1,000 records per base, but it only has 531 records.The warning says it has 1145 records. There is no filter applied, it only has 531 records!Nothing else is over the limit.

Hello! I'm slowly learning how to use date formulas, but I have hit a wall in my ability to troubleshoot.I have two date formulas causing me trouble.1) My Rush Due Date is displaying #ERROR! when "Rush" checkbox is not checked.DATETIME_FORMAT(IF(Rush, WORKDAY(Created, 4, '2023-11-11, 2023-12-25, 2024-01-01, 2024-02-19, 2024-03-29, 2024-05-20'), ""), 'LL')2) My "Time Since Ready for Pickup" formula is displaying NaN when a row is not yet "Ready for Pickup"IF(Completed, "Completed", DATETIME_DIFF( NOW(),{Ready for Pickup Timestamp}, 'days'))Are there any heros out there who can help me out?Thank you so much in advance!Devon

Hi everyone, I searched through the community posts but could not find anything.Using a formula I created custom URL for every person in our company that will allow prefills in a form.CONCATENATE('https://airtable.com/appxxxx','?prefill_Your Name=',Name)for example 'https://airtable.com/appxxxx','?prefill_Your Name=',John Doe)Problem is that there are now blanks and therefore only the first part of link is recognised as such. I know that I can use %20 is used in the final URL. But this does not make the URL in my dataset clickableAnyone an idea what I would need to do? Thanks for your help

On table A, I've added a linked record field to table B. On table A, I can add lookup fields from the linked record on table B.But on table B, I cannot add lookup fields:> No available sources to look up. Add a lookup source, then try to configure your lookup again.I created a new linked record field with the same configuration on table A and the lookup works both way. Is there a way to fix my original field to work both way too? 

Hello, I'm really enjoying building for the first time in Airtable but need some help creating a script (if that's the best approach).I have a form where users will put in 3 comma separated words to describe the Niche they work in.I want to turn this column into tags, so that I can group records by common Niche.My understanding is that I need to write a script to go inside an automation that fires when that field is not empty on a new record (when the form is filled in). And takes the text, parses it based on the commas and then adds it to my Tags column which is a multi-select field.I've tried using claude.ai and chatgpt to write the script portion but they're failing! I'm confident a real human can help me!cheersjonny

Hi (newbie here),Can you do a rollup on a Lookup field in a different grid?I have a table of employees.  There is a table of Trips where we look up the employees from the employee table.  Then I have a Departures Table that pulls in the Employee information from the Trips table. Now I would like to do a count(rollup) of the number of departures each employee has.I am having problems figure out how do this.  Any help would be appreciated.

Hello,My sister operates a bakery from her home, and I want to make things easier for her by creating a system in Airtable where she can take orders for her products.As a bonus I'd like to be able to track repeat orders from customers as a way to determine customer preferences, habits, trends, etc.There are a few problems I'm finding with this. Airtable has no way for customers to "make an account" so to speak. I'm inclined to create a table for customers, but...Customers would need to complete a separate form if they're a new customer, then come back to the order form, which feels cumbersome.For each customer that already exists in the base, Airtable will reveal all of the names in the customer table whenever a returning customer begins to search for their name, which just doesn't sit right.We could simply request name and phone number each time, but I'm not sure if that will allow me to combine those records based on phone number in order to be able to assess trends based on those or

Hi All,I have an automation issue coming from a formula field.The lookup field is coming from Tasks table, and the regions are repetitive, so i created a formula to make it as a text and im hoping the automation will take the Regions Text to a normal editable field 'TASKS - Regions', but it updates it with a blank value in the end (the blue circle in the end). Im not sure why, but if someone can help me with this. the formula im using is:CONCATENATE(IF(FIND("KSA", {Regions (from Task Tracker)}), "KSA, "),IF(FIND("GCC", {Regions (from Task Tracker)}), "GCC, "),IF(FIND("Levant", {Regions (from Task Tracker)}), "Levant, "),IF(FIND("EGY", {Regions (from Task Tracker)}), "EGY, "),IF(FIND("WW", {Regions (from Task Tracker)}), "WW, "),IF(FIND("NA", {Regions (from Task Tracker)}), "NA, ")) Not sure if there is something wrong with the formula or its the automation, which is when the lookup field is updated, take the Regions text and update it in 'TASKS - Regions' field. Thank yo

Hi, I would like to know if there is a maximum number of automation that a base can have or if it can have infinite automations?  Thank you 😊

Hi there, I’m a long term user of Trello and new to Airtable. Trello had a feature where you could forward emails to your board. I would have a to-do list board and whenever I got a request emailed to me I could just forward it to the board and it would create a to-do item for me. Does this function exist within Airtable? Thanks for your help.

I am trying to incorporate a formula column which looks for entries which may include swear words, but I cant seem to get this formula to work. Here is a snippet (I've taken out a lot of the middle which is just 3230 different swear words) but the beginning and end are there. Any ideas? IF((OR(SEARCH(“2 girls 1 cup”, ARRAYJOIN({Lower})) > 0, SEARCH(“2g1c”, ARRAYJOIN({Lower})) > 0, SEARCH(“4r5e”, ARRAYJOIN({Lower})) > 0, SEARCH(“5h1t”, ARRAYJOIN({Lower})) > 0, SEARCH(“5hit”, ARRAYJOIN({Lower})) > 0, SEARCH(“a fanabla”, ARRAYJOIN({Lower})) > 0, SEARCH(“a pecorina”, ARRAYJOIN({Lower})) > 0, SEARCH(“a tomar por culo”, ARRAYJOIN({Lower})) > 0, SEARCH(“a tomar por saco”, ARRAYJOIN({Lower})) > 0, SEARCH(“a$$”, ARRAYJOIN({Lowe

Hi Community,I'm trying to purchase a Teams account but I am part of an entity that is not allowed to pay taxes. The form I'm sent to has a space for a credit card and says I'll be charged "applicable taxes". I'm not actually sure what happens when I hit 'submit' after entering a credit card, is it charged then or is there some other page I get sent to? I expect the former.Is there a way to pay for Airtable without paying taxes?

I am looking to remove the comma separating the two lists. Here is a picture to show an example.    Is there a way to do this?Thanks!

Hello everyone,Trying to come up with a formula using Chat GPT (and some tweaking) to create a formula field type that displays a subscription's (record) amount in a cell based on budget status and the payment schedule.I want to create a formula that checks the following conditions:The Payment Schedule is "Annually."And one of the following is met:a. Budget Status is "Projected" and Renewal Date is within the specified range.b. Budget Status is "Actual" and Purchase Date is within the specified range.If these 2 conditions are met, it displays the {Subscription Amount}. If none of the conditions are met, it will display "Conditions not met".Here's the code:  IF( AND( {Payment Schedule} = "Annually", OR( AND( {Budget Status} = "Projected", {Renewal Date} > DATETIME_PARSE("2023-01-01"), {Renewal Date} < DATETIME_PARSE("2023-02-01") ), AND( {Budget Status}

In my "CRM" database, I am building out a reporting table that gets rollups of IDs from other tables (i.e. interactions, etc) and am trying to get one array of IDs that I can count to determine the number of unique IDsInteractions TableOne to Many Contacts, lookup field of Contact Record IDs from "Contacts" TableProjects TableOne to Many Contacts, Lookup Field of Contact Record IDs from "Contacts" TableReports TableRollup of Contact IDs from Projects, Rollup of Contact IDs from InteractionsMy formula below doesn't get all the IDs. I don't know if maybe there's some nesting going on. Any suggestions for combining these arrays? properly? COUNTA(ARRAYUNIQUE(ARRAYFLATTEN({Interaction Contact IDs}, {Project Contact IDs}))) Each of my rollups in Reports has this formula ARRAYUNIQUE(ARRAYFLATTEN(values))