Solved

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

“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!

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   

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    

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

Hello! one of the recipients of the marketing email unsubscribed by mistake.As i understand the mail was blacklisted in baseNow he wants to restore the subscription   Is it possible to manage in Base or by user   Sincerely, Kirill 

Is there a complete list of these options for record "names/terms"? 

Is it possible to select a range of records in grid view using the checkboxes and apply a sort to just that range?

I have a Projects grid and a Tasks grid.The Projects grid has fields for Project name, start date, and end date. The Tasks grid has fields for Task name, start date, end date, and reference to the Project name.  For each Project, I would like the start date to be the earliest Task start date among all the Tasks that reference that Project.Similarly, I would like the end date of each Project to be the latest Task end date among all the Tasks that reference that Project. Thank you in advance for any help!!  

Hello, I have a question regarding Gmail automations in Airtable.I'm starting a business and am new to the world of marketing. I have extensive experience using Airtable automations, as I've been using it for years for other purposes, but I have many questions about email marketing tools and the limitations related to email contacts, spam, etc.My goal is to collect interested leads through a form. After receiving a form submission, I want to automate sending an email via Gmail with details about the services I offer. I also plan to create follow-up automations to re-engage the lead if they don't convert within 1–2 days of filling out the form.In addition, I want to send other emails periodically to offer new services—but not in bulk on the same day. For example, instead of sending a service offer to everyone in my contact base at once, I’d automate it so that an email is sent only when a lead completes 15 days in the database. In this way, there would never be large-scale email blasts,

Hi guys! I'm wondering if I'm doing something wrong or something has recently changed? Long story short, I'm not able any longer to nest the records through the interface. Currently, I'm working on the new base and I wanted to nest records to organise them in some logical order. For example, if I look at one of the bases I already created, you can see the option to nest the records. Now, I'd like repeat the same process in another base and the option to nest the records is missing?Any idea if something has changed? Thanks!

In my base, I changed content type to multiple sections from single and now when I try to view the calendar view, "content pieces" it gives me a "Field “Content Type” was changed and can no longer be selected" Any suggestions on how to remedy this? Thank you.https://airtable.com/app6mSqDWyf5cSRa0/shrTfcyaeQloo2QZ8https://airtable.com/app6mSqDWyf5cSRa0/shrKoEdBGyLHbe1wr

I just want to make sure I understand this properly.  I can create a mobile interface list view, but I can only sort by one criteria. I cannot then sort by a second one. For example I have TV shows and I can only sort by show name or episode. Not show name and THEN episode. Am I missing something?  Thanks  

Hello all!I need help with a formula field. I believe I will need to use the IF function. Each week, I have to do math based on data input in 2 different fields and then multiply that number by a static field to get my total. I have to do this for 50+ records each week, so I'd love to save myself the time and energy and have my TOTAL field know which of my two fields it should compute against my static field. A screenshot is provided so you can see, and below is a little more explanation.Thank you for any help!Each week, some of the shows I am tracking are in preview performances and some are in actual performances, but never both at the same time. This number can change each week for either, and each show will start in previews then move to performances. I input the number of performances into the appropriate column, then multiple this by the {Production Seats} field to get my {Capacity}. Basically IF {Previews} has a number in it, multiply that by the {Production Seats} to get {

Hi,Due to rebuilding a lot of our automation to accommodate segment/tag based filtering for e-mail, I need to change my TAG fields. The TAG is a segment or interest area (e.g. nature, sports, food etc), and until now I have used this as linked records from a master TAG table. The automations I built require however the TAG field to be a single select, so I need to transform all of my linked record TAG fields to single selects.If I just change the field from linked record to single select I nicely get the existing values converted into single select values, but it seems all automations where this variable has been used break. There are quite a few automations and it feels both very time consuming and risky to re-build all these by hand.Can you think of another way to "convert" the existing TAG field to the single select type without breaking the automations?Cheers,Björn

HiI would like to compare 2 text fields. The first in "Internal" and the second is "External".I saw this solutionhttps://community.airtable.com/t5/formulas/comparing-of-two-values-in-rolled-up-fields-and-showing-true-if/td-p/61679IF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )which works only if the text fields are excatly the same including lower and apper case. ,eaning it is case sensitive.I am looking for a non case sensetive solution.IF( LOWER(ARRAYJOIN({Internal}, {Internal})) = LOWER({External}), "same", "different" )but "= LOWER({External})" is illigelHow can I useIF( ARRAYJOIN({Internal}, {Internal}) = {External}, "same", "different" )to be non case sensetive?   

Hi, I am hoping that someone might be able to help with a nested IF Statement I have a field that determines the size of an advert. I want another field to list the price for the advert based on the selection in the first column.This is the If Statement I created, but something is not quite right because it always shows the value £0.00IF(  {Advert Size}='Full Size','£100.00','£0.00',  IF({Advert ID}='Half Size','£50.00',  IF({Advert Size}='Quater Size','£25.00','£0.00'  )  )) Thanks in advance for your help.  S

I suddenly can't add multiple sync sources to my table.I'm on a business plan I have under 20 sources syncing to my table. Does anyone know what that might be the case? I can do it in other bases.I can add other sources in other bases: 

I created a new view in a base with existing shared views. On this new view, the share button is not visible like it is on the others (see attached screenshot). I submitted a support ticket for this last week and airtable hasn't gotten back to me yet. Can anyone help?

i will be as spesific as i can with the intention and infomation i'm gathering:At a scheduled time, every day at 8am, i will run a script.This script below here fetches the JSON i need. (example: https://data.brreg.no/enhetsregisteret/api/enheter?)This is the output of the console.log so i know it works:As you see, each object under the "enheter" array represents a company.I want the automation to create records based on each object and fill it with the infomation given there. Anyone willing to help me here? &#x1f605

I created an interface with tasks for each employee.I want each employee to be able to see only their tasks.I created a page with a filter for each employee, but I don't see an option how to make an exception so that employee X will not be able to see the tasks of employee Y and vice versa.How is it possible to exclude a certain page from any processing?thanks!

I am sure there is an easy way to do this but I am still fairly new to Airtable.I currently have a table that has six formula fields that give users information about their progress throughout the year based on criteria from other fields in the table.  I have created a record review interface that allows each user read-only access to see all of their updated fields as well as the information from the formula fields.  This is all working great except that multiple times throughout the year I need to go in and manually change which formula fields the users see.For example, at the beginning of the year, formula field1 is in the interface which provides the inital progress that the users will see. On date1, I need to change field1 to formula field 2; on date2, I need to change field2 to formula field3, etc.Is there a way to set up an automation to do this?  I am not finding an automation that will allow me to replace fields in an interface, and I don't know enough about inte

I have a table in my online portal with a hidden multi-select "filters" field that is only accessible via a dropdown menu but not visible on the actual table. I want to create an automation that triggers when my existing records (or newly created ones) matches the conditions I setup."If Field1 is none of ... and Field2 has any of ... update record FilterField with 2 filter options"The problem I'm running into is that existing records aren't updated, only newly created or updated ones. Of those newly created/updated records, it overwrites existing options selected in FilterField so instead of adding a 2nd option alongside the 1st one that is already on a record, it overwrites it and only inserts the option with is listed in my automation trigger. I have hundreds of records and it would take too long to do this manually!Thank you.