Ask the Community

We have a table called Documents and I want to use a formula that pulls the name of the file in the {Attachment} field in order to provide the Name of the record. I've been using the LEFT({Attachments},FIND("(",{Attachments})-1) for this purpose and it works great, but I've now found that if the name of the attached file contains a comma, then the formula name adds a quotation mark at the beginning of the name. So now I'm trying to combine the SUBSTITUTE and FIND formulas to:1. Look at the name of the attached file, and if it contains a comma then replace it with a hyphen (eg. 'Ocala, FL' becomes 'Ocala-FL' )  2. Then use the name of the attached file as the name of the record without the URL at the end (using the FIND formula). Another acceptable option would be to just remove the comma from any

Is there any way to be notified when a base has no new records in a period of time.I'm creating a base where managers need to leave a new record at least once every 30 days.  I want to be alerted when they have NOT left a new record since the last one was posted.Anyone know of a way to do this?

Hi there,In the last few months we been happy with getting an email on each new lead being created in one of our tables. The email contains all the needed data relevant for our sales team. BUT i'd really want that email to contain an attachment which is a .eml file (email) which is populated specifically with the records data. How can i accomplish this?Goal is to minimize errors when our sales rep copy/paste the data from the email. 

Hello,Looking at the current Airtable fields API, there doesn't seem a way to view or modify the filters for count and rollup fields. If I look at the field options for either of these field types, this does not seem to be supported. Is there a possibility to create a rollup field with a filter programmatically, and/or to see which filters are applied on an existing rollup field?If this is currently not feasible, do we know if there are any plans to implement this in the future?Thank you in advance.

I have embedded a “grid view with grouping by date” into a page on my website. When I view it in a browser on my desktop it looks fine. But when I view it in a browser on my Android phone (mobile), the grouping does not show and there is no menu bar at the top of the grid view. Menu Should be: Hidden Fields, Filter, Grouping, Sort, row height, print (this menu does not show on mobile) What am I doing wrong? https://lircal.com/airtable-browse-view

I saw elsewhere that Airtable-limited markdown is available for Automations (possibly only for emails? - not clear), but I can’t seem to get the markdown to work for Slack message automations. :loudspeaker: : The Accounting base in :airtable: has been updated by  [Record (Step 1: Trigger) | Field values | By | Name] with the following release notes: ‏‎[Record (Step 1: Trigger) | Field values | Description ] So that the message in Slack looks like this: :loudspeaker: : The Accounting base in :airtable: has been updated by frozenforum with the following release notes: Created a new Client Companies table Converted Client Company field to be a link to Clie

Hello Airtable Community! I am relatively new to the platform and looking to build a solution to track work relationships and contract info for individuals as part of an organization. Right now, I have multiple tables, one for each "level" or "grouping" of employment (Regional Directors, Program Managers, Program Associates, Country Staff, Consultants, etc). I also have tables for each level of organization (region, country). I have them linked to one another to show relationships (so, for example, each record in the Regional Directors tab has a column for the region they direct, the countries in that region, the program managers in their region, program associates in their region, country staff in their countries, etc, all pulled from the other tables).I have found that these separate tables are necessary because each class of info has different fields that it needs. Country staff, for example, have contracts with start and end dates and submit invoices that need to be track

Hi all, I have a tracking base for our student organization.  It keeps records of each student involved as well as their involvement (ie attendance, rsvp's, even leases).I'm working to create Interfaces so the other staff members can have a more visually appealing way to view the information.  They are very overwhelmed by the data side of the base haha.  Here's what I'm hoping to do:I have a List Interface page for the students.  Each student record can be clicked into.  In the Record Detail screen, I want to include the fields that link to the various attendance, rsvp, etc records - these will be view-only, just for reference.  But some of these will have a LOT of records linked in them (for our more active members) and that would be overwhelming.  Is there a way to limit the number of records to, say, the last 5 attendances with a little button to load more if they want to?So far, I have tried viewing that field as a List whi

I signed up for beta a long time ago, but seems I'm still on the waitlist. Has anybody one else been let in to beta?Notion's AI tools are cool and I'm using them already.  Wondering if I should be shifting my workflows over, or keep waiting.  It's almost 2024!  

Hi, I am super new here. I want to create a database for ecom owners with linkedin contact and etc.My question is how do I create an airtable where I can show a preview like only 20 / 5000 entries. If they want to view the rest they have to subscribe?Would really appreciate your help. Thank You

Hello, I'm trying to merge a CSV but the field that I need to map to is not available to select. I can't select the field I need as the merge field. It is not one of the options in the "choose a field" drop down.

I have a Teams plan and recently discovered that you can only have 50 Automations per base (I don't know if this is a plan limitation or not, just providing details). NOT a limitation that I've ever seen displayed anywhere on plan details or comparison pages.So it's a bit frustrating after investing a lot of time and effort into building out my base (including nearly 5k VERY detailed records), with lots of additional work in the pipeline to expand the base's capabilities, only to find out now that, as is, it will never be able to do what I need it to do. Development has come to a screeching halt because I literally cannot create an additional Automation...To resolve this, (I'm thinking) it will require a completely different approach to my base design. Instead of keeping everything under one base, I'll need to split tables off into their own bases. I guess I'll have to MANUALLY 😠 re-create all the Automations related to that table into the new base

I am using an automation that uses a script to append a record to another table's linked field. My code is shown below.This is not working however, as the record.getCellValue('Worksheet: BOM") is returning an array that has the format ("string") instead of the format (id: "String"). Is there any way to fix this?This is my error message:No overload matches this call.The last overload gave the following error.Property 'id' is missing in type 'readonly { id: string; name: string; }[]' but required in type '{ id: string; }'.(2769)env.22.d.ts(5964, 43): 'id' is declared here.env.22.d.ts(5959, 5): The last overload is declared here.

Dear Community, hope someone can help me out with this!The formula below indicates based on {Check in date} and {Check out date} how many months a booking of a rental apartment is actually in the current quarter. However in this formula, when the check in date is higher then the 17th of the month in gives one month less. So lets say check in date 17th of October and check out on the last day of December, it gives 3 months. Anything above the formula gives 2 months. However, this is not correct. For any date above the 17th of the month it should also give 3 months as the booking falls into 3 months of the quarter. Obviously if a new month start then it should give 2 months so 1/11 till 31/12 is 2 months. Can someone please help me write a correct formula for this?The formula below was created by Airtable support, but incorrect and they did not want to help me further! Thank you so much!!!ROUND

Hello, I have a table where I keep my website’s customers email addresses. I would like to create a random and Unique IDs for every email that I add to the table. Also, if the same email is entered more then one time, the ID should be the same as the first email. Is it possible to do something like it on airtable? Thanks

Hello, I am having a table in Airtable with Subscriptions. Each subscription record has its subscriber data containing the following fields:First NameLast NameAddressZip CodeCityBut each subscription can be assigned to a person more than once. So persons can have several subscriptions at the same time. I want to create unique IDs based on the subscriber fields from above (first name, last name, address, zip code, city). If there are subscriptions with the same person, the Unique ID (of the subscriber) should be the same. So basically I want to avoid duplicate people having a different ID. They should have the same ID.How can I do this with a formula? Thanks a lot for your help, Michael

Hello Airtable Community,I’m currently working on improving our Airtable system and could use your expertise. We have a setup where participants sign up for trips, and upon signup, we need to automatically generate a billing record. Here's the challenge I hope you can help me solve:We have a "Trips" table with trips that participants can sign up for, and a "Participants" table with a list of individuals who may sign up for multiple trips over time. When a participant signs up for a trip, we need to:Identify the most recent participant who signed up for a trip.Create a record in a "Billing" table that links the participant, the trip, and the cost associated with that trip to generate a bill.The main obstacle is that the participants are existing records, and their signups do not create a new participant record; they're simply linked to another trip. Here’s what we’re aiming for:A fully automated process: From the moment a pa

Hello, I would like to know if there is an automation integration planned for deployment on Netlify in the event of a change in the database.Currently, I work with Gatsby and I use Zapier to trigger a build on Netlify with my new data but unfortunately the threshold of 50 tasks is quickly reached during big changes in the development of the website.THANKS.

Hey all I've created an automation where when a form is submitted - a record is updated. However! Sometimes there isn't a record to update, so it needs to be created first. So I need to create a process like this:WHEN a form is submitted AND record exists UPDATE it. IF record doesn't exist CREATE itBut the automation is getting stuck on the first part and fails to run into the second. I've taken a screen shot to show what I mean. How can I fix this?Thanks!

Hi, I currently have this formula as part of a Task Days Remaining column: IF({Due Date}, DATETIME_DIFF({Due Date}, TODAY(), 'days'))Is there a way to update the formula... so that when another AT column (i.e. a task completed "checkbox" field) is marked complete, the value in the Days Remaining cell turns to a ✅... or even turn blank?The reason I'm doing this is because even after I mark a row (task) complete, the numerical value in the Days Remaining cell becomes a "-" number (eg. -3). So instead of seeing lots of - numbers, I'd prefer to have completed task cells become blank instead (or ✅ if blank isn't possible). Thanks in advance!Christopher 

Structure is as follows:Project tab has all of our project records with around 50 fields of project-specific details.Some project records are categorized as "Original Project" and some are categorized as "Revision""Revisions" are linked to their "Original Project"I want to do the following:1. Create a new "revision record"2. Fill out ONLY the fields that will be changing 3. Link the "original project" in the "Original associated project field"4. When that field is updated, I want an automation to run that will copy and paste fields from the original project record to the revision project record, but ONLY for fields of the revision record that are empty.Example:"Original project record" fields/Project info:Unique Project Number: #557 (Autonumber)Customer name: John DoeSolar module: Mission Solar 400WQuantity: 25Inverter: Solaredge 7600kWProject type: Ori

Hello, this morning I noticed a change within a few of my interfaces. Certain elements aren't auto resizing, and I can't manually resize them either. This was a recent change. I tried deleting these elements and adding them back, but they seem to keep word wrapping on the value instead of the heading.    

We have a list of questions in a base that we want to email out to gather answers, or ratings on a scale of 1-5. Is this possible to automate?

Hi,I'm using a form so users can enter their data into a table. In that table one field always has to have the value "SUM" I want that every new record to be receiving default “SUM” Thank you

I'm not authorized the table in my vs code using nodejsAirtableError {error: 'NOT_AUTHORIZED',message: 'You are not authorized to perform this operation',statusCode: 403}