Ask the Community

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

¿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

Hi guys!I am using Record Templates to auto-populate long text fields in existing records, but it doesn't seem to be working. I have a bunch of long text fields that I want to have templates for to auto fill them out when a project hits a certain phase. A manager will hit a Apply Template button on an interface to apply the template they want to a project. Current it only changes a single select option I have in the template. Do record templates not work with long text fields? If so does anyone know of a way to make this work? Thanks!

Ever since personal token system came in Airtable, my data is not showing in Kodular. I have tried everything, tried putting personal token instead of api key but got no result, can't understand where is the problem. 

I have created a base to track various components of our commercial kitchen operation.I have bases for Menu Items, Prep Items and Ingredients.I have created various columns for the quantity of ingredients for each dish and need to roll them up into the quantity of ingredients in total for a given period, using sales data.Because there may be multiple meats involved in a dish, I have created separate groups of columns with Qty Meat 1, Single Select Meat 1 and a formula column that multiplies Qty by average weekly sales. I need to roll this up into the meat table so that we can calculate the total quantity of each meat we use per week using a formula to sum the four columns for each meat.This all works fine for the first meat, and works fine for the initial calculations for the remaining columns (to Meat 4).However, when I roll up these columns to calculate the total, the second, third and fourth columns are grabbing the Meat single-select from Meat 1. The total quantities for those colu

Does anyone know of documentation that has an example of creating each field type using Node.js?There are certain field types I am running into issues with such as date fields and currency fields and I can not find much documentation of when an example for each field completed looks like.

I've done a lot of searching and tried a variety of suggestions but I can't get this to work.  I'm trying to make the viewing of record details in an interface very intuitive for the user.  Here is what I've tried:1. Button Field URL Formula: CONCATENATE("https://airtable.com/appxxxxxxx/pagxxxxxxxx" & RECORD_ID()) and CONCATENATE("https://airtable.com/appxxxxxx/pagxxxxxx?detail=" & RECORD_ID()) 2. Created a URL field that contains variations of the URL shown above in #1, along with a Button field that references that field in the formula.3. I found some information that suggested how to get the URL of the record detail view in an interface, but the format of the URL looks nothing like what is posted.  This is the format I read that I'd find when I got the URL of a detailed record view: https://airtable.com/tblXXXXXXXXX/viwXXXXXXXXX/recXXXXXXXXX but this is what I get instead: https://airtable.com/appxxxxxxxxxx/pagpxxxxxxxxxxx?de

Hello. I am having issue with my formula returning errors instead of 0. I tried using adding If to the beginning of the formula and also the ISERROR but nothing is working the way I need it to. My formula is returning 1 if Purchase Close Date was last month. Below is what the formula currently looks like. Thanks in advance for any help! DATETIME_FORMAT({Purchase Close Date}, “YYYY-MM”) = DATETIME_FORMAT(DATEADD(NOW(), “month”, -1), “YYYY-MM”)

One of my tables is “Accounts” and it has gotten really wide (40+ fields) and growing. (Name, ID, Address Complete, Address1, Address2, City, State, Zip, Phone, Fax, Comments, Attachments, COD status, Credit Terms, Tax Exempt, Tax Exempt Number…) I’ve backed up the table and started playing with linking sub-sets of account information in multiple tables (a 2nd table for Address information, a 2nd table for Credit/Billing information, a 2nd table for interests/category information… so each table can be limited to 15 or fewer fields) What are the pros and cons of wide tables? The way I see it, going wide is: Pros: Everything can be entered in one record (I don’t need to go to multiple tables and re-type the account name to continue entering information) No confusion over whether the additional records have already been made in the additional tables Can use custom views to make the data more visually manageable Cons: Googling DB vs Spreadsheet makes me think that DB’s are supposed to