Ask the Community

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 as well. My main concern

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(IF({Check out date}<=DATETIME_PARSE(DATETIME_FORMAT(IF(MOD(MONTH(TODAY(

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 participant signs up for a trip, the system should identify this

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: Original ProjectAssociated Original project: None"Revision project record" fields/Project infoUnique Project Number: #558 (Autonumber

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'm not sure if this will make a difference/make things more difficult but the column I need to multiple from (total # of grades licensed) also has a formula. Not sure how Airtable is with multi-formula mingling so just wanted to throw that out there! (side note: If ther

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") ) 

Hi, please help me with this automation. For added info, this is created on a Base within a workspace on a Pro plan. All members on this Base are part of this Workspace as creators.I want to assign a record to a member of my team based off another field's data. We operate in several markets (UK, Nordics, US, etc) and different team members work with different regions. When a record is created with a region, I want to automatically assign the relevant team member to that record.I have tried this multiple ways, and the only one that seems to make sense is the following, which isnt working. I have created multiple automations (1 for each market to assign to the right person)Trigger: When a record matches conditionsTable: Table 1Conditions: When market is (market name) - for this example "UK"Step 2: Update RecordTable: Table 1Record ID: "Assigned to | Name"Fields: Assigned to: (appropriate name selected) I continue getting the error "received invalid inputs" which doesn

Is it possible to do a header / group each section? I am looking to put a few points under different sections but I cant seem to find the option to add a heading or a divider. Kindly assist.

I've been using airtable in its most basic functionalities for a year or so now, though hoping to dive into it a little more deeply this winter. There's a specific tool I wish to build and have a roadblock that I think shows my novice status. The vision of the tool is that it'd function for capturing and organizing ideas and information I get in my day to day between the different life focuses (categories) and I'm not sure how to structure the tables or links/relationships. Essentially I currently take down my ideas and useful information in a notepad. Every once and a while I go through and sort it into some documents with sections. However, I figured why not create a form I can put the ideas into that categorizes them upon entry?For example, I'd have some main categories and each would have subcategories so I could have a field for inputting the idea, then choose the category it belongs to and subcategories and it'd organize it upon entry. For example (categories and subcategori

Hi all, i need help form you 🙂i have 2 tables : - VariantTable -CostTableThe key is the SKU, this field is in the 2 Tables.I would like to add colunn in VarianTable with the CostPrice.How to create field with Automaticaly put the CostPrice when SKU is same.  Thanks for you help

Fairly new here…so…I’ve created a form but the recipient needs to fill in the form over the course of a year (Growing vegetables for us & includes info/observations for the whole growing year)…is it possible for the recipient to save the form and add to it and then submit when all the data is complete? Or would it be better for me to create an app that they can fill in? Thanks for any advice, much appreciated.