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