Hi,I created a script which takes data in a project financial table and updates special table with payments report.I'm going to setup it to run daily or weekly automation, and add it to many projects in different bases.Problem with updating a single...
Hi,I saw several similar questions from past years, but nothing that could be the answer. Maybe somebody found the solution for that? I want to get rid of Cyrillic and use English characters and language, to present some data to international teamI ...
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,Try to clarify your goal. You have Donations table with X records and Totals table with Y records.You Create new record in Donations. Airtable needs to know which of Y records you want to Update in Totals. So, it asks for record ID.indeed, 'When ...
Hi,In your example, error is '£0.00', in first line.In common, it should be IF ( condition , _when condition is true_ , _when condition is false_ ) , but then you should substitute last argument and start next line right after _when condition is ...
Hi,Why don't you just filter records you need, create _temp field with formula {Filters (hidden}} & ',Option1,Option2'select it, press ctrl+cthen select multiselect field and press ctrl+vIt's a minute action, and no scripts/automations needed.BTW, if...
Hi,Formulas more flexible here, than in Excel.IF( condition , if_true , if_false ) can be written asIF ( condition , if_true ) . the default for third parameter is blank cell.So if you want to check field for 'non-emptiness' just use IF({Field}, Yo...
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
