Solved

Hello everyone! I’ve got several cols (days of the week) that have a time that I wasted in doing a task in minutes (ex: 120). All that I’m trying to do is a SUM of this minutes but in a h:mm format. Example: The task is “Book Design” and the minutes I’ve spent in doing that task are (120, 120, 60, 60, 30). The SUM of that minutes is 390… that’s 6:30 hours. All I want to have is this number 6 and I don’t know how to get it. Thanks in advance!

Hopefully this is a simple one and I explain this correctly: I have a table of products containing several fields, including: unique product ID and price. (Let’s call this the primary table) I am using the Data Fetcher Airtable app to pull updated product information from an API into a separate table in the same base. (Let’s call this the secondary table). This also contains a unique product ID and price I want to fetch the price in the secondary table and update the relevant price field in the primary table, using the product ID to ensure the correct item is updated. If these were two tabs in Excel, I would just use a vlookup to look up the id and return the price. However I can’t figure out how to get this to work in Airtable. Any advice much appreciated. For info - the two tables do have a name field, containing the name of the product, however the names in the primary & secondary tables don’t always match, so I cannot use this field to match an item. Many thanks

Hi! :wave: I am having some difficulty with creating a formula in my database. I have one table - ‘Feedback’ - where each row is a bit of customer feedback, and each bit of feedback has a column for ‘Insight’ (i.e. what type of problem it is) and another column for ‘CSAT score’ (ranging from 1-5). I have another table - ‘Insights’ - which lists all the insights from the feedback table in the first column (these are linked). What I want to do is calculate the average CSAT score for each insight. I have managed to create a new column in the insights table entitled ‘CSAT Score (from Feedback)’ which looks up the CSAT scores from the other table and presents them for each insight, separated by a comma. What I then want to do is create another column which averages these scores. However, when I used the formula average({CSAT Score (from Feedback)}, I get the error message shown below. Do you know how I can fix this?? The CSAT scores in the Feedback table are formatted as numbers, so I th

I’m running a scripting app that loops through all the records in my Airtable using await table.updateRecordAsync() in a few fields, including a single-select field. Every once in a while, through human error or something else, we’ll wind up passing something to the script that makes it try to update the single-select field with some value that isn’t one of the options for that field. Right now what that does is cause the script to throw an error and abort entirely. What I’d like to do is have it throw an error message and continue on to the next record in the table. What’s the best way to go about this? Excerpt of the script in question below (for context, we’re a nonprofit helping folks in the criminal justice system): if (parsedNewDate.valueOf() != parsedOldDate.valueOf() || postSentencePrison != newPrison|| inmate.releaseCode) { if (parsedNewDate.valueOf() != parsedOldDate.valueOf()){

I’ve created a simple table to inventory my card supplies. After creating I decided to make changes and combine two columns into one, then I deleted the no longer need rows. I now realize that I should not have deleted the rows but should have left them empty for reuse. My question is…when I want to create a new row is there any way that I can re-use a deleted row ID?

I’m building a database to track uniform assignments for the local high school marching band. I have one table for students, another for the jackets, another for the pants, and so on. In the Students table, I have a field using the link to another record option linking to a jacket. I’ve been careful to make sure to not Allow linking to multiple records. I’ve then gone into the Jackets table, and made sure to not Allow linking to multiple records. What I can still do, however, is assign the same jacket to multiple students. And when I go to the Jackets table, I can see that the same jacket is assigned to two people. I would love to have this set up in such a way so that once a jacket is assigned to one student, it is not allowed to be assigned to a second one. Is there a way to do this?

Hi, I want to write a formula that will return ‘Yes’ if a record has been modified before a specific time of day. I have my team ticking a checkbox, which if checked before a certain time will mean a yes result. If the tick box is ticked after that time the result is no. I’m using the ‘last modified time’ field type as the time stamp to use in the formula I tried Is_Before with TimeSTR but not sure about how to specify the deadline time. Any thoughts?

Hi! I’m trying to figure out how to get the gantt view to display a background grid of column & rows so it’s easier to read quickly. Is there an option somewhere for that? Just a plain ol’ outlined set of cells, basically. Thanks!

I’m running issues when running block release to deploy my Airtable app. I’m using npm workspaces as I develop my Custom Airtable App since I’m using a monorepo to make code management and sharing convenient. Here’s the basic folder structure for my project: project_root/ packages/ - houses workspaces common/ contains code shared by airtable_app and server workspaces package name: @shoptable/common airtable_app/ - contains the airtable block app server/ - another workspace Here are the steps I take before running block release: npm i from project_root cd packages/airtable_app block release I run into the following error: building copying package.json file copying package-lock.json file ❌ Error: package-lock.json does not exist! Failed to build the block code! There’s only a package-lock.json generated at the project_root level. How can I get around this issue with my development environment? Current Workaround The only way I’ve found that works is to run npm pack

I have an if statement that adds 2 different types of fields together (Lookup and Currency). I cannot format the lookup field to become a currency field and I think that because of that, I cannot do any mathematical operations between the 2 fields. Is there a work around to this? I’ve tried concat-ing a “$” in to the Lookup but no such luck. Thanks

There are two linked tables: Posts (ie. an index of blog posts, with dates) Companies (a list of companies who author blog posts) Companies already has a Count field column to display the total Posts by given Company. However, I’d like also to count the posts by Company within the last seven days. One view of Posts is filtered to show records with dates within the last week. But how do I utilise this or similar on the Companies table? Thanks.

I want to be able to split a url address into its component and use them as I may need. What I have: “Airtable Universe” What I’d like to achieve “https://” “airtable.com” universe how would you handle this use-case? can you provide any smart solutions? thanks in advance

I’ve seen a couple of postings that sort of sound similar so apologies if this is elsewhere and I couldn’t find it! I have a table, “Requests”, that is filled in by a form. When a new record comes in, an admin will review the submission and then check a box to trigger a welcome email. I’d like to be able to attach a PDF (always the same PDF) in the welcome email. I don’t want to pull this PDF from each record because that will eat away at our space (and because it’s always the same PDF), so I’ve placed this PDF in another table (called “Resources”) in the same base. I’ve set up an automation that: Triggers when an admin checks the “Send Welcome Email” box in the “Requests” table Does a “Find Records” on the “Resources” table to find the attachment I want But I think this method is failing because it sees it purely as a reference and not as the actual PDF. If I don’t want to use a third party app like Zapier, and I don’t want to embed a link to the PDF in the body of the email, is

Hey Everyone! I need a little assistance with my formula here. Basically, I’m trying to pack alot of information into my primary field so that it appears on the calendar blocks. I have a few fields of information here: Clinic Name Clinic Date Type of Vaccine Offered Number of Doses Offered Primary Team working Supporting Team working (if any) My question is this: Sometimes there won’t be a supporting team. Is there a way to build in an “if” statement to my formula to indicate “If supporting team isn’t empty, add this clause”, essentially? Here’s my current formula: DATETIME_FORMAT({Clinic Date},‘MM-DD-YY’)&" “&{Clinic Name + Activity}&” - “&{Lead Team}&” Supported By “&{Supporting Team}&” - “&{# Doses Scheduled}&” "&{Vaccine Dose Type}

Hello! I’m setting up a form where respondents would include their email address. I’d like to set up an automation that would use that email address to select a linked field based on the email addresses matching. Possible? Thanks!

I wrote the codes as below: IF({Priority of task} = OR("Emergency","Important","Urgent"), SWITCH({Days until deadline},3,"3️⃣",2,"2️⃣",1,"1️⃣",0,"‼️"),"This is not an important task") But the result is that all tasks shows “This is not an important task” even the priority is emergency. I wonder is it due to the misuse of OR() in the formula? Can OR() be used like IF(… = OR(…, …, …) , … , … ) this way? Thanks.

Hi, I’d like the date/time to be recorded based on the result of a formula but can’t seem to make this work. My formula basically compares two quantities (both numbers of course) and evaluates to “LOW” or “OK” depending the threshold I’ve set. I want another column to capture the date/time only if the formula results to LOW, but can’t seem to make this work. Things I’ve tried. Had the second column evaluate to NOW() if the the previous column formula result is “LOW”. This doesn’t help because as long as the prev. column stays as “LOW”, the date/time column keeps updating the timestamp based on NOW(). I only want a static timestamp of when the formula evaluated that to low. I tried to use the LAST_MODIFIED_TIME(), but that cannot work on fields that are automatically calculated such as a formula field. How would I accomplish this? Thank you.

Hi everyone! Thank you in advance for taking a look at this. I have a formula that I think is REALLY CLOSE but keeps giving me an error. The field I’m having the formula search contains a series of state abbreviations, so MI may or may not be present in the string, and I want to differentiate between MI not being present (but other states being present) and the cell being blank. The formula should work a little something like this: IF (MI is present, then “SLP”), IF (MI is not present, then “Applying”), IF(BLANK(), “Candidate”). Here’s what I have so far. Each half works by itself, but when I put them together they always give me an error. IF({SLPs Licenses (from SLP Onboarding Link)}=BLANK(), “Candidate”, IF( FIND(“MI”,{SLPs Licenses (from SLP Onboarding Link)}),“SLP”, "Applying”))

Hello, I want to add a condition in “Find records” but somehow nothing get added when I choose it. I can only add field which show me the “Insert” button. With the other option I can only press “continue” until I have no option anymore. Can anyone tell me how to add those value fields or tell my why it won’t work? Thanks in advance, Sebastian

I am trying to set up an automation so that when I tick a checkbox in one record, it updates a status field in the same record - I must be missing something in the help files as for the life of me I can’t find how to do this. Any help much appreciated!

Hello good people of airtable! I would like to know how to: add two percentages together, then minus that percentage from an amount? to get the sum of that calculation in this case- FEE (£40) - (CUT (10%) + TAX (20%) = 30%) = PROFIT (£28)

So im trying to calculate days that are left for a project to end. Im using DATETIME_DIFF({End Date}, TODAY(), ‘days’) but some ended projects show -2 (the ones that ended 2 days ago) how can I make them just stay at 0? Maybe an if condition. But Cant seem to find it. Thanks!

Automation keeps shutting itself off after 5 seconds. Tested all the step success all the way through. Trigger: New Google form Submission Action: Find Record based on email Action: Script to format data Action: Create new Record with data and linking to found record Error just says try again no information Airtable Documentation suggests it’s issue with managed accounts so I did a reconnect still no difference. Seems to be the Google Forms connection ideas as to why when the connection works and tests successfully welcome

Hi folks, I’m in the process of moving some data from Google Sheets into Airtable. In the Google sheets I have three tabs. The first two have data added manually. The third tab uses formula to pull through the data from tabs 1 & 2. This formula is working fine in Google sheets, but I get an error message in AirTable when trying to switch the column type to formula. I’m sure it’s something simple, like I’m referencing the wrong fields in the formula, but as I’m a newbie to AirTable, I’m struggling to find a solution.

I have a field in Airtable with L x W x H listed in one cell. The information follows the same format every time. There is a space followed by an x followed by another space. I would like to pull each value into it’s own cell. I know it would be easier to go the other way around, but we already have a lot of data in this format and it’d be easier for the team entering the information to continue their process. Can someone help me write a formula to get these 3 values into their own fields?