Solved

I just tried following the Hello world tutorial from Airtable Blocks SDK, but I wasn’t able to go through all of it successfully. When I invoke the block run command, I get the following error: Error: ❌ error:140AB18F:SSL routines:SSL_CTX_use_certificate:ee key too small It is possible to lower the default security level, but that does not seem wise. Basically, in /etc/ssl/openssl.cnf, changing from: CipherString = DEFAULT@SECLEVEL=2 to: CipherString = DEFAULT@SECLEVEL=1 makes the command work. I am running Crostini (Linux (Debian Buster) within ChromeOS), with openssl version 1.1.1d-0+deb10u3 in case that matters. The full system default section in /etc/ssl/openssl.cnf looks like: [system_default_sect] MinProtocol = TLSv1.2 CipherString = DEFAULT@SECLEVEL=2 This with a default install of Crostini, without me editing any configuration manually. I am using block version 0.0.50 from the NPM package @airtable/blocks-cli. Any chance Airtable can increase the key size somehow?

New to Airtable of course, trying to understand how to structure a base to track my exercise class payments by student. In a spreadsheet, the data looks like this: I understand this will be at least two linked tables: a student table and a class table. The intended usage is that on any given date & time I will be giving one of two or more different classes, and after each class, I will want to enter payments from each student who attended, the amount each paid & payment method used. How is this structured? How many tables are actually necessary? How many Junction Tables? Would a form be necessary for entering the student payments after each class? This seems like such a simple use, but I can’t find any equivalent tables to use as an example to set up my own. Any help is appreciated, thank you. Nick

Hi community ! I have ann issue with a zap (by zapier) I use to send a mail to each new users (in a record). I would like to display in a view records that follow certain criteria. The fact is that a record can appear in this view, disappear few minutes later, and appear again. I would like to send an email each time this record appear in this view, but it doesn’t work, it seems like the record is save in zapier memory … Do u know if i have to wait a certain time till the record id is forget ? Thanks by advance !

Hi everyone, I’m trying to use formular HOUR（）to display my Time as a number. But I keep getting wrong result. Normally, if the time is 18:30, the number from HOUR() should be 18, but I get 9.0. Could someone help me to have a look if my formular is wrong? Cheers

Is there a way to copy and paste a whole row or column? I would already have the column name and type set up -i just want to copy the information in the rows and columns. It doesn’t seem to let you copy and paste more than one cell. I’ve tried dragging to select and holding control while selecting but that doesn’t seem to work.

greeting - airtable noob here with my first post :slightly_smiling_face: i need to take a text string from a field called NAME - make it lower case - and then do search and replace for a number of characters . I have it working for one condition - replacing spaces with dashes. SUBSTITUTE(LOWER(NAME), " ", “-”) now i need to find special characters like ( ) " etc and eliminate from the string. is there a way to nest multiple commands…? or…? thanks!

Hi, I want to how can i get remaining salary when employee I absent few days and from total salary the days he is absent should be excluded and formula gives me answer. Below are 3 tabs from which I need formula to be completed. Please help me.! @Gareth_Pronovost , W_Vann_Hall anyone please

I have the pro version of AirTables and would like to be able to completely lock a table so no one can add or remove any information. I’ve changed both the table permissions and the view permissions, but I can still add information to the cells in the table as well as add fields.

Hello, I’m trying to subtract a specific time (3:30 hours) from a duration field using formula that looks like this: Difference field = IF({Ride duration}=3:30,0,({Ride duration}-3:30)) Basically, I want to subtract 3:30 hours from the duration field to know the difference between the times What am I missing here? Thanks in advance, Liat :slightly_smiling_face:

After block release, I deleted my block from Airtable. How do I get the same block back in development mode?

I need to write a formula that tracks our uniform distribution and cost. Here’s what it needs to say: We have 6 types of shirts: Newbie Shirt ($18) Gorilla Gang Shirt $26 Macaw Shirt $26 Rooster Shirt $26 Champion Shirt $26 Executive Shirt $26 Hat: $17 I need a formula that tells me based on the type of shirt they have * the qty based on the cost of the shirt what the total comes to. Let me know if you are able to write this and if you need any additonal information.

I know that Airtable has recently changed a few things and as someone who struggles to remember the technicalities of all of this, I just want to make sure that I am not doing any more work than I need to. Or maybe the update has made it simpler as it has for other things! What I want to do is populate fields from another table into a single cell, one on each line. This has multiple purposes, though right now I am trying to display to-do ID’s one at a time so my brain can actually grasp it, and then make a makeshift-dashboard displaying multiple categories in one place. Another purpose this has is when I do documentation I want to list goals we addressed and have it listed on a different line to, again, make it easy to read. I currently have a link to the table, an “array join” rollup, and then a formula to substitute the commas for new lines. This has the negative effect of creating a list, but having the first be one space off of the rest of the lines, which looks BAAAAD. Is there no

Hi everyone, I have a base where I have a list of invoices which have a date an an amount. I need to know the average earnings for each working day of the month the invoice is billed. To do so, I wanted to calculate the number of working days for each month of the invoices. I saw that there’s the WORKINGDAY DIFF formula, but to make it works I’ll need the first and last day of each invoice, as the screenshot below: Here, for example, I entered manually the 1st and last, but is there a way to automate this? With my manually entered 1st and last date of the month, I calculated the working days for the month. Then, I created a formula which calculate the average amount billed each day from the amount of the bill (Formula is: Amount of the bill divided by the # of working days in the month). Finally, I sum all the bills of the month to know the average amount billed by day for the whole month. See my screenshot below: I don’t really know if I’m heading in the right direction for that and

I created a time tracker block to track time and wish to create a billable time calculated field that will calculate the duration and set to 30 minutes if the duration is less 30 minutes. something like: IF( duration is less than 30 minutes, set "Billable Time Value to 30 minutes, Otherwise set to Current Duration). I’m assuming I need to create a field called “Billable Time” as a calculated field, I just need help with the logic. Duration Field is set to type: Duration

Hi In Excel I can put formula in one field which will calculate Sum(all fields in the column)/Sum(all fields in another column)*100= percentage How can I do it in Airtable for current and future records? I need just one value to gauge progress.

Hi :slightly_smiling_face: I want to create formula that will return true if today is after date or s within two dates. IF(AND(NOW()>{Check-in},NOW()<{Check-out}),“NOW”,"") Above is the formula that does not work for me, it always returns false. I would appreciate some help. Thanks

I’ve been using Airtable integration for a few years and its always been seamless. But since April 2020 I can’t do it anymore. When I try to open a new Airtable base directly from G-Drive I get a message " Sorry, the page you were looking for was not found". Does anyone have an idea what’s happening?

Hi everyone, I’m new to Airtable. I wonder if anyone can please tell me how I can reorder the fields in this view please? (see attached image) I’m sure it must be very easy but I just can’t seem to figure it out. Thank you!

I consider myself a fairly adept user of Airtable, but I think this question is going to say otherwise. My objective is to see this (the red dollar sign represents my Job Cost field): So on a calendar view, I want to see a concatenation of the Company Name, Contact Name and the Job Cost. The Company and Contact are two separate linked tables, and work fine in the primary field using the following code: {Link to Companies}&" | "&{Link to Contacts} But my Job Cost field is a Lookup from another tab called Proposals. My modified code of: works fine in any field/column other than the primary field/column: When I add the same code to the Primary Field, I get this error: Which makes no sense to me (novice apparently). Is there a way to do what I am attempting to do? Here is a link to the base for your amusement and hopefully help:

Hi! I’m working on a historical database and am putting in birth and death dates for historical figures. I currently have those field types set as dates (YYYY-MM-DD). However, there are birth/death dates for which I don’t know the months or days for these people. Is there any way to input a date as just the year (YYYY) in records where I don’t know the month or day for these fields? Thanks!

Hello, How can I format date column as DD.MM.YYYY It does not include in pre-defined formats. As example predefined format for 1st of February 1985 is; 1.2.1985 What I want is; 01.02.1985

I’m just a start working in this script block, Not sure about is there any option to set a schedule for block code and run that periodically

Hi. I have original db in airtable. And i want to copy it to other tables (in same project) several times and filter by category. like this But as i understand, this is available in same table to another (grid) view. (i need table, not view. becuz the reason i do this is i am making an app by Thunkable) Or if i just duplicate a table, then it will not update automatically. So please help me. Do i need a script block or something?

Hi guys, I’ve got a form with a single select option, that’s linking to another table. However when you click to add, it shows all of the fields for all of the records in the linked table. Is there any way to prevent seeing all of the fields during selection? It pulls every field from the linked table. Thanks for your help!

Hi all, This may be a quick fix that I’m missing but figured I’d ask the community for guidance here: I have a base with 8 tables. On 1 master table, I have a primary field (auto-numbered) and 7 additional fields pulling in information from linked records across the other tables. Each record on this master table is only linked to 2-3 other tables, so the majority of the Linked column fields are blank - making it a pain to see all of the linked information quickly when expanding the record (I have to scroll passed a bunch of empty fields). I’m wondering if there is an easy way (using either a formula or rollup field) to create an additional column on this master table that searches the other 7 fields and if there is a linked record, pulls it in to this field. In a perfect world, the information being pulled in wouldn’t just be the text of the linked record but rather the actual link itself - essentially just combining all linked items across the different fields on the record into this