Ask the Community

We use a form with our database so that students can post pictures of homework. When completing the form, each student inputs her student ID to create a new record, and attaches pictures of homework. The homework is associated with a specific session. The master table of students and sessions includes a unique “student session id”, but students don’t know it (ie can’t input it into the record). I would like to create an automation that is triggered when a student submits a record to the homework table. The automation would look for all of the “student session IDs” associated with that student ID, find the largest “student session ID” for that student (more recent = highest number), and input it into a field in the record. Can anyone point me to a script that would do something like this? Thanks!

I have both the Teams Plan and the Business Plan. Very often I found that Teams Plan is sluggish and unresponsive at certain times of the day. But I don't get that in the Business Plan. Do you also experience the same? Granted, that the Business Plan is 2x the price...

Hi!I'm trying to create a formula to calculate the number of hours between two date/time fields, excluding weekends. The fields are "Completion Date/Time" and "Writer Claimed Date/Time". So for one example, the Completion Date/Time field is 11/7/24 at 11:10am, and the "Writer Claimed Date/Time" is 10/31/24 at 2:59pm. Looking for the number of hours between the two, excluding weekends. Thanks in advance 🙂

I am working on in a table whose purpose is to have all aircraft on market & recently sold as a mechanism to build an MLS type system. I am trying to create an automation to delete a record IF a record that is being imported/create whose MSN matches and the Sold Price was filed where as before it might have been blank (signifying the aircraft was available). For ease of explanation here is a simple table structure to reference. What is the best way to achieve that? The question I have is that is I create a new record (via import of records) and the Aircraft Serial matches one t

We manage a vehicle fleet and to make it easy for non-technical staff to add vehicles, I have created simplified interface forms with just the necessary fields (and some optional ones). This is great for adding one at a time, however often we will be adding multiple of the same vehicle. being comfortable with large sets of data myself, it's easy enough to just duplicate the record mulitple times in a grid view, however for users not comfortable with a grid view, is there a way for me to add a dropdown or number field or something to my interface form that will create a number of duplicates equal to the number provided in the dropdown/number field? Or is there another simple way to generate duplicate records? Thanks for any help in advance!

I want to use a form to allow volunteers to register for upcoming events. Each volunteer can select multiple events. Volunteers may also return to fill out the form more than once, as many of them will return for future events. The volunteers will just be members of the general public, not Airtable users.Is it possible to set up my tables and form to ensure the following conditions are met?1. Each volunteer is listed in the Volunteers form once, with a unique email address and phone number for each volunteer.2. Volunteers select one or more upcoming events from a list of upcoming events.3. Volunteers who return to fill out the form more than once can select other events, but the name and contact information they enter is not duplicated in a new record. Only the new events they sign up for are added to the record that already exists for them.

Hi all! Looking to figure out a way to hide certain options in a Single-Select Field for a form. I run trainings throughout the globe and it’s all tracked via AirTable. The list of training dates is getting rather long, and I would like to shorten that list to available dates for users filling out the form. The only way I can figure to do this is move any trainings older than 30 days to another tab, but that is rather cumbersome to have data points in two locations. Any thoughts on how to best solve this problem?

Hey, I’m a newbie with JavaScript so this might be obvious … I need a delay(ms) method to slow down the script after 5 API calls (limit 5/min.). Problem is all the JavaScript help on the intertube points to the setTimeout() method of the Window object. But it appears that Window is not instantiated inside the Airtable code block, therefore, no setTimeout() method. What’s a good workaround for this? What might I be missing - other methods? Thanks David

Hey, basically I have got a table with important deals and using Record Track extension I managed to create a report with all statuses and prices and etc, however, I can not send it on a weekly basis on email using automation. Any ideas which extension I can use? To generate report and send it to email on a weekly basis.  Thanks

Hi, I'm using automations as a workaround to add more options to a dropdown menu, per Airtable Support's instructions, but it's not working correctly. Currently, a user can select "Other" from a single select and enter the "Other" option in a separate text field. The automation is supposed to pull that text back into the original single select field as a new option in the dropdown menu. Right now it is only pulling the starting character, rather than the whole string of text. I've tried deleting and reconfiguring several times, but it still is not working. I've attached some screenshots for clarity.  Thanks for your help!K

Hi! How are you? I’m new, and I’m having trouble with the average. I want to calculate the average of ao column that will ever grow (each day I’ll add new numbers). But when I create a new column to calculate it, it just repeat the numbers, instead of calculating the average number. I need a field with the Average, to link this field to Dasheroo (and I’ll do that with other fields, to, like the highest rated item in the database). How can I do that? Thanks

Hi! We've created a base with a tab for each project (e.g., Project 1, Project 2, etc.), and within each project, we need to view (in the interface) the payments made, sorted by year. To manage this, we've created a column for each year within the base. However, this setup makes all years visible across all projects, which is not ideal since each project has a different timeline. For example, if Project 1 runs from 2022 to 2025, I would want to see only those years on that project's page, and not years that apply to other projects (like a project spanning 2008 to 2025).In the interfaces, we have different tabs for different projects (e.g., charity projects), but currently, we don't have the option to filter the years so that only relevant years show on each project’s page. Is there a way to display different years per project within the interface, rather than having all the same years appear across all pages?Thank you! 

Hello!I'm looking to have a daily email automation run with a list of Found Records. I'd like the subject line of the email to have the current date. I see that I can add in a List of the Dates for the Found Records, but...it will show the date for EVERY record, rather than just one instance. Is there a way to suppress that to only the first instance of the date so that my subject line doesn't read "Daily Attendance Log DATE DATE DATE"?Thanks in advance for any help! 

Hi there -  I am attempting to track contract breach status (pending, resolved, or n/a) depending on the source of the breach and whether there is a specific response date. My formula will be 5 if statements, of which 4 are also if/and. I've been able to add the first two successfully but when I try to add the third, nothing happens. Any help would be most appreciated! Thank you in advance! If source of breach = avoidable loss, “n/a- avoidable loss”If source of breach = notice of agreement & noa received date >1, resolved otherwise pendingIf source of breach = repayment overdue & resolution date >1, resolved otherwise pendingIf source of breach = ownership transfers & resolution date >1, resolved otherwise pendingIf source of breach = miscellaneous >1, resolved otherwise pendingIF({Source of Breach}="Avoidable Loss","n/a",IF(AND({Source of Breach}="Notice of Agreement",{NOA Received Date}>"1"),"Resol

Hello Airtable Support, I’d like to know if the following HR automation is possible: Our goal is to streamline our interview scheduling workflow. Once we decide to interview a particular applicant, we’d like to send them an Airtable link. On that form, they should be able to: Book an available interview slot. Upload their resume. On our end, we have several roles, each with designated interviewers. The idea is that when an applicant selects a role from a dropdown menu, a calendar appears showing the available interview slots specifically for the chosen role. This calendar would need to sync with each interviewer’s availability. Is this feasible in Airtable? Thank you!

Hi all,I'm using:Airtable as the main databaseFillout connected to Airtable to get responses from users (about 250 fields)Softr as front-end to get list of filtered records, get record detail, and buttons to open Fillout form or start an automation (basically change the status field to be used as trigger to n8n)n8n for automating the data processing (mostly to generate PDF using PDFMonkey, I received data from Airtable in the trigger and just change the status field at the end)My understanding (that was also confirmed by the support chatbot) is that:getting a list of records in Softr = 1 API call (I have only 8 records)getting a record detail in Softr = 1 API callone response in Fillout = 1 API call (maybe 2 or 3 as there is a lot of fields)automation trigger = 1 API callchange the status from automation = 1 API call (changing just one field)etc.If I test the solution - open list of records in Softr, get record detail, open Fillout, fill one response, start automation in n8n and finish

Hello I need to build a form where users create a 'Deals' table record. The description of the form should contain  dates that come from a  record in another table: 'Cohort'. It seems that Fillout pre-fetch is exactly what I need, but it is only available for 79$/mo which seems too much for this form only (and mini-extensions likewise). Is there any another solution? Does scripting have anything to do with Forms? Many Thanks 

Hello,I have seen a few different solutions for questions related to my issue, but nothing seems to work still. I am going to hopefully explain this in the most concise, but detailed way possible.Overview:We have 2 tables that I am trying to make communicate. 1 table is an intake form with a production calendar view. The other table is an overall production calendar with many different views for different key stakeholders. We have an automation set up so whenever a client submits a request, it also get sent over to our overall production calendar.Problem:The problem is that the launch dates for these clients often changes and in return we need our overall production calendar to update whenever our intake manager moves the date on the intake calendar.Our current process:Someone submits a form.It is automatically added to the intake calendar.We have an automation set up to push this to our production calendar.Our intake manager will then move the date on the intake calendar to align with

Does anyone use an external tool for viewing/creating/editing complex formulas? Is there a tool that you like to copy and paste your complicated formulas into? Notepad++, Visual Studio? I know you would lose the linking to existing fields and the function lookup, but I’ve been struggling with some of my really long nested if’s. Thanks, Mike

I am looking for help creating a formula field to change the format that phone numbers appear in.On Airtable, the phone field automatically formats phone numbers as: (555) 555-5555.I need the phone numbers to be formatted as follows instead: +1 555-555-5555.Please help!

Hi there,I built a custom CRM on Airtable for a client. But I end up with a lot of pages on the interface. So to organize them, my usual habit is to break up the initial single interface into standalone interfaces. One for each category. Like here:But in my client's case, this design choice wouldn't make a lot of sense since a. only one single team will use the interface, b. all the pages refer to the same category (CRM), c. they want something that's as simple to use as possible.So for now, here's the solution I found to sort out the multiples pages. I created blank pages and used them as dividers between sub-groups of pages and renamed those pages '–––'.Have you guys found any other creative workaround for this need?Thank you. 

Hey,I have tables of:customersAssets - each customer can have several assetsFaults - any property can have faultsThe handyman - for each fault there can be several handymen who will fix the faultSuppliers - for each malfunction there can be several suppliers through whom we will buy the materials to repair the malfunction.My problem is that I am unable to send the bank details of the handymen and suppliers to the customer by email.For example, if I have a problem that 2 handymen fixed the problem and we bought materials to fix the problem from 2 suppliers.When the fault has been fixed, I want to perform an automation that will send the customer a message in the following style - "Hi X, please transfer payment for handling fault Y to:Handyman 1:Bank - XXXXXBranch - XXXXXBank account number - XXXXXXHandyman 2:Bank - XXXXXBranch - XXXXXBank account number - XXXXXXSupplier 1:Bank - XXXXXBranch - XXXXXBank account number - XXXXXXSupplier 2:Bank - XXXXXBranch - XXXXXBank account number - XXX

hello sir. Are you available to help? I'm new to airtable and need help..so i have a recipe table which have these columns:Recipes Table:- "Resep Bahan 1/2 jadi", checkbox column, user will check this box if the recipe is for sub-ingredient that made from other ingredients.- "Nama Resep", this is the name of the recipe- "bahan", this is ingredient name- "jumlah", this is the number of ingredient used- "unit final", this is the unit (i.e.: kg, litre, etc.)so every line (every row) is a single entry. for recipe that need more than 1 ingredients then will have multiple rows/lines with same name of the recipe (same "Nama Resep") for every ingredient ("bahan" and "jumlah").for example:Recipe A (sub ingredients) need 3 kg of "Bahan" B + 5 kg of "Bahan" C, so will have 2 rows ("v" is ticked checkbox for "Resep Bahan 1/2 jadi"):v | A | B | 3 | kgv | A | C | 5 | kgThen I already have Inventory Table which consists of below column:- "Tanggal" : Date- "Nama Bahan" : Ingredient names- "Dari Lokasi

Here is the situation and thanks for all help in advance.I have a grid view where the primary filter is to only show records where a date field is empty.  This could be as many as 50 records at any one time.I'd like to add today's date to all records in the found set (empty dates) in fell swoop.  Of course, if I add the date to the field, it drops off the found set. This means I have to select todays date in 50 records with the awkward disappearing record.So an automation that will update the date field in all records in the found set might work.  I played around with an automation to do this, but couldn't figure out how to do it.I am open to alternative ideas.  Essentially, I have a set of 50 records that have an empty date and I want them to disappear from the list when a date is put in the empty date field.  But I'd like to automate it somehow.Hope that makes sense.  I have two attachments. One a screenshot of the found record set.  Notice that the