Solved

My first community post...In a table Results I have a structure like this:Category field selects from another tableProcess field also selects from another tablePressures field selects from a third tableEach row of Results has a unique combination of Category - Process - Pressures for which it provides numeric data (analysis results) in subsequent fields. How can I create a lookup with both Category and Process to  identify the Pressures and numeric results? Another catch is that Process is also dependent on Category, as not all Processes are available to all Categories.So ideally the user would choose a Category and then see available Processes. After selecting a Process, they get a report of all the Pressures with the numeric data in a report.Possible in Airtable?

i’m creating a database where one of the tables is “people.” currently i have it set up so that the primary field concatenates the person’s first and last names to become a full name field. i also have this linked to another table in the base so that people in the table can register for events by finding their record in the people table to associate with their registration. however, it just occurred to me that i haven’t accounted for the fact that people in our database might have the same name, which would make the primary field not unique. i don’t really want to add their record ID to the primary field formula, which is the easiest solution i can think of, because then people would see that when they register for an event & find themselves in the list. i suppose i could create a more complicated way to handle RSVPs where it comes into another table & then matches with existing people somehow (i know this is possible, but haven’t learned how to do it yet). is there an easier w

Hi all, I figured out an easy workaround, but trying to understand why this is happening.I have three table that matter to this scenario - Employee, Certificate, and EmployeeCertificate (junction table)The Certificate table has a number field {Period of Validity} that records the period of validity of each certificate in months.The EmployeeCertificate table has the following fields:What is happening is that I have a lookup field in my EmployeeCertificate that looks up a number field in my Certificate table. The field it looks up is calledEmployeeCertificate is a junction table. It has one linked record field to my Employee table and another to the Certificate Employee (Linked Record)Certificate (Linked Record)Date of Certification (Date)Period of Validity (Lookup from Certificate table)Expiration Date (formula)The Expiration Date formula is DATEADD({Date of Certification}, {Period of Validity}, 'M')No matter the number in {Period of Validity}, that formula returns the same date as

SituationI've got a base (with 2 script extensions) which I share publicly and with all sharing options (copy data & extensions) enabled. The base is also not over it's extension limit in the workspace.ProblemWhen another user accesses this shared link and copy it to his/her workspace, the 2 scripts are there but their code is overwritten/removed with the default 'hello world' script.I do see for example this shared (vlookup example) base  where the scripts are working when you copy that base.Do you have an idea why it does not work for me?Do I need this deprecated beta to share extensions?Thanks in advance!   

Hi there,I'm not a developer but I'm exploring and using various scripting options, but can't seem to mitigate the crash I encounter when to use the script below. Can someone help with this? Thanks in advance!The feature I want to build is a bigger one: it's a vlookup feature with auto categorization based on the intermediate table [personal categorization] - so a script to conditionally link a record.But this is a simplified version without that auto vlookup to focus first on the crash when trying to link a record:Here I choose one record from table [personal expenses] and one from the table [personal categorization].The field [Type] in table [personal categorization] is a linked field with a link to a record in a 3rd table [personal budget].What I want to do in the end, is that the chosen record in [personal expenses] is linked to the record in [personal budget] via the field [tmpLookUpLinks], and that value should be retrieved from the field [Type] in the [personal categorization] t

Hello,I am experimenting with Airtable and Make, but I have a table with a Primary key which is a Formula field.I am trying to create a record in Airtable with this primary key as a formula, but the primary key is populated with NaN value.Isn't supposed Airtable to create this primary key even when I create a new record via Make?edit: I added some screenshot to show that inserting a new record via Airtable API is NOT updating the formula primary key------My second problem is that Upsert from Make in Airtable is not working, it constantly replies with "NOT FOUND", but Upsert is supposed to create the record if not found.Thank youCamillo

We are evaluating Airtable for use as a flexible project management system. A significant part of our workflows concern the intake, organization and review of PDF documents (e.g, correspondence, memos, progress reports, etc.).We have a firm grasp on how Airtable can help us with respect to the intake and organization workflows for PDFs as attachments. However, we are struggling with using Airtable to efficiently review PDFs, which is largely a product of our inability to display full resolution (or near full resolution) views of PDFs.The "record review" interface layout would be nearly perfect for our PDF review workflow if we could immediately display a full resolution view of PDF attachments when the record review interface is first opened without the need to click on the attachment, wait for it to open, and only then be presented with the full resolution view of the PDF.Based upon my search of this forum, it appears several people have requested the ability to incorporate full

Hi,I’m using Airtable for our fundraising Auction database to store items to then upload to our Auction website. We have our items in Airtable and then different image fields for the donation. We have 10 image fields. Each field has its own image. Those images are named by the product ID we assign them.Anyway, the issue I’m wondering about is when I download the CSV of items to then upload to our Auction website, some of the image fields have the image file name which is great, and then a lot of them have the image file name AND then a link to the image in parentheses as well. I’d like it to just have the name of the file without the parentheses and the link, nothing else. Is that possible?Here is an example of an item with two images: Argus BarGrilleArgus BarGrille $30 Gift Certificatechecked33363336a.jpg (https://v5.airtableusercontent.com/v1/17/17/1685080800000/e3lVoj8FvtRxx8BWOwj2BA/ilaexjilCZ2adMCU99U5nZUNWU_s6USfdE48s528CIWonEMKILjcGtyFCBQOdTGdjKWR88WeiIaste66H5TicItFRblGL9O

Scenario: I have a base with a table in it.  This base has the grid view, kaban view, and a form view.  The form view allows for the creation of new records.  When using the Kaban view from within the Data section, it seems very useful in my overall goal in creating a ticketing system.What I am trying to figure out is when creating an interface for these records using Kaban as the element, is there a way to allow for adding 'seeing and adding collaborator's comments' from w/in the Interface?  I can see these comments fine in the 'Data>Table>Kaban View' but don't know how to see these comments, let alone add new ones via the Kaban view in my interface.  Any help would be greatly appreciated.

I would like to find records whose ID field match a given value, playlistId, in a specific table I defined as playlistsRecords. In other words, I want to find matches in a field, get their record IDs, and if there are no matches to tell me that there are no matches. I've tried "playlistsRecords.includes(playlistId)" without success and suspect I need to rely something like the following: base('Playlists').find(playlistId, function(err, record) { if (err) { console.error(err); return; } console.log('Retrieved', record.id); }); Any pointers? Past experience? 

Simple and easy question, I plan on using airtable with a group of 25 for a project. Is it possible that I can allow all of them to edit on the free plan?

My brain is broken (or my formula is)… We have 4 departments (Production, Creative, Marketing, BD). When a prospective client is in our radar we run their product through a review process to get a sense from a variety of perspectives, the quality of their work. We submit the materials into an interface and the head of each department assigns a member from their team to the review. Once all 4 heads of assigned and marked their department ‘ready’ an automation kicks in and sends out an email… Sometimes there is 1 person assigned from each department… sometimes there are 2 or more… So my sheet has (for each department) 1 field for the user assignment 1 field that looks up the emails (and formats it in the manner expected “graham@email.com, joe@email.com” finally though, I have a formula feild that attempts to combine all those emails into one string of comma separated emails to that it can be inserted into the to: field of my outbound, automated email. Problem is… that doesnt work… When

I have a formula field in one of my bases that is designed to show us how much work is left to be done before a project's start date.So we have the start date and the number of outstanding tasks.  The formula field looks at those two fields and lets us know how many tasks per day are due.What I would like to do is drive an automation flow in the event that formula field spits out a number that is higher than it was before.  In other words, if we've been at 2 tasks per day but it jumps to 3 tasks per day, I'd want to know that.But I don't see any straightforward way to monitor a formula in this manner.  Anyone have any creative ideas?

Hello,I would like to create a job board with webflow and use Airtable as a backend when an application is submitted and send an automatic email summarizing the application (for the applicant and for me)First question :- Does an airtable form can be dynamic depending on the job page ? I don't want to create a new form for each job

I have tried wrapping both fields in VALUE(field), ABS(field), etc. How do I get this to behave? What is the reasoning behind this?

We are setting up a Booking system with Airtable and trying to find a way to hide / disallow our customers from selecting weekends on the Form View. We want to be able to see weekends on our end in the calendar view, but the customer should not be able to select a weekend as a start or end date. Any ideas?

Howdy AT community!Hoping an AT wizard can assist with the below forms automation conundrum:I have a subscription activation request form for a particular subscription product whereby customer organisations/managers can submit up to 10 nominated subscribers.  Form record fields are minimal, just nominated subscriber emails and organisation are required (with subscription product name hidden on the backend). I have set up an automation that creates records in a Product Slices table as submissions are received. However, the automation creates 10 records in the table regardless of nominated subscribers submitted (resulting in a lot of blank records!) Furthermore, the Organisation name does not populate for the first record created for some reason (see attached images). Can anyone advise on a way to tweak the automation to only create records against submitted nominated subscriber emails? 

Hello everyone, Pretty new to Airtable but I am enjoying the platform and the features it offers. Currently I have a table with data for when we last saw specific people. The date is being entered as February 13, 2023 for example and I am converting it to a different format for reporting purposes. I am currently using the formula:DATETIME_FORMAT({Date of Entry},"YYYYMMDD") which outputs the date as 20230213 which is exactly what is needed. The problem is that there are other sections where specific people will not have dates entered so it is returning errors in the table "#ERROR!" How do I make the formula only activate when there is a date entered?

Hi there. Has anyone figured out how to filter records in Interfaces for current week? I want to summarize values for this ongoing week and don't really know how right now. Thanks!

Hey all! Working on making Page Designer work hard to create the thing I need 🙂 A couple of limitations I have run into that I haven't found a workaround for yet:1) Flowthrough to another column. Currently I have this list of information:But I want to be able to run it over 2 columns like this (duplicated the field to illustrate what I want):The information would flow from the bottom of the first column to the top of the second in my perfect world.2) Grouping within the field in Page DesignerI love being able to do this in the regular tables, and this particular list I need to have grouped by Department in the same way:So the table above that I want in 2 columns...I also want sub-grouped by Department. The simple sort by department is ok, but not ideal because I need this form to look like what my film guys are used to seeing. Any thoughts?Thanks!!  

Hi all, I’d appreciate some guidance on how can I change the filenames of my attachments. I have a table with 500 records. Every record has a name and multiple images (attachments). The attachments have identical file names in multiple records, e.g I might have a file called 1.jpg in one record, then a different attachment in a different record with the same name of1.jpg. I managed to find a script that does that, but it changes the name only for one attachment. Ideally, would be to create a rule that adds to the current filename, the name from another field. e.g: Gorge 1 + current filename.jpg // Setup const mainTable = base.getTable("Test") const mainQuery = await mainTable.selectRecordsAsync() // Build new attachment data let updates = [] for (let record of mainQuery.records) { let attachments = record.getCellValue("images") if (attachments.length) { updates.push({ id: record.id, fields: { "images": [{

I have a work date formula in the 'end date' column.IF(AND({Start Date},{SLA (days)}), WORKDAY({Start Date},{SLA (days)}))When someone changes the SLA number, start dates and end dates changed because I setup a dependency automation.However, I'm seeing that some of the end dates are on weekends even though there is a work day formula in the end date column. Any insight? Also including a screenshot of the dependency roll up. Thank you!

Hello friends, I’ve had an automation running correctly in the past. Today, I’m getting the following error" The Automation is simple: When Condition is Met > Send Gmail Email. I tried reconnecting my Gmail Account, but problem still isn’t solved. Clicking on Learn how to fix common issues doesn’t provide a solution. My assumption is that this is an external error to Airtable, but I haven’t changed a thing in Gmail to possibly cause an error to this automation. Any suggestions? Solutions? Thanks

I am building an automated script that fetches two properties from an external API and subsequently upserts those data points into distinct fields in Airtable. The input is a URL field in the relevant record, and entering a URL in the field triggers the script.So far, I've put together a getData() function that retrieves the data from the external API and stores it as two variables: name and owner.I'm stuck as to how I actually populate the fields. In basic terms, I want to populate the "Name" field in Airtable with name and the "Owner" field in Airtable with owner.I've found the following snippets that may be the key, but I would appreciate some guidance:  let table = base.getTable("Records list"); let record = await input.recordAsync("Converting record", table); and base('Records list').update([...]); I can't find a learning resource for understanding the .recordAsync() method nor for the base.update() syntax. Is either of these what I'm looking for? Furtherm

Hi all,Wanted to see if anyone had any ideas why the following isn't working.BackgroundI have a table of issues each with a specific codeI also have a table that takes form submissions for the yes/no output of questions in the form.When the a question is answered "yes" I want to create a link in a lookup field to the issues table to record the specific issue found.IssueUpon the form submission the automation I have set up only works for the first question. After the first question none of the other questions answered yes are linking to the specific record.Any ideas why this is?