Solved

I have two tables:Table one shows a list of tasks done on different computers and when the task has been marked as finished:TaskId, FinishDateTime, Computername.In table two I have information who was logged in when on on which computer:DateTimeStart, DateTimeStop, EmloyeeName, Computer. I want to have in table one an extra column, showing the name of the EmployeeName that was working on that computer while the task was finished. So we need to use the FinishDateTime and Computername to query the other table to find a match with exactly this computer and FinishDateTime in range between DateTimeStart and DateTimeStop. The result of the formular should show just the Name of the Employee. I hope this is clear. How to create the formular? I am familiar with excel, where i would do some kind of nested vlookups, but have no idea how to achieve this in airtable.

I am trying to fix a formula for hours, but I can't find the error. For some reason, the last argument in an OR Formula is ignored.The base has 2 tables (Table 1 and Table 2)Table 1 has one record with the following values:Field 1 (single line text) = AField 2 (single line text) = BField 3 (single line text) = C Table 2 also has one record with a multi-select field. The values areField 1 = C, D, E, F My OR formula should check if any of the 3 values from the record (Table 1) is included in the multi-select field (array) of the record in Table 2.  OR( FIND(Field 1 (Table 1), Field 1 (Table 2)), FIND(Field 2 (Table 1), Field 1 (Table 2)), FIND(Field 3 (Table 1), Field 1 (Table 2)) )  When I add "C" to Field 2 (Table 1), then it's correctly counted.If I add C in Field 3 (Table 1) I don't get an error, and the formula just goes through. It just ignores the last argument, "FIND(Field 3 (Table 1), Field 1 (Table 2))". Does anyone have an idea

I have an Airtable automation that uses the AI module to summarize text fields for each record in a view. A repeating group iterates through that list. In Make, those newly updated records are processed through a Word template to output a report. I'd like to figure out a way to trigger them with one button press.There are three ways I'm aware of for triggering Make, but I can't figure out how to make any of them to work.Webhook doesn't work (I think) because I need it to happen sequentially, with the Airtable automation running first.Record update: my original plan was to update the status of a report record that Make was watching after the Airtable automation looped through the whole list, but it doesn't look like you can add another action after a repeating group. So I also tried a script within the group that would count the loop iterations and compare to the list length, and at the end of the last iteration, would update the record. But I don't think it's possible to save the itera

I want to create a chart that shows record counts of a table over time.  In our case, we have a table of clients and want to show how the total number of clients has changed over time.  I have a "Created time" column and I can use the COUNT formula to get the current number of clients, but I'm not sure how to get that COUNT over time.Any ideas?

I am trying to calculate the number of months between today's date and the "Test Date" field. When I use the DATETIME_DIFF formula it does not calculate it correctly for all values.  In the Test copy column I have this formula:DATETIME_DIFF({Test Date}, TODAY(), "months")It calculates some of the values correctly but then other ones wrong and I am uncertain how else to do this calculation in Airtable. What I need is that if todays date is Nov 7, 2024 then any dates in Nov 2024 would give a value of 0, any dates in October 2024 would show -1 but you can see the dates on October 16 and October 30 show a value of 0. You can see this issue also on the last row of the screen shot where the date of Jan 2, 2024 should be 2 but gives a value of 1.     

Hello fellow automation experts.Need help in updating a filed but this automation has kept me up all night.The senario is simple.I have a task table called " Email Task" where i want to update status of that task from "not started" to "in progress" based on its date.My automation is as followsHere is the condition to find the records:This step is working fine as seen below:now here is what i need help with. do not know what i am doing here but final step wont run.Thank you

I recently updated a form to "new forms" (by clicking on the "⇧ upgrade to new forms" button from a form view within a base) and edited/published the form via an Interface (as opposed to within a base, as I've done previously). I want to enable the same "email me at xxxxx@domain.org"  option that is available in the old form builder, but I don't see that option anywhere in the new Interfaces form builder. I've set up an automation to send me a generic email each time the form is submitted, but what I really want is the same nice email I used to get with an overview of the form responses. Am I missing something obvious? Or is this feature not available with "new forms"? Thanks!

Form question for you all. I need to capture phone number on an Airtable form however I can't figure out how to require it be entered as a 10 digit number so that area code is captured. The Phone number field type does not require the response to be 10 digits. I'm open to using the Formula field type however can't find a formula to use that would require 10 digits. Any help you can offer is greatly appreciated. Thanks!

@AasiaWhen a form is submitted from he/she.  I want that Airtable to send a confirmation email for successfully submitting the form. 

I have received a support request from one of my organisation’s users, copied below. Does anyone have any suggestions? Do AirTable forms bug on some browsers, for example? Other users have used the form and we have received the data. Many thanks in advance, Julie "I have just spent 3 hours filling in the form (Make a Policy Development Request) to have all the information I entered wiped. this is the 3rd time i have tried to present my proposal on this webpage to have all information wiped. this is highly frustrating."

Hello!I'm using a prefilled form URL field. When a customer submits a button it opens the prefilled form in the corresponding URL field.The problem is that it works perfectly on desktop, but when using App, the prefilled form formula does not work.Is this expected bahaviour?Thanks!

Edit:Airtable response: Our engineering team has successfully deployed a fix for this issue (which arose from a recent update to our code) and any automations referencing an attachment should now run as expected without error.It's working again. Thank you all.---Hello.I've been using the Send Email action in automations for more than a year. Always worked great. In the Send Email action, in the Attachments section (Bottom) I selected the column that contained the file, and that file was attached in the email.3 days ago, my automation worked fine. But today, when the automation triggered, there was a problem (An attachment url is disallowed):I already turned off and on the automation, changed the trigger, changed pdf file for jpg, and always the same error.I tried the automation with records that already triggered a few days ago and worked fine (My trigger is a Single select column, so, to trigger it again, I deleted the value in the single select field, and select it again). Same

Hi,I am sure you will all tell me to simply build my web form in Airtable and connect it to my website. ( I dont know how to do this). I have a web form with fields in it on the web site ( fluent forms on WP) . I have got a token and connected to Airtable but i do not know how i can use the fields in the web form to create the fields in the Airtable base?any help will be gratefully received. ash 

Since space is limited, is there a way to limit file sizes for files uploaded via forms? Thanks.

Hello, I just signed up for the business plan and as it says in the plan (photo attached), it says unlimited editors. I have created an app that collects feedback through a form so I need many external people to be able to edit the form. Is there a way to do it without being charged on the invoice for each user who edits (the option to do it through a form link does not exist, I need to be able to edit the interface, not the data).  

Hi Airtable gurus,I am trying to create an automation that will locate a specifc record based on the record ID then update the Status field.It would look like this:Trigger: When a webhook is received (an invoice is paid in Stripe) I actually have the webook createdEvent: 1. Locate record (the appointment record that was created based on a Calendly appointment creation), 2. Update that record to reflect that the invoice for that appointment was PAIDI feel like I am close to getting the automation to work, but I can't figure out how to find that appointment record based on the record ID. Any help would be so appreciated! 

Hi, using the Free version I'm trying to import a  15MB Excel sheet into an existing base with four tables (3-6 records per table) but I get the following message:"testfile.xlsx exceeds maximum allowed size of 5 MB"I assume this is a limit of the Free version? If so; what are the filesize limits of Team and Business versions?

Hello. I'm struggling to find a way to combine the contents of several Multiple Select field into a new field, while retaining the value and color for each entry. Here's a stripped down version of what I'm trying to do: I've got 4 separate multiple select field, each with their own set of options. The field called "Combined Types (Manual)" shows what I want the output to be. How can I aggregate all that data while retaining the color coding for each one? Thanks a lot.  

  One of my bases mentions "Over Limits · 30 days left" / This base has gone over the record limit. To keep adding records, upgrade your workspace.I sill can add new records... what will it happen now?Do i have 30 days to remove or to move records out of the base? 

I have an automation that is triggered when a user clicks a button in an interface. The automation is current set to simply create a new record in the underlying table, and fill in three fields:user = should be the Name of the user who clicked the button. This is a "User" or "Collaborator" field in the underlying table. I have the user who clicks coming into the script using the input variable selector.status = should be "Assigned" which is one of the possible values in the field, which is a single-select field.string = "string is string" this is obviously a placeholder, but this is just a string.Here's my code:  // Get the input variable let inputConfig = input.config(); let userName = inputConfig.userName; // Define the target table let table = base.getTable('Table'); // Get the list of active collaborators in the base let collaborators = base.activeCollaborators; // Find the collaborator object that matches the userName let assigneeCollaborator = collaborators.find(coll

Hi Everyone,I have base called PROJECTS with two tables:   1.  "Sync" that syncs all the values from another base called CLIENT MASTER.   2. "Projects" which is a list of projects.  Each record in "Project" can only have one client.When a new record is created in the "Project" table,  the user selects a linked client record from "Sync"  then there are lookup fields that auto-populate with fields like Account Executive, Partner, and other client information.So far that works just fine.I have created an interface with a list of records from the "Project" table.   I want to set a filter on the interface so that the only records displayed for the user are the ones where "Account Executive"= Current User.However, when I create the filter,  "Current User" is not an option.    Strangely, when I create another test field in the Projects table called "Test User" (User field type), I AM able to use that field as a filter and "Curre

Hi there,I have a button that translates my article information using deepl. So the button is connected to an automation. I would like to re-use that button in another interface, but when I duplicate the page, I need to create a new automation. Can we not connect two buttons to the same automation? Cheers,Konrad

BonjourJe reçois un fichier importé automatiquement avec une colonne "Date début" au format "texte sur une seule ligne" de type01/10/2024, c'est à dire jour/mois/annéeJe voudrais dans la colonne suivante extraire le mois et le passer au format "octobre" en toutes lettres.J'ai réussi avec la fonction  DATETIME_FORMAT({Date début}, 'MMMM') à créer un lien mais le mois affiché se base sur le jour et pas sur le mois de la colonne "Date début" : Pourriez-vous m'aider svp ?merci d'avance   

Hi everyone, I am trying to get unique values from a lookup field. I have tried the solution suggested in: Solved: Exclude Duplicate/Repeating Values via Lookup or R... - Airtable Community. by  @kuovonne. Which stated: Create a rollup field that rolls up the multi-select field. Set the formula to values. Save the rollup field.Convert the rollup field to a lookup field. Notice that the lookup will be formatted as plain text instead of the usual pill format.Create a new formula field that refers to the lookup field (that used to be a rollup) and use the formula ARRAYJOIN(ARRAYUNIQUE(ARRAYFLATTEN({lookup field})), ", ")But this does not seem to work for me, as converting the rollup back to a lookup, changes the formatting back to pi lls.In the screenshot provided you can see the formula I am using, as well as both the rollup and lookup field. I have tried different combinations of using ArrayFlatten and ArrayUnique across the rollup and formula but noth

Okay, a bit of context for clarity.I have a base that I am using for tracking inventory. We send out the packages of items. Sometimes we have some of the items in stock, and sometimes we need to order more before the package is sent. I am using an interface that lets the end user select the items that they want to add to the package. Then they have the option to click a button to trigger an automation.The automation looks in the table and finds all items with a check box. Then, using a repeating group, it send the relvant infromation for each item to Make via a webhook. Make then checks to see if the qty needed is less than or equal to the qty in inventory. If it is, Make creates a new record in an Inventory Change Log table to remove that qty of items from the Inventory table. The problem I am facing is if two items with the same name are sent at the same time, the webhooks are sent to make faster than make can process through them.For instance:Say I have 1 trashcan left in stock