Solved

Hi, Airtable newbie here. We are trying to setup a table that calculates farm type based on size of farm. The result we are looking for is this: Acres…Farm Type Empty…Unknown 0.0…Landless 0.1-5.0…Small 5.1-20.0…Medium 20.1+…Large Trying to use this formula: IF(Acres = "", "Unknown", IF(Acres >= 20.1, "Large", IF(Acres >= 5.1, "Medium", IF(Acres >= 0.1, "Small", IF(Acres >= 0.0, "Landless", "Unknown" ))))) This is causing a conflict between Unknown and Landless. Any idea why and how to fix this? Please help. Thanks in advance.

My reactjs application is running successfully. now I need to import css file (styles.css) when I run the code after adding import "./styles.css"; it displays error unexpected token . import {initializeBlock, Input, useBase, useRecords} from '@airtable/blocks/ui'; import React, { Component, useState } from "react"; import ReactDOM from 'react-dom'; import "./styles.css"; class Access extends React.Component { //content goes here } I

I have a table with {date_approved} column, now I want to summarize the count for this per week. For example: {date_approved} | {count} 06/01/2020 | 5 06/02/2020 | 5 06/03/2020 | 5 06/04/2020 | 5 06/05/2020 | 5 06/06/2020 | 5 06/07/2020 | 5 06/08/2020 | 5 06/09/2020 | 5 Let’s say 06/01/2020 and 06/08/2020 is Monday. 06/07/2020 is Sunday. Total count: 35 (Monday to Sunday) At present, this block is only summarizing the count per week, Monday to Sunday. But I it to count/group from Friday to Thursday by default. Is this possible? If not, what should I do to get the same effect? I just want to get a summary of {count} each custom week range {date_approved}. Thanks!

Hi, I have a table with several categories and they all have a month assigned to them (essentially types of activities being undertaken in that month). I want to create a view that shows one category across specific months. For example “Real Estate” in March, April and May. I can’t do it with filters, because I would need to combine AND OR filters. I saw a post about combining formulas: https://support.airtable.com/hc/en-us/articles/221561507-Combining-AND-and-OR-filters but can’t seem to write the correct formula for this. I would really appreciate any help! Thank you so much!

Can I create a formula for calculating Interest like the one I use in Excel: UPB*{Interest Rate}*(({To Date}-{Bill of Sale Date}))/365 In Airtable, this formula generates a NaN error message: I got it to work by breaking it out into two cells and using the formula recommended for differences in dates from Airtable’s support page on NaN errors: Cell labeled “test:” IF( AND( {Bill of Sale Date}, {To Date} ), DATETIME_DIFF({To Date},{Bill of Sale Date},‘days’), BLANK() ) And in another cell, this formula: UPB*{Interest Rate Total}*(test/365)

I’m trying to make gantt chart that calculates how long different product will take to make. Depending on how busy the workshop is we might work in the weekends - however if there is a national holiday or something similar we’ll not work. I’ve made comma separated iso dates for all holidays. I can easily calculate an end date with the WORKDAY(startDate, numDays, [holidays]) but I’m trying to find a way to calculate an end date if we worked in the weekends but not holiday. So basically is it possible to only exclude the holidays?

Is it possible to conditionally shade fields themselves instead of a color line on the left side of the entry? Those are NOT catching my eye at all, and I need them to!

I’m trying to make a script that’ll work along side the Gantt chart. I want the script to automatically to find the record above the current record and push that into a link field to create a dependency. Does anyone know if that possible? I’ve been looking through the documentation, and haven’t found anything to get me started.

I’m trying to connect to the API with a private code playground such as Codepen for quick experimentation. I’ve added the retrieve script to the JS editor: var Airtable = require("airtable"); var base = new Airtable({ apiKey: "key123" }).base( "app123" ); base("Base").find("rece123", function (err, record) { if (err) { console.error(err); return; } console.log("Retrieved", record.id); }); But I get this error: Uncaught ReferenceError: Airtable is not defined I’ve tried linking to the Airtable CDN but that hasn’t worked. What else am I missing to get this to work? Is there a simple way to get Airtable running in a JS editor in the browser? It’s private so the API key is protected. Here is a sample pen (not private with dummy key) https://codepen.io/meowpower/pen/eYJNoXK?editors=0011 Thanks in advance

I have a table which is a collection of contacts which are family units (kids & parents/guardians). I had planned on establishing relationships between records by having a “guardian” field which would be a link to a record in the same table. This works great. Problem is that when doing that between 2 tables it creates a linked field in both tables so I get bidirectional link. When linking to the same table I don’t get that bidirectional link - the “guardian” record can’t see what children it has. I feel like I’m missing something simple but I can’t think this morning. Any way to get the bidirectional link in the same table?

Hello, I have a field where I have a list of collaborator. I’m developping a block and I would like to get all the users ID from my field of my table. Currently I can get the name of the collaborator with : const base = useBase(); cont table = base.getTableByNameIfExists(“name_of_the_table”); const value_user = my_record[0].getCellValueAsString(“Name_of_collaborator_field”); I got the name of all my users in the value_user But now, I would like to get the list of user ID. How can I got it ? Thank you :winking_face: . Viken

I have a field named Postcode Area which is type formula and has nested IF statements. Is there any way to add a second action to an IF statement such as: IF (A=B, (action 1 & action 2), action 3) I would like to take the value that is returned from the IF statement and paste it into another field within the same table so that I can use it in another lookup. If there’s no possible way to do that in the IF statement, is there another way to duplicate the value of Postcode Area into another field? I have done this successfully with a script but I don’t know of a way to trigger the script when a form is submitted.

I’m trying to format a bunch of date ranges to be used in WORKDAY(). I created a script that collects these dates from a base and have them converted to iso-dates. However all my dates has a trailing time stamp of T00:00:00.000Z. Wondering if there is a quick way to omit of the time stamp so it’s only YYYY-MM-DD?

Hi, I am using mini extension to generate barcode in airtable. While the picture shows, when I try to print it using page designer, the barcode only shows black box, How can I address this?

Thanks so much for looking this over- I have a odd request and I don’t see how to do it, so figured I would hit up the masters of AirTables. I have a few different AirTables, I would love them to link to another Airtable, or just a section of info. Is there a way to do that? Do I even make sense? Thanks

I have my logo.jpg image inside frontend folder of my helloworld app. I tried to call the image but nothing is being displayed. import { initializeBlock, useBase, useRecords, } from '@airtable/blocks/ui'; import React, { useState } from 'react'; function HelloWorldBlock() { // YOUR CODE GOES HERE return <div>Hello world 🚀<img src={'./logo.jpg'} /> <img src='./logo.jpg' /></div>; } initializeBlock(() => <HelloWorldBlock />);

Hi Airtablers, I’m a total newb here and I’m struggling with forms for data input. I have achieved a passable/usable form on one grid which I would like to copy over and reuse with other grids rather than manually go through all the set-up and again. I’m pretty sure that this can be done since no one likes redoing stuff they already done. But, I have not discovered how. I would really appreciate hearing from you if you can tell me how to basically cut and paste a form from one grid to another. Thank you for reading. T

I’m new to JS and been playing around with the scripting block, quite alot. I’ve been wondering about the use of the await keyword. I think i learned somewhere that await can only be used to consume promises inside async functions. Await is used in the main code. Is it me who is wrong or is the script block one big async function?

I have a table called “Settings” and a field called “Next Number” and a field called “Format” Next Number is 101000 Format is ‘TRnnnnnn’ How do I write a script that when I press run, it updates all blank Primary Keys on my view, with the new numbers in sequence, and updates the Next Number setting, ready for the next time I run the auto sequence script. I have tried using a formula, but that doesn’t work because I need to use the next number from the other table, not from the same table. I have tried using a script but I get an error all the time trying to update my barcode primary key, so thats very weird. Type 'string' is not assignable to type '{ text: string; type?: string; }'.(2322) and Can't set cell values: No record with id rec711laJqEuPh65f exists I have looked at all of the script examples. but there are not nearly enough simple examples to do even basic things like updating a simple barcode field. Thanks in advance.

Hello, can anyone suggest how to create a filter where {date) is equal 2 days from today. The {date} is from Airtable and it is a lookup field. This will send email to client 2 days after the service was provided. Thank you for help

Say I have a whole table with various flowers listed, with bloom seasons, color, and whether or not they’re deer resistant. I want to be able to see JUST the records that are tagged “bloom season” in a new table. What’s the easiest way to do this? Thanks!

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?