Ask the Community

I’m trying to move a tool my organization uses from excel to airtable.Previously, we would update a data sheet in excel with components, and their individual unit costs. On another sheet, someone could enter the component name (ie, “widget”) and they’d excel would calculate the average cost of that component across the data set OR let someone know it’s not a component we’ve ever used. I’m okay with the “widget” query also returning results that include widget, such as “long widget.”Is there a good way to do this in Airtable? Am I wrong to think an interface is the best bet?

Where in Airtable do I look to find how many emails have been sent per day? And is it every 24 hours or per actual day?

Hello, I want to front load that I am annoyed and have been frustratingly trying to brute force this for two weeks with no luck. This is meant to be read with a neutral tone of voice.My issue: I operate a small nonprofit and have hit a brick wall trying to get airtable to work for what we need it to do. We have a beautiful form that we created, information populates great, but printing the completed form is impossible. I’ve tried creating it with the design tool, but that doesn’t work at all (it’s broken, we can’t even create something to test it), and we can’t afford to pay yet another company hundreds of dollars to do this for a platform that should have it built in.I’m surprised and rather irritated that this simple thing isn’t included in the pricetag for airtable… I have a staff of 5 and a minuscule budget. I can’t afford to pay multiple organizations to do something that we were told was built in. This is literally the only reason we went with airtable over other platforms, and n

Hello there,We have been thinking about how to approach this, but it seems we are unclear about the options or simply don’t see the solution.We are creating a base designed to handle multiple tenants.Tenants must be able to view and edit only the records linked to them. Additionally, we are facing a challenge when linking new records, as it appears that the records must be manually assigned by selecting a collaborator (i.e., current user filtered view).That’s the general overview.Key questions: Beyond linking collaborators to the current user, is it possible to associate users with a group and dynamically use that group to filter views in interfaces? Does the Portals feature provide the functionality we need? Since there is no trial, we cannot validate it ourselves—perhaps someone else has insight into this? (Note: Yes, we are aware of alternative solutions for Portals, but we haven’t explored them yet.) If we use multiple bases, can we route a Portal user to a specific base with i

I can’t be the only one who finds the edit field dialogue box for single and multiple select fields outrageously small, can I? If we have two or three dozen options, or even more, how are we supposed to manage them when we can only see three or four at a time? Is there an extension or something that helps with this?  

Hola a todos,Tengo una automatización que se activa cuando el campo de la casilla de verificación "Asignar o actualizar" está marcado. Funciona bien la primera vez que se marca, pero el problema es que este campo se puede marcar y desmarcar varias veces (ya que se esperan actualizaciones regularmente). Me he dado cuenta de que, aunque la casilla de verificación se vuelve a activar (se desmarca y luego se vuelve a marcar), estos cambios no se registran de manera consistente en el historial de revisiones y, como resultado, la automatización no se vuelve a activar.¿Alguien ha experimentado esto antes? ¿Existe una limitación conocida con los cambios de casilla de verificación que no se capturan como actualizaciones, o una solución alternativa para garantizar que la automatización se active cada vez que se marque la casilla?¡Gracias de antemano!

Thanks @openside for your famous post "New Script: Same Table Linked Records Backlinks".Is there a way to use this in automation so that whenever the Parent task is updated, the child task runs? How would you need to modify the script?

Hi Community,Is it already possible (with a workaround) to set up your own programmed OpenAI assistant in the automations? I see the different LLMs listed but not yet the option to connect to your own assistant.Anyone have a solution for this - would be super valuable

Hi all. My first question on the Community forum, so please bear with me. Now that Airtable has added a Find Record action in automations (Yay!), I am wondering if anyone has figured out how to create an action in the event that a record is not found matching the criteria. I have found a need for this automation a few times. To give one example, here is a summary of a scenario: I have two tables - an “All Contacts” table and a “Submitted from Form” table. When someone submits their name, phone, town, state and email address, that info goes into the “Submitted from Form” table. When a record enters the “Submitted from Form” table, I want to search the “All Contacts” table to see if any record has a value in the email field that matches. If there is a matching value, then I want to update the record in “All Contacts” to the current info for the other fields. [So far so good, using the current/new automations] If there is no match, then I want to create a record in “All Contacts.”

Hello - I've searched the discussions, but found no resolution to this issue - to display my database addresses on a map, I have to convert the addresses to GPS coordinates, which I've done - now to re-integrate the new columns with the coordinates into the Airtable base, I found the CSV import extension, which would work great... however, the option to merge by Record ID is not available, and I have no other way to merge them. We have branches of organizations with the same name multiple times - how can I get the same functionality but matching by Record ID?

Hello, my airtable is used within data within a project management platform I built in sotfr. my client portal users enter data via a softr modal which lands into the airtable and a softr table view that displays the entered data. I need each entries of by user to be auto-numbered from 1 to whatever the final entry is.For example if the data represented a christmas wishlist, and little bobby entered a “toy truck”, “building blocks”, and “book”, I need the list to show:toy truck Building blocks bookAnd if little tommy entered “Basketball”, “ipod”, and “ball cap” the list should be basketball ipod ballcapThe number needs to be hard coded to the entry, so that when the list is sorted differently the number follows along, for example, if I sort little tommy’s list within the softr presentation layer alphabetically the list should be:3. Ballcap1. basketball2. Ipod So how do I assure that the user’s entries are getting numbered automatically and the numbering range is limited by the scope of

Sometimes we have URLs that include "?" for example www.mytravelsite.com/deals?destination=florida. Its best practise when adding UTMs that if a url already includes a "?" then the UTM should start with "&" instead. The below is the expected outcome of this.www.mytravelsite.com/deals?destination=florida&utm_source=Offsite_P195&utm_medium=Patnerships_Video&utm_campaign=VisitFlorida_Sep-Oct2023_YouTubeThis is the formula i have attempted to use.IF(FIND("?", {Landing Page (from Campaign)}), CONCATENATE({Landing Page (from Campaign)},"&utm_source=",{Source (from Product)},"&utm_medium=",{Medium (from Product)},"&utm_campaign=",Name), CONCATENATE({Landing Page (from Campaign)},"?utm_source=",{Source (from Product)},"&utm_medium=",{Medium (from Product)},"&utm_campaign=",Name))This is what its returning, which is incorrect. www.mytravelsite.co

Hi guys, I’m trying to find a way to insert a formula that calculates the expiration date of leases based on the commencement date and the number of months that the contract is for. So far, I have this: DATEADD({Commencement}, {Term (mos)}, ‘months’) This calculates the expiration date almost perfectly, but I need to find a way to take one day off of the formula. A 12 month lease starting on 03/01/21 would return 03/01/22, but the expiration would actually be the last day of February, not the first day of March, if that makes sense. How can I get the formula to subtract one day from the result? Thank you!

Hello!Does anyone know why I can’t simply download a file from my interface? I have an audio file and can’t locate a button to download the file to my local device. It feels like this should be simple - am I missing something?Can’t locate a download button for an interface attachment fileThanks!

Hey. I'm new to Airtable because the person previously in charge left suddenly. I think my question is regarding Historical Viewing in Airtable. In an Interface, is it possible to look back further than 30 days ago? I am able to look ahead 10 months but can only look back 30 days. Is there a simple way to do this, or do we need to upgrade our plan to unlock this feature? Thanks.

I am using Airtable with a new nonprofit. One of my bases is all about the Volunteers. I have successfully set up the tables to track contact info, training completed, hour tracking and more. I was even able to figure out how to set up a form for the Volunteers to fill out using a wall mounted iPad to do the data entry themselves for their hours worked. On that form, they are able to choose their name from the existing list because I have linked it to the main table. It works perfectly and allows me to create reports to track hours by person, role, date, etc. But then my boss asked that we have a photo for each Volunteer attached to their information in AirTable. OK. I can do that with an attachment field. But then I decided that I wanted the Volunteers to do that data entry as well. So I created another form that works satisfactorily and allows them to use the same iPad to take a photo. They have the ability to choose their name because it is linked to the main table, and then do an

I’ve created an automation that uses the Google Docs integration to create a report. Records found by the automation are added to the GDoc in grid format. Unfortunately, each grid tops out at 10 records in the GDoc, even though the Find records actions have a limit of 100 records. Any ideas?

Is it possible to make a form that requires authentification in order to make sure that “Created by” is populated when the form is submitted?

I have a table with a list of articles that need to be written. The fields on the table are; article id, article progress status, author, drive link, Article title, Guidelines and deadline. I have created a sharable view with which my writers can see which articles they are assigned to and the necessary details without signing in. I collect the articles via a form where they submit the drive URL and the article id with a status (writing done) Problem is, when they submit the article it always creates a new record and I have to manually transfer the URL and change the status to the original record and delete the row that has been created by the form. Is there a way, to make it possible that the writers can submit the URL to the original record and change the status? without signing in.

I need external parties to update existing records. I have successfully created a second base that serves as the receiver of the updated fields. I accomplished that by creating a form in the second base and using the URL from the form to create a formula field in the first base that will pass a record identifier to the second base. The URL works well and the record identifier from the first base shows up in the new record (RequestID) in the second base to match the record being updated from the first base. My problem seems to be with the automation. I am using when the form, from the second base, is submitted to trigger the automation. I then added update record to the automation. Based on a video covering the topic by Julian Post, I list the second table called New Update as the Table in the configuration. I list RequestID from the second table as the Record ID. For testing purposes, I add just one field in the Field section. I set it to dynamic and map the corresponding field wi

I am using Airtable for volunteer sign up for an event and wondering if somehow I can add the liability release form electronically. Has anyone done this before within forms? We need a signature and what not so I don’t know if there’s a way to add an attachment they can type in and then that would save on my end. Any suggestions appreciated.

Hi everyone, I’m new to using Script in airtable and was using ChatGPT to help me write my script. Basically, I want the script to read my table (titel is Workshop registration) and when people register, they can click on as many workshops as they want. The script was to then separate the 1 registration into multiple, and it worked! However, I changed one of the columns from single to multi-select and it messed everything up, including the set up. It also just started to bug out a lot. Do you guys know what I could do? I’m not a coder at all and was primarily using ChatGPT to help me write it. 

Hi, I’ve been using Airtable for a few years and a heavy automation user with Make.com and Zapier. However, I don’t have any programming experience whatsoever.The script is used as one of the steps in my Airtable automation. I’m in need of a script that:Takes a value from a field Multiple that value by -1 (negative 1) Return that value as input for the next step in my Airtable automationI’ve just started online course on Javascript, but this course obviously takes time and I need the script right away. It would be great if someone can help me out with this so I can implement it right away. From my online course, I know that the code should be straight forward enough even for someone with basic command of Javascript.Thanks!

Hi, I would like to create a fitness tracker for our climbing team. I periodically test our athletes (ie, vertical jump, shoulder strength, etc). I would like to track each athlete’s test scores/numbers, enter that information into airtable and have the ability to track each athlete’s improvement for each fitness test. One test is the vertical jump. I will need to test their standing reach and then standing jump. Ideally, I want to enter standing reach every so often (not every test) since the kids don’t grow that quickly. But I want to update standing jump every time we test. How do I enter standing reach into airtable and be able to retrieve that for future tests? I would like future tests to record standing jump but then reference standing reach in order to calculate vertical jump (ie, standing jump less standing reach). Thoughts?

I want to create a table in my send email automation because there are several features that I want to put in the email and formatting as a table makes it easy to understand. I tried creating a table using markdown and HTML but it isn't working.