tag:notes.deven.dev,2005:/posts_feedDeven Jadhavhttps://cdn.u.pika.page/c5sCv9r2hxn_J6PKAOLCnXS66zaauX-7zMWQR5jqHjc/fn:Floating%20Sticker/plain/s3://pika-production/x8xrsn5k6vspqe8ozduzk0m4utyf2026-03-05T03:17:05Ztag:notes.deven.dev,2005:Post/920572026-03-05T03:17:13Z2026-03-05T22:35:03ZThe plan for hack club world dominance<div class="trix-content">
<p>Good hackers / engineers are never quite an employee. They can be managed, but rarely directed. They follow their own curiosity their own way, always honestly, often infuriatingly, along with their sense of taste for which problems are interesting and which aren't.</p>
<p>This writeup is meant to be my best-effort explanation of what exactly the Hack Club YSWS model is, why I think its genius, and how it lets us hire some of the best, most ambitious engineers, entrepreneurs and problem solvers without having to deploy a swarm of middle managers.</p>
<h3 id="what-the-hell-is-a-you-ship-we-ship-ysws">
<a href="proxy.php?url=#what-the-hell-is-a-you-ship-we-ship-ysws" class="anchor" title="Link to this heading" aria-hidden="true"></a>What the hell is a You Ship We Ship (YSWS)?</h3>
<p>A teenager (age 13-18) is challenged to engineer a real <em>shipped</em> project from scratch, and they get prizes to support them on their next project, like a Raspberry Pi, a soldering iron, or a flight scholarship for a hackathon when they publish their work.</p>
<p>A shipped project <strong>always </strong>has an open source GitHub repo, a live play link (imagine an <a href="proxy.php?url=http://itch.io">itch.io</a> link for a game, a link to a compiled .exe file for a windows app, or a link to a web app, etc!). For hardware projects, we make an exception for the play link and let it be substituted by a link to the schematics, a video of the project, etc. </p>
<p>Additionally, to ensure that a project was shipped by a real person, and to ensure compliance with United States anti-terrorism laws, we also collect home address, date of birth, and the first and last name of the person shipping the project. This means that every dollar spent by a Hack Club YSWS program can be tied back to the individual hack clubber that received a prize, earned a travel scholarship, or got some sticker sent to them in the mail.</p>
<h3 id="weighted-projects-and-time-spent-building">
<a href="proxy.php?url=#weighted-projects-and-time-spent-building" class="anchor" title="Link to this heading" aria-hidden="true"></a>Weighted projects and time spent building</h3>
<p>A shipped project with 10 hours of time spent building through good practice. Aimlessly vibe-coding is not good practice. Hours spent watching a YouTube tutorial is not good practice. A project with 20 hours counts as 2 weighted projects, 30 hours as 3 weighted projects, and so on!</p>
<p>Time spent debugging and problem solving is good practice! </p>
<p>Each YSWS program must use different methods to determine how much time was spent on each project. Time spent on projects must be well-substantiated and must stand extensive scrutiny from the YSWS leadership team because it is directly tied to financial incentives.</p>
<p>The most popular tool for time tracking and substantiating “Hours spent on good practice” is <a href="proxy.php?url=http://hackatime.hackclub.com">Hackatime</a>, but some programs may sometimes choose to use different methods of calculating this.</p>
<p>The bottom line though is that this number must always be high integrity and well-substantiated (and almost always a lower-bound estimate of the actual time spent coding).</p>
<h3 id="incentives-for-shipping">
<a href="proxy.php?url=#incentives-for-shipping" class="anchor" title="Link to this heading" aria-hidden="true"></a>Incentives for Shipping</h3>
<p>I personally deeply believe in the intrinsic joy of building personal projects. Given this <em>very strong</em> belief, how many projects have I shipped without an incentive as a teenager? Zero.</p>
<p>At least here in the US, parents put a lot of pressure on teenagers to succeed, but they often lack understanding of the importance of project building. Some things from parents we hear: </p>
<p><em>“Don’t build projects, enroll in 15 AP courses”. </em></p>
<p><em>“Run 3 clubs, get a summer research internship.” </em></p>
<p><em>“Please, god, don’t spend your time working on projects. You’ll never get into college.”</em></p>
<p>This is why incentives are important, especially to get beginners hooked on to the very addictive journey of building personal projects. In Hack Club, we’ve seen that the following incentives really work (in decreasing order of effectiveness):</p>
<ol>
<li>
<p><strong>Adventures:</strong> Both intellectual and physical adventures. </p>
<ol>
<li><p>Examples of intellectual adventure include <a href="proxy.php?url=https://github.com/hackclub/easel">Easel</a> - a YSWS where you make your own programming language and <a href="proxy.php?url=https://saycheese.hackclub.com/">Saycheese</a> - a YSWS where you hide your program in a QR code. </p></li>
<li><p>Examples of physical adventure include Hack Club <a href="proxy.php?url=https://trail.hackclub.com/">Trail</a> (7 days in-person backpacking adventure on Pacific Crest Trail) and Hack Club <a href="proxy.php?url=https://juice.hackclub.com/">Juice</a> (In-person game jam in Shanghai, China)</p></li>
</ol>
</li>
<li><p><strong>Friendships:</strong> Getting to meet new people online that share your interests and just “get” you, and then being able to meet them in-person at a hackathon. We invest hundreds of thousands of dollars on flight scholarships for teenagers to go to hackathons each year so they can meet their internet friends IRL and spend time building projects with them!</p></li>
<li><p><strong>Prizes / Electronics / Tools</strong>: We give out millions of dollars in Laptops, iPads, 3D printers, soldering irons, hardware components, etc to teenagers and this serves as an excellent incentive for a beginner friendly YSWS since it’s so easy to understand what these prizes are and work towards getting one!</p></li>
</ol>
<p>I don’t want our YSWS programs to feel like an endless stream of transactions, so I especially appreciate programs like <a href="proxy.php?url=https://siege.hackclub.com/">Siege</a> and <a href="proxy.php?url=http://blueprint.hackclub.com">Blueprint</a> that run with the same underlying economics, but don’t feel as transactional. Remember — everything in Hack Club is a YSWS!</p>
<div class="attachment-gallery"><figure class="attachment attachment--preview attachment--png">
<img height="827" width="1103" data-zoom-src="proxy.php?url=https://cdn.u.pika.page/Wgu76__cseAiteqlYD_7FOmppiC7WHqYz28cLU8aQuI/s:3840:3840/fn:image%20%2851%29/plain/s3://pika-production/u6465nzuxwsidrawdoubv60k75c7" data-original-src="proxy.php?url=https://cdn.u.pika.page/1MigBPQaKluliMydJLCB_r1-yr_46ef6rh6dxPGPKOY/fn:image%20%2851%29/plain/s3://pika-production/u6465nzuxwsidrawdoubv60k75c7" alt="" src="proxy.php?url=https://cdn.u.pika.page/ik93DHv1W76ELJq91LnO2YdUe2-hqBPQNPYj8N2YelE/s:1800:1400/fn:image%20%2851%29/plain/s3://pika-production/u6465nzuxwsidrawdoubv60k75c7">
<figcaption class="attachment__caption" aria-hidden="true">
A bunch of online Hack Club friends building projects together at an in-person hackathon for the first time!
</figcaption>
</figure></div>
<h3 id="spend-and-economics">
<a href="proxy.php?url=#spend-and-economics" class="anchor" title="Link to this heading" aria-hidden="true"></a>Spend and Economics</h3>
<p>Hack Club has a very sophisticated way of thinking about spend, and we directly tie it to shipped projects</p>
<p>As a member of the YSWS team, each person gets a 1000 USD personal YSWS budget when they get onboarded onto the team.</p>
<p>Then, for every program that produces one <em>weighted (10 hours)</em> project, we pay out 85 USD to the program budget (8.5 USD per hour spent building with good practice).</p>
<p>For programs that do not have an in-person component, members of the YSWS team are encouraged to spend 50 USD per weighted project (or 5.00 USD per hour). Any left-over money from the program is then transferred into their personal YSWS budget.</p>
<p>Over the first couple months, a lot of the gap years will often accumulate 15-20K USD in their personal YSWS budgets, and they can then use this money to run bigger, more expensive programs. That way, they’re allowed to combine their personal YSWS budget funds with the $85 per weighted project program budget to run programs that may need more money! </p>
<p>As a member of the YSWS team, if you play your cards right, you can spend as high as 200 USD per weighted project running really cool programs towards the end of your gap year.</p>
<h3 id="summer-2026-and-the-path-forward">
<a href="proxy.php?url=#summer-2026-and-the-path-forward" class="anchor" title="Link to this heading" aria-hidden="true"></a>Summer 2026 and the path forward</h3>
<p>Is this the perfect model that helps us get teenagers shipping? No.</p>
<p>Is it pretty damn good at what it’s supposed to do? Yes.</p>
<p>I say this in the most candid, unbiased way possible, but I feel like there isn’t a better deal as a teenager fresh out of high school than a gap year with Hack Club. Thanks to this system, and the ownership / high agency it offers, a gap year fellowship at Hack Club is comparable (and in some ways, even better than) the <a href="proxy.php?url=https://thielfellowship.org/">Thiel Fellowship</a>!</p>
<p>As a teenager fresh out of high school, you get paid 50k a year and a access to a pool of 8.5 million dollars to run events around the world and build programs that get tens of thousands of users. There are no approvals, no paperwork, no bureaucracy. All you need to do is get teenagers to ship weighted projects, and you get 85 dollars paid to your program budget.</p>
<p>It’s also worth mentioning that this system is <em>bottomless</em>, which means that there’s no real cap on how much money you’re allowed to spend as a gap year at Hack Club!</p>
<p>We’re still figuring out a system and the best path forward for this, but I’m really happy with what it has been able to unlock for Hack Club. At its core, Hack Club’s mission is to transform teenagers from consumers into creators, fostering a love for building cool, fun, and meaningful things. </p>
<p>We want to make building projects a national pastime by 2030, with Hack Club becoming as ubiquitous as the Boys and Girls Scouts of America were in the 1970s. </p>
<p>I personally want to live in a universe in 2030 where the CEOs of Netflix and Meta get to work every morning, and start scheming the downfall of Hack Club because teenagers around the world are now suddenly spending all their free time building things instead doomscrolling and being on TV all day, and I think the current implementation of the YSWS system is going to get us really frickin close to that goal ;)</p>
</div>
<br><hr><br><p><a href="proxy.php?url=mailto:[email protected]?subject=Re%3A%20The%20plan%20for%20hack%20club%20world%20dominance">Reply by email</a></p>Good hackers / engineers are never quite an employee. They can be managed, but rarely directed. They follow their own curiosity their own way, always honestly, often infuriatingly, along with...tag:notes.deven.dev,2005:Post/800732026-01-18T03:08:36Z2026-01-18T03:10:23ZI asked a coding agent to come up with a religion<div class="trix-content">
<div class="attachment-gallery"><figure class="attachment attachment--preview attachment--jpg">
<img height="360" width="1080" data-zoom-src="proxy.php?url=https://cdn.u.pika.page/kF84rplPhDyQmF_P1yMsxbSd_uRV72ufR5c8mnohMEc/s:3840:3840/fn:illuminati/plain/s3://pika-production/genygdqxh8od5v1cck1oa09t4xg4" data-original-src="proxy.php?url=https://cdn.u.pika.page/AorILgDR9yg5MZqY6uUqDywL5NPphX1-aUtxT9W-86g/fn:illuminati/plain/s3://pika-production/genygdqxh8od5v1cck1oa09t4xg4" alt="" src="proxy.php?url=https://cdn.u.pika.page/QNshplY8qS5BJKm2P_1rC_Nb4vVA_2KDZKh8HFbAlNk/s:1800:1400/fn:illuminati/plain/s3://pika-production/genygdqxh8od5v1cck1oa09t4xg4">
<figcaption class="attachment__caption" aria-hidden="true">
Here’s an illuminati banner that I found on the internet, which was my only human contribution to this experiment.
</figcaption>
</figure></div>
<p>This will be a work in progress post. The results of this experiment have been quite interesting and I’m still digesting them.</p>
<p>Here’s a basic summary: </p>
<ul>
<li><p>I gave Amp (which, as far as I understand, uses Clause Opus 4.5) some instructions to create its own religion and build me a website for it. In the same prompt, I told Amp that this was a critical and important task, and that it should perform it with utmost care and precision.</p></li>
<li><p>Amp spent 9.35 USD thinking for almost 7-8 minutes and came up with a terrible looking, almost conspiratorial website.</p></li>
<li><p>I then asked Amp to write some more CSS to make it look like a boring government website, using lots of blues and whites and blacks and Serif fonts for titles.</p></li>
</ul>
<p>The final output now lives at <a href="proxy.php?url=https://manifest.deven.dev">manifest.deven.dev</a>.</p>
<p>Honestly, I think I’m going to add a pop-up explaining what this site is. I do not want people to think I’m schizophrenic.</p>
<p>More thoughts soon!</p>
</div>
<br><hr><br><p><a href="proxy.php?url=mailto:[email protected]?subject=Re%3A%20I%20asked%20a%20coding%20agent%20to%20come%20up%20with%20a%20religion">Reply by email</a></p>This will be a work in progress post. The results of this experiment have been quite interesting and I’m still digesting them. Here’s a basic summary: • I gave Amp...tag:notes.deven.dev,2005:Post/793812026-01-15T15:54:15Z2026-01-15T15:54:16ZUnreasonable Hospitality<div class="trix-content">
<p><em>This is a part of an internal memo I circulated with the events team. If you are reading this and not a part of the team, you might be missing some context! </em></p>
<p>The last few weeks have been such whirlwind for me. I finished the first semester of my Sophomore year at UNC, flew out to San Francisco for Prototype, went to India right after to visit family for just over a week, and then flew right to Austria for Midnight. </p>
<p>I've been reflecting on the experiences I've had for the last month, meeting and talking to Hack Clubbers- and I think I have a couple of important takeaways.</p>
<p>Firstly, Hack Club is really huge in so many ways but feels small in a lot of other ways. Like the fact that Hack Clubbers were literally the showstoppers at this year's CES at Lisa Su's keynote still blows my mind. We consistently seem to have a gazillion different things happening at the same time, have such an incredible team of gap years running programs, in-person events, and everything in between. </p>
<div class="attachment-gallery">
<figure class="attachment attachment--preview attachment--png">
<img height="1206" width="2622" data-zoom-src="proxy.php?url=https://cdn.u.pika.page/EY97PYtCBnk0izwY4sitJlliO6KjQYOWPn90pYp0Qis/s:3840:3840/fn:image/plain/s3://pika-production/ylee0kn7cfxuqry52itdh30oj9gz" data-original-src="proxy.php?url=https://cdn.u.pika.page/8JTRxNcCggyDqN8POWB5sFEgTuUVBNBkV-OTHyJ4ZMU/fn:image/plain/s3://pika-production/ylee0kn7cfxuqry52itdh30oj9gz" alt="" src="proxy.php?url=https://cdn.u.pika.page/1U6gfiFwJFrIMCU-QWK6f0823CJlNwVVFvD3IKfq3B8/s:1800:1400/fn:image/plain/s3://pika-production/ylee0kn7cfxuqry52itdh30oj9gz">
<figcaption class="attachment__caption" aria-hidden="true">
Hack Clubbers on stage at CES alongside Lisa Su and Michael Kratsios
</figcaption>
</figure><p></p>
</div>
<p>Secondly, peer-to-peer and staff-hackclubber interactions shape a large part of what makes Hack Club so special for our students. Someone came up to me after Midnight and said that they were so grateful for Hack Club and that it has had such a big impact on their life. They also mentioned something oddly specific- less than a year ago, the same person happened to run into me and a bunch of other Hack Clubbers at a public library and they mentioned that they distinctly remember me going out of my way to find them a chair to sit down. They said that they clearly remembered this interaction and that really made them feel like they belonged in this community. </p>
<p>As we grow and continue to serve more teenagers than ever, I do not want us to lose the magic of a great personal 1:1 connection, and I think this is the right time for us to build systems around incentivizing kindness and this idea of unreasonable hospitality. </p>
<p>So- what exactly is unreasonable hospitality? The remarkable power of giving people more than they expect. Here are some examples I've encountered before: </p>
<ul>
<li><p>You overhear someone at an in-person event saying they wish they had some boba right now. You decide to go out and get boba for them and the group. </p></li>
<li><p>Someone emails you with a small concern about the logistics of an event. You respond back with an elaborate, over the top email offering support and also offering a 1:1 zoom call for any further questions.</p></li>
<li><p>There is a limited number of hoodies / merch / food at a hackathon, so you decide to make sure the participants get one before you do. </p></li>
<li><p>Someone is feeling sick at a hackathon, and you go out your way to get them food, water, and make sure they're well rested. </p></li>
<li><p>Overhearing someone say it's their birthday and rallying everyone for a surprise announcement + cake.</p></li>
</ul>
<p>There are two aspects to running something that's hack clubber-facing successfully: <strong>Service</strong> and <strong>Hospitality</strong></p>
<p>Service at a hackathon is the basics: wifi works, food shows up, judges are briefed, submissions close on time. Hospitality is how a nervous first-time hacker <em>feels</em> walking in: do they feel like they belong? Does someone notice they're lost and help them find a team?</p>
<div class="attachment-gallery">
<figure class="attachment attachment--preview attachment--png">
<img height="4284" width="5712" data-zoom-src="proxy.php?url=https://cdn.u.pika.page/DvkNHhCDf-RvSTa8eBvOlt0iNoAlNhOpOmz52dFkmQ8/s:3840:3840/fn:image/plain/s3://pika-production/ozx832bvarow1ojbslbye4jmvlu0" data-original-src="proxy.php?url=https://cdn.u.pika.page/-s9mRkjn_--muRhbMzoz6PXRBG02DtZpHGSsbR2ufXw/fn:image/plain/s3://pika-production/ozx832bvarow1ojbslbye4jmvlu0" alt="" src="proxy.php?url=https://cdn.u.pika.page/2CzrAyGZCE3QO7bepkUe8lzyc7n8Jh2ZlwkV158SRgI/s:1800:1400/fn:image/plain/s3://pika-production/ozx832bvarow1ojbslbye4jmvlu0">
<figcaption class="attachment__caption" aria-hidden="true">
The Midnight team at our beautiful venue in Vienna!
</figcaption>
</figure><p></p>
</div>
<p>Starting today, we are creating an incentive structure that starts with gap years and RMs, and seeps all the way down the line to event volunteers. We have yet to formalize this with metrics, but here's a general idea: </p>
<ul>
<li><p>Staff members are highly encouraged to perform "Acts of unreasonable hospitality" as outlined in the examples listed above. </p></li>
<li><p>There will be a form in Attend + other places online where you can document these interactions, optionally attach photos, and earn a "brownie point" for each act of unreasonable hospitality. </p></li>
<li><p>There will be a shop where you can cash out brownie points for rewards like orpheus plushies, flipper zeros, and more!</p></li>
<li><p>All feedback forms will also have a section for staff kindness + compliments, and any mentions made directly by participants will earn you bonus brownie points. </p></li>
</ul>
<p>Campfire and Campfire Flagship will both be a beta test for this program, and we will roll it out to future events if things go well! The whole point of this is to give more people that warm fuzzy feeling that got us all so deeply involved in Hack Club. </p>
<p>Will share more details on exact implementation soon.</p>
<p>Until later, Dev</p>
</div>
<br><hr><br><p><a href="proxy.php?url=mailto:[email protected]?subject=Re%3A%20Unreasonable%20Hospitality">Reply by email</a></p>This is a part of an internal memo I circulated with the events team. If you are reading this and not a part of the team, you might be missing...tag:notes.deven.dev,2005:Post/709072025-11-02T14:25:55Z2025-11-02T14:25:55ZField notes on writing recommendation letters<div class="trix-content">
<p>I’m a sophomore in college and I’m still traumatized by Common App in the big 25s. How, you might ask? Recommendation letters!!!</p>
<p>I’ve been writing these for the last 4 years (Yes, I’ve written recommendations for people applying to university even when I was in high school), and I think I have a good formula for how to get the most out of them. </p>
<p>I’m mainly writing this piece for myself when I have to write these letters again next year, but I also want something I can share with people so they send me the right information beforehand. </p>
<p>First of all, I only write letters for people I have closely worked with, and feel comfortable personally endorsing. If I decline to write a letter for you- it’s nothing personal, I just don’t know you very well in a professional capacity. This also means that I cannot write letter for you that I think is high quality ¯\_(ツ)_/¯</p>
<h2 id="brag-sheets">
<a href="proxy.php?url=#brag-sheets" class="anchor" title="Link to this heading"></a>Brag Sheets</h2>
<p>Brag sheets are, in my opinion, very important when written properly. I like to structure my letters so they are very specific, and describe you as a person in very detailed manner. Here’s an ideal brag sheet: </p>
<ul>
<li><p>What do you want out of this letter? Some people want me to structure it around their technical accomplishments, others want me to talk about leadership, kindness, or their entrepreneurial outlook. I need to know what you want the letter to focus on! </p></li>
<li><p>When did I first meet you? Give me the exact date, event, and a few anecdotes that I can talk about.</p></li>
<li><p>Then give me at least achievements you want me to talk about. Eg- I organized X event (include exact dates, timings, number of participants, location, etc). Include at least two specific stories from these achievements (for eg. “I stayed up all night to help a hackathon participant with version control, and they finally ended up shipping a game”)</p></li>
<li><p>At the top of your brag sheet, include the program(s) you are applying for. I won’t explicitly mention it in the letter but helps me get a good understanding of what colleges are looking for!</p></li>
</ul>
<h2 id="timeline">
<a href="proxy.php?url=#timeline" class="anchor" title="Link to this heading"></a>Timeline</h2>
<p>If you would like to request a letter from me, please give me at least 2 weeks of lead time to write one. If you need one urgently, ask me anyways but depending on what I’m in the middle of, I might not be able to write one for you in time :( </p>
<p>I’m not interested in sending generic one-size-fits-all letters to universities, which is why it takes time to draft one.</p>
</div>
<br><hr><br><p><a href="proxy.php?url=mailto:[email protected]?subject=Re%3A%20Field%20notes%20on%20writing%20recommendation%20letters">Reply by email</a></p>I’m a sophomore in college and I’m still traumatized by Common App in the big 25s. How, you might ask? Recommendation letters!!! I’ve been writing these for the last 4...tag:notes.deven.dev,2005:Post/702132025-10-21T01:38:05Z2025-11-02T21:18:09ZAirtable Naming Conventions<div class="trix-content">
<p>After countless crash-outs, and 200+ hours spent sword fighting Airtable, I decided to write down a set of best practices to follow when creating a complex Airtable base. If you have any suggestions on what I should add, please do not hesitate to reach out to me!</p>
<hr>
<h2 id="field-names">
<a href="proxy.php?url=#field-names" class="anchor" title="Link to this heading"></a>Field names</h2>
<ul>
<li><p><strong>snake_case only.</strong> No spaces, caps, or punctuation.</p></li>
<li><p><strong>Booleans:</strong> <code>is_</code> (state), <code>has_</code> (possession), <code>can_</code> (permission).<br>Examples: <code>is_archived</code>, <code>has_signed_waiver</code>, <code>can_check_in</code>.</p></li>
<li><p><strong>Status:</strong> <code>status_…</code> (Single select; values in Title Case).<br>Example: <code>status_review</code> → <code>Draft | Ready | In Review | Approved | Rejected | Archived</code>.</p></li>
<li><p><strong>Time & people:</strong> <code>*_at</code> (timestamp), <code>*_on</code> (date only), <code>*_by</code> (actor).<br>Examples: <code>created_at</code>, <code>due_on</code>, <code>approved_by</code>.</p></li>
<li><p><strong>Units:</strong> suffix numbers with units — <code>_usd</code>, <code>_qty</code><br>Examples: <code>amount_usd</code>, <code>duration_min</code>, <code>win_pct</code>.</p></li>
<li><p><strong>Counts & flags:</strong> <code>_count</code> for counts; soft delete is <code>is_archived</code> (+ optional <code>archived_at</code>, <code>archived_by</code>).</p></li>
<li><p><strong>Derived fields:</strong><br><code>calc_<thing></code> (Formula), <code>lookup_<field>_from_<table></code>, <code>rollup_<agg>_<field>_from_<table></code>.</p></li>
</ul>
<h2 id="relationships">
<a href="proxy.php?url=#relationships" class="anchor" title="Link to this heading"></a>Relationships</h2>
<ul>
<li><p><strong>Linked record (one):</strong> singular — <code>event</code>, <code>attendee</code>.</p></li>
<li><p><strong>Linked record (many):</strong> plural — <code>events</code>, <code>attendees</code>.</p></li>
<li><p><strong>Role suffix when ambiguous:</strong> <code>event_host</code>, <code>event_venue</code>.</p></li>
</ul>
<h2 id="triggers-automations">
<a href="proxy.php?url=#triggers-automations" class="anchor" title="Link to this heading"></a>Triggers & automations</h2>
<ul>
<li><p><strong>Any manual trigger field uses </strong><code>action_…</code><strong>.</strong> Type is <strong>Button</strong> or <strong>Checkbox</strong>.<br>Examples: <code>action_send_welcome</code>, <code>action_publish_event</code>.</p></li>
<li><p>Automations must be <strong>idempotent</strong>, and <strong>reset</strong> the trigger on completion → <strong>Very important</strong>. If want to hear a fun story about this talk to @msw.</p></li>
<li><p>Write standard outputs: <code>last_<action>_at</code>, <code>last_<action>_status</code> (<code>Success</code>/<code>Failed</code>), <code>last_<action>_by</code>, and optional <code>last_<action>_note</code>.</p></li>
<li><p><strong>Automation names:</strong> <code>auto__<scope>__<trigger>__<action></code><br>Examples: <code>auto__registration__on_create__send_welcome_email</code>, <code>auto__sponsorship__daily__remind_overdue_invoices</code>. It is acceptable for automations to not have any form of snake casing. </p></li>
</ul>
<h2 id="tables-primary-field-and-ids">
<a href="proxy.php?url=#tables-primary-field-and-ids" class="anchor" title="Link to this heading"></a>Tables, primary field, and IDs</h2>
<ul>
<li><p><strong>Tables:</strong> Title Case, singular: <code>Event</code>, <code>Person</code>, <code>Registration</code>. Join tables describe the relationship: <code>Event Participant</code>.</p></li>
<li><p><strong>Primary field:</strong> human‑readable <code>autonumber</code> (or a <code>label</code> formula). Avoid raw IDs as primary.</p></li>
<li><p><strong>Record ID field:</strong> <code>record_id</code> = <code>RECORD_ID()</code> (formula). Always have this when you base interacts with another database (like is the case with Cockpit)!</p></li>
<li><p><strong>External IDs:</strong> <code><system>_id</code> like <code>slack_id</code>, <code>hcb_id</code>.</p></li>
</ul>
<h2 id="views-interfaces">
<a href="proxy.php?url=#views-interfaces" class="anchor" title="Link to this heading"></a>Views & interfaces</h2>
<ul>
<li><p><strong>Views:</strong> <code>[Team] — [Purpose] — [Filter]</code><br>Examples: <code>OPS — Action Queue — Due Today</code>, <code>ENG — QA — Missing Email</code>.<br>Personal scratch views should ideally start with <code>~name</code> (e.g., <code>~deven — triage</code>).<br>Views for running actions begin with <code>Action — …</code> and include only the fields needed.</p></li>
<li><p><strong>Interfaces/Forms:</strong> <code>Team — Purpose</code> / <code>Form — <Table> — <Purpose></code>.</p></li>
</ul>
<h2 id="change-management">
<a href="proxy.php?url=#change-management" class="anchor" title="Link to this heading"></a>Change management</h2>
<ul>
<li><p>Try not to hard‑delete fields unless things really get crazy. <strong>Deprecate</strong> with <code>z_deprecated_…</code> and hide from views.</p></li>
<li><p>WIP- I’m still testing out the Airtable sandbox, so I’m excited how that makes things earlier for making schema changes. I’ll update this article once I gain some degree of proficiency with the sandbox feature.</p></li>
</ul>
<hr>
<h2 id="final-checklist-before-you-start-drowning-in-data">
<a href="proxy.php?url=#final-checklist-before-you-start-drowning-in-data" class="anchor" title="Link to this heading"></a>Final checklist before you start drowning in data.</h2>
<p>Fields are <strong>snake_case</strong>, with correct prefixes/suffixes.</p>
<ul>
<li><p><strong>Triggers use </strong><code>action_…</code>, are idempotent, and <strong>reset</strong> after run.</p></li>
<li><p>Numbers have <strong>unit suffixes</strong>; percentages use <code>_pct</code> (0–1) unless <code>_pct_100</code>.</p></li>
<li><p>Status field starts with <code>status_</code> and uses Title Case options.</p></li>
<li><p>Derived fields follow <code>calc_/lookup_/rollup_</code> patterns.</p></li>
<li><p>Links are <strong>singular for one</strong>, <strong>plural for many</strong>; role suffixes where needed.</p></li>
<li><p>Views follow <code>[Team] — [Purpose] — [Filter]</code> (add <code>Action — …</code> where applicable).</p></li>
<li><p>Any deprecations start with <code>z_deprecated_</code> and are logged in <strong>Changelog</strong>.</p></li>
</ul>
</div>
<br><hr><br><p><a href="proxy.php?url=mailto:[email protected]?subject=Re%3A%20Airtable%20Naming%20Conventions">Reply by email</a></p>After countless crash-outs, and 200+ hours spent sword fighting Airtable, I decided to write down a set of best practices to follow when creating a complex Airtable base. If you...