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 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:

Alexey_Gusev · Jan 26, 2023

Hi,you can recursively update value and checkbox as conditional action when "Find records" (same group, field A is empty) array length > 0. To get a single ID from array, use this approach, for example.Note it will cost one automation run for each up...

Alexey_Gusev · Jan 24, 2023

Sorry for misunderstanding, previous picture with automation setup has nothing to do with last portion of code. The code launched manually, single run to copy all field values.

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

Re: Delete first matching characters in a column

Re: Multiple fields in script config

Re: lookup - most recent entry

Re: Automatically copy a value to another record

Re: Unable to add new option on single select with automation script