Ask the Community

We have a paid Teams license - just a few seats for the development team.Am I right in thinking that if we share an Interface by email as readonly, then that doesn't require a paid license for that user?We were going to use Softr as the front end, but it looks like Interfaces gives us better functionality.  

Please community members😔, I'm new here and really need help understanding some things with airtable. In fact I upgraded for the team plan more than a month ago, it told me that my database is full yet I only have one database with 2100 records. I don't understand absolutely anything

Hi everyone. I'm new to Airtable and getting used to the automations and tools. I'm hoping there's a way to do what I'm trying to accomplish, even if it's not the way I'm thinking...First, a little context:We teach different types of classes (at least 😎 and have a list of students we contact to offer classes and enrollments. Some students may take only one class, some may take 3 or more.What we have doneWe want to be able to store our students' information, assign them to the groups they are interested in (for example, if they are interested in class A, B, and D), and perform the registration process(es) for each of them.To do this, I created 2 tables: one for the classes and all the information related to them (price, dates, location, etc.), and one for the students, where I store the students' information and track their stage as a lead (if they are new, if they need to be

I need to create a base that will allow a user to add a new item (a change in operations, ie: we now date all produce boxes upon arrival, or Host to open all doors for guests arriving and leaving)then each item is assign to a department (Kitchen, Host, etc)Then each team member is to sign off on new process I can create the first part, however, how do I build the base to allow for staff to initial/sign any changes for their assigned departments? (without logging into airtable - this would be liked to Glide apps)I need to be able to view the change, department and all signatures (plus who has not signed for that department)  

Question on best practice. As an automation consultant, I'm building a CRM for my client which will integrate with Typeform, Make etc.Eventually I'd like to transfer ownership to the client while keeping enough access for any maintenance, but I am foreshadowing changes to credentials/access tokens etc resulting in broken links on integrated apps.How does everyone else do it with the least amount of moving pieces in the transfer? Do you start a new workspace and get the client to sign up for a paid Airtable account?

Hi - I am trying to do a daily balance and bills owed table and am wanting to match expected income so that the dates match. Ideally it would also have a daily exchange rate. I am just not sure how to match and roll-up based on varrying criteria without needing a new column for each date. How do I do this? Do I need a third table?

Hi, I have a large table with many columns. But some columns are empty whilst some are full and this differs from a row to row. Is there a way to view single row that it would show only those fields which have some value in it and do not show empty fields? As to have a simpler view of the information. Thanks for suggestions!

Hi! It seems like the OAuth refresh flow randomly fails for no apparent reason even though nothing has changed. It doesn't happen predictably, it's quite random and this forces our users to re-authenticate Airtable which is a lot of friction. Has anyone else experienced this or found workarounds?Thanks!

i'm tryng to create a record in a table from base "B" by running a scritp from base "A"but how can i get the table from base B in my script that is in base A?

I'M TRYING TO UPLOAD PDF FILES TO AN AIRTABLE BASE USING PYTHON, BUT I'M FACING ISSUES WITH THE PROCESS. I'VE TRIED MULTIPLE PYTHON LIBRARIES, BUT NONE OF THEM SEEM TO WORK CORRECTLY FOR MY USE CASE. Here's the code I've been using (replace with your latest code snippet): import osimport globfrom airtable import Airtable # Configure Airtable connectionairtable = Airtable('base_id', 'Table 8', api_key='api_key') # Path to the folder containing PDFspdf_folder = r"C:\Users\camip\Desktop\_adjuntos_prueba" 

Hi. In the past week, I started getting random "[500] Server error" when calling various Airtable modules via Make. No other information is provided. If I retry the scenario, usually then it works.Any idea what this could be? Could it be that I'm hitting some kind of limit? According to this page (https://airtable.com/developers/web/api/rate-limits), it says the error code in case of a limit should be 429 not 500. Screenshot below shows an example of the error. Note that it is not happening only on one type of module like 'Update a Record', but even say 'Get a Record' or Search.

My goal is to create a single automation, that checks multiple separate fields and if they contain values, process separate actions.For example, if a new record is created and there are values in the field weight, then update the weight field of the linked record. If a new record is created and there are values in the location field, then update the location field of the linked record.Now the statements follow an IF -> ELIF (Otherwise if) logic, therefore if a new record is created and both fields (Weight and location) are not empty, only the first condition is fulfilled and the automation stops. In this case the weight would be updated (matching the first IF condition), but the location would not (because the first condition was fulfilled).My workaround for this has been creating first a field that checksIF weight AND location have values, update both,ELIF weight has values, update weightELIF location has values, update location

¿Como puedo hacer para que despues de guardar un archivo, sea descargado en mi disco local, utilizando PyAirtable?El siguiente codigo muestra el comando para guardarlo, pero ¿Como puedo descargarlo mediante PyAirtable? archivo='https://archivos.ujat.mx/pagina2020/index/divisiones/dacsyh.png'#Ingresar Datostable.create({'id_division': 'DAViS',                    'nombre': 'Division Academica De Soporte',                    'ubicacion': 'Cunduacan',  &nbsp

A few months ago I received an email from product@mail.airtable.com descibing changes to handling of dates and timezones in scripting. Do I recall correctly? Can someone point me to the info it described? I’m still doing manual timezone adjustments in scripts but think this new feature can handle it properly???

I've created a Grid View in my base, and created a specific order by dragging and dropping records (not using a Sort condition). When I share the view, the order is preserved. When I add the view to an interface, the order is NOT preserved. What are my options? Is this a bug that will be fixed? Is there an easy way to create a priority field of some sort instead that will auto-change when I re-order the records based on changing priorities? 

I have 2 bases (Payments and Ledger)And on Ledger base i have a sync table from Payments baseI'm making a script that runs on a table in the Ledger database. This script will create a record in the Payments base and then link that record to a table in the Ledger base.But I'm having problems because the synchronization table has a different ID and recordID than the original table in the Payments base.If I pass the recordID from the Payments base to link it to the table in the Ledger base, will that work?

I have a fields called Due date and I am looking to highlight/color the value of this field. ( this is a date field not a single select or multiple select)Is there are way to only color the value of that fields ( not the row )

Hi,Somehow Airtable doesn't understand my dates as dates so grouping goes wrong. In an interface I have a list of booked events that I want to be grouped by their date. That way, I can easily see day by day how many events are booked. The grouping column is based on a formula picking out only the date from another column where the full date/time is stored.As a European I prefer 'DD.MM.YYYY' as the format, so my formula to give only the date is:DATETIME_FORMAT({date/time},'DD.MM.YYYY')This gives me visually 27.5.2024 for May 27, 2024, which is what I want. The grouping result, however, becomes like this:02.06.202414.06.202422.05.202428.5.202431.5.2024Grouping is apparently performed on the first digits, not as dates.Why doesn't Airtable understand a date that is only formatted into DD.MM.YYYY as a date?Rgds,Björn

Hello,I'm looking for a way to filter records dynamically similar to currently available options "Current user" and "Current user's email". What I have in mind is a formula field in the database that outputs something like "@acme.com", "@company.org". Then, in the interface designer I would like to set up a filter that filters all records and shows them to the user of this domain. A similar feature is available in forms sharing permissions, where I can share a form with users from the specific domain.Thanks to this feature, I could have one interface with dynamic filters, where the user with email ending with "@acme.com" would see all records associated to this company.The current workaround would be creating separate interfaces and sharing them with the necessary users, but if I'm providing services to multiple companies and want to implement some changes or upgrades to the interface, I have to reproduce it in all the separate views.

Working with birthdays where I only know the client's Month/Day and not their Year of birth.  So text field is 5/12 for example but I'd like to have an actual date of 5/12 so I can set up reminders 5 days before the actual birthday.  I used the following formula but it's not working correctly.  DATETIME_PARSE(Birthday, 'MM/DD')Thank you in advance

We see that from last three days we are frequently getting 502 Error in spite of no changes on the URL and how we retrieve the data from airtable.It's even seen that Api calls are working for some time of the day and failing for some cases.We would like to know from community what and all trouble shooting can be done.Troubleshooting done.1. Called the API locally and it's working fine.2. Checked the number of calls as well its well in limit only of the Teams subscription.

So let's say I have a table that is going to have different numbers in rows listed in a single column, like below.2331618And in another table, I have some ranges filled into two columns, with a min column and max column, and a third column with a name, like so below.0-10 Sally 11-20 Joe21-30 Bob31-40 JaneNow how do I have the first table use the second table to evaluate a number to determine which range it fits into so that it can show me the name in the first table?23 Bob31 Jane6 Sally18 JoeI'm OK with formulas prior to this need, but now I am totally lost. I don't know if I am supposed to use rollups, lookups, linked tables or what. I've never linked tables before and I need a guru to translate my need into something that gives me a clue on what to try. 1st time here on this forum.It's like I want to say "see which range my number fits into and display the name for

Hello,I need help ☹, here a the scenario :"Real Estate" table has several fields (A1,A2, A3=( link(recordId of the "owner" table)), the "Intervention" table has several fields (B1,B2, B3=(link(recordID of the "owner" table) "Real Estate"), B4=(Lookup(recordId of the "Owner" table which is linked to the "Real Estate" table), B5=(link(recordID of the "Owner" table), . list in field B3 based on the equivalence between fields B4 and B5, and integrate this new list into a new field. Do you have any ideas for a formula or automation?I'm building an app with softr and airtable, i'm an owner and i want to create some cleaning intervention in my homes with a formula.   i would like when i whant to create a new record "intervention" with a formula, only show   the real estat list that belong to the owner (me) not all the list of real estat in the database.

Hi I cant get Airtable to load today. I cant get to my boards or even onto www.airtable.com. The page is just white!!! HELP!

HiThis must be possible!?So I want to populate an Airtable from a Softr.io front end? I want users to be able to create records.As part of the user sign up process, I will capture their address/location.When they create a record, I want airtable to populate a field with location. This location should be pulled from the user record.Does that make sense?