This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,I need to build a script to parse a webpage. At first run it crafts POST request to search for item, the page returns a table-like list of several matching items with their statuses. (I'm on that stage now). I need to choose item(s) with certain ...
Hi,From time to time we see posts from new users trying to use lookup field in formula. And I remember my first time issue with that when I just learned to use Airtable . Of course, info about lookup field behavior in formula can be found by search, ...
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,make Assigned staff linked field. When asked where to link, choose new table. It will contain list of staff linked to Clients. Use lookup or try rollups to get info in your desired form.
Hi,You can use autonumber field, putting it's name instead of 1 in your formula.You can also click and drag down, from two date cells, with any given interval between them
To be honest, I couldn't understand your question, and why did you mention records order.The purpose of steps I described - temporarily swap your 'index' field with primary field, in order to set proper links. In usual normal state, you should be abl...
Hi, You can link it without automation.Duplicate your timestamp field (in Master, for example). Change primary field to the formula exactly as in the Subject Grade Module field. Check it to be all unique, choose 'Unique' as field total and ensure tha...
Hi,Your configuration might work for a single linked record, but it's not accurate, as there might be several linked Applications. Linked field contains array of IDs and some time ago it was a common problem - how to use it as a single ID value. Now ...
Former Systems Administrator of local company,
Windows Server Engineer in outsource teams,
offshore Microsoft Certified MSSQL DBA for Nordic companies
with ~20 years of experience in wide area of IT.
Currently, DBA in Enterprise, working mostly in Airtable, studying Javascript development.
Residence: Kyiv, Ukraine
