Help

Welcome to the Airtable Community!

47661members
114125posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Designer/Florist Looking for Base Setup!

I've been scouring all threads, extensions, and templates for help with creating a base- and several threads I came across that had the same requests as me tended to come up with "hire an expert"My workflow consists of different phases:1. Inquiry2. P...

MeganLW_0-1670135346069.png
  • 13 Views
  • 1 replies
  • 0 kudos

Problems with embedding code blocks on Community forum

Howdy everyone!Is anyone else having issues with embedding code blocks on the new forum?Markdown went away so I used the regular code block from the tool bar, but still there are some funky errors showing up...If I add just the block by itself - the...

Greg_F_0-1670125983108.png
  • 24 Views
  • 0 replies
  • 0 kudos

Using a form to remove a multiple-select option from a record

I have a fairly complex set-up with Airtable automation and Integromat automation that does a whole bunch of stuff very nicely. I'll attempt a simple description of one part of it that is relevant to my request...People can use a form to "watch" for ...

  • 44 Views
  • 14 replies
  • 0 kudos

Trouble Connecting to Facebook Page

I'm an admin on 300+ Facebook Pages. When I try to select a page to tie an automation to, I receive this error message: "Facebook returned an error. Error hashes: rm0604cd3138feed20, ufm7db6c9a23a36fa83"Anyone else encounter this or know of a workaro...

  • 13 Views
  • 0 replies
  • 0 kudos

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 ...

  • 25 Views
  • 1 replies
  • 0 kudos

Resolved! "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
  • 35 Views
  • 3 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...

  • 17 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...

  • 52 Views
  • 2 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
  • 22 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...

  • 32 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
  • 24 Views
  • 3 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 ...

  • 19 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...

  • 61 Views
  • 2 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...

  • 16 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...

  • 27 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
  • 54 Views
  • 6 replies
  • 1 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