Junction Box 8x8

[Katrine Freggiaro]

Windows2000 and later support junction points, where a directory serves as analias to another directory on the computer. For example, if the directoryD:\WIN specified C:\WINNT\SYSTEM32 as its target, then an applicationaccessing D:\WIN\DRIVERS would in reality be accessingC:\WINNT\SYSTEM32\DRIVERS. Unfortunately, Windows 2000 comes with no toolsfor creating junction points. You have to purchase the Windows 2000 ResourceKit, which comes with the linkd utility for creating junctions. I thereforedecided to write my own junction point-creating tool: Junction. It createsNTFS junction points, it allows you to see if files or directories are actuallyreparse points. (Reparse points are the mechanism on which NTFS junctions arebased. The Remote Storage Service uses reparse points as well as volume mountpoints.)

If you want to automatically delete junction records when one of the linked records is deleted, you can trigger an automation when one of the linked record fields is blank. Then use a scripting action to delete the record. (A scripting action is currently the only way to automatically delete a record without a third party integration. I include a script for deleting a triggering record in my automation helper scripts in my Gumroad store.

On the other hand, I am a fan of scripting and I would probably do this with scripting to avoid having the extra direct linked record field. However, I recommend only hiring a script writer who is familiar with writing scripts for Airtable. It is important to have a developer who understands the Airtable architecture as well as JavaScript.

Some scripts can run in both Scripting App and an Automation Scripting action, others only work in one location or the other. Someone experienced at writing scripts for Airtable can convert a script that works in one location to the other location.

However, if you want to trigger the automation when a new record is created or deleted in either table, I do not recommend using that script. That script examines all records in all three tables, making it inefficient. If you end up having multiple new records trigger the automation simultaneously, you may also end up with duplicate junction records.

We are an investment fund dedicated to energy transition and nothing else. Our team is a junction of former entrepreneurs and investment professionals. We take on the challenges and the complexity of energy transition shoulder to shoulder with entrepreneurs and founders.

We back ambitious energy transition entrepreneurs with the aim to gain critical mass, expand the footprint of their innovative solutions and make actual change happen. We do this through a combination of growth equity and buyout capital.

In our previous roles, we have collectively reduced GHG emissions by more than 1 million tons per annum. We achieved this by building and growing green energy suppliers, project developers, PV installers, zero-emission aggregators, and energy storage developers.

3a8082e126