Ask the Community

Thanks in advance everyone - Tried searching but couldn't find anything recent/relevant Currently we are using email automations to conditionally send first articles to our customers to approve, which works - but I'd like a more elegant solution. In an ideal situation, once a record matches certain conditions, it sends a form (interface or other) pulling the image from our base, and the customer can use a check box / comment section to send approval back to us - and updates our records with the checkbox selected and or comments sent.Thanks again - If I missed anything in my search, another advanced thank you for pointing me in the right direction.                                                                   

Hi all,The Utilization function is pretty great for visualising workloads and capacity, but when adding in the 'Time Off' part of the tool, I'm struggling to get exactly what I'd like.My Capacity planner is a timeline view of tasks grouped by team with all team members' capacity rolled up to the team level. This is great as I can see an entire Team's capacity when adding in new jobs.  However when I assign time off into the 'Account for time off' section it just blocks out the entire team as PTO for those dates on the planner. I don't think it can just subtract member X's time off from the total team capacity. Does the Account for time off functionality only really work when you are viewing capacity at the Team member level?Any ideas much appreciated!

I saw this video on using air table for schools, and tried to copy the design she talked through at the end - but since it was all in groups and I am pretty new to air table, I couldn't get the automations to work, or see how the grade and assignment tables were actually set up.Does anyone have a base design for recording assignments and grades for students - something where once the assignment is created student record lines are automatically created for the students in that assignment's class  in the grades table for scoring data to just be added?This is the podcast I watched and really failed to imitate - https://www.youtube.com/live/Z3vdf9INifY from 46 minutes onwards. 

I have the following TS code (using the Airtable REST API) export const updateInstanceQRCode = (instanceId: string, qrCodeUrl: string) => { return base('Instance').update([ { "id": instanceId, "fields": { "QR Code": [{ "url": qrCodeUrl }] }, }, ]); } which works great when I am testing in development, but the moment I try to build the project, I get the following error: > tsc -b && vite build src/externalAPI/AirtableClient.tsx:127:21 - error TS2739: Type '{ url: string; }' is missing the following properties from type 'Attachment': id, filename, size, type 127 "QR Code": [{ ~ 128 "url": qrCodeUrl ~~~~~~~~~~~~~~~~~~~~~~~~~~ 129 }] ~~~~~~~~~ Found 1 error. In my package.json, I'm using the following version of the official airtable module: "dependencies": { "airtable": "^0.12.2", This definitely seems broken, especially c

Is it just me or is anyone else having trouble with api calls on interfaces?Get / Delete / Add workspace or base collaborators work perfectly fine. But seems like anything to do with interfaces in not found. The below specifically.Even putting the URL directly in my browser gives 404, instead of a permission error. Anyone else? 🤔 🤔Get interfacegethttps://api.airtable.com/v0/meta/bases/{baseId}/interfaces/{pageBundleId} Delete interface collaboratordeletehttps://api.airtable.com/v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators/{userOrGroupId}Add interface collaboratorposthttps://api.airtable.com/v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators

Hi,  I am very new to AirTable but have a lot of relational DB experience years ago, using first dBase, then MS Access.  I am working on a simple project for my golf club that calls out for a RDB solution.  I have started learning AT, but am stuck at a very basic level. Can anyone please advise?  I have read countless posts and watched videos and I somehow feel I am missing something very basic.Here is the problem simplified down to the most basic level.  I have two tables, Members and Rounds Played.  The fields in Members are their unique Member ID first, then lots of Member details, like name, address, phones, etc.  Rounds played has three fields.  The first is the Member ID, then the month, and finally the # of rounds played that month.  From my background this is a pretty easy 1 to many relationship, the tables linked by the Member ID.   In my old world, Member ID would be the primary key for the Members Table, but I have learn

I have an automation that runs based on the trigger, when a record is created.  This automation runs perfectly in all tests.  However, when I run a process that creates 5-10 records within 2 minutes, the automation does not run for all records.   This clearly tells me that the Airtable infrastructure cannot handle even the smallest volume.  This is deeply concerning.  I would not expect an automation to run into volume issues until the volume was over 1000 a minute.Has anyone else seen this similar poor performance from Airtable interfaces?

Hello there, I'm trying to write data from one base to another through Airtable's API. My JSON is something like this:  let body = { "fields":{ "prod_serv_cia_id": inputConfig.cia_id[0], "NroParte": inputConfig.codigo[0], "DescripCorta": inputConfig.descrip[0], "DescripLarga": inputConfig.descrip[0], "Marca": inputConfig.marca[0], "Cantidad": inputConfig.disp[0], "Costo": inputConfig.costo[0], "AlmacenesScript": inputConfig.cia[0], "StatusProducto":[ { "id": "selq********yr", "name": "1. Producto seleccionado" } ], "typecast": true }, }  And the response I'm getting from the Airtable's API is:  {error: Object} error: Object type: "INVALID_VALUE_FOR_COLUMN" message: "Cannot parse value for field StatusProducto"  The "StatusProducto" field is:  {id: "fld*******j9", name: "StatusProducto", description: "", type: "singleSelect", opt

Hi all,I have an Airtable built that collects info for upcoming events. I've created a filtered view, that only includes Confirmed events. I want to add the ability for staff to sign-up to work at these events, so I've created a form view. I want the first question of the form to be a single select, where the staff person selects which one of these events they want to work. Is this possible? So for example, I'd like "Event 1", "Event 2", etc. to be the options staff select in the form. Then in the grid view, we'll have a new column for staff that have signed up to work each event. Hopefully that makes sense.

I am trying to generate a formula where:1. If date in field x is greater than 1953, then 1 is put in field zOR2. If checkbox is checked in field y, then 1 is put in field zI came up with this formulaIF(OR({NO DIGITAL} = 0), ({CODE-DATE} > 1953), "1")However, this is producing a statement that reads 'true' if {CODE-DATE} > 1953, and '1' if {NO DIGITAL} = 0 (that is to say, box in {NO DIGITAL} is checked)Any idea why this is happening or how to get the results I want?

Wondering if anyone has managed to sync MySQL data into a Airtable base? What we are basically trying to do is sync a SQL query data to Airtable - this is currently done manually multiple times a day and imported to Airtable base. Has anyone done anything like this or are there any 3rd party solutions out there? Thanks in advance :slightly_smiling_face:

Hello! I have a formula to count how many workdays are left between a data and “today” and when the reference data is “after today”, the output returns a negative number (as it should). I am looking for a way to get my formula to only return “0” when that situation occurs. I haven’t figured out the nested if statement logic to make it work. Does anyone have a solution to this? Thank you!

Hi! I am trying to summarize a range of fields from one record. I know that there is a formula Sum({Column 1}+{Column 2}+{Column 3}…). However, I am looking for a formula to choose all the columns between Column A → Column X. I will have a database with many columns and I need to summarize multiple records quickly. Is there any formula that can help? Or what are the possible solutions for this? This is an example ! Thanks for any help!

Hi there,My company has several different interfaces that have more or less the same table in them, just filtered by a different project name. In the past, users (editors on the interface but no database access) have been able to duplicate these records without problem.It seems like there has been a change with how Airtable now handles filters, access, and record duplication. Now, when the user duplicates the record, they get a permission error that tells them that they don't have access to that record. If a user with database permissions (e.g., db creator) duplicates it, there is no problem. It's almost like the filter is being applied before the duplication is complete.A couple other observations: this only happens if the field used for filtering is not included in the table itself. Again, historically this has not been an issue, and it has duplicated without problems. If I add the field not to the table but just as a grouping value, this also mitigates the problem.Has anyone else en

I have a field generating an email for each person on a list: CONCATENATE( {First Name},".",{Last Name},"@Gmail.Com")  This formula creates a First.Last@Gmail.com list in my "Resource email:" field.The issue is, when I create an automation to send an email to the "Resource email:" field, it throws an error, showing that the email it read for that field was just ".@gmail.com". It's not detecting the first or last within the automation. The automation is set up as "when a record is created"  currently as well. Any help on getting the email field to read correctly? 

This would be really useful for transparency when dealing with large lists / dashboardsSimply pop up a list of what records are being counted. 

Hi! I'm not sure which location to post this in but hopefully someone can help out. I have an interface form which will be collecting question answers prior to a client call. During the call we then want to be able to access and comment on each answer individually as we get clarification from the client. We can obviously have a "notes" column but that would be for the whole record, whereas we need a notes section for each answer (so for each column in the table basically, and it would be incredibly clunky if there was one notes column added after each question column). We then want another 1 or 2 interfaces or tables (or whatever) which again pull in question answers plus our clarifying notes to put next to some other info on post-call actions.I'm new to interfaces for anything other than form creation, so I tried creating one from scratch which had a record selector at the top then all the answers down the left hand side, then I added a "text" element next to each - not realising that

I'm developing an api in which Airtable will request information, I was configuring cors for the api to accept requests from airtable, but I don't know which domain they use

HelloI'm looking for some assistance with my base design. I come from a SQLServer background and can do this easy here but not getting the best way to build for AT...The ScenarioI have a list of users and a list of products.  It's collectibles so I want to be able to know what users have what products, and more importantly which don't they have.In SQL I'd just create a UserProduct table and pretty much create a record for every user for every product and just record it there (not hugely scalable I know but not a big issue).In AT I already have the two base tables Users and Products.  I know once I have the base data I can create Got/Not Got views easily but that base table is baffling me - probably over thinking!!!I'm sure it's easy but I'm just not getting itTIAMike

I'm new to airtable but i keep running into the same issue that when you try to link a column to another base (to effectively do what would be a vlookup in excel) that when a link is found the value of the cell you are linking from is displayed but if no link is found its empty. Is there a way to overwrite this behaviour so that the value still is still displayed despite no match?The value is still being recorded in the table as the links will sync if that value is added to the looked up table, it's just not shown when a match isn't found.

Hello,I need to send a csv file to my email when a record matches a condition. I was hoping simple scripting would work, but it seems like this is not yet doable with native Airtable tools. I saw in a previous post that someone suggested to "use a script that creates the csv or Excel file using the CloudConvert service (or another similar service) and attaches the csv file to a record". I will only need to do this max 25 times a day, which it seems like CloudConvert offers for free. I would like to try to make this process free. I tried setting up an API key on Cloud Convert but my script is saying it is unauthenticated. Is anyone familiar with how to set this up? 

Hello Community, I need help with one task that should help us save lots of time. We have two tables with attachment field in both tables. One table is called Appointments where we upload an invoice in the attachment field called "Invoice" and another table is called "Contacts" where we store all invoices in the field "All Invoices" for a certain contact. What we are trying to do: When an invoice added to attachment field in "Appointments", we want a copy of this invoice to automatically go to a dedicated attachment field in "Contacts". When I try Gemini AI help, the answer was like this: Airtable doesn't currently offer a built-in way to automatically copy attachments between fields when one is updated. However, you can achieve this using a combination of scripting and automations. Here's a general approach:1. Create a script that loops through the updated record's attachments and copies them to the desired field.2. Set up an automation triggered "when a record is updated."3

I have the following piece of code in an automation.      plantingsWateringsRecordId = await plantingWateringTable.createRecordAsync({ "Watering": [{ id: recordId }], "Planting": [{ id: planting.id }], "Crop Picker" : {name: planting.getCellValueAsString("Sort Name & Category")} })     The Crop Picker field is a single select field and I want it to expand the selections if the value passed in is not already there. It appears that this can be done using typecast:true but I can't for the life of me figure out where to put it. The documentation is not very clear about this.Any help would be much appreciated.Thanks

My team's work involves tracking and acting on various publication editorial calendars. For example, if a publication is covering [topic x] in January, we like to be able to see that in a spreadsheet and act on it. Currently we collect hundreds of these kits and enter them into Google Sheets separated by month tabs for a full year for each publication. My question is whether an Airtable interface or forms could be set up to make that entry a little easier? Plus maybe make for a more pleasant viewing / sorting experience? I don't have much experience with Airtable interfaces and I couldn't find a similar solution when I searched around.Essential elements: -Ability to enter editorial calendars which include month and associated topic, deadlines associated with each month, and publication name. Ideally also the ability to link publications with specific clients to indicate relevance. Additionally ideal to import editor and other relevant contact info and link it to the publication.-Abilit

Im trying to build a marketplace of sorts that connects wholesale suppliers to store-fronts, and then in turn to retail customers. I'm just not sure how to do this with linked records.I want to have one base that houses all the information about each supplier as an individual record.I want to have one base that houses all of the information about each store front.I want to have one base that houses all of the information about retail customers who sign up for this service.I want to have one base that acts as a primary product database. This will link the manufacturer / supplier and the store-front through two linked fields for each individual product as its own record.Lastly, I want to have a primary order database so when orders are put in they're created as new records in this base and link the store front, products bought there, and the customers who bought them.That all seems easy enough.Here's where I'm starting to run into some trouble and need some help:When I build the front en