Solved

Hey guys, I have hundreds of records that contain one of 12 combinations of initials. I want to create a new column that finds those initials and depending on what they are, write the entire name. For example: Column A includes: 2017-02-07.boe_.ag_.pdf 2017-02-07.bos_.ag_.pdf 2017-02-09.bof_.ag_.pdf I want the formula for Column B to find the initials, and write in the full name following these rules: if it finds “boe”, write “Board of Education” if it finds “bos”, write “Board of Selectmen” if it finds “bof”, write “Board of Finance” So, the end result in Column B would be: Board of Education Board of Selectmen Board of Finance Thanks for any and all help with this! If cell contains A, write X - or - if cell contains B, write Y

I am very new to AirTable. Here’s what I would like to accomplish. An email is sent to AirTable, which is then triggered/processed because it contains a specific subject of “Inventory”. AirTable then looks at the body of the email and looks for fields with thier values. For example, the email could look like: Body: Batch = 000012 User = Mary Jane Usage Type = Discarded I would then have a table in my database which contains columns named: “Batch”, “User” and “Usage Type”. I would like the values (after the equal sign) to be added into their matching columns as a new record in the table. I have a method for creating the emails, and I can have them formatted in anyway to get this to work correctly. I looked into Zapier which appeared to be my only solution, but even that I struggled with setting up. Any kind of advice, tips, articles, videos, would be greatly appreciated!

Hi, I have a formula DATETIME_DIFF(Date,28/06/2020,‘days’) This should give me the number of days between “Date” (a date field) and a specified date. I must have something wrong as it displays 18441 regardless of the date I specify. What do I need to do? Cheers Jason

Does the custom block API allow us to call POST/GET requests to external services such as one’s own AWS EC2? It seems that I can only call Wikipedia and other services fail

Hi! I am working on a Block that would require a backend server (with API access tokens), what is the recommended approach? Should I host the backend myself, or is there a nodejs equivalent of frontendEntry for backends? Thank you in advance!

I’m trying pass a string as a field - which I’m pretty sure I’ve seen @kuovonne explain someone else that it’s possible. const mainCur = base.getTable("Contacts").getView("Currency"); const mainCurMatchField = 'Currency name' const mainCurrencyConversion = async (tableView, matchField) => { let selectRecords, gbp, eur, usd selectRecords = await tableView.selectRecordsAsync(); [gbp, eur, usd] = await getConversion('test') for (let record of selectRecords.records){ console.log(record.getCellValue(matchField)) } }; await mainCurrencyConversion(mainCur, mainCurMatchField) I’m trying to get record.getCellValue(matchField) to use ‘Currency name’ as field name. I’ve tried to wrapped it in {}, but so far I’ve been out of luck. Is this possible or is it me who got this wrong?

I am trying to write a string of IF statements…so the logic is this: If user selects "Country’ as “North Vietnam” and/If the ‘Ultimate Destination’ is “Long Beach”, then the result should be the date column{North Vietnam to LAX}. This works. But… The problem is it won’t let me keep adding to the IF string. for example below: it won’t recognize the "China’ Query. I am really struggling with this one…any help would be so much appreciated. IF({Country}=“North Vietnam”,IF({Ultimate Destination}=“Long Beach”,{North Vietnam to LAX},IF({Country}=“South Vietnam”,IF({Ultimate Destination}=“Long Beach”,{South Vietnam to LAX} IF({Country}=“China”,IF({Ultimate Destination}=“Long Beach”,{China to LAX},IF({Country}="India ",IF({Ultimate Destination}=“Long Beach”,{India to LAX})))) This formula works, but I cannot add onto it: IF({Country}=“North Vietnam”,IF({Ultimate Destination}=“Long Beach”,{North Vietnam to LAX}))

I’ve created a bar graph to show my sales by fiscal year, grouped by quarter. Sorting the fiscal years into the correct order is a cinch. However, the order of the quarters isn’t as easy. I’d love for it to display the quarters in order of Q1, Q2, Q3, Q4. Instead, it’s going Q3, Q4, Q1, Q2. I’m guessing that this might perhaps be because Q3 is at the beginning of the calendar year, but who knows.

I saw a post that showed an answer that delivered almost everything I wanted and I have pasted that in below. That post has been closed hence starting a new one. However please could someone advise how to adjust the formula so that the entry is only removed from the current year and moved to the following year once the day has passed (rather than on the day itself). For instance, using the formula below, a birthday on 27 June 2020 will disappear from the 2020 calendar on that day and appear on 27 June 2021. I would like to delay that until 28 June so I can still see the current event on the day itself (27 June in this case). Here is the formula from the previous post that I would like to adapt. Apologies for not crediting the person who posted this formula - I have navigated away from the page and can’t find it at the moment. I tried messing about with IS_AFTER but I am not sure if this is the right way to do it or how to insert that successfully into the formula if it is. DATETIME_P

Hi there! I am a public speaker, and I would like to use Airtable to track my “gigs”, from point of interest until they are complete. This will help me track documents and vital things I forget due to the long time frames this involves. One thing I am struggling with is that Gig start days and times are inconsistent. Meaning, I may do a full-day workshop for an organization, and that’s easy. But sometimes they want me to do two workshops, or smaller trainings split into multiple days but they are all part of a series. Currently, I have to add each day/time in as a separate Gig, which makes me cringe because they are NOT separate, but rather nested as part of the overall gig. I would like to not have to use multiple tables for this–is that even possible? Any ideas on how I can lay this out?

I am looking to take a long string of comma separated numbers (it is a string from a look up). Here is an example of numbers to summarize: 1.17-01, 1.17-02, 1.17-03, 1.17-04, 1.17-05, 1.17-06, 1.17-07, 1.17-08, 1.17-09, 1.17-10, 1.17-11, 1.17-12, 1.17-13, 1.17-14, 1.17-17, 1.17-18, 1.33-01, 1.33-02, 1.33-03, 1.33-04, 1.33-05, 1.33-07, 1.33-08, 1.33-09, 1.33-10, 1.33-11, 1.33-12, 1.33-13, 1.33-14, 1.33-15, 1.33-16, 1.33-17 If you look closely, there are missing numbers. I am hoping to find a formula that will output: 1.17-01 --> 1.17-14, 1.17-17, 1.17-18, 1.33-01, --> 1.33-05, 1.33-07, --> 1.33-17 I am flexible on the “–>”, but as you can see a simple dash won’t work, because dashes exist in the numbers. Has anyone seen something like this before? Any help would be greatly appreciated!!

Sorry sure there is something simple I am missing - I have a table which is essentially people rating how excited they are about different themes for a summer playscheme for disabled kiddies because I needed everyone to vote the columns are the themes and they have a rating of our 5 for every person who has filled it in - is there a way to create a chart to show which theme has the most votes? On the chart block, I can only find a way to make it from the different people and not the theme scores am I being silly?

I am using the Airtable Python API With the following code I get a successful response, minus the API key I removed. *from airtable import Airtable* import os* table_name = ‘PeachTree 903’;* base_key = ‘app9F0yiPo2kvFBsA’;* api_key = ‘’;* airtable = Airtable(base_key, table_name, api_key)* print(airtable)* The response I get from the above is: Which matches my table_name. Now when I go to add this next line and run the script I get the following errors like nothing is returned which does not make any sense. airtable.get_all() Anyone solve this?

Hi! I imported an Excel spreadsheet into a new Base. When I did, some of the addresses and phone numbers had a question mark appear next to them. What is this and how can I get rid of it? 434-332-8227�

Hello, I am trying to find out if there is a way to create a link, that when you click on it, it immediately brings you to/opens up a different table. For example: I have a main spreadsheet with labels in Column 1, stating the type of promotional item we need. T-Shirts, Coffee Cups, etc. Then I have a separate table for each type of item. So a table for T-Shirts with info on each t-shirt order. I want to be able to click on the word “T-shirts” from Column 1 in the main table, and have it open up the “T-Shirts” table with specific information on each order. I understand how to link so it will show you the records when you expand the data field, but I want to actually GO to that specific table. I also noticed if I try to do this with just a single data field, then it links ALL of the data fields in the column to the same record. I want each record to be able to link to a different table. I hope this makes sense! Please feel free to ask any additional needed questions. Thank you in advanc

Hi 3 tabs: vacation: form > start and end date vacation + linked records to “employees” so they can select themselves employees projects: per record 1 day to work on a project + linked records to “employees” to select technician Question: is there any way to signal in any way (preferably not being able to select the technician in question) that the selected/to be selected technician is on vacation on the workday in question?

Here is my goal. I have three fields within my table as follows: Button Field (for the purpose of running script, available in Beta) Check Box Field (used for filtering view) Linked Record Field I am looking for script (or other method) to do the following: Click button to run script Script marks Check Box with Check Script adds all available records from linked table in the Linked Record field. For example, say there are 3 records in the linked table. When I click the button in the record in my table, the Linked Record field should populate with links to those three records. Thanks!

Hi, With AirTable, can you create a view where you see the details of a single record and a list of linked records for a given field underneath? e.g. As per the above spreadsheet example: I have a Unit that has multiple fields, e.g. course description, learning outcomes … it would link to a Sessions table with multiple records there. Can I have a list of Sessions records underneath? Thanks, Daniel

I tried searching the forum but could not find what I am attempting to do. My objective is to create a Case Study and Employee Resume master database. My goal is to be able to select an employee, select a project that the employee worked on, and then receive an output that shows that employees resume description for that project. I’m stuck on how to achieve this in Airtable. Here are my tables so far: Case Studies Project Name Client Name Role State Employees that Worked on the Project Description of Project Role Firm Played … Clients Client Name Projects (linked) Main Contact Email …. Employees Employee Name Title Projects Employee Worked On (Linked) I’m not certain how to get to the next step. Where should I store the employee’s project description when I have 65 employees? Can I do conditional formatting to be able to select what I want? Any help would be greatly appreciate.

I’m trying to create a single-select field for easier sorting based on a compiled age based on the Birthdate (DOB) column. Here are my formulas: Age column: DATETIME_DIFF(TODAY(),{DOB}, “years”) Which returns the age of each student. Age Groups Column: IF( {Age} <= 2, ‘PRE-K’, IF( {Age} = 3, ‘3-5’, IF( {Age} = 4, ‘3-5’, IF( {Age} = 5, ‘3-5’ ) ) ) ) Please tell me there is an easier way to do this lol. I want it to autocompile, but I’d like it to be single-select rather than return plain text for the visual aspect with color coding. I hope this makes sense! The “Age Group” column is how I would like it to autocompile, allowing me to delete “Age Groups.” Attaching a photo for reference!

I am looking to create a button that will dial a number in a separate field with Ring Central. The URL I have for a standard dial is “rcmobile://call?number=+16194039535” however I’m not sure how to specify that instead of the number I want it to dial the number that is shown in the {Phone Number} field. I’ve tried various combinations at this point. Any suggestions?

Hi, I am having some issues with some fields that I’m rolling up. My goal is to use an automation via Integromat to take a Rollup field from a multi-select field in Base 1 and populate that data in Base 2 as another multi-select field. The rollup itself is generated from data in Base 1, where I have a “Posts” Table that shows various Social Media Posts. Each Post can be in multiple categories in a Multiple Select field, and each Post will link to a Report on a “Reports” Table. On the Reports Table, I am using a Rollup field to get all of the unique Categories associated with all of the linked Posts. This works perfectly when each Post only has 1 Category attached to it, but when the Post has multiple Categories attached to it, the data doesn’t show up or send to Base 2 correctly (like shown in the first screenshot). I have tried plenty of different things but can’t seem to get the data to populate correctly. I believe the issue has to do with Airtable reading each multi-select field

Hello, I am using AirTable for my plumbing company workflow. My base is currently set up with a table for Jobs (each record is a single job with info like data requested, job status, plumber, revenue, etc) and a linked table for Plumbers. I would like to be able to produce summary reports by week & month. For example, I would like to calculate the revenue generated by plumber for each week into a new record. This way I can summarize with a bar chart showing totally weekly revenue over time with a breakdown by plumber. In Excel, I would do this by creating a new Summary tab. It would have a table with Plumber Name across the columns and Week Of across the rows. I would SumIf with two arguments (date within a range and plumber name). It would have a final column totally revenue across all plumbers for each week. I could use this data to create various graphs. How can I recreate this summary in AirTable?

I need to obtain a simple margin profit. the formula i use in excel is this one: =(retail price / wholesale price) - 1 Everytime I try it doesn’t give me the right answer.

Hey folks. I am trying to read an Airtable view into a pandas dataframe and I am having a heck of a time to get it to work. I tried the airtable-python-wrapper, but no joy, something about the code causes it to die. Thanks