Top 10 Most Active Topics by Makers 🏃🏽‍♀️

[steph]

Day two of our 10k celebration and we’re just warming up!

Today, we celebrate by shouting out the top 10 Most Active Topics by Makers by year since the community started in 2018. Two Makers from each year (and their topics) are considered by engagement such as replies, likes, and views. But also by their community standing and maintaining an active status in the community within the last 3 months. Bonus for the topics have screenshots, formulas, and Coda doc embeds!

But first…

Rare badge alert! How many total replies are there in all 10 Top Active Topics?

Send a DM to @steph with the correct number no later than Feb 15th, 2022 to receive your badge. Do not post publicly or you’ll be disqualified. Makers will receive one-of-a-kind community badge: The 10k Reply Count Champion

Where can I see the reply counts for each topic?

All topics have a Replies count in the original post after the body content. You must visit the full topic to view this detail. It is not available in topic previews.

Without further adieu…

Our 2018 winners are @tomavatars and @cnr!

Timer formula : should need variables?

Hi there. I’m struggling to find a timer formula to track time on actual tasks. I would like to be able to track time when I check a task on. But I can’t find a way to make a timer. I tried to use named formulas to increment a timer by using the same formula with a delta time (which I’m not sure is working) like : [image] But it doesn’t work as expected as I can’t see a timer, it just adds a random value. I’m wondering if Coda doesn’t lack some variables possibilities, with getter and sett…

Why is my time off by an hour with Now()?

Pretty much says it in the title. When I use the Now() function it’s off by exactly one hour. Is this because of Daylight Savings Time? Is there a way to get around this? [image]

---

Our 2019 winners are @Benn_Bennett and @Chase_Schwalbach!

Linking Master Table to "Tiered" Todo List

Ok, this might not be possible, but here’s what I’m trying to do . . . I have a master table of people and each row looks something like this: Table: Master People Table Bill | Status 1 | Demographic Info [multiple columns] Sally | Status 2 | Demographic Info [multiple columns] Sam | Status 3 | Demographic Info [multiple columns] I also have a 3 separate table views of each Status with its own unique rows: Table: Status 1 (view of Master People Table) Bill | TodoItem Bill | TodoItem Bi…

New Line in FormulaMap

Hello, I’m trying to write out some lines in a table into text using FormulaMap() Right now they all show up as a list, and I was trying to figure out a way to line break between the list. Any thoughts? Concatenate(Value, “\n”) etc aren’t seeming to work

---

Our 2020 winners are @Brendan_Woithe and @Tim_Richardson1!

Calendar Setup options, possibilites, frustrations and questions

Hey all, I’m trying to figure out a way to show projects and upcoming bookings in a clear way for our small business - potentially using the calendar. Unfortunately, Gantt chart displays of our projects are not working well since we cannot zoom into just this week… Either, we see a zoomed out view (some projects go for months) or if I make a filter to zoom in, it excludes all the longer project from the view. So - this is what it looks like without filtering - its not great, especially for t…

Version control question: complex!

Hi all, I’m creating a Coda doc in order to control the versions of the way standards are worded. There are “Standards” and then “sub-standards”. The wording for each standard is contained at the sub-standard level. When a sub-standard wording changes I duplicate the row, change the wording, then change the version number. What I want to do is find a way to see only the latest version of each sub-standard. That means for Standard A there are going to be, say, 9 sub-standards. 3 of those sub-sta…

---

Our 2021 winners are @Bill_French and @Connor_McCormick1!

Packs Builder - Mind Blown

Now that the Packs Builder has arrived, I just informed my family that I will not see them or any sunshine for the next 32 hours. [image]

Coda Formula Challenge: All Combinations

Given a list of elements, return all possible combinations of those elements of all possible lengths. For example, given this list List(A,B,C,D) return this result: [image] The result you return can be in any order. All that matters are the combinations. Ideally, the result does not use a helper table, it’s just a pure Coda formula. Honestly, I haven’t figured it out yet. Have fun!

---

Our 2022 winners are @joost_mineur and @Johg_Ananda!

Coda API table access

I hope somebody can enlighten me a little bit on working with the API. What I would like to accomplish is showing a couple of fields from a table from a non-publicly-shared coda document on a page on a website, preferably in the middle of some other (already existing and non-changing) text items. An example of what I am trying to do is retrieving the text from the column messages from the 3 newest rows in the table Updates. I know how to get the API token for the table and how to get the ID of…

In Debug Calculations, what are the "[integer] X" referring to?

On debug calculations, there is a time value (how long its taking to load) and then an ‘[integer]X’ value, such as 0X, 1X, 10X, 30X. Is this referring to how many times this object is loaded? How can we use that information to help us make our docs more performant? Thanks!

I’m so thrilled to present these Makers with a special badge called the 10k Active Topic Starter in recognition of their achievement. Be sure to give a reaction to send your appreciation for their contributions on the community!

Congratulations to our top 10 Most Active Topics Makers!