Alexey_Gusev - profile

Alexey_Gusev · Nov 06, 2022

Hi, for a long time I thought about ‘what IF’ - display bases and workspaces as tables and fields displayed in base schema. I played a little with array transformations and did 2 model bases to use with base schema app. First, 2 levels up, Workspaces...

Alexey_Gusev · Sep 23, 2022

Hi, i’ve implemented Levenstein function in my script to compare 2 tables of names from different sources. For some matches where match ratio is not very high, I added step, where user can choose from several options with maximum ratio (using await i...

Alexey_Gusev · Jul 25, 2022

Hi, I need to extract text from multiple (thousands) of PDF files and load it to Airtable so that I can read that text by AT script, each portion of text for each file. Files are stored locally, and I wrote an uploader, which can, for example, for ea...

Alexey_Gusev · Dec 16, 2021

Hi, tried to script “show size of all attachments in all base”, and after debugging with “check null”, “check empty array”…“check array of nulls” still get unexpected result. Investigation discovered rare bug ( I checked several huge tables with tens...

Alexey_Gusev · Dec 10, 2021

Hi, i’m strugling with it 3rd day and read many docs about querying with fetch on JS, but seems like my understanding of web stuff is not enough. I used similar method for fetching from API with JSON, or from simple html site parcing text, but here I...

Alexey_Gusev · Jan 31, 2023

Hi,The short answer is in this topic and numbers of discussions about it:Changes to Airtable Attachments | Airtable Support

Alexey_Gusev · Jan 31, 2023

Hi,I can't clearly understand your goal, but it seems like on your place I would create 2 tables: 1st for Startups, linked to the second table of Investors.

Alexey_Gusev · Jan 27, 2023

Hi,Use SUBSTITUTE to remove some certain characters patternUse REPLACE to remove characters at some certain place in stringIn your case, you need to remove 'from start (position number 1) to period (located by FIND)' REPLACE({field}, 1, FIND('.',{fie...

Alexey_Gusev · Jan 26, 2023

Here the piece of code in my program doing exactly what your want, let tfields=tableOne.fields.map(f=>f.name.toString()) let ask=''; let chosen=[]; tfields.unshift('DONE!'); while (ask!='DONE!') { ask=tfields.length==1? 'DONE!':await input.buttonsAs...

Alexey_Gusev · Jan 26, 2023

Hi,I suppose tables are linked. You should add rollup field, choose {date_field} in settings and type MAX(values)like this:

User Statistics

User Activity

Base schema for bases and workspaces

A way to continue script execution while awaiting user input

What is the best way to extract text from many PDFs

(Rare bug) Attachment may exist in table with "undefined" size, can be opened and previewed as usual, but missing "download" button, and link is not working

Issue with POST to the php-site, using remoteFetchAsync in Scripting app. Filled form data passed as empty form due to Redirect 302

When will airtable allow you to download all attachments in a field at once? (LIke Smartsuite)

Re: Returning multiple row headers based on match within one column, both tied to same base

Re: Delete first matching characters in a column

Re: Multiple fields in script config

Re: lookup - most recent entry