Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Hello,I have a rollup field with the following output:FirstName1 Last Name1- XXXX Title Company , First Name2 Last Name2 - XX Title CompanyWithout going back to the original table to pull the "XXX Title Company" I need a formula to help split and d...
Dear Airtable + Apple Shortcuts Mavens,N00B, here with a N00B question.Using Airtable's API Encoder, I crafted a GET URL with filterByFormula.curl "https://api.airtable.com/v0/app[Redacted]/Items_Table?filterByFormula=%22%7BItem%7D%3D'D123'%22" -H "A...
Hey, I am looking for a formula field to extract city, state and zip code from a full address fieldThis is how a full address looks like "New York, NY, 10031". I want to split them 3 ways using formula, how can I do thatI used this formula to get the...
Hi allIs there a way to delete the certain matching characters that might appear in a column? For example I have a column of data (800+ cells) of company names, and 90% of them are prefixed with a 'number' (that run between 1 and 9), followed by a 'p...
Hello-I am trying to roll up 10 date fields that are all deadline dates to a long text field in a bullet format.Ideally I would want the field name to be visible as well as the date like this (Field name/Date):- Designer due date: 1-2-23- Submittal d...
Hi there, I know how to get things off the end of a string but not the start!!! I have recipes that look like this Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)Greek salad with crispy chickpeas and potatoesMiso eggplant with broccolini...
I have a series of fields I want to concatenate together. The final result needs to include a semi-colon in between each piece of data, but not all columns have data. So I was working to do an IF statement to check if the last of the columns (far rig...
I'm trying replace the following text with different values within [] with values from single select columns[art medium], [main objects], [attribute], [expression], [key light], [detailing], [camera shot], [media], [engine], [artist]I thought this wo...
Hi All,I need some help with extracting specific text. I've looked through the community and tried to apply the examples offered...but I am not getting it quite right.I need to extract the suburb, state and post code from a (text) address field. Some...
I can't for the life of me figure out what's happening with this one transaction in the personal finances base I've been building. Would you guys take a look?These are two of the same type of transaction for comparison. The top transaction calculat...
Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I w...
Howdy yall, I am trying to do a simple math setup for a client. calls per hour, demos per hour, calls per demo... The issue I am running into is the math seems to be coming back wrong. I have tried a few different ways and still having issues. Here y...
Requesting some guidance here. I'm new to Airtable and have read some documentation but have not fund any examples similar to my use case. I have a single select data field that I need to convert each selection items to a numeric value that can then ...
Hi there, I have a single select field name "Département" and I want to concatene the 2 first letters (later for automation).I have a problem with this formula :IF( OR( {Département} = "75", {Département} = "78", {Département} = "77", ...
Hello everyone, I would like to create a form where people can add their event dates (event begin at 1st January 2023 and end at 2nd January 2023) and prevent the possibility of the end date to be before the start date (event begins at 1st January 20...
Dear Community,I am faced with the following problem:I want to pull data from a different table when the status in each table is the same.I am creating a text.Say the status in Table 1 is "First Text" then it should check in Table 2 for the row named...
Hey guys, I've got a new challenge in my quest to create a base for tracking personal finances. A quick review:TablesCategories (I call them buckets)TransactionsDesignationsTransactions are either entered manually or bulk imported via csv from my ba...
Hello everyone,I have to create a calendar of course sessions and I have a table in which I enter in one column the date, in one column the start time and in another column the end time because different days might have different times.I use the for...
I'm trying to clean up my text with Regex. Some ranges are listed as 3.0 - 3.0 which I want simplified to just 3.0 whenever the two numbers match. I tried using regex101 and MDN references, but Airtable seems to use some different syntax than either ...
| User | Count |
|---|---|
| 760 | |
| 696 | |
| 575 | |
| 457 | |
| 267 |
