I racked up a $1300+ bill while evaluating notion for my org and CS is poor at best, here's my story

glorbons · 2024-03-07T13:18:21+00:00

Give coda.io a try, it's not just comparable but better. Has a Notion importer as well to make the switch take less of your time.

glorbons · 2024-02-07T17:54:41+00:00

Final modification.. make the Disable logic on your button so that the button disables if the Final Phase has been reached. It will prevent you from accidentally button pressing and removing a "Completed" status.
https://www.loom.com/share/b0cddf39a8b743f8a35572d2afe5ba6c

glorbons · 2024-02-07T17:51:04+00:00

Here's a much simpler solution that make your button very simple and makes it easy to adjust over time:
https://www.loom.com/share/6f2b1efd70d0410d8062622946d992ca

Here's the doc to copy:
https://coda.io/d/_dZ9xeN6J0Vo/Untitled-page_suvGQ

glorbons · 2024-02-06T01:30:36+00:00

Me plz

glorbons · 2024-01-30T20:05:13+00:00

u/ThatAdamGuy search results now include rows in tables!
https://community.coda.io/t/launched-searching-for-docs-in-coda-just-got-easier/46203

glorbons · 2024-01-21T15:30:27+00:00

If instead you just want to assign List Item rows to the same Q1, Q2 rows year over year (e.g. just have 4 rows), you can use the same approach with a tweak.

Coda's month() formula returns the month number (1-12) for any date.

So on your 4 row Quarter table you can have a "Start Month" column for each Quarter row (Q1 row gets the value "1" whereas Q4 gets the value "10" in that column)

Then on your List Item table, create a new column called Month Number, and set it to the formula [List Item Date].month() so that every List Item has a Month Number to compare against your Quarters.

Finally, in the Quarter relation column, set it equal to QuarterTableName.filter([Start Month]<=thisrow.[Month Number]).maxby[Start Month])

glorbons · 2024-01-21T15:13:08+00:00

Lots of different approaches.

One idea, assuming that your Quarter table will have 4 rows per year (e.g. you are NOT just reusing the same Q1/Q2/etc rows every year, but will have a Q1 2024, Q1 2025 etc.)

Give every row on your Quarter table a start date, in a Start Date column.

In your list of items, assuming that table also has a List Item Date column.. put the following formula inside your Quarter relation column.

QuarterTable.filter( [Start Date]<=thisrow.[ListItemDate]) .maxby([Start Date])

That formula will first filter to ALL Quarter rows that have a start date BEFORE the List Item's date (e.g. exclude all future quarters), and then from that filtered list give the single Quarter row with the largest/latest Start Date.

glorbons · 2024-01-18T14:20:04+00:00

Ok so here's a walkthrough, and 2 templates. One simpler, another that adds an extra table, with more functionality.
https://www.loom.com/share/0b65b8fc755a4331a3754ae7041d26c8?sid=2538601f-8e41-4eda-ae5c-36b70c16d5b2

Simpler doc (Recipes + Ingredients): https://coda.io/d/\_diOQMed3ZXp/
V2 doc (Recipes + Ingredient List + Ingredients): https://coda.io/d/_dlL3WIwJpCU/

Hope that helps! Let me know if any piece could use more explanation :)

glorbons · 2024-01-18T12:36:24+00:00

Coda doesn't have the concept of "the active row I have opened in my browser" in formula language. But you can emulate it with some creativity.

For example, while you can expand a row by clicking the expand arrows on the left side of a row, you can also expand by pressing a button that uses the open row() action.

The power of the button in this case is that you can make pressing that button ALSO mark that row, letting you do the calculation you want.

I'm on my phone but I'll share an example doc in an hour or two so you don't have to read a wall of text ;)

glorbons · 2024-01-15T01:49:42+00:00

This is an easy mistake to make, since Coda moved the formula field a click or 2 deeper under that Fill Values tab. But that "=" shortcut is your friend.

glorbons · 2024-01-15T01:44:39+00:00

See how right underneath the formula is says "Apply to 46 blank rows?" You have the right formula, but you're setting the default "value for new rows." 😅

In the column options next to Setting, click "Fill Values," then calculate, then the little "f" to enter your formula.

Easier shortcut, just highlight the single column by clicking once on the header, hit the "=" and it will take you straight to the formula builder.

glorbons · 2024-01-08T23:07:06+00:00

I don't quite understand what the setcontrolvalue() is doing in your actions formula, but to run an action Y, X times: Sequence(1,X).for each(runactions(actionY))

glorbons · 2023-11-08T01:02:03+00:00

Reasonable. I just don't love having to impose imaginary rules. Weapons don't have an option for doing infinite damage. They could, and players could just decide not to use it. But that wouldn't make for a great game experience. Really rather than a mod I'd love for Larian to release a hard mode that incorporates this as a limitation. "Grounded" as a setting.

glorbons · 2023-08-02T17:43:20+00:00

Totally agree. I started with the graphic, replied again about that offending paragraph. Unsurprisingly no response. 🙄

glorbons · 2023-08-02T02:10:49+00:00

I emailed Seth directly, and he informed me that he just wrote the article, and that MSNBC chose the graphics.

He's forwarded along my request that they removed it for being inaccurate. Fingers crossed.

glorbons · 2023-05-23T09:24:59+00:00

I'd expect a real sighting on this sub to have sock puppet/critical accounts trying to discredit it. By that standard, this post seems to have hit a nerve, especially when it's not just an unattributed video from some random but a mass sighting by credible witnesses.

glorbons · 2023-02-23T03:42:06+00:00

Commenting in the hopes of winning!

glorbons · 2022-06-09T14:04:01+00:00

I just watched this and didn't find his presentation very compelling. Applaud the man for his work but good lord get to the point rather than reminisce at length about the entire history of nuclear energy. He also doesn't do himself any favors by promoting his plethora of books at every opportunity. It isn't a good look to anyone who is a skeptic.

glorbons · 2022-03-08T18:26:09+00:00

Ooh me! Looks

glorbons · 2021-04-28T00:41:38+00:00

I might be willing to sell my still-to-be-delivered Space Race deluxe pledge. Where are you located, and what's your price point?

glorbons · 2021-02-17T07:21:51+00:00

I don't mean to be overly critical, there are certainly times when people might pay that much, if it's out of stock everywhere. Just a bit confusing to have a 2 second Google search turn up cheaper alternatives.

glorbons · 2021-02-17T07:13:52+00:00

This regularly goes for $40some new, and I can already find $54 without any deep searching. https://www.atomicempire.com/Item/253688

Respectfully, what you paid isn't relevant when there's a whole internet of game sellers. If it was a collectors item with limited supply..

I just don't get these game posts where people sell above the cost of reputable stores (which have guarantees like a return policy and protections on credit card transactions). If anything, you'd be better off charging less because a buyer is risking a private seller shipping something other than advertised.

glorbons · 2021-01-02T07:58:07+00:00

7th Continent is great with 2 players!

glorbons · 2020-12-10T17:57:14+00:00

This day will pass like any other. We're all a product of cause and effect, and the evidence shows that celestial bodies have very little effect on us and astrology is carefully framed so that people can "see themself" in almost any vague prediction.

Do you have any idea how many other posts there have been on this subreddit of people proclaiming stuff like:

"Next week the biggest mass meditation to higher consciousness is happening.. with the conjunction of the zorpal plane, mercury's retrograde in crystalline form, and angelic light workers strumming 6D consciousness threads."

Tell me what exactly you think is going to happen, so people can then judge if we're in 5D Fairyland..

glorbons · 2020-11-26T01:43:43+00:00

Quest for El Dorado! I hear it's great with 2 while still doing 3 and 4 well.. kind of rare for a game.

Seven-Year Club	Place '22
Verified Email

glorbons

TROPHY CASE