Ask the Community

HelloWe have 50,000 max record limit on our plan.On our settings page, it says we're up to 35,500+ records thus far.However, when I manually look at all our master tables of data, it only ads up to 28,000So I'm wondering where is that 7,500 record discrepancy is coming from?If I have ONE record in my master table that shows up in 10 other views, does that single record actually count as 11 records?? (in the master table + the 10 other views)I always assumed that views simply pull select filtered items from the master record set and didn't count toward the base record max, since they are just regurgitating data that already exists, and not adding more data rows. Is that incorrect thinking?Thanks.

Hi there,we try to find solutions for this use-case:We want to create "logic" URL's for our data-sets, what we can do at the moment is creating a formula "www.airtable.com/base-id/table-id/" & recordID().What we would like to define is the part recordID(), because all of our fields have a type-number (for example AA550). So it should be a formula "www.airtable.com/base-id/table-id/" & type-number with the result:www.airtable.com/base-id/table-id/AA550The reason for that is, that in the past often dataset were be deleted by someone or we have to transfer the database. We're using this URL's in an other database and if the recordID is changing, we have to check that again (yes

I'm using airtable to manage all my seasonal employee hiring. I have one column where from a multiple selection I choose their job title (eg. Camp Ops, Kitchen, or Waterfront). I want another column that show what certification are required based on the job title I selected. I believe this should be a IF or SWITCH formula.Currently I have a working formula that is IF(Job='Camp Ops',"First Aid & CPR" ) But I can't figure out how to get the formula to also be IF(Job='Kitchen',"First Aid & CPR) and IF(Job='Waterfront',"Lifegaurding") and so on. 

Hi guys!Does anyone know if there will be any AirTable conference in Europe this year?Or some similar conferences about no-code/low-code platforms?Thank you! Have a nice day!

I am a Developer and a paid Business tier account holder. I have sent numerous support and sales requests with no response. I would prefer to handle business privately and use appropriate channels to communicate. But, it seems like no one is home. Please advise.

Hello!I have 2 bases with a table that has two-way synchronization.In the destination base I have added many formulas to calculate prices and costs.Now I need to return the final result value to the source table.I tried using automations, but using "Update Rung" is not allowed in these syncs.I also tried with formulas, but it is not possible.Is there a way to do it within Airtable?The other option is to use third-party tools, such as Make or Zapier, but I prefer to avoid that for now.

Hiya! I spent a lot of time googling and trying to find the answer but not having any luck. I need to find a formula that displays the previous Monday date based on a date in another field. Would also love to know what each element does so I can learn a little too rather than straight copy/paste. Thank you so much!

Hello Airtable Community,I have 2 tables linked - the common column being "Deal Link" a.k.a "URL" (which is primary in Table 2).I have a script that updates Table 2 via API.The problem is, when updating via API, all the data linked in Table 1 from Table 2 disappears (even when record is unchanged). Is the link broken at this point ? How to remedy that ?Thank you.

I'm trying to have the viewer select a job field in a form (post-production, design, etc.)Based on that selection the next entry would be a limited selection of our main record field "primary role" (editor, producer,etc.). I'm able to do this easily, however, if I duplicate this limited selection and change the conditions to another job field (visual arts, culinary) then change the limited selection, the "primary role" field becomes a copy and no longer allows input into the same "primary role" field.Example:'Creative Field' selection (POST-PRODUCTION, DESIGN, etc.)if user selects DESIGN'primary role' selection is limited to those relevant to DESIGN based on conditions met with the selection within 'Creative Field'how can I change those limited 'primary roles' to reflect the other

Hi everyone!I have a schema of 252 records to apply to some client in a standardized order. This is the script I made (deleted different lines because of number of characters:   let duplicaTable = base.getTable("Duplica_Form") let tyrecords = await duplicaTable.selectRecordsAsync({fields: ["Dashboard Clienti"]}) let cliente = tyrecords.records.filter(item => item.getCellValue("Dashboard Clienti")) //console.log(cliente) let arrayTypeform = [] cliente.forEach(item => { arrayTypeform.push( {fields: {"order": 1, "typeform":[{id:"recg1yUeuxfjKfn0t"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 2, "typeform":[{id:"rec0TnCthwKaCsBcF"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 3, "typeform":[{id:"recg9NPL21ZWduc5g"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 4, "typeform":[{id:"reck4nzT8lp9Us5Nx"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 5, "typeform"

Hi there ! I used to have automations running with an outlook connected email being a shared mail box. These kind of mail box doesn't have an outlook account (no password).Since a year now, my automations are no longer working, I have to change every account connected with an exchange account with log in + password. So I tricked here and put a standard email address as connected account (mine) and use the option "send as" and there I put the shared mail box I work with.... still, I have an error message in all my automations saying I don't have the right to send on behalf of...but checking the exchange tenant, I do have these rights....can somebody help ??? How can we used shared mail boxes to send email automation from airtable ???

I have a column in the first table with dollar amounts like this: $20 $20 $20 etc I would like the second table (in the same view) to total these amounts. How would I go about doing that? Thanks

Hello! We were previously using this formula to calculate a recurring date in the future: DATEADD("Publish Date", 7, "days")  However, we're now getting an #Error Message in our base.  I did some searching and found this blog from Airtable.  I tried using their exact formula in that blog as: DATEADD({Publish Date},7,‘days’) but it is telling me "Sorry there was a problem saving this field. Invalid formula. Please check your formula tex

The "Link to" field shows the fields in the edit/detail form. In fact, in the example you can see the title. When editing the Add task form it is not possible to show the fields, thus making selection difficult.The two forms should have the same possibilities, I believe they are not aligned.Form edit/detail:Form Add task: 

I currently have a Node.js application that makes requests to the Airtable API, which I have been using as usual. However, from yesterday to today, I am encountering this problem:[Nest] 31452 - 02/02/2024, 9:32:17 AM ERROR [ExceptionsHandler] connect ETIMEDOUT 18.214.64.4:443 Error: connect ETIMEDOUT 18.214.64.4:443Has there been any change to the API?

Hi everyone, Does anyone know of an extension that allows you to mind map ideas/projects? Kind of like an XMind or Miro?I'm trying to keep as much inside Airtable as possible. Thank you!

Hi Team,I would like ask for your assistance on this matter please.Whenever our clients would want to submit an inquiry to Softr, this error is always appearing. Thanks 

Looking for help with my base. I want to automate importing a csv on a schedule into Airtable. Currently, I have to delete all of the records in my table, export and import a new csv from NetSuite, and then the rest of the base does the work. How do I automate this? My goal is to have this run 3-4 times daily.

Can someone assist me with writing this formula? I'd like to basically have a column in which the staff or faculty nominee column is combined with the value. For example: Cameron, Ali - Innovative SpiritI'm running into an issue were if the staff column is not populated the staff one is, and I need the names to pull from either or both- I tried using and "if" statement but am not having any success. Additionally, if there are multiple names linked, I'd like to separate them by a comma. Screenshot attached for reference of the table!

I just saw the final deprecation email a few days ago (my work email has so much junk I rarely check it unless I already have a thread going). I'm trying to update a touch screen experience I built 2 years ago. This is the first and only project connecting an app I made in unreal to airtable so hopefully I'm just rusty and it's an easy fix.I'm able to see the records using web.postman.co so I know the personal auth token is working, but retrieving and sorting them in unreal (using the VA rest plugin) is more complex.here's a comparison of the old API key method VS one of many things I've tried so far for the API call. they're identical except for the third line.I also tried removing the 2nd line with the sorting but that's not working either. like this-

Help! We are a Charity that trains Assistance Dogs for Autistic Families. I have a table with ALL the people that have ever had to do with thecontact/dealings with charity at some point... however, this is my dilemma:Mr X is currently a 'Volunteer' and a 'Subscriber' but he used to be a 'Fostererer' so his Contact Type is currently a multiple select field where all three are listed. BUT it doesn't tell me which Type is active and I have been asked to show who's doing what currently and not previously. What do I need to do to my base to identify that Mr X has 'Active' status on both Volunteer and Subscriber but 'Inactive' status for Fostererer.

Hello ! So i have a base and i want to delete all records that are on the table every sunday (weekly). i heard that it’s possible to do it with a script, but i don’t know how. Can you help me please? Thanks

I'm looking for a bit of assistance. I've created an automation that sends a message to a specific MS Teams channel when a record enters a view.However - the message is sent from myself, which means that when the automation triggers, I don't actually get any notification on my PC or my phone (since technically it's "me" who's sending the message).Is there any way to bypass this so that I actually receive a notification? I could use Zapier, but I'd like to avoid that if possible.

Hi everyone,I would like to create 1 automation that starts when a record is created in airtable and that creates an event on google calendar. I used the "when recordmatches conditions" trigger specifying the conditions to make it activate (for example the date field must not be empty). I then inserted my Dynamic "Date" field as "Start date" and "End date", which is made up of both the date and the time. The problem is that when I go to create a record and choose the date, the time is automatically filled in, the automation starts and creates the event at the wrong time. Does anyone know how I could solve it?any help is precious!

Hello,I was elated at the ability to prefill forms in interfaces just like you can do with the standard forms. However, I'm not able to prefill a linked record in an interface form.I was successfully able to prefill other field types with the interface form, just not the linked record.In addition, I tested the same prefill string on both a regular form and an interface form and even "hardcoded" the string with the Field ID and Record ID (?prefill_fldXXX=recXXX). It worked as expected on the regular form but not on the interface form.Is this functionality not yet possible (other posts on here suggest it should be)? Is this a bug?Thanks!