Happy French Fry-Day! π
β
Human beings REALLY suck at one thing. Developers especially.
β
ESTIMATING THINGS.
β
Let me ask you a simple question . . . "How much does a blue whale weigh?" I've asked this question to a room full of developers and the answers stretched from 2 tons to 100 tons--that's a MASSIVE range.
We're just horrible at estimating--even what seems to be a pretty straightforward answer.
β
One day, a team at Coda decided to cap the number of rows you can sync at 10,000. Why? Probably to limit resources. If you give people 5 billion rows, they're going to fill up 5 billion rows. We're all really good at that. So they picked a good round number.
And I don't have any inside information, but I'm pretty certain that limit isn't going to increase before Coda Brain is released.
β
In my Slack Magic pack, you can sync in your Slack users. Yesterday, a Slack Magic+ customer raised a concern that they are nearing 10K users and didn't know what to do.
Here's the problem:
- They're already filtering bots and deleted users (using my pack) -- they can't filter any more
- Coda only allows one sync table per document
β
How did I solve this?
I added a second sync table.
β
The first table is called SlackUsers. The second table is called AdditionalSlackUsers.
They can now sync 20,000 users.
β
How do we segment both lists? I added StartName and EndName parameters to both sync tables.
For the first table, set the EndName to "M" . . . this syncs all users UP TO the letter M (including users that start with numbers).
For the second table, set the StartName to "M" . . . this syncs all users FROM the letter M.
β
In the end, we had two tables with roughly a 60/40 split.
β
On the downside, tables can only reference one SlackUsers table, so they would need to add a custom column formula to lookup across both tables. Annoying, but not a big deal.
β
So when faced with row limits in Coda, just remember the famous line from Chief Brody in Jaws . . . You're gonna need a bigger boat!
In honor of this solution, today's Deal of the Day is Slack Magic+, now at 30% off at The Low Code Groceryβperfect for navigating those big user lists without sinking your doc with row limits.
β
β
Troy Larsonβ
CODA MAGICβ’οΈ , CEO | SOFTWARE DEVELOPER | CODA MAKER
Doc of the Day
Personal Restaurant Database by Patrick Barry (@patrickbarry)
Find and curate good eats for easy dining selection.
|
π Coda Packs
π§ The Coda pack carousel holds steady β come back soon for new adventures!
π Updated Packs
π New updates: Take your Coda packs to the next level!
- βSlack Magic+ v19 - π² TABLES:
β FIXED:
- SlackUsers: Fixed LastUpdated display
β CHANGED:
- SlackUsers: Added IncludeProfilePhoto parameter
- βMonday v28 - Added support for syncing Docs table from Monday.com
|
Here's how we can keep the magic flowing, so whenever you're ready, let's go for a joyride through Coda-land!
β
- The Coda Magic Daily- Start your day with the latest pack updates, tips, and our featured Coda Doc of the Day to keep you engagedβ Subscribe now.
- My LinkedIn- Iβve finally joined the LinkedIn craze and spruced up my profile. Letβs connect and expand our network. Connect with me.
- X- Call it what you will, Iβm there and ready to tweet, chat, and share. Follow me on X.β
- The Low Code Grocery- Your one-stop shop for Coda packs and services. Explore our store.β
β
Choose the way thatβs right for you π«΅π», or explore them all! Iβm here to make your Coda experience as magical π§ββοΈ as possible.
Did someone forward you this email? Get your own daily dose of magic directly in your inbox, here:
|
β
If you change your mind about receiving our daily email, you can manage your preferences here or βunsubscribe anytime.
β
Disclaimer: Just a heads-up! Some of the links in this email might be affiliate links, which means I could earn a small commission if you make a purchase. No extra cost to youβ¦ just a way to keep the magic coming! β¨Thanks for supporting!
β
300 Peachtree St NE Ste CS2, Atlanta, GA 30308-3565
Β©2024 Calvinware, LLC β’ All rights reserved
βUnsubscribe ββ
|
β