Mar 01, 2019 07:38 AM
How does everyone else save/bookmark/remember all the formulas they have built?
Mar 14, 2019 10:47 AM
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.
Mar 14, 2019 02:16 PM
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:
Mar 15, 2019 06:20 AM
Yea Justin I was thinking the same thing, why not build a base to track that very thing. :grinning_face_with_sweat:
Mar 15, 2019 06:38 AM
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!
Mar 15, 2019 08:22 AM
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.
Mar 15, 2019 08:46 AM
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.
Mar 15, 2019 08:46 AM
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.