algonote(en)

There's More Than One Way To Do It

Create VCDB 2.0 with No Code(Glide)

No code app for searching Japanese venture capitals

f:id:hiromichinomata:20200307090736p:plain:w200

TLDR Demo

www.youtube.com

https://jpvcdb.glideapp.io

What is VCDB

Two years ago, I surveyed the fund size of Japanese venture capitals. I ended up just searching at that time. Visualization was only HTML table.

Thanks to no code trend, inputting Google Spreadsheet can generate simple PWA app recently. VCDB was updated to Glide app as v2.0.

What is Glide

Glide is no code app creation tool.

In this context, app means not native app on App Store. App means mobile web app. Since it supports PWA, you can register app to smartphone home.

The other no code tool like Bubble need setting up many configurations because there are many custom options. Glide spec is simple and due to this, making MVP is much easier.

Generally no code tool use Google Sheets as DB. Google Sheets API was migrated to v4. Some v3 features like filter is not available. Internal structure of Glide is Google Sheets <=> Glide internal DB <=> Glide app. Dependency level of Google Sheets API is smaller.

What I considered

  • Data Structure、UI concept

Venture capital has multiple funds. One fund can be managed by multiple VC. many-to-many relation.

However, if I were CEO, the fund name is not so important because CEO or CFO wants to know who they should meet. I pushed all information to one single vc table.

Like Heroku, Glide plan is limited by the number of rows. Normalization is not good at least for free plan.

  • Icon

The icon of seed, early, middle, later is coordinate with technology change, direct talk, letter, telephone, smartphone. Initially I tried to use animal, but animal icon was only available in Pro plan.

  • Many Kabu

The default of Glide icon is the first letter of the list item if the image is not set.

Some CVC name starts from 株式会社xxx (Kabushiki gaisha, Limited Company xxx). That means there are too many kabu, kabu, kabu. So I removed that part.

  • Unique Score Definition

We have to validate the statement of VC. One VC says we invest on early stage and later stage, but each capital has each criteria. Also, sometimes the amount of investment is not listed on press releases.

I took opinionated way and I assumed max investment size is 1/20 of fund size.

Phase is categorized as

  • ~100M JPY: seed
  • ~500M JPY: early
  • ~2000M JPY: middle

Impression

Based on Japanese Venture Capital Association list, I added VC from press releases. I regularly update the list, but if you know the missing VC, please let me know.

jpvcdb.glideapp.io