Al Chen
Al Chen
  • Видео 137
  • Просмотров 200 657
How to do capacity or bandwidth planning for engineering teams in Coda [+Template]
Capacity or bandwidth planning for engineering teams ensures that you don't over-extend your engineering team based on the number of person hours/effort they have available for a given time period. This template utilizes t-shirt sizing to help you scope projects in a sprint and then helps you calculate how much over or under capacity you are. The main audience for this template are engineering and product leaders who want to tweak the bandwidth allocation assigned to different categories of projects to get a better sense of the engineering team's overall capacity. Template here: coda.io/@atc/capacity-and-bandwidth-planning-for-engineering
Easily jump to sections in this video:
* Intro - 0:0...
Просмотров: 53

Видео

How access and refresh tokens work with OAuth using the Coda Zoho Backstage Pack
Просмотров 55Месяц назад
This is an explanation of how access and refresh tokens work when a user authenticates with OAuth to access an application. In this case, I show how to access the Zoho Backstage API using access and refresh tokens. The Coda Packs infrastructure makes it easy to deal with the cycling between refresh tokens and access tokens. Easily jump to sections in this video: * Intro - 0:00 * OAuth access to...
View progress percentage of Jira issues based on story points or t-shirt size [+Template]
Просмотров 75Месяц назад
Calculating progress of a Jira epic based on issue count can be misleading. If one issue's effort take many more hours than another issue, then the progress isn't calculated correctly. This Coda template walks through how you can calculate the true progress based on effort/story points and on t-shirt sizing. Template here: coda.io/@atc/view-progress-percentage-on-jira-issues-based-on-numeric-ef...
How to automate sending pre-release notes with Jira, GitHub, and Slack in Coda [Tutorial]
Просмотров 1123 месяца назад
Technical program managers might be sending out pre-release messages to different teams internally to let them know when the latest bugs will be fixed or latest features will hit prod. This template shows you how to integrate your Jira issues (release blockers) and GitHub pull requests (cherry picks) into an automated release message that can be sent to a Slack channel. Easily jump to sections ...
How to create Google Calendar recurring events with sequential numbers in the title [Tutorial]
Просмотров 1,1 тыс.4 месяца назад
If you create recurring weekly or monthly events, sometimes you want to add a sequential number at the end of the event title to know how many times you've done something. This could be useful for doctor appointments, medicines you take, and more. The current method involves duplicating a Google Calendar event and then manually adding a number to the event title. With this Coda template, you ca...
How to sync Zoho Backstage event data into Coda to filter and sort attendees [Tutorial]
Просмотров 1465 месяцев назад
Sync in your Zoho Backstage events and attendee data into Coda. See your Zoho Backstage data update in real-time in Coda and filter and sort the attendees and events as if you were using a spreadsheet. The Zoho Backstage Pack let's you set up the sync easily without any coding necessary. Drag-and-drop the attendees and events sync tables into Coda and you'll see your data instantly. Easily jump...
Instead of using column notes in Google Sheets use Convert to Table in Coda [Tutorial]
Просмотров 1315 месяцев назад
When you need to explain what different things mean in a column using a note in the column header (in Google Sheets), people have to hover over the column header to read what each thing means. If something about your list of data changes, you'll have to edit the column header note. Or you might create a key or legend explaining what each thing means. Instead, Coda has a simple Convert to Table ...
How to import Jira issues into Google Sheets with Google Sheets add-on - Tutorial [2024]
Просмотров 9396 месяцев назад
This is a tutorial on how to import issues from a Jira project into Google Sheets with the Google Workspace add-on from Atlassian. The add-on does a one-way sync into Google Sheets and lists out all the properties of your issues in a sheet in Google Sheets. Easily jump to sections in this video: * Intro - 0:00 * Install Jira Cloud for Sheets add-on - 0:24 * Set up add-on - 1:07 * Use JIRA() fun...
How to combine Jira issues, GitHub pull requests, and customer tickets together with feature roadmap
Просмотров 1187 месяцев назад
This is a tutorial on how to you can see all the data about your feature roadmap in one place. Most TPMs might manage a feature roadmap in a Google Sheet because it's flexible and easy to update when working cross functionally. The issue is that the actual work being done against the roadmap is being tracked in Jira and GitHub. This example in Coda shows how you can combine your Jira issues wit...
May 2024 No-Code: NYC meetup
Просмотров 868 месяцев назад
May 2024 No-Code: NYC meetup where Daniel Brown presented his project in Bubble and Phil Lakin discussed the NoCodeOps community.
How to bulk edit issues and change status of issues in Jira Data Center & Coda [2024 Tutorial]
Просмотров 3268 месяцев назад
This is a tutorial on how to bulk edit issues in Jira Data Center. I also show how to bulk edit the status of issues. The bulk edit feature also exists in Jira Cloud. I also show how you can bulk edit Jira Data Center issues using the Jira Data Center Pack so that you can edit your issues like you would in a spreadsheet. Easily jump to sections in this video: * Intro - 0:00 * Jira Data Center b...
Atlassian Team '24 Recap - All About Jira
Просмотров 798 месяцев назад
Recap of Atlassian Team '24 and what people love about Jira, what they would improve, and advice for non-eng teams who are getting started with Jira.
See all 3,000 NYC Citibike stations in a table in Coda and pick your favorites - Tutorial
Просмотров 1779 месяцев назад
This is a tutorial and walkthrough on how to use the Citibike favorite stations template. You sync the list of all stations in real-time and favorite the ones you use the most. Template here: coda.io/@atc/citibike-nyc-favorite-stations Easily jump to sections in this video: * Intro - 0:00 * Favorite a Citibike station - 0:18 * Refresh the Citibike Pack - 0:33 * Search for a station - 0:49 * Hea...
How to build a Coda Pack in less than 1 hour for syncing NYC subway alerts - Tutorial
Просмотров 3149 месяцев назад
This is a tutorial and walkthrough on how to build a Coda Pack (integration) in less than 1 hour (20 minutes, actually). I want to show how simple a Coda Pack can be when you have a single API endpoint and want to bring that data into a Coda sync table. The doc that utilizes the Pack in this example is called Is my train fucked? It let's you see if a certain NYC subway line is experiencing issu...
No-Code: NYC April 2024 Meetup - Spotlight on No-Code influencers
Просмотров 829 месяцев назад
We've got two awesome speakers coming through to tell us about what they are building in the No-Code space and as always we'll be talking no-code news and highlights. Our Guest Speakers Include: 1) Matthew Wensing showing off his no-code tool: usesummit.com/ 2) Doc Williams answering questions about his YT channel: www.youtube.com/@docwilliams
How to replace Jira with Coda to prioritize, sort and filter your tickets Part 2
Просмотров 30110 месяцев назад
How to replace Jira with Coda to prioritize, sort and filter your tickets Part 2
No-Code: NYC February 2024 Meetup - Citizen Development at Enterprise Scale
Просмотров 42010 месяцев назад
No-Code: NYC February 2024 Meetup - Citizen Development at Enterprise Scale
Show milestones on Jira timeline/roadmap in Coda - Jira integration
Просмотров 2,4 тыс.Год назад
Show milestones on Jira timeline/roadmap in Coda - Jira integration
Part 2: A company OKR workspace - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 113Год назад
Part 2: A company OKR workspace - Strategic Planning & OKRs for Enterprises in Coda
Part 1: Intro to OKRs - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 159Год назад
Part 1: Intro to OKRs - Strategic Planning & OKRs for Enterprises in Coda
Part 5: Planning & executing company OKRs - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 73Год назад
Part 5: Planning & executing company OKRs - Strategic Planning & OKRs for Enterprises in Coda
Part 4: Company roster - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 56Год назад
Part 4: Company roster - Strategic Planning & OKRs for Enterprises in Coda
Part 6: Integrations with other enterprise tools - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 58Год назад
Part 6: Integrations with other enterprise tools - Strategic Planning & OKRs for Enterprises in Coda
Part 7: Team hubs for OKRs - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 45Год назад
Part 7: Team hubs for OKRs - Strategic Planning & OKRs for Enterprises in Coda
Part 3: Workspace folders for teams - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 84Год назад
Part 3: Workspace folders for teams - Strategic Planning & OKRs for Enterprises in Coda
Part 8: OKR accountability - Strategic Planning & OKRs for Enterprises in Coda
Просмотров 54Год назад
Part 8: OKR accountability - Strategic Planning & OKRs for Enterprises in Coda
How to use story points in Jira and create accurate reports with Coda's Jira Pack [2024 Tutorial]
Просмотров 1,1 тыс.Год назад
How to use story points in Jira and create accurate reports with Coda's Jira Pack [2024 Tutorial]
How to sign into Jira using Python library and Coda Jira Pack [2024 Tutorial]
Просмотров 773Год назад
How to sign into Jira using Python library and Coda Jira Pack [2024 Tutorial]
Why no one cares how you built your tool or product and 3 key takeaways
Просмотров 72Год назад
Why no one cares how you built your tool or product and 3 key takeaways
Show Jira epics from other projects in the timeline/roadmap in Coda - Jira integration
Просмотров 516Год назад
Show Jira epics from other projects in the timeline/roadmap in Coda - Jira integration

Комментарии

  • @Krylone
    @Krylone 12 дней назад

    This would have been useful if it was per track. Playlist tagging is little to not useful since you can name playlist with any words (tags) already through the app.

    • @al-chen
      @al-chen 8 дней назад

      Good to know

  • @saradayo
    @saradayo 14 дней назад

    The same as another commenter, I hit refresh after entering the sequential number and got an error saying "couldn't find this action in Google calendar." Can you please give a solution?

    • @al-chen
      @al-chen 8 дней назад

      Instead of hitting refresh, can you try hitting "Send edits?" That sends the new calendar titles in Coda back to Google Calendar.

  • @Lukas-vh5gg
    @Lukas-vh5gg 15 дней назад

    Awesome. Thanks!

  • @RickardAbraham
    @RickardAbraham Месяц назад

    Nice, I think the diagram was very intuitive!

  • @fredbloggs42
    @fredbloggs42 2 месяца назад

    This is a bit outdated now. Notion now has full support for forms and buttons. I like your comparison of how much easier it is to work with relations in Coda (more like conventional coding) but I think you should state up front, not at the end of your video, that you are a Coda employee.

  • @andrewwildman
    @andrewwildman 2 месяца назад

    Hi. When I go to the link here for the template it says I need to reqwuest access. Have done that and am awaiting access. Is that right?

    • @al-chen
      @al-chen 2 месяца назад

      You should be able to make a copy of the template to your account!

    • @andrewwildman
      @andrewwildman 2 месяца назад

      @@al-chen Its working. GENIOUS! Thank you Al

  • @NornChaver
    @NornChaver 2 месяца назад

    Thank you so much!

  • @SamKapoor-s2t
    @SamKapoor-s2t 2 месяца назад

    hey cannot see the template link working can you please help

    • @al-chen
      @al-chen 2 месяца назад

      Fixed the link!

  • @nikola.khalil
    @nikola.khalil 2 месяца назад

    You did not show how we do it step by step, can you please provide that for me for github and how to make the feature table

    • @al-chen
      @al-chen 2 месяца назад

      Hi, take a look at this article that walks you through how to set up a Pack: help.coda.io/en/articles/7980712-install-packs-in-your-doc

  • @susel_vazquez_acuna
    @susel_vazquez_acuna 3 месяца назад

    It worked! thanks!

  • @user-yj4hk4oq9m
    @user-yj4hk4oq9m 3 месяца назад

    📝 *Coda vs. Notion: 1️⃣ 🧮 Easier formulas: Writing is simpler in Coda. 2️⃣ 📊 Advanced table functions: Coda formulas outperform Notion's. 3️⃣ 🤖 Automations: Coda automates tasks seamlessly. 4️⃣ 🔗 Third-party integrations: Coda integrates fully; Notion lags. 5️⃣ 🔘 Functional buttons: Coda buttons are interactive; Notion's are basic. 6️⃣ ✍️ Formula editor: Coda allows formatting with spaces and breaks. 7️⃣ 🔍 Detailed layouts: Coda customizes row views better. 8️⃣ 📈 Sorting animations: Coda visually highlights changes; Notion's are abrupt. 9️⃣ 💰 Cost savings: Coda's pricing favors larger teams. 🔟 📋 Native forms*: Coda offers forms; Notion uses third-party solutions.

  • @zink08
    @zink08 4 месяца назад

    I successfully connected to my calendar, but when I hit Refresh Calendar after entering the sequential numbers, I get an error. "Google Calendar error. Couldn’t find this action in Google Calendar." Any idea why this happens?

    • @al-chen
      @al-chen 4 месяца назад

      Instead of hitting refresh, can you try hitting "Send edits?" That sends the new calendar titles in Coda back to Google Calendar.

  • @Mirabalbin1914
    @Mirabalbin1914 5 месяцев назад

    Thank you! I was looking for this. Have a Nice day!

  • @rahgandarahganda3813
    @rahgandarahganda3813 6 месяцев назад

    Why the monthly cost of Aston Martin is only $2k? Doesn't it takes 68 months (not 12 month) to collect $136K money to buy the Aston Martin?

    • @al-chen
      @al-chen 6 месяцев назад

      This was just taken from the PDF from Tim's blog

  • @anonymouschessaccount5508
    @anonymouschessaccount5508 7 месяцев назад

    HEY HOW CAN YOU CHANGE IT TO QWERTY

  • @JACCAdmin
    @JACCAdmin 7 месяцев назад

    why noitn does not knowthis huhuh even notin have limitaiton Maximum recursion depth exceeded.

  • @farbexyt
    @farbexyt 8 месяцев назад

    Excelent work. An error appears for me. TypeError: Cannot read properties of undefined (reading 'cells') sortCodaTableCols @ Código.gs:132 updateSheet @ Código.gs:32 runSync @ Código.gs:27

    • @farbexyt
      @farbexyt 8 месяцев назад

      I did several tests, created a new doc, copied the table and in the new doc it worked, I don't know how to explain it, maybe the size of the original doc being large has some influence

    • @farbexyt
      @farbexyt 8 месяцев назад

      I found the problem and will post it here in case others have the same configuration. I couldn't get the rows due to a filter in the table that show the rows according to the user

    • @al-chen
      @al-chen 7 месяцев назад

      @@farbexyt Thanks for following up on this! I didn't think the filter would affect the script but good to know it does.

  • @seun-ohm
    @seun-ohm 9 месяцев назад

    Awesome tutorial. Thanks for sharing.

  • @pubguc6771
    @pubguc6771 9 месяцев назад

    0:06

  • @valeriiapoliakova7327
    @valeriiapoliakova7327 10 месяцев назад

    Thank you for instruction! I used this approach however I have view of tasks instead of Epics (parent in my case) and I don't see the option of grouping them in this way. Is it possible?

    • @al-chen
      @al-chen 10 месяцев назад

      Are you referring to what you see in Coda after you've synced in your Jira issues?

  • @valeriiapoliakova7327
    @valeriiapoliakova7327 10 месяцев назад

    in my timeline I see User Stories instead of Epics / Parents. Is it possible to fix?

    • @al-chen
      @al-chen 10 месяцев назад

      Are you talking about the timeline view in Coda after you've synced over your Jira issues?

  • @SteveHolly-m4n
    @SteveHolly-m4n 11 месяцев назад

    Fantastic discussion and insight from the panelists. Thank you for sharing.

  • @JonGubler-j9m
    @JonGubler-j9m 11 месяцев назад

    Awesome video! I was able to run the sync but running into one issue. Most of the columns from my table are syncing, but several are not and are instead all null when I've confirmed they're non-null in my Coda table. I've double checked the column header names between g sheet and Coda and they both match. I've also tried running the script on just the problamatic columns in case the sync was too large but that didn't solve it either. Any suggestions?

  • @kajsatunius3207
    @kajsatunius3207 Год назад

    How do you get the start and end date from task/issues to show in the timeline? I only get the epic to show in the timeline. Thanks for a greate video :)

    • @al-chen
      @al-chen Год назад

      You just need to make sure the issues in your backlog have 1) a start date and 2) due date. The timeline layout in Coda requires a start/end date to know how to plot the bars!

  • @systeradmin
    @systeradmin Год назад

    perfect - just what I needed - thanks!

  • @santocabo
    @santocabo Год назад

    Thank you! I didn't know about Guru, but this KB is what we need. :)

  • @andydataguy
    @andydataguy Год назад

    Great video!! Thank you for this candid analysis

  • @rohanm7695
    @rohanm7695 Год назад

    It's a great doc, but those captions are horrendously distracting 😳

  • @fhjazzz
    @fhjazzz Год назад

    Hi how can I get access/copy of this template. Id love to see how it was created and play around with it.

    • @al-chen
      @al-chen Год назад

      Sure here's the link to the template: coda.io/@atc/home-construction-cost-estimator

  • @RandyKoendjbiharie
    @RandyKoendjbiharie Год назад

    Nice vid! Can I see also somewhere how you build the table? Struggling bit with that

    • @al-chen
      @al-chen Год назад

      You can just type "/table" in a Coda doc and start adding the columns for the calendar.

  • @jimspencer
    @jimspencer Год назад

    Great template! Very nice!

  • @mdemko
    @mdemko Год назад

    Thank you Al.. this is awesome.. Love it. Love it, Love it

  • @VianneyLAPOUBLE
    @VianneyLAPOUBLE Год назад

    I totaly agree with you. And you din't even mention the publishing feature which provide much more advanced features.

  • @DivinaVillalino
    @DivinaVillalino Год назад

    Thank you so much for this! A true lifesaver. Keep it up <3

  • @leapochio
    @leapochio Год назад

    Thanks for the video, its great. I make this a few months ago. Now I have created more records in Coda, so I want to update the sheet. I have multiple scripts (.gs), one for each Coda table. But it seems to always run the same script although I select a diferent one. The execution log always refers to the same table. Do you know what I could be doing wrong? Thanks!

    • @al-chen
      @al-chen Год назад

      You may have to put each script in new projects instead of creating multiple scripts in the same project.

    • @leapochio
      @leapochio Год назад

      @@al-chen correct, doing that it works fine. Thanks!

  • @rca3691
    @rca3691 Год назад

    Great tutorial! Would love to know if it works for the file attachment also? Since I have column for file attachment in coda. Thanks!

    • @al-chen
      @al-chen Год назад

      I believe if you do the sync with a file attachment, it will give you a link to the file stored in Coda into your Google Sheet. Worth testing it out!

  • @Markus-ht5uc
    @Markus-ht5uc Год назад

    🤣 "promosm"

  • @brettertogether
    @brettertogether Год назад

    Al! LOVING this content. Just getting into Coda and it’s very exciting. :) Quick question. What if you have one person who is part of multiple teams and has multiple roles within your organization? Can you make the Team Roster table include more than one team or role option per person? For example. I am COO but also part of the Content Team within our org. How would you approach this? Thanks in advance for your help!

    • @al-chen
      @al-chen Год назад

      Yup! The team roster table is just a table with columns and the column is a "select list" type. Select lists can have multiple options selected. So for team you could set the select list setting to allow multiple team selections. See more here: help.coda.io/en/articles/2013579-create-select-list-columns

    • @brettertogether
      @brettertogether Год назад

      @@al-chen Awesome! Thank you so much. Super helpful! Continuing to watch your videos...

  • @BriannaRose-m9y
    @BriannaRose-m9y Год назад

    Hi Al! I keep getting the following error: TypeError: Cannot read properties of null (reading 'getDataRange'). Any idea how to correct/fix this?

    • @BriannaRose-m9y
      @BriannaRose-m9y Год назад

      I'd also like to note, I completely realize this script is 3 years old now lol

    • @al-chen
      @al-chen Год назад

      Kinda hard to debug without seeing the Google Sheet. Maybe check to see if you spelled the worksheet name right for the SOURCE_WORKSHEET_NAME variable in the script?

  • @fantom2967
    @fantom2967 Год назад

    Oh one more request as you my favorite Coda RUclipsr, can you make a video on how we can have master place that pulls all dates from various Docs so we can see today, tomorrow, this month and etc. I have different projects, personal vs business, reminder, birthday and etc Docs, each has own dates, so everyday have to go each to see what due today, tomorrow and etc. There must be a way to pull all into Master Doc with a bility to link to original Doc/Row if we need to edit. Thanks so much for very creative videos on Coda!

    • @al-chen
      @al-chen Год назад

      This is possible with the Merge Table Pack created by a member in the community: coda.io/packs/merge-table-lite-14572. Another option is to create a big table in your Master Doc and then in your other docs, set up a cross-doc from that big table and filter those tables to show your personal, business, and other areas of your life. The only issue here is that cross-doc isn't two-way yet, so to update stuff in your "spoke" docs, you'd have to set up buttons that take action in your main big table in the Master Doc.

    • @fantom2967
      @fantom2967 Год назад

      @@al-chen Thanks a lot!

  • @fantom2967
    @fantom2967 Год назад

    Now that is a great use case. Next challenege for you, try to replicate bookmark manager (like Start Me), only issue Coda link does not pull favicons natively. Thanks for this great video Codan | AI Chen =)

  • @fantom2967
    @fantom2967 Год назад

    any tutorial on how to build such template?

    • @al-chen
      @al-chen Год назад

      Will work on one soon!

    • @fantom2967
      @fantom2967 Год назад

      @@al-chen Awesome!

  • @danielvelho6627
    @danielvelho6627 Год назад

    AI seems unable to realize how powerful Coda is 😅

    • @al-chen
      @al-chen Год назад

      Hopefully it will catch up soon!

  • @Abss0966
    @Abss0966 Год назад

    How can i create this system on Notion ?

  • @Devingel
    @Devingel Год назад

    can i have this template please

    • @al-chen
      @al-chen Год назад

      Unfortunately the AI feature isn't publicly available yet, but you can sign up for the alpha here: coda.io/product/ai-alpha

  • @ashwebb5400
    @ashwebb5400 Год назад

    It seemed that when you applied the "voice" mostly all you ever got was a word or two or a pithy slogan that the voice has used at the end of the output. Average at best. The summary of Tims process was good in each filter question. What the seeker is looking for from ChatGPT I presume is the 10 or 15 suggestions or alternitives that Tim says to do for each outcome. That was what I personally wanted when I went through the exercise.

    • @al-chen
      @al-chen Год назад

      Yeah I'm tweaking the structure a bit to have ChatGPT go more in-depth on each step of the exercise and also for it to do a better job of giving the advice from the voice of the person. Still a work in progress :)

  • @HippieP629
    @HippieP629 2 года назад

    Looking again at this video 10 mos later, I firmly believe that as a long-time notion user and beginning coda user, that both marketing and algorithms play an extremely large part in usage. The amount of notion fanboy comments and workarounds on the socials is absurd. Both craft and coda are functionally superior to notion in many (not every) ways but bc users get caught up in the tiktok, yt, twitter, etc algorithms and workarounds that 3rd parties and template makers provide, it's very hard for ppl to get out of the notion sphere. It's curated for them unless they watch videos like this. For example, recurring tasks. Instead of looking for a similar platform w/ baked in functionality, many users asked "when are recurring tasks coming?" for YEARS. Even now you have to create a "recurring tasks" template. API. It took notion YEARS to open the API. I could go on and on about the functionalities users demanded for so long. Why didn't many switch? Marketing and algorithms.

  • @theresearcher6024
    @theresearcher6024 2 года назад

    Thank you

  • @sahil-lele
    @sahil-lele 2 года назад

    Where can I get this exact template that Uri is showing here? Doesn't look the same as the one linked in the description

    • @al-chen
      @al-chen 2 года назад

      Hey Sahil Uri never actually published this template, but you could customize the template linked to in the description to mimic what Uri built.