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 ...
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...
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...
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...
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...
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...
Whenever I try to copy/paste formatted text (eg bold) in a long text field within an Interface, whenever the long text field is long enough across the screen, it makes my screen jump to the beginnen of that field AND it forgets the formatting (bold w...
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...
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 ...
I have developed a Facebook messenger chatbot in Node.js that generates PDF using [PDFKit](https://pdfkit.org/) and sends it to the FB UserWorking:1. First the PDF is generated using PDF kit and uploaded to Google Drive with the filename Eg: John_PDF...
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...
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...
Hello!I have a question about the best way to set up workspaces and bases for our marketing department. Our department has five digital marketing teams, each digital marketing team has different social media editorial calendars to manage, which we're...
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...
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 ...
I use airtable essentially to create daily schedules.These schedules are PDFS that i print from the layout extenionsi then upload the pdf to a seperate kanban view for employees on site to be able to go thru at start of day to know what they need to ...
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...
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...
Hi!I have this small test function to reproduce my issue:```IF(AND(5=6,LOWER(50)), 'ok', 'not ok')```Normally I would expect this to output "not ok", but it gives an error. The AND operation does not stop after the first mismatch. Usualy in programmi...
MySQL or PostgreSQL or MongoDB or some KV Database? (include table fileds and view and record)SQL or NoSQL?And what is the structure of the table of database?
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
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
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
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
