Solved

Hello Airtable Community! My table has a single select field with 3 options. The field is called SVC Broad Category: There is another single select field with 20 options called SVC Area: When we add tasks to the table, we assign them to a SVC Area and to a SVC Broad Category. I am hoping for assistance with an IF Statement for SVC Broad Category, so that whatever is selected in SVC Area (e.g. Alcohol) is automatically assigned to the right SVC Broad Category (e.g. Ops/Logistics). The image below shows the Areas and Categories. As always, any assistance is greatly appreciated.

Hi everyone, I’m looking for a formula to check if any cells on a selection of 5 are empty. Hard to explain globally, but theorically the formula would look like this: IF (Cell 1) is empty OR (Cell 2) is empty OR (Cell 3) is empty… THEN display :white_check_mark: How can I achieve this on Airtable? Thanks in advance for your help.

nOt sure if I’ll ever get the hang of this formula thing. How do I write a formula to calculate the minutes based on hours times days using these types of options the columns are and both field types are a single select resulting in these kind of combinations? |4 day workshop| |Full Day 8 hours 8-5| |4 day workshop| |Full Day 6 hours 9-4| |3 day Workshop| |Full Day 8 hours 8-5| |3 day Workshop| |Full Day 6 hours 9-4| |2 day workshop| |Full Day 8 hours 8-5| |2 day workshop| |Full Day 6 hours 9-4| |1 day Workshop| |Full Day 8 hours 8-5| |1 day Workshop| |Full Day 6 hours 9-4|

Would love to know if it is possible to use the Script Block for something like this - basically, send a record to an Asana Board and create a ticket with certain fields. Is that possible?

How to navigate from one page to another with Airtable reactjs I have 2 pages(home.js and access.js) linked to index.js when I run the code via block run. it says Bundle updated but am seeing this error in my airtable Error: Objects are not valid as a React child (found: Error: [object Object]). If you meant to render a collection of children, use an array instead. in Error (created by Context.Consumer) in Route (created by HelloWorldBlock) in Switch (created by HelloWorldBlock) in div (created by HelloWorldBlock) in Router (created by BrowserRouter) in BrowserRouter (created by HelloWorldBlock) in HelloWorldBlock in div (created by BlockWrapper) in Suspense (created by BlockWrapper) in BlockWrapper (created by ForwardRef) in ForwardRef throwOnInvalidObjectType@https://localhost:9000/__runFrame/bundle.js:59956:15 reconcileChildFibers@https://localhost:9000/__runFrame/bundle.js:60856:31 Here is the code index.js import { initializeBlo

Is it possible to get the linked table id from a Field? I was looking at the Field docs and I couldn’t find anything. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. I tried using the options property, but there is nothing in there. Many thanks, Gustavo

Greetings, I’m trying to do a simple multiplication formula. I want to multiply two columns. (Pic 1 of 3) I am using the formula as described in the directions, Price * Quantity. (See Pic 2 of 3) I only get an error message! (See Pic 3 of 3) I can’t figure out what I am doing wrong. Thank you.

I am using the Time Tracker block, and the Pivot Table block to track hours and total hours. Now, I need to calculate earnings based on the total hours. I’ve played around with a few formulas and field types and can’t get it QUITE right. I have my clients listed in a multiple select column. I need the total earnings to be calculated by client and I’m having trouble wrapping my head around how to set up the base to get to this calculation.

I am looking to automatically categorize information submitted in a form into individual databases based on 1 question in the form. is this possible? I was thinking that maybe all information is submitted to one database and then split into multiple bases automatically based on some sort of linking. Can anyone help?

I am having a hard time with the IF statement. I have a Status category I would like to make student status change based on Anticipated graduation date, however, I don’t have that for all students. So this is the formula I am trying and failing at: IF( {Anticipated Graduation Date} <= TODAY(), “Graduated”, IF({Anticipated Graduation Date} > TODAY(), "Active Student”, “Unknown” ) I’ve done a couple variations and can’t seem to do it. Any thoughts out there?? Thank you, R

Hi there :sunny: I would like to automatically import contact forms from my Wordpress site to Airtable (prospect view). Do I need a special plugin? If someone has already implemented this workflow, I would be happy to get your advice :slightly_smiling_face: Thank you so much in advance for your help. Have a very nice day. Alexia

Hi everyone ! Here is my issue : I have to manage the planning of different training session. For each session (ie : each entry), I have 3 dates, and each date has a trainer : Training A / Date 1 / Trainer 1 / Date 2 / Trainer 2 / Date 3 / Trainer 3 Training B / Date 1 / Trainer 1 / Date 2 / Trainer 2 / Date 3 / Trainer 3 … Each trainer can be on different session, and different dates. In the end : how can you get a personal planning for each trainer ? :thinking: Since filters apply to the whole entry, I have difficulties to keep only the date related to a specific trainer. I suspect I may have put my hands in the script blocks but if you have a workaround, I’ll take it ! Thanks ! Arnaud

I am attempting to create a formula that finds the latest lastModified Date from a group of records. The group is a single select column. = greatest lastModified date of “group1” Thanks

Hello, I am using masterdata tabs in my table to harmonise data. My problem is that every time a user enters data manunally or automatically in specific columns linked with the masterdata, this may create junk data if not recognised by the masterdata list; thus requiring constant clean-up. Is there any way I can block/limit the data entry for those specific columns linked to the masterdata ? if YES, can you please provide a step by step Thank you Cloé

Hello AT community! I have a question regarding creating formulas. In my base I have 2 tables: a recipe table with each ingredient in its own field, linked to my ingredient table. In the ingredients table I have several single select fields for each allergen that a particular ingredient contains. So let’s say I want to summarize the allergens in my recipe for lemon meringue pie. I’m using a frozen pie crust that contains dairy and wheat, allergens which are indicated as “yes” in their respective fields in my ingredient table, plus eggs (another allergen). Back in the recipe table, I would like to summarize all the allergens present in my recipe for lemon meringue pie, so I could easily look at the recipe and see that it contains eggs, dairy and wheat without having to go back to the ingredient table and look at each ingredient individually. Is it possible to create a formula to summarize all the allergens present in my recipe, within the recipe table? I’m an AT newbie so not entirely s

Hello, can I join three fields un one? I want to mix three fields in one automatically. Is that possible? I dont know wich rule I have to follow. In A I have different categories (A) which belong to another column (B); and I want to mix in a third field the categories which are the same. Is that possible? A: blue B=house; C= Carla=blue+ 13yearsold D: I want to mix in other names in C, the words that are the same. thank you Cristina

Hi all, this is my first post on the Airtable community. :slightly_smiling_face: I have a base that I use to track my FB groups activity. So I have a column with a checkbox to mark when I’ve completed something in that group. What I’d like to do is have those checkmarks automatically clear off at the beginning of each new week. Is that possible with a formula? If so, can someone point me in the right direction of where to get started? Thanks so much for any help! Valerie

Hi all, I’m quite new to Airtable and I’m trying to transition my logical thinking to relational databases from Excel but i’m struggling with something… I’ve recently imported an Excel worksheet into Airtable that contained form data and formulas on the same worksheet. In Airtable, I have been creating the tables I need and linking them to the main Data table where possible. In the Excel file, there is a form that I have also replicated in Airtable. The use case is that the form is filled out by a user and once submitted, a new line is entered into the Data table. The first 20 fields/columns within the Data table are for the inputted data from the form. The next 10 fields/columns are supposed to be calculations based on some of the data from the form and some data from other tables (vlookup from Excel). I am now trying to replicate the formulas that the Excel worksheet had (Vlookup) in Airtable but I don’t know how to use the value of another table in a formula of the current table. So

I run a pet relocation company and we have many clients who hold their pet files with us in case of a future move. We need a formula that red flags when a vaccination expiry date is imminent (e.g. in 14 days, in 28 days, etc). Really struggling with how we can incorporate this into airtable.

I have a scenario where I am mapping a Multi-Select Field in one Airtable Base to a Multi-Select Field in another Airtable Base using Integromat. The scenario requires the JSON Parse module in order to correctly parse the data to show up correctly in the 2nd Base. The Multi-Select Field can contain a variety of social media Channels, like Twitter, Facebook, Youtube, etc. The scenario works great unless I add in more fields beyond the ones that are being sent. For example, if I map it to where there are 6 potential Channels to choose from (Youtube, Twitter, Facebook, LinkedIn, Tiktok, Snapchat) but only 3 are sent in the Scenario, those 3 extra fields will be sent as “null” and this causes an error in the Scenario. Is there any way to remove that null, so that the JSON produces THIS: {“Channel”:[“Twitter”,“Instagram”,“Youtube”]} instead of THIS: {“Channel”:[“Twitter”,“Instagram”,“Youtube”,null,null,null]} Thank you!

We’re making use of Airtable to help manage our delivery menu for bud.com. Airtable’s CSV Import Block helps to bring on new products for various regions into our overall catalog. Now we’re running into an issue with field mapping in the CSV Import Block: Airtable mixes up the fields to match as we import different spreadsheet, and there’s no way to quickly reset the import system. Details: We import a CSV of items from Sacramento using the Airtable CSV Import block. We have matching field names for the import data, so the fields show up matching immediately - hurray! We are importing fast. Then we go to import a CSV of items from Oakland. The Oakland fields are about 95% the same, but with a few different field names, and a different order to the fields. For this second CSV, even if they have many overlapping field names, AirTable will suggest non-matches - ignoring direct matches. So if we had matched these fields for a Sacramento CSV import: Published <= Published Weight (g) <

Hi! Does anyone know if it’s possible to give visibility to blocks (mainly Gantt + Timeline) while creating a shareable link to a view? Thanks!

The formulas are calculating in real time, while I’m typing values in another field. Is there a way to set it to stop behaving like that and calculate only after I type Return?

Hi all, I am trying to format a field to show whether a deadline is “On Time” (before deadline due date), “At Risk” (same day as deadline due date) and “Late” (past deadline due date/time). Is this possible? I keep getting lost in my nested if statements and when I add another component, I am getting blank records. Thanks, Lauren

Hi all. I’m getting really happy about Airtable, but have one question I can’t seem to find an answer for (I’m sorry if it is actually obviously out there): I’m the owner of our workspace. Is there a way to temporarily “limit” my own permission to Editor? When I use the database for daily work, it would be good to know, that I can’t accidentally mess up the fields etc. I’ve used Knack previously and like the clear distinction between messing with the actual database and using it for work as intended. Thanks!