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