Ask the Community

Hi Everyone,I'm new to Airtable and formulas and have a pretty simple formula that is displaying a hyphen as a result of a calculation of zero, instead of the number 0. I admit I borrowed the formula originally from one I found on here, but not sure why the number I've designated isn't being displayed.It's not a true numeric calculation, but a replacement I'm using to give a numeric value to a field that also has text for ratings, i.e. 3 - Exemplary, etc., so that I can total up all the ratings from different categories and assign a value.Here's the formula:    IF( {Field1} = '0 - Deficient' , 0, IF( {Field2} = '3 - Exemplary', 3, IF( {Field3} = '2 - Accomplished', 2, IF( {Field4} = '1 - Developing', '1', 'Out of range' ) ) ) )    I personally have no idea why the formula shared was nested and if that has something to do with it, bu

Hello All,I need to migrate all of my records from an old base in to a new base.  The records in the old base have been assigned a number (through Auto ID plus a formula).  We are leaving the old base behind, importing all of the records in to the new one base, and resuming work in the new base.  I am trying to figure out how I can have Airtable resume number sequencing from where we left off in the old base and continue in the new base.  The new number sequence does not have to start exactly where the old one left off, and i cannot have the Auto Number feature assign a new number to existing records that I have imported.For example, we use Airtable to create and track projects.  Whenever a project is created, we have a summary field formula that takes the Auto Number (in this example 50011) and joins with with the prefix PR- (making it PR-49998) and also joins it with the project name (again in this example it is Organic Social Retainer - TEST

Hi there,I would need some help. I have entries with a field "Description" this field contains a lot of text (coming from calendar entries). Part of the text is the name of a store. it's the words after "Name des Stores: ". I need to extract these words and make them available for the next action. Any help is highly appreciated!!thx!!!!!

I have multiple values in two separate cells located within the same row. My objective is to subtract the first value from the "Stock" column from the first value in the "Quantity for Production without Units" column, and continue this process accordingly. Finally, I would like to place the result in a third column.So it would be something likeEstoque          Quantidade para produção sem unidades          Estoque-Consumo46200                              6000                             

Hi all,I'm using Airtable for a recruitment company. I have a table for candidates and for job listings. I want to be able to enter a new job with a salary, location and function and then have candidates who match the 3 criteria highlighted.So far I've created tables for salary, location and function then put linked fields for each in my job listing table and candidate table. So I can now tag the roles and candidates with each criteria and then using look-up fields show the candidates who have matched each criteria individually against the role.It would be great if there was a way to show candidates who match each of the 3 criteria. So a way of comparing the data across 3 lookup fields and highlighting any matches. Or is there an easier way to achieve this?Many thanks

Hello Community, please help to solve in an elegant way!I have record, and in a field called "FOOD" I have text separated by comma, let's say in the text I have"FOOD" = Apple, Carrot, sausageI then have another table caleld "FOOD CATEGORIES" with all the food separated by categories like (Can be a table for each category, same situation):Apple - FRUIT Banana- FRUIT Mango- FRUIT Carrot - VEGETABLEZucchini - VEGETABLEPotato - VEGETABLESausage- MEATBeef- MEATChicken- MEATIceCream - DESSERTCheescake - DESSERTCandy - DESSERTSo now I want that in the field next to the field "FOOD" will be a field called "FOOD CATEGORIES" where it will appear the food categories according to the table classification, the previous example, I want to see CATEGORIES FRUIT, VEGETABLE, MEATAt first I tough I could do with a super concatenation of IF, but seems not very elegant app

Hi Airtable community, first time posting here. Thanks for your help in advance.So, I'm trying to create something like YC Startup School weekly update forms: every new record will be named as "[Monday of the week of {created time}] - [Sunday of the week of {created time}]". Just like this:I'm very new to using formulas, but would really love to learn how that works.Tried "Weekday", "Dateadd"Got stuck right here. Thanks a lot! 

Hello,I would like to develop a script using scripting extension that would take 2min to run. Is it possible to schedule this script to run in every 5 min? If I schedule using this method there will be a 30 sec runtime limitation?https://support.airtable.com/docs/at-a-scheduled-time-automation-triggerThanks.

Hi !I'd like to substitute the "€" symbol only when it's alone in a field. (alone but with a space in front)For example, I've sometine a field with :1.00 €2.00 €€€€and it's very ugly in our contract.  ><I thought at the "LEN" and "FIND" formulas but I struggle to not replace the € when it is accompanied with a number... It would require a formula that only searches and replaces € symbols when it is alone with a leading space.Any ideas will be greatly appreciated :-)))) Thanks !

Hi .. Hi. How can I show 'next week day' . I know.  DATETIME_FORMAT(Date, 'dddd'). but anyway I can how 'next Monday' ?

Hello,When I run the script below as an automation, I get an error:Script exceeded execution time limit of 30 seconds Here is the code: let table = base.getTable("WPS-EVRI"); let result = await table.selectRecordsAsync(); let sums = {}; 

How do I get fields to wrap content (not just strings)? See image. Thanks!

Quick functionality question. Is there a way to highlight a set of records and make quickly assign them the same value in a given field? I.e. instead of assigning them the same value for X field independently, just highlight the records and do it with a couple of clicks?I know about the fill handle, but that isn't always practical

I have Typeform on my website that I use for Lead Generation. When I integrate that Typeform to Airtable, it imports all data (Name, Phone, Email etc) except for the Mailing Address data. I have tried all relevant Field Types but it still doesn't work. Collecting the mailing address is mission critical because I need to mail samples to that address of potential clients. If someone could help, I would really appreciate it.  

I want to update my Airtable attachment field with a pdf that is loaded in a Google Drive folder. This is what I have so far, and I think I am almost there. There seems to be an issue (Request failed for https://api.airtable.com returned code 404. Truncated server response: {"error":"NOT_FOUND"}) in the final step (attachPDFToRecord), which I cannot figure out. Any assistance would be appreciated. -----------------------------function getPDFFilesFromDrive() {  var folderId = "DRIVE FOLDER ID";  var folder = DriveApp.getFolderById(folderId); 

Is there any way to allow a collaborator to EDIT records, but NOT DELETE any records?

HelloSo I have a calendar view in my interface where a user can add a record to schedule an asset to play at a certain day or time. It's been working well so far, but the actual schedule never changes week to week only the asset assigned to that timeslot.The table for this calendar has a date/time (ex. 8/18/2023 10:00pm) primary field and I was wondering if there was a way to automate the creation of blank records for the time designated timeslots so that when a user tries to schedule an asset all they have to do is click one of the blank records in the calendar and assign the asset? This would make it faster for them to do the scheduling without having to manually recreate the scheduling time slots every week that never change anyway.I attempted to do this with a create record automation... but it seemed like I could only create date/time records for a specific date instead day of week. For reference below is the scheduled slots I'm trying to c

I'm totally new to Airtable automations, and these questions will probably show that.I want to set up an automation where the trigger is "When a record is created" and the action is "Send an email." The To field will draw from a lookup field in the table that contains email addresses.My first question is, if I create a record but don't enter an email address quite yet, will Airtable send an email when I go back and enter an email address later?Also, if I set up this automation for a table that already contains records, will Airtable send emails for all existing records, or just ones I enter after turning the automation on?

Hi All, I have a very simple automation to email a group of educational course participants at a scheduled time every week. All of the tests I run are successful, but the automation fails because "Google reported an error while processing this action: too many recipients." Since my automation is set up like this...trigger (at a scheduled time) > action (find records) > action (gmail: send email) ...I am trying to email the max number of records, which is 100. It's usually not a problem to email 100 people through gmail, so I'm not sure why the automation would fail. Does anyone have any advice on this? I have 700 people to email, so if I need to decrease the number of people I'm emailing, that would kind of defeat the purpose of the automation...Thank you!

Rolllups showing percentages or dollars aren't appearing in automation (sending gmail) the same way they are appearing in the data view. Dollars are showing a million places past the cents and percentages are reverting to numbers after a decimal. How do I fix this?

My goal is to calculate the percent of hours per week spent on a type of task. I have managed to calculate the sum of hours spent on each type of task for all entries regardless of the week number, but I can't figure out how to calculate the sum per week.In the table where I calculate the sum of hours, I have three fields: Task, Time (from my Time Track Entries table), and Sum. The Time Track Entries table contains the week number for each timed entry.Any suggestions for how to calculate the sum per week?Thanks,Lene

I could not find a solution for this in the forums: From a list of dates, I need to find that date that is the last date on that list before the launch date of a given project. The idea is to find the date best suited for an event to happen before a project is launched.Full description:Records in table "Status" are each linked to one specific "Project" and one specific "Outlet". "Status" looks-up the launch date of that project. In "Outlets", multiple dates are rolled-up from a table called "Release dates".I am looking for a formula that returns the one "Release date" that is closest, but not after the Launch date of the Project. The returned date must be in the "Status" table.I cannot use conditional look-up, as the date I need to compare with is not relative to today, but referenced elsewhere. So no way to use a relative condition like "before today" or so.I have transformed the dates in to Unix timestamps already. Mathematically, the date

Hey guys,I'm creating a competency framework.I've these tables :- Jobs (lookup to "Competencies" table)- Competencies (6000 rows) with macro-competencies in column 2 (multiselect)- Macro-Competencies (600 rows) (isolated from but not linked to "Competencies")I'd like to re-create the link/lookup between "Competencies" and "Macro-Competencies" tables. I tried to replace the multiselect field "Macro-Competencies" in "Competencies" table by a LookUp field and the replacement looks good EXCEPT when Macro-Competencies fields contains a COMMA. Then, there is an (unwanted) "auto-split".Is there a way to AVOID this split when there is a comma into the datas ? Thanks in advance !

Hi, I recently ran a script to pull updated changes to our airtable into our application and all the urls to attachments changed. I looked it up and saw that this was to make them invalid after 2 hours. We were using them to point to images on our site so this means a big change in our workflow as we will now have to download the images from the API rather than pointing to them in airtable. We wanted to opt out of the change for now and schedule the work closer to Feb. We opted out in settings and I ran the script to pull the data and get the non-expiring urls. They are still showing in the browser as expired. I have re-run the script and the urls don't change. Does anyone know what is going on?

Good morning and thank you for reading,we are collecting submissions (text + image) via Webhook into airtable. Both the text and image arrive well. We create a mail campaign in MailChimp. The image sometimes loads correctly via the URL, like in this casehttps://v5.airtableusercontent.com/v1/19/19/1692280800000/LV9HfgdvyYdgrTnNAMeSyA/ykTk-XRD0rj-hsr7z2m3YsPSITp32deMnMGtnnz3fOmneO1S5scCMbTy1wGxcOO13yQfh5wQE6ezVIvHfgh1bw1fORYHjXqFkX85WjJ92i9_sRi6iJSmmbIZieylNvxcnYWA34MX4lQfrC02jD6-CQ/pX-UW4Sv54vbuQ3r_VkKx6pBZJLqtDujjlm4lGk8hJgand sometimes it fails, like in this case