Solved

Hello, this is more like a documentation rather than a question, for those who might find it helpful and have similar use cases. If there are errors in the formula, please point them out. I have an attachment field called Picture. The number of pictures I’ll have in the attachment field can vary from 1 to 20. I want to grab the URL of each image, and put them into multiple columns. To do this, I’ll have to create 20 additional columns, one for each field. Note that this works as long as the image names don’t have any brackets in them. Hopefully, this won’t be a problem for many. The logic behind the formula is as follows: I have an attachment field called Picture I create a formula field called URL beside it, and the formula in it is {Picture}. This returns the URL of all the images in the Picture field, along with the image names. This is the field I’ll try to clean up and extract the individual image urls from First, I’ll use this formula to find the first “(” in the URL field: FI

I have a field that captures the URL for a webpage, but some URLs contain extra parameters after the .html part of the string. How can I remove anything after the .html for those records but not have a blank cell if the URL does not contain parameters after .html? I’d like a formula so that new field displays the URLs, just trimming the ?utm… part where needed: https://www.test.com/page3.html?utm_campaign=hc-sc https://www.test.com/page2.html I figured out the trimming part using this formula, but not how to display URLs where there is no ? LEFT({URL}, FIND("?", {URL}) -1) Thanks!

Hi everyone, I have this problems when i use GG docs to manage my data i create multiple choice option for drop down list in code like this So now when i import my GG Docs to Airtable all my optional choice are become 1 option How can i convert them into 1 single option in Airtable ? Like this one because i have tons of data , it will be consume hunreds of hours to do it manually. Thank you for reading my topic !

I have set up a number of Tasks within different Design Projects, but for some reason I can’t seem to move the Tasks up and down the list within each Design Project. I try to drag them from the left side of the Task row where the numbers are, but they don’t seem to move up or down the list. I would really like to order them in terms of priority… does anyone know what I am doing wrong, or why it is not working? Thanks in advance!

I have created an excel power query to retrieve data from airtable, I would need to expand this to be able to pull from multiple tables which is fine. My question is, has anyone encountered any issues with making multiple data pulls a day from airtable and getting IP address blocked, similar to what can happen with web scraping data?

I feel like this is simple but I’m missing something. I want 2 text fields joined with 4 blank spaces in between. Field1 & " " & Field2. It is trimming out 3 of the blank spaces on me. Is this possible?

I have an interesting problem. I need to create database-sort-friendly versions of names, where all definite and indefinite articles are dropped from the beginning of each name. I came up with this formula: IF(REGEX_MATCH(Name,'^THE'), SUBSTITUTE(Name, LEFT(Name, 4), ''), IF(REGEX_MATCH(Name, '^A'), SUBSTITUTE(Name, LEFT(Name, 2), ''), IF(REGEX_MATCH(Name, '^AN'), SUBSTITUTE(Name, LEFT(Name, 3), ''), Name ))) But it’s not working for names that start with “AN”. The formula is deleting all "AN"s. Why is it working with “THE” and “A”, but not with “AN”? What am I missing? I am at a loss. Thank you in advance!

Hi, can someone help me with a formula? This is what I have now: DATEADD(DATESTR(“2021-04-25”),-{Indoors Weeks Prior},‘week’) I want to add something so that if nothing is in the Indoors Weeks Prior column, it will show nothing. How do I do that? Also, currently, it displays DATE and then time. How can I omit the time part?

How can I write a formula where I could say "return true if value is 95000, or starts with 923, or …) I’d probably use a regex for this but airtable doesn’t allow that. What’s the next best thing?

Hi, I’ve got an ‘‘Email addresses’’ column in a base. When I send emails, I go on this base , copy the email addresses and paste them into the sender section of the composed email. This works well when I select email addresses that are in a continuous order in the column, however, I’m not able to select multiple fields for email addresses that aren’t in a continuous order. In an excel spreadsheet, you can select different cells by pressing ‘‘ctrl’’ on the keyboard. Is there a similar function on airtable or do I always need to copy/paste the emails one-by-one?

Hi, I’m using a function to check for how long people had registered with my group. It’s working like a charm. DATETIME_DIFF(TODAY(), {Position (since)}, 'days') On the screen below, you can see it works great. It’s all good. But when I change the view, the same cells aren’t updating… What am I missing? What do I need to do to see it updated alone? On the screen below, you can see it’s not displaying what was entered on the main view.

Hello everyone, I need help with my problem. I haven’t found a solution so far. I have an airtable where we include currency rates. Those are in this format #.##### (always five digits after the decimal point) I’m using this formula to switch the decimal point to comma to convert the number to EU standard: SUBSTITUTE(CONCATENATE({currency rate},""),".",",") This works fine so far, unless there is a number like this: How it should look like: 0,02580 What it looks like: 0,0258 The formula omits the final 0 I tried using VALUE to change it to a number field to use “formatting”, but this made things worse. It turns the number into “258”. Any idea how to fix this? Kind regards, Heike

Hi, I have a field which is a formula field for a due date group. I have 'due tomorrow set to → DATETIME_DIFF({Due},TODAY(),‘days’)=1, “ :yellow_circle: Due Tomorrow” But screenshot shows ‘due tomorrow’ for things which are actually due 2 days from now (today is 21st), not tomorrow. I assume its a timezone issue? But not sure what I need to change to fix? Or maybe I have done something else wrong? ?

:wave: Hello Airtable community! Here’s my use case: I have a table Items where each items has a price and a date period. Given their period of validity, I can or cannot add the item to an invoice. Example: I can add item A anytime in the year as its validity starts 01/01 and ends on 12/31. Item B however is only available from 03/01 to 03/31. I have a second table Invoices where each invoice covers a period of time, from a start date to an end date. Example: For customer A, I issue invoice #1 starting at 01/01 and ending at 02/15 and invoice B starting at 02/16 and ending at 04/30. For customer B, I only issue invoice #3 which starts at 02/15 and ends at 03/15. So given these parameters, I should have these items in my invoices: Invoice #1: Item A Invoice #2: Items A & B Invoice #3: Items A & B Does anyone have an idea how to write a formula that can check if the date period of each item overlaps with the date period of each invoice? The rule is as soon as they have

**Solution ** REGEX_EXTRACT({url}, ‘[^/]+$’) Note: replace “URL” with column’s NAME and make sure the single quotation marks are STRAIGHT. Hi Airtable Community, TL;DR I’m trying to write a formula that’ll turn part of a URL into a Primary Field Specifically, I have a list of URL’s like below. I need to separate the last bit of each URL (e.g. shopify, how to use, square vs paypal, what is credit card processing) and automate it into the Primary Field name - leaving out everything before it. The problem I’m unable to solve is that the part after the main URL is variable. For example, in https://www.usnews.com/360-reviews/credit-card-processing/what-is-credit-card-processing the emboldened part varies in each URL, making it hard to remove it with a formula https://www.usnews.com/360-reviews/credit-card-processing/what-is-credit-card-processing https://www.usnews.com/360-reviews/credit-card-processing/paypal https://www.usnews.com/360-reviews/credit-card-processing/shopify https://www.us

I am trying to create a formula to return the difference in time between two dates in terms of the number of months and number of days. For example, being age “8 months 3 days.” This is the formula I came up with so far, but this direction doesn’t get me an accurate return since not every month has exactly 30 days in it: (DATETIME_DIFF({DATE},‘2 Feb 2020’,‘M’)) & " mos " & ((DATETIME_DIFF({DATE},‘2 Feb 2020’, ‘d’))-(DATETIME_DIFF({DATE},‘2 Feb 2020’, ‘M’))*30) & " days " Any ideas? Maybe I need to start over using different functions?

I am trying to add conditions to my nested IF statement, but somehow it’s not working. I want to extract musical key information from the end of file names. The information I am trying to extract is marked bold. BRASS CHORDS DARK G BRASS CHORDS DARK D1 FLAT BRASS CHORDS DARK C SHARP BRASS CHORDS FORCEFUL A FLAT BRASS CHORDS FORCEFUL B The extraction should only happen if the file name belongs to the category “Musical Sound Design”, but I can’t figure out how to get that condition into my formula. I am using this formula: TRIM( IF(REGEX_MATCH(NAME,'SHARP'),RIGHT(NAME,8), IF(REGEX_MATCH(NAME,'FLAT'),RIGHT(NAME,7), RIGHT(NAME,2))) ) Am I trying to get too much into this formula? The musical key information can either be 1 or 2 digits (G or G1), or 7-8 digits (C SHARP or C1 SHARP), or 6-7 digits (B FLAT or B1 FLAT). The CATALOG field determines tells us if a filename contains musical key information or not, but I cannot figure out how to work that condition into the formula. Thank you in

Hello, I have a problem with a SUBSTITUTE formula. I have a text field that contains two consecutive spaces between two words. I want to SUBSTITUTE these 2 spaces by nothing ("") but the formula doesn’t work because airtable consider these 2 spaces as infinite number of spaces. I know it because I tried to apply on this field a substitute 3 spaces by “X” formula and the output was first_word+space+X+second_word Something weirder: if I copy the output of my formula and paste it somewhere else, the space is not present… But it is problematic to me because I want to compare the output of my formula with another field in airtable …

Not sure if I’m missing something obvious, but was wondering why is Airscript.dev listed with the anchor of “airscript tutorials” in the scripting app (Documentation tab, item #4 of “Other Resources”). The site itself says it is neither endorsed nor owned by Airtable. A forum search yields two topics from the apparent owner of the domain, both of which are self-promotions and don’t explain the link. I understand the half a dozen or so marketplace scripts come from third parties but is the scripting app itself not owned by Airtable? Just to be clear, the site is a pretty decent resource but I’m amazed a company with a ten-figure valuation like Airtable would promote anyone for free. And that particular link has some pretty insane promotional value in terms of domain authority juice from Google.

I am trying to figure out how to have two columns in some sort of table or report where one is drawn from one table and another is matched according to an aggregate on another table. In SQL, this would roughly look like SELECT a.name, a.target, sum(b.value) FROM TAB1 a, TAB2 b WHERE a.name = b.name GROUP BY a.name Here, unique names occur once in a but many times in b so that many rows of b match to each row of a. TAB1 Name. Target A 1 B 2 C 3 TAB2 Name Value A. 5 A 3 B 2 C 3 B 6 C 4

I want to show a message if a number field is blank. 0 is a valid, non-blank entry. I’m using the formula IF({Number}=BLANK(),"Blank","Not Blank") where {Number} is an integer. What I’m seeing is that blank values and 0 values are treated the same in this formula. That is, the formula field shows “Blank” for both empty values and 0 values. I would expect this to show “Not Blank” for 0 values. Conditional formatting will highlight only the empty values, which is what I would expect. So the concept exists. Is there something missing or is this a bug? Any workarounds?

I came across an issue recently where a linked record column in table ‘A’ without the option to allow multiple linked records, still contained some records with multiple links to records in table ‘B’. Upon researching the matter it turns out that when you duplicate a record in table ‘B’ it duplicates the entire record including the column tracking the reverse link to records in table ‘A’ and therefore causing the record in table ‘A’ to now contain a second link to the newly created record. I understand why this is happening, as duplicating the record in its entirety includes the linked records column, however i am not sure this is the correct behavior, certainly if it violates a constraint added in another table

Hi guys! I have trouble with the roll-up fields. Currently, almost nothing seems to work – even fields that worked before. As an example, I’ve created a roll-up field to count the linked records (see attached). Let me know if you need anything else! Martin

Hi, first of all new here :grinning: I’ve searched in the comunity and nothing really answers my question I have a formula DATETIME_FORMAT(DATEADD({Data Pagamento 1},{Produção Dias},‘days’),‘DD/MM/YYYY’) When I go to calendar I cannot select that field. Am I doing something wrong? I also thought of the possibility that the fact of being a “formula field” does not let the app recognize it as date, even though it is. So I thought a work around that I don’t know how to apply Create a second “date field” which value is equal to the formula. I thought maybe with … automation? :roll_eyes: I tried but I wasn’t able to find such function. “Date Field” = “Formula Field” Thanks Juan