Help

Welcome to the Airtable Community!

47648members
114084posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

View showing lowest price per category/sub-category

Hi,I need to supply to my team of buyers the "best deal" for any given category and sub-category of products in our database. At first, it was easy to group by category / sub-category into a view sorted by price ASC. But over time, the database grew ...

  • 6 Views
  • 0 replies
  • 0 kudos

"Long" formula issue

Hello,I'm totally new in the formula game, I created mine by putting pieces of tutorials together and using answers obtained here (by the way, thanks to the community!)That's the deal :When my cell x show 1h, I need to show 0When my cell x show 2h, I...

Capture d’écran 2022-12-03 à 17.58.54.png
  • 4 Views
  • 0 replies
  • 0 kudos

Auto Categorization

HII face an auto-categorization issue with no solution so farI update a table with hundreds of credit card transactions, with lot of them recurring with 95% of the text string similar from a month to another month.Is there any chance there is a solut...

  • 8 Views
  • 1 replies
  • 0 kudos

Filter by two criteria

Hello,How can we do, in a script, to apply a filter that returns records that match two conditions.My attempts :let filteredConcurrents = query.records.filter(concurrentEdition => { return concurrentEdition.getCellValue('Edition Record Id')?.includes...

  • 14 Views
  • 1 replies
  • 0 kudos

Date formatting

Hello,I configured my date format to European on Airtable, however, when I send this data to Integromat and making a Google Sheet template, it reformats the date in US.Date on Airtable (03/12/2022) :Date format received by Integromat (2022-12-05, yes...

Capture d’écran 2022-12-03 à 15.35.18.png Capture d’écran 2022-12-03 à 15.42.15.png Capture d’écran 2022-12-03 à 15.38.57.png
  • 13 Views
  • 2 replies
  • 0 kudos

Resolved! Split text with linear range to multiple columns

Hello community!I'm trying to extract some words of a column in 2 new columns. The number of words is always the same before the parentheses, example :2 big cars (With little windows)3 big cars (With black roof)4 big cars (With a lot of gas)I'm tryin...

  • 18 Views
  • 2 replies
  • 1 kudos

Invalid URL in parameter in "MAKE" after passing an empty field

Hello everyone, I have a scenario where I am extracting entries from Google Sheets (different types) and pass it to #Airtable using #Make (#Integromat)The error that I'm getting is "Invalid URL in parameter", I mapped the fields from G Sheets (URL) t...

xXTMXx_1-1670058264089.png xXTMXx_0-1670058134467.png xXTMXx_3-1670058383884.png
  • 11 Views
  • 0 replies
  • 0 kudos

Lookup from multiple columns

Hello,I have a following situation:Table buyers has 8 rating columns (AAA,AA,A,NR,B,C,No Rating) which are determining different interest rates for each rating value. Each buyer has different interest rates in these rating columns.Table invoices has ...

  • 15 Views
  • 1 replies
  • 0 kudos

airtable make rows non editable based on criteria

HI, I am new to Airtable. I reached for my query before i am posting this in forum.Let's say I have 2 records.ID, Type, Item,FYxx_Total1, Fixed,A,2001, Fixed,B,1001, Variable,null,0As you see, ID is 1. When the user enters the FYxx_Total, the first a...

  • 20 Views
  • 1 replies
  • 0 kudos

Assigning Numeric Value to Text

Hi! Im trying to assign a currency value from a single select field text and am having trouble. I've tried using the IF function and I can get it to look how I want, but the field is not a number field and so will not give me a sum. For example my si...

  • 13 Views
  • 1 replies
  • 0 kudos

Find Records Script Help Needed

Hello, I'm hoping that I could get some help writing a script to get around the 100 records limit with Find Records. Currently, I have an automation set to run each weekday at the end of the day to find all the records that meet two specific conditio...

  • 24 Views
  • 1 replies
  • 0 kudos

Troubleshooting Airtable attachment error messages

So it seems I may be dumb, but I was under the impression that how I'm using the attachment field is ok and I wouldn't be impacted by the changes but I'm now seeing all my attachments are broken.The way I have it configured is I scan a document into ...

brokenairtable.png
  • 45 Views
  • 6 replies
  • 1 kudos

Automation failing when sending email with attachment

we have several automations that involved sending an email with an attachment. they worked as designed on 11/30/22. However today, 12/2/22, they fail to send. i've attached a screenshot with the error. The error says "Microsoft reported an error whil...

  • 10 Views
  • 0 replies
  • 0 kudos

Formula Help on Phone Number Formatting

I am looking for help creating a formula field to change the format that phone numbers appear in.On Airtable, the phone field automatically formats phone numbers as: (555) 555-5555.I need the phone numbers to be formatted as follows instead: +1 555-5...

  • 11 Views
  • 0 replies
  • 0 kudos

Announcements

Welcome to the new Airtable Community 🚀

Welcome to the new Airtable Community Experience! We are so excited to welcome you back. Whether you've been a member of the Airtable Community since day one or you joined us a few clicks ago, thank y...

Announcements

Community Change Maker: Danielle Combs

The Airtable Community Change Maker Spotlights are a new ongoing series where we will be highlighting inspirational creators across the Airtable Community. We are thrilled to be able to highlight Dani...

Announcements

Community Change Maker: Hannah Wiginton

The Airtable Community Change Maker Spotlights are a new ongoing series where we will be highlighting inspirational creators across the Airtable Community. For our first spotlight, we are thrilled to ...

Announcements

The Airtable Community is moving ✨

Hi all - I hope you’re doing well and for those who celebrate, I hope you had a great Thanksgiving. I’m excited to share that on December 1, 2022, the Airtable Community is moving to a new platform! U...

Announcements