Formulas

Hello, I automatically create invoices based on the data in my database. Ideally, each line comes with an invoice number that I have to add manually based on the previous line. Is there a function that allows you to increment this data and add it automatically at the creation of each new line? I would like to reduce the number of manipulations and the risk of possible errors. Ex: Line 1: Invoice number: 207. Line 2 : Invoice number: 208 and so on and so forth. Also, some data is recurrent, such as the Logo. And I wanted to know if instead of manually copying and pasting each time, there was a function to add it each time? Thanks !

In my base, I have a column called Authors. I would like to make a formula so if the Authors field has “Hoch” in it, it will say Author, and if it doesn’t, it will say Not Author. How do I do this?

Hi! I have 2 tables - one with a long list of individual clients, and another listing “teams”, which the clients belong to. The client table has 2 fields: “Team” & “meal preference”. I want to summarise the meal preference data in the Team table table, organised to show the total number of each meal preference for each team. I have set up a pivot table block, which does summarise this, but I don’t know how I can pul this info into the “Team” table. Any assistance greatly appreciated!

Hey all, Just getting to play around with the new button field (it’s awesome) and had a quick question - any idea if it’s possible pull multiple emails into the “To” section of the email? To explain further, I have two 2 tables within a base: 1 is locations and 1 is contacts. On the locations table, each location has multiple contacts linked it. I’m looking to build a button that when clicked, would include all of the contacts associated to that location into the “To” section of an email. Appreciate any and all help! Noah

HI all, I am trying to use a base to “build” and format HTML that can be copy/pasted into an E-bay description page. This would then save me tons of time and give me unity in my listings. I can get output as simple text, but line breaks, bold font and even color formatting eludes me. Here is a the current “formula” , I would like (ex) TITLE to be 14pt and BOLD when deposited in the listing (see bottom) TRIM(TITLE) &"-" &GUAGE &"-" &COLORQLTY &" " &COLOR &"-" &TRT &“min " &DESCRIP &” Unfortunately if the film does not have a synopsis in the can. Please search the web. " &VS &" V.S. " &STORAGE &" " &CONDITIONOLD &" Overall condition-" &CONDNOTE & Wear & " wear " & IF({Teach Guide}=1,“Comes with Teacher’s guide”," " ) &" I

I have a field with a value "feather29sum"cxa. I need to extract the feather29sum only and ignore everything else. Can someone please help with this formula?

Hi there! I’m trying to write a formula that will pull JUST the image url into my column. Not all of this add’l info:

Hi everyone, we are building a little CRM inside Airtable and I am trying to do something that seems to be almost impossible. Perhaps I am just not seeing it. So, would love some help to get this going: Setup: One table called Customers Another table called “Health Score Reviews” The first table is self-explanatory. The second one, has a series os “log entries” for every time someone from our Customer Success team interacts with a customer. In that interaction, they can add a SCORE to the interaction from 1 to 3. Objective: We want to show the LATEST Health Score for that customer in the Customers table. The first part I was able to do, which was to retrieve the max(id) for the Customer Health entries and pul that number to the Customers table. The problem is that I want to Lookup in another column what was the Score that was

Is it possible to only download a group of records and not the entire record table?

Is there a way to count the number of times a duplicate name appears in one table and display that number in another table? For example, Minnie Mouse’s name appears 3 times in the “Billing” table and I want to output the number 3 under a column for Minnie Mouse in the “Child” table. The way my data is set up is I have 2 tables, one for “Child” and another for “Billing”. The “Billing” table keeps track of all the client with the months we billed them for, their name will appear multiple times corresponding to the month he/she was billed. This duplication is how our biller kept track of the data, by having a Jan, Feb, Mar, etc tabs in excel and the client’s name being inputted in the corresponding month tab. The “Child” table has a different set of data that can’t be combined with “Billing”

Hi everyone. I’m trying to extract a string that occurs between the same left string, but the right string has 2 possibilities The bolded string is what I’d like to extract VAR. 1 - between > and > Industry > Banking & Finance > Trading (1.0) VAR. 2 - between > and ( Industry > Banking & Finance (1.0) Thanks a ton for your help. Subir

I’ve a linked field that I want to compare to a lookup field. If any of the linked records in the linked field appears in the Lookup field I want to generate an error of some kind. Linked field: Wishlist (Internal) (link to toy table) Lookup field: Toys (lookup toy table) Formula that I used: IF(FIND({Wishlist (Internal)},{Toys})<2, “ :white_check_mark: Wishlist updated​:white_check_mark:”, “ :stop_sign: Wishlist has given toys​:stop_sign:”) It works if there’s only 1 linked record in the “Wishlist (Internal)” But it doesn’t work for multiple records. Is there any other way to do this?

Hi there, I wanted to create a formula for a field with 15 variables. See table below. Basically, is % complete + status is what’s on the corresponding column, it updates the “new stat” field. Tried using this, but wonder if there’s a more efficient way than using ‘IF’ statement 15 times. IF(AND({% Complete}=0, Stat=‘red’), ‘red’, IF(AND({% Complete}=0,Stat=‘white’), ‘white’))

Hi! A while ago I asked for help to concatenate several values together (kids’ ages) and the following was suggested by Justin_Barrett, which I am using now, thank you Justin. SUBSTITUTE( TRIM({K1 age} & IF({K2 age}, " " & {K2 age}) & IF({K3 age}, " " & {K3 age}) & IF({K4 age}, " " & {K4 age}) & IF({K5 age}, " " & {K5 age})) , " ", ", " ) However, it doesn’t seem to allow for a “0” value. Can someone advise why and/or how to modify this formula to allow for the “0” value?

We are using a form to accept and manage participant registrations for various groups (we call them Circles) we are offering (and managing through Airtable). The participant registration feeds a Participant table to collect all registrants. Each registrant can select multiple groups. The groups are provided on and linked to another table on the base. Each group has a different maximum number of people that they can accept in their group. I’d like to create a formula to use that when the maximum number of registrants for that group has been met, it will automatically move the participant record from the accepted participant record type (column) in the Circles table (our group table) to a waitlist record type (column) for that group. Here’s the form --> https://airtable.com/shrVhQh9RC40kuqhj

I have an attachement link that has a bunch of attachments but every now and then one of them looks like the below, but works when clicked. It seems to usually be .pdf’s. Any way to avoid this?

I need some help editing my original formula which is: IF(IS_BEFORE({Actual Site Walk}, TODAY()), “ :white_check_mark: Done​:white_check_mark:”,IF(IS_BEFORE({Forecasted Site Walk}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,“ :running_man: In-progress​:running_man:”)) I’d like to add/change the formula to show “DUE SOON” for dates in the Forecasted Site Walk field that are within the next 14 days, but keep the rest as well. How do I do that? Thanks!

I am using the AND() formula to apply multiple filters through filterByFormula query in the API via Adalo. Each formula within the AND function works independently, but when combined, neither works. There is a discussion open on the Adalo forum with details: Adalo – 22 Jul 20 Filter (airtable populated) list by search term? @bgschust Try to change from double quotes “ to s

Hello! I am creating a workflow with 12 tasks for a client tour. 4 tasks are due 30 days before the tour, 4 tasks are due 7 days before the tour and 4 tasks are due 7 days after the tour. Each task is a checkbox field. I’d like to create a conditional format that shows the record is “red” if any of tasks go past their due date without being checked “complete”. Here is how I can do it: Create a new field called “All On Time?” Use a long IF statement with OR (check all 12 tasks) and AND (box is unchecked and deadline has passed) to check all criteria against their due date If any of the 12 tasks are not done on time, the field will display “Late”, otherwise it will display nothing Then I will use the Color formatting to make the record red if the new field says “Late”. If anyone has a more elegant solution, I’d love to hear it! Thanks, Ch

Hi everyone! I have been working on a general Airtable for a huge team that needs the same field to show a value called “what”. But every team calculates that value in a different way so I did a Nested IF formula that almost worked for every team but didn’t work for Content Demand Team :cry: Here is the formula I did: IF(Department="Illustration/Logos",{What}, IF(Department="Content Publishing", {What}, IF(Department="Mockups",{What}, IF(Department="Stock Photo", {What}, IF(Department="Content Operations", {What}, IF(Department="Mockups External Content",{What}, IF(Department="Logos External Content",{What}, IF(Department="Motion Graphics", IF({Motion To Publish}=1,({%Project}+{%Q&A}),(70+{%Q&A})), IF(Department="Graphic Design", IF(AND({Did SC}=1,{Did Assets}=1), AVERAGE({Assets Performance %}, {SC Performance %}), IF(AND({Did SC}=1,{Did Assets}=0),{SC Performance %}, IF(AND({Did SC}=0,{Did Assets}=1),{Assets Performance %}, IF(Depa

I’m trying to send multi-line text through an airtable button via webhook to zapier. Zapier is picking up the text as a single line with no line breaks. How would I send multi line text? The text that is being sent across is of inconsistent length, so some records will longer and have more lines than others. Any help greatly appreciated!

Hi, I’m working on a button field that will allow one of our users to send emails to our customers. Within this table, I have a field containing customer specific URLs that we want to use within the email. My question is whether there is a way to map the hyperlink to text within the email I am formatting using the button field. I’d rather not send our customers the entire URL, it would be nice to show them something like a hyperlinked “Click Here” or something along those lines. Hopefully this is enough to go on. Thank you for all the help.

I.m new to Airtable. I’m trying to concatenate the nickname if the field isn’t empty or the first name if no nick name then a space then the last name. It puts NaN in the field. Here is my code in a formula field: CONCATENATE(IF(nickname="",First,nickname)+" "+Last)

Hello! I am hoping someone can help me create a formula that will calculate the date on which a child turns 7 years old. I have listed their birthday and have figured out how to calculate the child’s age today, but am unsure of how to figure this other data point I need. What follows is a screenshot of the columns. Thank you so very much for your help! ScreenshotforAirtableQuestion|448x142

Hello! I am a programming coordinator at a library, managing programming for 3 different branches with multiple different rooms. I’m trying to create a formula to pull from a “room” field into another that will formulate the “address” for the building the room is in. Example: Room X, Room Y, and Z should put Address 1 in the formula column, but Room A and B are at Address 2, Room C is at Address 3. I am able to use an IF formula to get it to work for 1 room, but anytime I try and add others I get errors. Here’s what I am working with so far: IF(Room = “HPL Program Room”, “Address 1”, “Address 2”) This will give me Address 1 for the “HPL Program Room” records, and address 2 for anything that is not “HPL Program Room.” If I try adding other conditions, I get errors. How do I add the other circumstances to the same string/formula field?