Formulas

So I have a paragraph, from which I would like to extract a few sentences via formula. The reason for this is that I need to copy the sentences in the middle and insert them into other pieces of text. I need to do this a lot of times, for text in several languages I do not read, which makes it annoying to do visually.  While the number of characters will vary a lot language to language, the number of sentences is the same, so I had hoped to use periods and REGEX to isolate the sentences I need. Basically I have: > This is the first sentence. Here’s another sentence. Beginning of the part I need. I also need this. Here’s a sentence I don’t need. <!--more--> I can use Regex and LEN to get rid of the <!--more-->,  but it seems like going further than that is beyond my current skill. Any ideas?

Problem SummaryI'm building a WhatsApp AI concierge system using n8n that sends data to Airtable, but I'm having issues with field expressions not being processed correctly.Current SetupTool: n8n workflow Integration: WhatsApp → n8n → Claude AI → Airtable Airtable Base: "My Premium Concierge - Master Database" Table: "WhatsApp Automation"The IssueWhen I use expressions in my Airtable node fields, they appear as literal text instead of processed values:What I'm trying to capture:Phone Number: Real customer phone number Client Name: Real customer name Notes: AI response from ClaudeWhat I'm seeing in Airtable:Phone Number: $node["Code"].json["customerPhone"] (literal text) Client Name: $node["Code"].json["customerName"] (literal text) Notes: $node["HTTP Request"].json["content"][0]["text"] (literal text) Phone Number: 34630158432 (actual number) Client Name: John Smith (actual name) Notes: Hello! This is Lincoln Silva... (actual AI response)What I've Tried✅ Fixed values work: When I use s

I think this formula IF({Last Deployment} = 'MM/DD/YY', 'MM/DD/YY', "*") says: IF (the value of the field Last Deployment is a date, show the date, otherwise pop in an asterisk (instead of #ERROR!)) But what I’m getting now is either an  * or #ERROR! - pretty much the opposite of what I am trying to accomplish. Help!

I have a base to manage my vendor payments, and a table that warehouses the vendors’ contracts and payment terms. In that contract table, I’d like to make a formula field that returns the next date when I should expect an invoice, depending on the payment terms (in this table, that is a single-select field titled “Invoice Schedule”). One of the “Invoice Schedule” options is “monthly,” meaning the formula field I am trying to make should just return the last day of the month (preferably month-over-month, as several contracts are long term). Here’s how I’ve set up that part of the formula - AT accepts the formula, but returns only blank values. I think that I’m misusing or misunderstanding SWITCH() - wondering if anybody can advise on what I’m doing incorrectly here? Also definitely feels like I’ve overcomplicated this solution but was the best I could figure out, so super open to more elegant solves if you’ve got them! IF( {Invoice Schedule} = "monthly", SWITCH( MONTH(TODAY()),

Hi, I’m trying to roundup the following formula: ({GROUP PRICE}+({EXTRAS}*3))/3Where GROUP PRICE is the pricing for a group to which I add extras * by number of guests and then divide by 3 to obtain a price per person. The formula is working and in this case I obtain a pricing of 101.667€. I’m trying to roundup this number to 102€.Thanks

Hello, I have an airtable app that supports our HR and Finance teams.  As part of the build, I am looking to reference the employee ‘start date’ and ‘end date’ to determine how many days, or workdays that employee worked in a specified month (assume each month starts on the 1st and ends on the last day 30/31) Example fields:Start date: 01-10-25End date: 01-25-25Month Start: 01-01-25Month End: 01-31-25 The month start and ends fields could be done without referencing the fields if needed and handled within the calc using datetime parse/datetimeformat or the like. In many examples the end date of the employee will be after the month end but have kept the duration short for this example.In theory, a simple formula like the below should work, but I’ve tried so many different options of doing this and the formulas keep returning a 0 or error. The fields above are all calculated as date fields.WORKDAY_DIFF( MAX({Month Start}, {Start date}), MIN({Month End}, {End date}))I’d expect a working f

I’m trying to use the SUBSTITUTE function to get rid of emojis so I can have a “clean” version of some fields my client want to have as downloadable in .CSV I need to have a formula with a bunch of substiutions, but I started from the very first and I get nothing but errors, formula atm looks like this:SUBSTITUTE({Respuesta Pregunta 1},'✅','')I realised the error has something to do with the type of field of {Respuesta Pregunta 1} as it is a lookup field, just for testing I created a single text field next to it, copy the data of the lookups to the new text field, applied the formula to the text field, and it works. So I’m suspecting SUBSTITUTE doesn’t work with lookups? Any ideas to work this out?

Hello All,In one of the columns in my Airtable, I would like add my Amazon affiliate link to the Amazon Product URLs so when the product is integrated to my website, selection of this product will have my Amazon tag in the URL. I am having trouble with a formula to create the new URL. Any suggestions? Thank you!

I’m attempting to set up air table to distribute parents possessions between 10 siblings Scenario:  If there are 100 items and 10 lots of 10 items each.  Each sibling wishes to receive a certain decoy, a certain lamp, and a certain painting. Sibling one rates, only three items, the decoy, the lamp and the painting. Sibling 2 enters a rating for virtually every item on the lists Sibling three enters a rating for 30 different items on various lists that she desires, leaving the rest blank.  Under this scenario, my understanding of the program is that sibling one is almost certain to receive at least one of the three items she covets.  Sibling 2 is highly unlikely to receive any of the three items. Sibling 3 has a middling chance of receiving one of those three items. Am I correct?   

Sometimes we have URLs that include "?" for example www.mytravelsite.com/deals?destination=florida. Its best practise when adding UTMs that if a url already includes a "?" then the UTM should start with "&" instead. The below is the expected outcome of this.www.mytravelsite.com/deals?destination=florida&utm_source=Offsite_P195&utm_medium=Patnerships_Video&utm_campaign=VisitFlorida_Sep-Oct2023_YouTubeThis is the formula i have attempted to use.IF(FIND("?", {Landing Page (from Campaign)}), CONCATENATE({Landing Page (from Campaign)},"&utm_source=",{Source (from Product)},"&utm_medium=",{Medium (from Product)},"&utm_campaign=",Name), CONCATENATE({Landing Page (from Campaign)},"?utm_source=",{Source (from Product)},"&utm_medium=",{Medium (from Product)},"&utm_campaign=",Name))This is what its returning, which is incorrect. www.mytravelsite.co

Hi guys, I’m trying to find a way to insert a formula that calculates the expiration date of leases based on the commencement date and the number of months that the contract is for. So far, I have this: DATEADD({Commencement}, {Term (mos)}, ‘months’) This calculates the expiration date almost perfectly, but I need to find a way to take one day off of the formula. A 12 month lease starting on 03/01/21 would return 03/01/22, but the expiration would actually be the last day of February, not the first day of March, if that makes sense. How can I get the formula to subtract one day from the result? Thank you!

Hi,   I’m used to work with spreadsheets where you can refer to a cell in a previous row.And I know spreadsheets (data in rows) and database (data in records) can’t be compared.But I would like to build a project where I can see the evolution of a certain value.Here you have a simple table where the first column (datum = Dutch for date) is chronologically ordered and each value is unique.In the third column, I entered the difference between the current status and the status of the “previous month”  manually to show what I want.  Is there any possibility to get this done in Airtable?  With formulas in another extra table?

I need a column to calculate the total days- formula being ENDDATE minus STARTDATE plus 1.  Any suggestions?  I can get the datetime_diff, but that is days between not total days.Thank you!! 

[URGENT HELP] Error 422 in Make.com + Airtable – “Invalid Formula” in Search Records even with correct fields📌 The problemI'm constantly getting this error: pgsqlCopiarEditarRuntimeError [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text. Even though all the Airtable field names are correct, Make.com keeps rejecting the formula.🧩 Airtable Table Details: Table Name: Table 1 Fields: Nome do Cliente (Single line text) Produto Qtd Valor do produto Valor Total Data da Entrega ✅ Confirmed: Date with time format ❌ Formulas tested (all returned 422 errors in Make): plaintextCopiarEditarAND( {Nome do Cliente} != "", IS_AFTER({Data da Entrega}, DATEADD(TODAY(), -5, 'days')) ) Also tried with IS_BEFORE, simplified formulas, and also using "ok" in a formula field with static text — still getting the error.✅ Formula that worked in a previous database: plaintextCopiarEditarAND( {Cliente} != "", IS_AFTER({Entrega}, DATE

HelpI have a formula adding 17 days from a date in another column. It is adding the time. How do I eliminate the time?ALSO, is there possible logic to add to move the date forward if it falls on a weekend?Thank you for any help provided! 

J’aimerais créer un champ dans une table qui permettrait de calculer le nombre de rdv réalisés pour chaque personne à partir des rdv portés sur un calendrier

I have a multiple select field called “Weaknesses” in which a client can select different areas they’re struggling in with the language they’re learning. I’d love a formula that takes their responses and transform it to 1 word weaknesses and puts them together in a grammatically correct sentence. So... If they say “I can't stick to goals”, then I want the return to be “Goals” in the formula field. If they say "I can't stick to goals" and "I'm not great at speaking" it should return "Goals and Speaking." If they say "I can't stick to goals", "My habits and routines could be better", and "I'm not great at speaking" it should return "Goals, Habits and Speaking."What I can get it to return is a response of “Goals, Habits, Speaking,”I’m starting to think that’s not possible, and just want to see if maybe I’m wrong. Here’s what I have for a formula currently. REGEX_REPLACE( REGEX_REPLACE( TRIM( IF(FIND("I can't stick to goals", ARRAYJOIN({Weaknesses}, ",")), "Goals, ", "") &

Hi guys!I'm trying to convert a string into a slug, and I need to replace polish diacritics with standard Latin characters. Should I use the regex_replace() formula? If yes, which expression should I pick in this case?

Hi All,I’m relatively new to Airtable and I’m struggling to figure out how to structure the formula to do what I want. I know roughly how to do it in Excel, but really struggling to translate how it’d work in Excel to Airtable. There are multiple things I need the one formula to do, any help on how to structure one or more parts of the formula would be appreciated.Formula is in my “Modules” tab, but looking up data in my “Tasks” tab “Module name” field in both tabs is linked with a “Link records” type of field in the Tasks tab Each Module has multiple tasks (they’re sequential, with no more than 1 “In Progress” at a time) and I’m wanting the Modules tab to have a field that displays what Task is currently “In Progress” I also want it to state “Not started” if all the Tasks associated with that Module are “Not Started” or “Complete” if they’re all set to “Complete”The structures I’ve tried that are similar to Excel keep saying that the formula has issues and can’t be saved so I’m gettin

I have a date, some weeks, and some holidays. I need to add the weeks to my date and exclude all holidays and weekends. I’ve used the WORKDAY function. However, I’m a little uncertain how to treat my weeks. Should I multiply them by 5 (since there are 5 working days in a week) or by 7 (since there are 7 days in a week, and the function will filter out all the weekends)?    

Hi, I have a Table "Main" that is Linked to table "Agenda".Being in Main, on a record, lets say “33” I want a button to view agenda filtered by ID (Both table have the ID field, in this case “33”).Any idea to turn aroud this?Im new to Airtable. Thank you-----------------------------------------------Example:Table Main:-------------------ID Name 33 Marta34 Martin35 JohnTable Agenda:-------------------------ID  Done33 Mailed45 Called46 Mailed33 Zoom87 VisitedResult Expected------------------------------33 Mailed33 Zoom  

I want to sort 9 fields of numbers on a single row and order them into 9 new fields on the same row that show the numbers from lowest to highest. If the old fields are labeled #1-#9 and the new fields are labeled A,B,C,D,E,F,G,H,I, then I want to search #1-9, find the lowest, and put it in A, then search #1-9 for the next lowest and put it in B and so on.I’m not sure if I need to write an automation with code, a script, or what, but the base features of Airtable do not seem to be able to handle this.

I have two multiple select fields that I am joining into one field. The items are showing in reverse order. is there a way to show them in the order in which they are entered in the multiple select field?

Hi everyone,I'm encountering a data integrity issue when transferring a large set of records from Google Sheets into Airtable, and I’d really appreciate any advice. **Scenario:**  I maintain an a list in Google Sheets. The "Source URL" column contains rich-text hyperlinks — for example, display text like `Narrative Enneagram Resources` linking to `https://www.narrativeenneagram.org/resources/`.**Issue:**  When I click the link, it shows an error because the URL has become http://narrative%20enneagram%20resources/ instead of the correct URL When I try to bring this data into Airtable, the URLs get misconverted. No matter the method I use:- **Copy-pasting** a multi-row range directly into a URL field,  - **Importing** via _Add base ▸ Import data ▸ Google Sheets_, or  - **Exporting as CSV** and importing into Airtable,   **Question:**  Is there any way to preserve the original hyperlinks (i.e., the actual `href` URLs)? Thank you so much for any help! 

I am using Documint to generate PDF from data stored in Airtable (via link). It was working without problems for more that a year but I recently have trobles to build PDF on first try. Still some data are missing. I checked with documint and all is fine on their site. While the situation is getting worse, I am adding one more field to generated document to dump all data received from Airtable - so I see, that lot of data is missing so Documint has not enough inputs to generate PDF. It usually take several tries to get what I need, but tonight even 50 is not enought. I asked Airtable support on 15Jun but no reply  - still (OK 3 emails that they are busy, but no solution). Is there any way to make Airtable properly prepare all data and send it to Documint? What is the problem after one year?