Solved

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?

Hello! I’m fairly new to using Airtable but right now I am creating an application where I pull data from a table I created and populate React components with that data. It’s a pretty simple integration and has been pretty straight forward for the most part but the only thing I am struggling with at the moment is pulling an image I stored in a table. I know Airtable has the “Attachment” datatype which is what I’ve been using but it’s been causing me runtime errors every time I try to pull the image for each record. Is there a better way to store and fetch images using Airtable? Is it better to use a third party alternative?

I’m from the UK, I want to store contacts including their post code. I want to somehow have the table display the area in which the contact lives based off the first part of their postcode. So for example if I have John Smith who lives in PL5 9KG, I want a formula to display only the ‘PL5’ part of his postcode, and then somehow have the next field then look this PL5 up in another table and then display ‘PLYMOUTH’. This would need to work for other, longer post codes too like PL21 or TR58. I already have the formula "LEFT(Postcode,4) to get the first 4 characters of the postcode field (Including the space if it’s only 3 characters at the start), but that’s as far as I have got. I have looked at various threads on here but can’t seem to work it out!

Hi everyone, I want to create a formula that gives the first day of the current month, one that gives the last date of the current month, and one for the first day of the next month. Does anyone have suggestions? Thanks in advance

Slightly different from the other many birthday calculations. I have AGE(date of record opened) and need to calculate AGE(Current). I do NOT have a birthdate and can’t get it. How do I calculate - DateCreated - XX(years) = YOB Which would allow me to then use - DATETIME_DIFF(TODAY(), {YOB}, ‘years’)

I have created an weekly triggered automation I want to call the Airtable Form Designer App, that i have installed on dashboard. This App is configured to create a well formatted document using a filtered table view. I am aware that i could create an email action in my automation, however the email options are Grid or List which is not formatted. Please advise thanks

Hi all, I am hiring a staff member to work with my in my small business. I have a recruitment agency and naturally my database is so valuable to me. I would love to know if there is a way I can stop a collaborator from being able to download the data in my base? What is to stop a person from taking my database (either by copying and pasting or downloading) and starting their own recruitment business in the same, very specialised industry. No harsh comments please — I know I need to trust my future staff and sure I will eventually but in the meantime I also need to protect my intellectual property. PlEASE NOTE: they do need the database access in order to do their job Thanks in advance!