Ask the Community

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" # Get a list of PDF files in the folderpdf_files = glob.glob(os.path.join(pdf_folder, "*.pdf")) for pdf_file in pdf_files:try:# Get the name of the PDF filepdf_name = os.path.basename(pdf_file) # Extract the number from the file name by removing the extension and converting to intpdf_number = int(os.path.splitext(pdf_name)[0]) # Get all records from Airtablerecords = airtable.get_all(view='Grid view') # Find records where the name contains the

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 locationHowever this does not scale very well if I want to che

Hi, Does anyone have a working integration, where stock prices are automatically (eg timebased refresh) fetched into an airtable sheet, depending on eg ISIN, etc. I just found quite old posts and only one newer video (How to Track Stocks in Airtable - YouTube), but the script link in the video is outdated… So any help with providing a script, etc. would be highly appreciated. thanks a lot, Chris

¿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',                    'documento':[{'url': archivo}]})

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.Could this be put on the feature roadmap? &#128

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 me".My actual real-life problem is of a larger scale where I have close to a hundred ranges, not four like I have i

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?

I have a JSON array in a field called 'Output' in a table called 'Assessmnt converter'. I am trying to create new records into a table called 'Submissions test' and populate the data into four respective fields; Question number raw, Question raw, Number of marks raw and Student answer raw. I have created an automation whereby if the 'Output is not empty', it runs the following script. However, every time I run the script, I'm getting the following error:CONSOLE.ERROR"Error parsing JSON data:"▶Error {name: "SyntaxError"}Here is my script:// Load the Airtable scripting environmentlet assessmentTable = base.getTable("Assessment converter");let submissionsTable = base.getTable("Submissions test");let query = await assessmentTable.selectRecordsAsync();let fieldName = "Output";// Iterate over all records in the "Assessment converter" tablefor (let record of query.records) {// Get the JSON data from the 'Output' fieldlet output = record.getCellValue(fieldName);// Debu

Hi, I have an issue with transferring personal credits to my workspace. I just updated my plan to a business one, and now I want to transfer all my personal credits, but it doesn't work. I already resublmitted my card details, still no success. Please sort this out for me ASAP! 

Hello!Have a bit of a challenge and wondering if anyone else has been in a similar situation / need, and how they may have addressed it.Scenario(1) Simplified case: Say I have a Projects table that specifies a StartDate, EndDate, and EstimatedHours. I have one record (Project#1) that starts in JAN and ends in AUG with 800 hours. Assuming a simple linear average, how [would we get Airtable to tell me how] many hours should I expect to spend in MAY?(2) The first complication: There are many projects (of course), each with their own overlapping StartDate, EndDate, and EstimatedHours. How I can get Airtable to report what our total monthly commitment is for MAY? JUN? etc?(3) The second complication: Say there is also a Resources table (i.e. the labour that will be working down the commitments). Each of these records has their own StartDate, EndDate, and AvailableHours (not actually, but simplified for our purposes here). How would I see [and use in other calculations] the result of (2) alo