Ask the Community

When I use the user search in my list interface, it displays "4 results" in the search field but no items show in the list. What am I missing?

Hi,I am super new to this. Essentially I want to have a master base that my team and I can work from that is synced to 4 other bases that our partners work on individually. I don't want one partners data to reflect on another partners base. Is this possible?TIA!

I'm working on a project where I have 3 tables in play."Database" - "Data2" - "Match"The script I developed allows me to take a record from the "Data2" table, compare it with each record from the "Database" table and if there is a correspondence between the two, based on 3 specific values ​​which are multiple choice fields, then it is created a new record in the "Match" tableThe automation starts n times based on the number of records flagged in the "Data2" tableThe problem is that having more than 1000 records in the "Database" table, even if I have optimized the script as much as possible, in some cases I run into the 30s limitI show you the current code:// Ottieni le variabili di input let inputConfig = input.config(); let nomeBando = inputConfig.nomeBando; let areaInteresse = inputConfig.areaInteresse || []; let tipologiaSoggetto = inputConfig.tipologiaSoggetto || []; let settore = inputConfig.settore || []; let bandoContributiRecordId = inputConfig.recordId; let scadenza = inputCo

I am looking for a way to parse a lookup field (Sprint Start Date) that contains multiple, comma-separated date values, and pull the most recent date into a new field. For example:IF --> Sprint Start Date = 2024-10-12, 2024-12-22THEN --> Formula Field = 2024-12-22 I have tried to use the following formula to parse the Sprint Start Date field and convert it, but it always returns the same value, or an error:DATETIME_PARSE(MAX(IF({Sprint Start Date}), VALUE(DATETIME_FORMAT({Sprint Start Date}, 'YYYYMMDD'))))Outcome #1: 12/31/1969 Outcome #2: #ERROR!I have also tried this, which gets me closer, but not quite what I'm after:DATETIME_PARSE(MAX(IF({Sprint Start Date}), VALUE(DATETIME_FORMAT({Sprint Start Date}, 'YYYYMMDD'))),'YYYYMMDD')In this case, I get one of two outcomes:Outcome #1: The correct date, minus one daye.g. If Sprint Start Date = 12-02-2025 the formula field returns 12/01/2025T

I want to add images to an attachment field in an Airtable.  I've read all of the documentation and Community comments but can't seem to find an answer to my problem.I have a publicly accessible link to the imageI can call https://api.airtable.com/v0/{baseID}/{tableID}/{recordID} and add an image fine, however, I want to make multiple other calls adding new versions of the image and this call overwrites what is already there but I want to keep the previously uploaded files.  (I understand this is an Update call and that logic makes sense.)Therefore, I believe I should call  https://content.airtable.com/v0/{baseID}/{recordID}/{fieldID}/uploadAttachment  passing in a similarly formatted JSON object, however, I cannot get that to work.  I get something added to the attachment field, however, it is just 1K gibberish file.Here is a copy of what I'm calling:curl --location 'https://content.airtable.com/v0/{baseID}/{recordID}/{fieldID}/uploadAttachment' \--h

I'm attempting to paste Date and Time information into an Airtable "Date" field which has the "Include time" option checked. But, when I paste Date and Time information, it all goes in the "Date" part of the cell, and none of the text goes into the "Time" part of the cell.For example, I'm trying to paste "11/21/2024 10:00 AM" into the Date and Time cell, but it puts all of this text under the "Date" portion, keeps the cursor in the "Date" portion, and enters the current time (i.e., 2:13 PM) in the "Time" portion of the cell, lol.How can I accomplish this basic copy-and-paste operation with Airtable's Date-and-Time formatted column so the Date goes in the Date, and the Time goes in the Time?For those unfamiliar, Airtable's "Date" field with "Include time" checked creates a cell with seemingly two cells within it, as shown in the screenshot below.Finally - I have all my data in a Google Sheets spreadsheet, which I could easily copy-and-paste into the Airtable table. BUT, right

Hi, I have two tables for which I'd like create a formulaTable 1Feature NameFeature End Date Table 2Sprint NumberSprint Start DateSprint End DateI'd like to create a formula that checks if "Feature End Date" is between "Sprint Start Date" and "Sprint End Date" and if so, assign a Sprint Number accordingly. How can I achieve that in airtable?

Hi,I am trying to understand how interfaces and users interact. I have a series of interfaces that I intend to have users edit the information for certain fields.I have set up the interface pages to have the correct fields editable and I set up a user (different from the owner) so that I could check that it is working properly. When I go into it with the test user though set as an Editor, I am unable to edit the fields that I should be able to. Can anyone please explain how this work, or how I should have the interfaces so that they can be edited by users? Thanks in advance for anyone's help. S

Hi friends, I would appreciate your help with something that I have been stuck on for too long..I have 2 tables -1. Students2. Student ActionsIn "Student Actions" I see all the lessons that the students have completed.In "Students" I see the student's status - both his details and I also want to pull the last lesson he took, the date of the last lesson, etc.I was able to use ROLLUP to pull the date of the last lesson, but no matter what I did and what I tried - I was unable to pull the name of the last lesson he completed.Now it seems like something very simple to me, because I need to pull the name of the lesson whose "Autonumber" is the highest, regardless of the date.I was unable to do this and it is really frustrating.I would really appreciate your help!Thank you very much! 

How do I make an attachment field editable in a synced base?  Any work around? 

“Client Table” contains clients in column A. One client to a row. Each client belongs to a group (Group 1, Group 2, Group 3, etc), which is listed in column B.  “Project Table” contains projects. The name of each project is in column A. Each project has one or more clients. One project could have clients from multiple groups. I’d like a column in the Project Table to list all the groups represented in a project.  Thanks!

Hi, I'm currently trying to display my teams averages in an interface. In my table, I have a user field where records are assigned to a team member, a date completed field and a status field where the team marks "Complete" when finished.In my interface, I would like to display the average count completed per day. I know this can be accomplished through lookup/rollup fields but I'm struggling to get it to work properly and would really appreciate some assistance.

Hello,I am celebrating my automation is now working, however, whenever it seems that Airtable is sending me an automatic email titled, "Something went wrong with an automation...". I've pasted the email and error screen below.Can you help me understand if there's actually a problem, and how I can get the emails to stop?TIA,ML   

Good morning.We are experiencing issues with email sending from automations. We have detected a change in behavior with email dispatches when several emails are entered in the "TO", "CC", "BCC" fields.When the action is triggered, it appears that Airtable sends multiple independent emails instead of a single email. For example: If "Email_1" is entered in "TO" and "Email_2" in "BCC", then "Email_1" receives the message, but "Email_2" does not receive a copy. Instead, "Email_2" receives a direct email, as if "Email_2" had been set up as "TO".The expected behavior would be: "Email_2" receives the same message that was sent to "Email_1".We have observed this change in behavior today, 2024-03-07.##### Message edited to detail the case ####.To detail our case I have conducted a simple test, easy to replicate; creating a basic automation where I have only added a time-based trigger and the action Send an email, which I tested to trigger the action. I have set up the email sendi

Hi All Through automations you can: Create an outlook meeting Update an outlook meeting But I can’t find a way to cancel a meeting? Is it impossible? Thanks in advance Matt

In my account, on both the free and paid workspaces, I have the option to update a record's date field with "A specific time" -> "Actual Run Time" in an Automation.  However, in a clients account, they only see When a Record is created (or Form is submitted, or conditions are met, etc., for the trigger) and Base Structure. They do not have the option for "A specific time."Is this something that's only just now being rolled out and not every account has it yet? Like I said, I can see it in both paid and free workspaces that I have, so I don't understand why they wouldn't see the same option for their Automation to update a date field with the date/time that the automation is run. 

Hello,I'm looking for help on Airtable Automations. I'm trying to Find a record to update based on Table:Sessions field matching Table:SignUps field. Both fields are "formula" fields that make a text number because the original Sessions field is a linked record, and the original SignUps field is a Primary Key.I don't know why, but I keep getting the error message below saying, "No valid nested options". It won't let me pick *either* the text field or the original Primary Key for Finding the match, and I have no idea why.I already went through this post explaining how both of the "Find" fields have to be congruent... but as far as I can tell, mine *are* congruent, but I'm still getting the error. How can I get this automation to work?Additional context below. TIA,ML    

I created an automation that creates task records when a new project record is created. It finds the matching records from a "task template" table and creates new records in the "task" table. It runs fine except for records that have a user group populated in the "assignee" user field. It won't create those records. Both the "task" and "task template" tables have matching user group fields, so this isn't the problem. In the example below, the automation will create 2 records where the assignee is a single person, but won't create the 3 records where the assignee is a user group.  

Is it possible to change the position of the menu in Interface so that it appears at the top? Or maybe on the right side?I would be happy to helpthanks! 

Hello - I want to have a form that has different paths depending on your answer, but all link to an Airtable base. Is that possible? I think I need to use Zapier for that, is that correct? Basically, I do research - so I want the client to be able to choose the type of record they are seeking, and then it will pull up different fields depending on that answer. Once the rest of the form appears, they’ll proceed with their research request and submit it on my website. On the back end, the Airtable would have a combination of some fields that are awaiting input (e.g. their name, contact information, notes, etc.) and some fields that I already have the choices populated (repository, record type, etc.) I’m just trying to gut check that this is possible before I go creating. I would use the forms within Airtable alone for an easier solution, but it’s too complicated to include ALL the fields when some are only needed for certain types of records. Thank for any input! Alexa

I need to use Gravity Forms on my website because it allows me to take Paypal payments as part of completing the form. Can submissions via Gravity forms add records to an Airtable table configured with the same fields?

Hello, I want to show “0000009” in my cell inside Inventory table. I tried to use roll up but it shows “0000009” and “0000008”. How can i only show the latest one only (in this case is “0000009”) Thanks

Good morning guys,I need help with an automation for my base. I'm not an expert at all, everything that I already did, I figured out very slow and with a lot of help, but I can't figure out how to put this automation..... 🙂So, I have a base for my company. We are exporting different products to other countries. Therefore I have an order and sales table, as well as business expenses. In all 3 tables I have business cycle that shows the month and the year - it is automatically updated when the purchase or sales date is added to the table. Now I have another table that I named business cycle. Here I want to get an overview of my cash flow - money that comes in and goes out every month. I created an automation to create on the first of each month a new business cycle.Until here all good, now the problem:Once I add to my purchase, sales or expenses table new data I want them automatically added to the business cycle table in the right business cycle.Here are the fields I create

Hi everyone, Following Situation: I have Projects, Reports, and Tasks. Projects are linked to Reports, Report are linked to tasks. Tasks are not directly linked to projects. Now in Projects, I have a Lookup field for Tasks from reports. I really need to filter this lookup field by two checkboxes in Tasks. But unfortunately I can only set filters around Reports: "Only include linked records from the reports table that meet certain conditions..."Is there any way to filter the Tasks directly? Or is there any clever workaround that I am missing? Any help or ideas would be appreciated!Cheers 4

Hello friends,I am looking for an automation/script that does the following.1. When the field 'Start date' is updated in a record in the table called 'Projects'... I would like...this new 'Start Date' to replace the current date on a field called 'Deadline' in a record which is always called 'Project Start Date' in a linked record field of the triggering record called 'Tasks'.If it helps at all:- the linked record field 'Tasks' is linked to the table called 'Tasks'- The record which I want to change called 'Project Start Date' sits under a field called 'Task', in the 'Tasks' table I have no experience in scripting, Gemini provided me with the following, but it doesn't appear to be workingNote: My trigger is When a record is updated - "Start date" - on the "Projects" table:async function updateLinkedRecordDeadline(record) {const linkedRecords = record.getCellValue('Tasks');// Iterate through each linked recordfor (const linkedRecord of linkedRecords) {if (linkedRecord.getCellV