Solved

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?

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