Solved

This is a newbie question. I have a sequence of numbers in my inventory and these are not auto generated, so I am either working with Number or Formula here. I am trying to add zeros to a sequence so that all numbers have 6 digits. Currently, my numbers start at 0 and go up to 4 digits, I think I am looking for an If / Then LEN formula, but I can’t figure out the syntax to make it work. For example, I need 5 to read as 000005, and I need 1401 to read 001401. etc. Thanks in advance.

So in search extensions say I search up like “walmart” and all the Walmart tabs come up how can I print that?

Hi everyone, I have a table design query in 2 parts. Firstly, I’d like to know your opinions about creating a ‘people’ table in a base - is it best if it is one table or many? For example, I have people that are: ‘students’ taking classes, ‘payees’ that might pay for those students’ classes (some students pay for their own). ‘company contacts’ who normally don’t take classes or pay (but work for companies that do pay) If I create 3 separate tables, all these 3 groups of people will require similar fields in each of those tables and a payee could also be a student themselves… also a company contact might also be a student so I think that one table would probably be better with each person marked with a different (or multiple) ‘person type category’ (in the case of students who are also payees for example). Is there any reason/advantage to keeping these different types of people in different tables? The second part is payment related: Classes can be paid for either by the students th

Hello Right now Im on airtable pro trial plan and Im trying to use automation script but it tells me that its not available for my current billing plan. I was wondering whats the point of pro trial if I cant access its features? Then I tried to upgrade my plan to plus and Im only able to select yearly plan for billing and I cant choose monthly. As you see the image Im upgraded to plus but still not able to use this script feature. Thanks for reading

I am trying to use Promise.all to asynchronously get data from an array of urls. I’m fairly new to promises but as far as I understand the below code should work? The code executes but no response is logged from the promise.all Promise.all(urls.map(u=>fetch(u,options))).then(response=>{ console.log(response[0]) }

Hi is it possible to tell airtable to look at two fields and look it up/match the fields on a different table and return the corresponding value? For example: Looking at the first image, L5 field (Media Engineering) and the size field (s) lookup the value for “s” in another table, second image, AND for Media Engineering and return the corresponding value? In this case it should return 20%. Any suggestions welcome! Thank you!

Hi guys, It looks like a change has happened overnight - URLs to attachments have changed from this structure: https://dl.airtable.com/.attachments/d656d5c54fbc38ad9195c2f62cd02dae/5eb64051/Supreme_Apex-1120x740.jpg To this structure: https://v5.airtableusercontent.com/v1/10/10/1668182400000/q_tvhAt9ivi_oCjJ5LvWQQ/ghcs73y0Vma8Rz6c7EJaen3sRTVMOCrqmPpkS38kxl2SOiMEE5boOfVOorY5nfQ9PZkrQCYfehg76B4CcI8-MA/1wi2qtg7XnHCVhZhtKjxg_BXwwegwsGxphbPlJRYlao This has broken our API integrations for saving images to WordPress / WooCommerce as WordPress requires a file extension to exist. Has there been an announcement anywhere about this major change?

Hey guys, I’ve been really struggling with this for quite a long, hope you can give me a hand. I’m aware, that those questions have been asked already several times here, but still I couldn’t apply any of proposed solutions to my case. I have table A where I’m adding booking numbers. There are also several “special” booking numbers in table B. Whenever in table A there is a booking number, that already exists in table B, I want to have it tagged/highlighted in the next column (in table A). In the same table A, I’m adding a notification numbers. Whenever I add the notification number that already exists in the same table A, I want to have it highlighted in the next colum. Thanks a lot

Greetings! I’d created a formula: CONCATENATE({Month #},“-”,Month) so that grouping in my table(s) would do so since obviously April would be first in the order, etc. However, when I have it sorted in the chart, as you see, the order is, well, not what I’d expect. Any suggestions?

We have an Automation setup to send an email notification via gmail account. In the email body is an Attachment field. The email recipients could open the attachments perfectly fine for month. In the last 2-3 days (likely as a results of the Attachment URL change/expiration), these attachments thumbnails show in the email body of the email notification recipients, but there is an error when clicking on the thumbnail image to try to view the attached file. Here is what the recipients see… The email recipients, as in the example of the screen shot above, are not users of Airtable. We just send them email notifications. Any way to fix this? Thanks, Khuned

I have a “Tasks” table with a checkbox (Open OR Complete). I want to list (Rollup) all “Open tasks” in one field and “Complete tasks” in another field on a different table (Clients) What should the formula be?

I have a formula field that creates a URL from a form, with pre-filled data. We are sending this URL link via an automated email. When someone receives the link on a mobile device and tries to open it, they land on the Airtable site and are asked to sign up. It does not display the form in a browser.This is not an issue on a computer. How do we fix this?

Hi there! I am looking to add to my formula (below and attached) that when the date is blank or 0 for the field to say “due today” CURRENT FORMULA DATETIME_DIFF({SHIP}, NOW(), ‘days’) & " " & IF(DATETIME_DIFF({SHIP}, NOW(), ‘days’) > 0, “days remaining :hourglass_flowing_sand: ”, “days overdue :boom: ”)

Hi! I created a field that concatenates the last name and full name in a table. I am trying to write a function that takes the 2 letters first letter of the first name and 2 last letters of the last name. But it only returns the 2 first letters of the first name. Here is the formula CONCATENATE( UPPER( LEFT( {Full Name},2), RIGHT( {Full Name},2) )) How can we make it happen ? Thank you

Hi, can you help me? I need to sum 16% if the field “Incluir IVA” contains 16%, if it doesn’t, just do the first arithmetic operation. Thank you

Hello! I am building out a new base for my department which runs a variety of Programs throughout the year. Thus far I have set up some dummy data (i.e the “steps” you see in the screenshot) to successfully link my tasks to projects. There is a flow to how we approach the different programs we offer in terms of our when open applications, when we contract instructors for a workshop and so on and so forth. I have it set up so that every time I create a new project - based on the project I select, the are a number of tasks that will be automatically generated. I am now hoping to make it so that when a “Program Start Date” is entered, the “Task Due Date” will auto populate a deadline for each task based on a formula that aligns with our overall event timelines. Based on some previous community posts and through general research I see that the SWITCH formula might be the right way to go. However, after trying to create and implement what I thought was a proper formula - there are no tasks

I have this formula WORKDAY({Release Date},-{weeks out in #days}) it returns the date that I need but if there is a cell with Release Date empty, it returns #ERROR. I have tried this formula IF( AND( {Release Date}, {weeks out in #days} ), DATETIME_DIFF({weeks out in #days},{Release Date},‘date’), BLANK()) it removes the #ERROR on the cells that it should, but it puts #ERROR in all of the date fields, I lose the dates that I need. I have tried this formula WORKDAY({Release Date},-{weeks out in #days}, BLANK()) this one puts #ERROR in all cells. what I need: the first formula that returns dates, but if the {Release Date} cell is empty, I want to see a blank rather than #ERROR.

Surely this is an easy formula, but I just can’t get my brain to bend this way: I am using Airtable for my timesheet for my employees. I would like to improve upon my existing “Total Hours” formula by showing “Total Hours by task” , and each task is a single select item in another field. Here’s my “Total Hours” formula currently: DATETIME_DIFF({Time Out},{Time In},‘minutes’) / 60 Field for the different tasks is aptly named: “Task” Specific Single Select is “Teaching” Please help! Thanks!

Hi there, I noticed that the HTML attachment preview seems to be unable to render Unicode characters. Characters like typographic apostrophes or em-dashes turn into garbage character sequences. (See attached screenshots.) Is this a known bug? Is there a workaround available?

Hi Community, I have a table with multiple records. Each record has the name of a colleague in the first column/field, an email in the second column, a link for that email in the third column, and the weekday in the fourth column. E.g., Record 1: Simon, simon.g@gmail.com, URL 1, Thursday Record 2: Jack, jack.f@gmail.com, URL 2, Thursday I need to send the links to the email addresses for each person. Since each link is specifically designed for that colleague, I would have to send individual emails to each colleague. Is there a way to automate the process? So that by every Friday, Airtable could automatically send URL 1 to Simon and URL 2 to Jack, and so on for every colleagues. Thanks!

Hello, I am new here. I am also new to formulas. Have managed to work out the formula to calculate the number of 12hr shifts between two date/time fields. ROUNDUP(((DATETIME_DIFF({DepartureDate},{ArrivalDate},‘minutes’) /60 ) /12), 0) My struggle is that shifts are from 06:00 to 18:00 day shift and 18:00 to 06:00 night shift. Therefore if a start time is any time between 06:00 and 18:00 I need it to 'snapback to the default start 06:00. And the same for if the start time is any time between 18:00 and 06:00, I need it to ‘snapback’ to the default start 18:00. Bearing in mind that these are date and time fields formatted YYYY-MM-DD HH:mm. Can anybody help with the correct formula? I hope my explanation makes sense!

Depsite @Justin_Barrett’s help last time, I still cannot figure out simple regex patterns. This time, I’m combining in a roll-up year and value and am trying to extract the value based on a date. IF( AND(Date, Values), REGEX_EXTRACT( Values, "(?:" & DATETIME_FORMAT(Date,"YYYY") & " )([^,])")) For example Values: 2023 530,2022 480, Date: 2022 Result: 480 Preferably each string would be Year:Value,Year:Value… but I was afraid the double dot may me some reserved character and dropped it.

Hello! I was wondering is there a way to do what this screenshot shows with a formula? I want to use the output of that formula to update an automation to change a single select field to show when the project is due. We can’t use the color feature anymore because we are trying to switch over to interfaces and unless I completely missed it, there isn’t a way to have the color feature on a record review interface. Any help would be great!

Hello, For my plant tracker I’ve been using a formula to give me an estimated date of transplanting. This has been working fine. Now I want to add a check-box, so that when I plant something in-ground and i check this, the Estimated date of transplanting box will return an N/A vallue. I got all of this to work but I have a problem with how to date is formatted. As you can see the last column has a different date format. This is the code: IF({In-ground} = 1, “N/A”, IF({Germination Date}, DATEADD({Germination Date},{Estimated days to Transplanting}+0,‘days’),IF({Estimated germination date}, DATEADD({Estimated germination date},{Estimated days to Transplanting}+0,‘days’)))) I tried to add a BLANK() after the DATEADD so I can change it in the formatting tab but it doesn’t work. I think I have to add a DATETIME_FORMAT but i’m not sure where to add it in this formula. Thanks for your help!

Hello! I have two fields. One titled: Naming Convention Help w/ this formula: SWITCH({Naming Convention},"Series",{Standard File Name (Series) Template}, "Movie",{Movies - Naming Convention}, "Awards & FYC",{Awards - Naming Convention}, "Free",{Free Series - Naming Convention}, "Series V2",{Series Naming Convention V2}, "Series V3",{Series Naming Convention V3}, {Standard File Name (Series) Template}) and another formula field titled Naming Convention Final: IF(AND({Language}&"" = "en-US", {Naming Convention}="Series V3"),{Series Naming Convention V3},{Naming Convention Help}) I’m completely stumped on this one and need to reduce the number of fields in my base, any way to combined these two fields into one?