Ask the Community

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}

Hello! I'm new to Airtable formulas & could use some much needed guidance! I need to calculate the total with an option of a discount if a multi-select answer is chosen. For context, this is in reference to grades of elementary curriculum books purchased. I am trying to create a formula that will show me:If Rural Discount multi-select = 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $250 + additional invoice amount= total invoice costIf Rural Discount multi-select does NOT equal 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $500 + additional invoice amount= total invoice costHere was what my closest effort was: Additional info:

I have a team that wants to send a weekly digest that shows updates only from the previous week. I found a formula that can show if a date is this week or not but can't figure out a way to show just dates from the previous week 

I was wondering if there is a way to fetch data of all automations that are created in my account, as well how many times they were ran. I tried to find an API for this, but didn't found.

Hi all!I'm looking to use Noloco like @scottsworld suggested, and I'm curious if having a button to allow people to edit or create records in airtable on that interface means we'll be billed extra for these peoples since they will be doing 'creator' level actions.Thanks a bunch 🙂

Hi, I am trying to automate an email message with invoice details for the finance department to create an invoice. For each record (invoice) I have one or multiple sales, invoice lines, so each record will have fields with multiple linked data. In the body of my email I would like to split out these fields by the invoice line (sold item), but they lump together by the fields on one line.Message body build up: Below you can see Sale #1 and Sale #2 with their corresponding fields are clustered on the same line. I need them to be on separate lines with their corresponding fields:Thank you.Best regardsChristopher

Currently I have a Date & Time (duration) field.  I have combined them into  The combined date & time formula is showing a different time zone it seems?  I want it to be Los Angeles.  Is there a way to do this?"COMBINED START DATE & TIME" FORMULA:IF( ({All Day Event}), DATETIME_FORMAT({Start Date & Time}, "MM/DD/YYYY"), DATETIME_FORMAT({Start Date & Time}, "MM/DD/YYYY HH:mm") )