Solved

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remain separate would be ideal, but otherwise, it could just be text formatted like this "MM/DD/YYYY, MM/DD/YYYY").Then I'd like to have another column that shows the oldest date and a column that shows the most recent date.Another column that just adds the number of times the content has been published, so counts the number of fields with a date in them.The error you see currently in the far right field had the formula that I tried on my own which was:DATETIME_FORMAT({Publish Date 1}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 2}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 3}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 4}, 'MM/DD/YYYY')A screenshot is attached. Thanks in advance!

Hey!I am trying to update a record based on the user's id, currently, I have this code but for some reason it errors saying: TypeError: Invalid arguments passed to table.updateRecordAsync(recordOrRecordId, fields): • recordOrRecordId → recordOrRecordId should be a Record, not a number (5) or recordOrRecordId should be a string, not a number (5)Basically I am trying to update the field URL for the user based off their user id, the text I want in the field URL is from the "strHash" stringlet table = base.getTable("Participant"); let record_id = inputConfig.record_id; await table.updateRecordAsync(record_id, { "URL": strHash })   

Hi, I want to update the choices a singleSelect field has without adding a new record.I tried this approach, but that yields the following errorTypeError: Cannot add property 2, object is not extensibleHere is the relevant code (MtypeName gets its value from a singleLineText field)let MtypeName = Mtype.getCellValueAsString("Meeting Type") let Types = MeetingsTable.getField("Meeting Type") Types.options.choices.push({name: MtypeName}) I this possible without residing to API calls?If this is only possible using the Rest API, I suppose I cannot use this without providing the authentication details, right ?

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).The bit I'm struggling with is doing this with lots of IF formulas in the same formula field. (I need about 47 different dates each returning their own specific text. Is this the easiest way to do this or am I missing a trick somewhere? Thanks in advance. 

I've been submitting tests for me event form however there is no restriction on being able to put the end date earlier than the start date. Does anyone know how I can remedy this?Thank you.

I have a project management base. I use the in-built Time Tracker extension to track the time spent on each project. I have several ongoing projects, and I work on more than one project each day. It annoys me that I have to select the project from a relatively long list before starting the time tracker, so I am trying to figure out if there is a way to skip that step.I have a table with clients and another with projects (Project name, Authorized number of hours, Time spent, and Time left). Is it possible to use the button field in the projects table to start the time tracker for a specific project with one click on the button in that project's row? Or is there perhaps a better way of doing this?Please feel free to ask if my question is unclear.Thanks,Lene D. Kottal

Hello there, I’m using Make / Integromat to create Google Docs and upload them as PDFs to Airtable. Occasionally this results (without obvious reasons) in broken PDF files. While the file name is correct, they’re missing a preview, open as blank and are read corrupted in external PDF apps. The automation completes successfully. If I open the Google Docs PDF export link, the PDF comes out alright. This makes me think the PDF file breaks while being imported to Airtable. Is there a known error, fix or workaround to this? I can’t find an indicator to tell the system the file is corrupted (still has regular file size) to let it redo it automatically. Thanks for your input

Hi,I am new to the Airtable forum but been using Airtable for over a year now. I am trying to create a Gantt view with multiple start and end dates for an employee (the employee has multiple contracts and I want to make sure the contracts don't overlap (too much!) with a visual display. Currently I was able to create a Gantt as seen here:The different contracts are highlighted with boxes, are sourced from a Lookup Field (from a separate, linked table) and separated by commas. How can I make the Gantt recognize the start & end dates associated with each contract? Right now it just shows the employee working (this is hidden off to the left side of the screenshot) from the start date of their first contract through the end date of their last contract, even if there are dates in which they are not working (on the top example 7/7–7/11).The Grid View the Gantt is based from is this: Person#1 is the upper Gantt chart & Person#2 is the lower one. Currently the Gantt is sourced fro

Hello!We made the request to have the form answers emailed to the respondent optional; however, now I have a person who did not tick the box, who would like a copy of their responses. What is the easiest way to send that to them? I do have their email.Thanks!

When someone completes a form and a new record is created in the grid, how can I notify my team about the new record?

Hello all,New to Airtable and still figuring out things.I am creating a job board, and want some data to be blurred in the main page for non logged in users. I am attaching two screenshots -- one from Airtable and the other from the app I am using to create the board. For example, I want the Company details to be blurred.Is there a way to do this in Airtable (the app itself doesn't have any). TIA 

Hello,I am using make to create a google doc using information coming from airtable. I then download the google doc into a pdf that I upload back on my google drive, it works fine.Trouble comes when i try to feed back to Airtable. I have no problem with sending back a URL into airtable to open the document stored on Google Drive.But I do not know how to send the PDF into an attachement field in airtable. Here is my Make scenario:I have tried to insert a google drive share link action before the last airtable action and to pass this share link in the attachement field. Scenario works, and attachement field is populated, but clicking on the attachement in airtable opens a blank document (the direct link to the same document does open correctly).What do I need to do to correctly populate the attachement field?Thank you for helpingPascal 

Hi all, Hoping someone can help with a solution! My company has numerous assets that are “active” for long periods of time. I have a formula to calculate the “Active Status” based on the Asset Launch Date & Asset End Date (see below for reference). I would like to make an additional field that lists ALL dates an asset is going to be active based on the start and end dates (placeholder included in the image above). For example, if Asset Launch Date = 9/1/22 & Asset End Date = 9/5/22, I’d like the ALL ACTIVE DATES field to read: “9/1/22, 9/2/22, 9/3/22, 9/4/22, 9/5/22” Note: This field would be hidden 99.9% of the time and ONLY used in an Interface Filter element to allow users to type in specific dates (i.e. 9/3/22) and see the assets that will be “Active” on that date. If there is another solution you can think of, feel free to leave it here as well! Thank you in advance!

Hi, can I also indicate another email address that will receive an email after submitting a form. Or is this only for the owner of the base? Met vriendelijke groeten, Geert Dornez

Hello! We are using Airtable for a project plan, where we have one table with tasks and one table with milestones (several tasks are linked to each milestone). We would like to calculate the percentage of tasks completed for each milestone in the milestone table, so we can quickly see that for a specific milestone e.g. 70% of the tasks in the task table have a status of ‘complete’. Thanks in advance for your help!

Dear communityI need a formula to sum number rows. This seems a bit difficult, but maybe I'm just dumb...I just need to summarize #Beløb F and #Beløb S into #Beløb. I am doing it manually right now.Basically: #Beløb F + #Beløb S = f BeløbCan anybody help?Uffe, Klassiske Dage, Holstebro International Music Festival

Hello,I'd like to ask for help in troubleshooting an automation. I built an automation that works correctly when I "Generate a Preview". BUT, when I go to actually use it, the automation does NOT work. I.e., it does not update my live/active Base in the same way that it updated the Test Record. Actually, it appears to have done *nothing* to my Live Base, lol. Is this a common issue???Specific Context for my Automation:Table 1 is "Applications" where Client Application Forms are received. Table 2 is "Sessions" which lists all of the available time slots for Applicants to sign up for.Table 3 is "SignUps" where SignUp Forms are received indicating a specific Application # is signing up for a specific Session. When someone completes a "SignUp" form it automatically includes the Session they're choosing as well as their Application # (through a Prefilled URL). I want the automation to add the Application # from the SignUp Form to the Sessions Table to finish the circle of Applicat

I am attempting to create a SignUp Page in Airtable. My current iteration is live at this link. The form does meet the basic requirements I have, BUT the design/UI is lacking, especially the "Select Your Session" drop down.Is there a way I can change the "Select Your Session" into a Grid View, List View Interface, or even a Radio Button List within this form? Context: I'm trying to accomplish the SignUp process on an Airtable form because in addition to giving people a list of time slots to choose from, it enables me to prefill the guest's application number on the form (and hide it from the guest). This means the guest's application will be automatically linked to their session when they submit the SignUp form.I don't know of any other way to accomplish this because, for example, an interface doesn't allow me to prefill the guest's application #. Ideas or input welcome! TIA,ML

Hello community, I have an automation that informs the user by e-mail if the deadline of a task is before the start date. Unfortunately, in my opinion, it is not possible to set a dynamic validation for fields that would prevent this.However, if the user wants to move the timeline for the task, he usually changes the start date first and then the due date. this triggers the automation. Does anyone have an idea how to prevent this? best regardsMirko

I have 2 tables (Table 1 and Table 2) in a base (Base B). I have created 2 automations, the second one is not working.The records are created in Base A - Table 0 and synced to Base B - Table 1, so Table 1 is a synced table. The first automation works: When a record enters Table 1 (view X), a record is created in Table 2. The second automation doesn't work: when a record is updated in Table 1 (view X, all fields), update the record in Table 2The error is: The record does not exist. I wonder whether the problem is the fact that its a synced record. The record IDs in Tables 1 and 2 are exactly the same, but Table 0 shows a different one.Would anyone know how to fixt it? Thank you in advance. 

I'm trying to score based on a percentage another field is calculating.If Profitability is greater than 0%, score 2.If Profitability is between -5% and 0%, score 1.If Profitability is less than -5%, score 0.I can get it to work for greater than 0% and for less than -5% but it won't score the percentages less than -5%. I've tried at least 4 variations on this and can't get it right. Does anyone know what I'm doing wrong?

i have gotten the same error message several times in a row: Microsoft reported an error while processing this action:Microsoft may be experiencing issues with their API Any ideas on how to resolve this?

Hello airtable enthusiasts,I was wondering if anyone here has tried documenting airtable automations. I have a bunch of automations that use airtable blocks and sometimes even use the airtable scripts. I want to do a step by step documentation of what the the script does in a separate file for future reference. Is it possible using airtable? Alternatively does airtable AI help with it? If not, are there any other tools that help with the documentation process? Thanks 

I joined a team that's been using Airtable for a few years and noticed there's a view that was created by someone who's now retired. Is there a way to tell who's using a view so we can determine if it's okay to delete it?

Hello Airtable community,I'm trying to build a light personal content management tool, and I would really value your help. I've tried to explain the situation and questions as clear as possible below, and appreciate your help. Please let me know if you'll need a clarification.SituationThe database consists of (among others) the following tables:Industries: each record is an industry such as [IT] and [HR]User: each record is a user with basic user info, and also fields like [language] and a linked field [industry] (from table [Industries])FeedPosts: each record is a content item from a rss feed, with fields such as [title] [text] [image]  and a linked field [industry] (from table Industries)Content: this is the table where I need help for: see belowChallengeMy challenge for the records in the table [Content]:Multiple records should be created: for each user with the same value for [Industry] which matches the value [Industry] from the [FeedPosts] table a record should be creat