Skip to main content

How does everyone else save/bookmark/remember all the formulas they have built?

Hi @BobBannanas,



There is nothing inside Airtable itself that keeps track of all the formulas built by users. So what I personally do, is simply to store the most complex formulas I built into a text file. It might eventually be stored in gitHub or something like this but right now, a simple text file is enough and I can search for a key term if I need to remember the structure of particular formula.


I haven’t done anything specific, mainly because my current base collection is small enough that I know where to find the formulas I might want to reuse. However, there are formulas I’ve offered while helping others that I haven’t saved anywhere, and your question got me thinking more about those.



If only I had a tool where I could save collections of related things, filter them, add notes, screenshots, dates, etc.



:winking_face:


I haven’t done anything specific, mainly because my current base collection is small enough that I know where to find the formulas I might want to reuse. However, there are formulas I’ve offered while helping others that I haven’t saved anywhere, and your question got me thinking more about those.



If only I had a tool where I could save collections of related things, filter them, add notes, screenshots, dates, etc.



:winking_face:


Yea Justin I was thinking the same thing, why not build a base to track that very thing. :grinning_face_with_sweat:


Yea Justin I was thinking the same thing, why not build a base to track that very thing. :grinning_face_with_sweat:


My goal was to essentially have people show off their formula databases. As we all know, sometimes people view data in different ways. It was simply maybe a show and tell of people’s formulas that they keep safe. Ive built quite a few that I totally forgot about or have to rebuild because I lost it! Lol!


My goal was to essentially have people show off their formula databases. As we all know, sometimes people view data in different ways. It was simply maybe a show and tell of people’s formulas that they keep safe. Ive built quite a few that I totally forgot about or have to rebuild because I lost it! Lol!


Last I checked, I had upwards of 270 bases in my workspace — so not only do I occasionally recreate already-existing solutions, at times the second (or third) pass at a problem results in a less-optimal solution than an earlier one. Maybe this would be a good time to put together a ‘base di basi’ for my Airtable work…



I’d also like to recommend people update — and stay up-to-date with — @Jeremy_Oglesby’s excellent ‘Show and tell’ wiki collecting helpful data tables, formulas, and routines. The collection of @willinspire’s URL- and text-cleaning routines alone is worth the price of admission.


The wiki forum post is nice and all but not searchable.


@BobBannanas if you’re up for it we could collab, we can create a base to track and then use the API to make a front end where people can search and even show examples of use.


We can have the airtable form for people to post theirs.


Last I checked, I had upwards of 270 bases in my workspace — so not only do I occasionally recreate already-existing solutions, at times the second (or third) pass at a problem results in a less-optimal solution than an earlier one. Maybe this would be a good time to put together a ‘base di basi’ for my Airtable work…



I’d also like to recommend people update — and stay up-to-date with — @Jeremy_Oglesby’s excellent ‘Show and tell’ wiki collecting helpful data tables, formulas, and routines. The collection of @willinspire’s URL- and text-cleaning routines alone is worth the price of admission.


Lol thank you for the kind words. I hope people can find my contributions useful (especially the URL parser function that is over 140,000 characters long lol)



I only wish we were allowed to share links in here - like to GitHub or something - because then it would facilitate us coders and hackers being able to contribute more substantially to the community.


Reply