Solved

Hello! I am currently pulling info from Jira into a table, and then pulling Sprint Start / End dates from Jira into another table. Because Jira doesn't expose that information directly, it is pulled into a GSheet, which I then pull into Airtable.The Sprint Name is pulled from Jira directly into my main table, and there is an exact match for each in the Sprint Info table. I created a Link to Another Record field which sources from the Sprint Info table, and corresponding Start / End date Lookup fields based on that table. I created an Automation that looks for any records in my main table that have a non-empty value and updates the Sprint Info 'Link to' field with the value from the Sprint field (screenshot below).When I generate a preview of the automation results, I can see that the Sprint Info linked field gets a value, but when I go back to my table, nothing is actually being updated. Any idea what I might be doing wrong, or a better way to accomplish this? 

Good morning, what alternatives are there to generate reports or export our views to PDF that are available for the free plan (I know that in the payment plan is the export to google docs).Thank you very much for your support

Hello AirTable Community,I am trying to export multiple AirTable records in one PDF. Concrete case is a list of samples that have several values, I want to create a pdf that will be handed to the lab for testing containing a list of multiple selected records in a nice format, not just a CSV. Are there any tools or extension for that? I couldn't find anything so far. If this is not possible in AirTable, does anyone know a work around? For example exporting a view as CSV and then automatically converting the CSV to the PDF format, maybe in Google Workspace? Or through the interface?Thank you very much!

I need to pull some data from a computed field (actually a filtered lookup field) in Airtable to prefill a form in Jotform. It should be easy as Jotform have introduced the feature (bizarrely under the publish menu) but despite several ways of trying, it will not map to computed fields.My inteded workaround is to map it to a long text field which an automation would update with the value from the lookup field, triggered if the lookup field is not empty. On mapping the fields in the automation, Airtable greys out the lookup field {Instruments} reporting the same issue as occurred whilst trying to mp directly from Jotform, that the field cannot be used because it's computed.I've spent a whole week on this. I've tried converting to text, using a string, an array, and concatenating, but of course, they all need computed fields to hold and reference them.  Anyone know a workaround? Post edit/after thought....Perhaps I can use a script with the same trigger but I'm not really a scr

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?