collabapi_infographic_20141108.v3

collabapi_infographic_20141105.v2

Builders Invoice Mobile App

Lets say we want to create an app for a home Builder / Carpenter – they need to quickly make up an invoice on their mobile tablet, while onsite at a job.

The different things to keep track of are :

  • Customer
  • Job / Invoice
  • Invoice Line Item
  • Product

 

Step 1 : Define the ‘DataModel’

We define all the properties for each of these :

  • Customer : Name, Address, Phone
  • JobInvoice : Date, Description, link to a Customer, list of InvoiceLines
  • InvoiceLine : a Product, an Amount, a Cost Total
  • Product : Name, Description, CostPerUnit, Units, Photo

I’ve shown the relations in bold, where one item refers to another item.

 

Step 2 : Run the App

So you just click thru and define the ‘DataModel’ above, and then you can run the app and try it out immediately.

For this Builders Invoice datamodel, the app looks like this :

 

Screenshot from 2014-09-02 19:51:34

 

Screenshot from 2014-09-02 19:51:53

Screenshot from 2014-09-02 19:52:27

 

Quick and Iterative

The immediate feedback is really useful.  You can show a user, get them to try it and give feedback.  You can try out different models and see which fits their business better.

This iterative approach really helps to reduce risk and cost in developing an app.

 

Any Datamodel

We could have picked any domain and modeled it in the same way with CollabAPI.  Its not about Invoices .. its about making an app to fit your particular business : quickly and iteratively.

If your business finds it helpful to have a photo in each InvoiceLine, to give the customer more insight into the Job .. so be it.

When you business changes, you can change the datamodel to fit the new circumstance.

I hope you’ll agree, CollabAPI takes a pretty radical, and yet very practical approach.

gocanvas.com is great : you can create form apps for your business without programming.

Replacing paper with mobile touchscreen and having your data in the cloud is such a big win… BUT there are a couple of crucial missing pieces that are vital to business  :

  • more than one kind of thing !
  • relationships between things

 

The Problem

In real life and in business, there are a few different kinds of things, such as :

  • Customer
  • Address
  • Vehicle
  • Branch
  • Product
  • Invoice
  • Event
  • Group
  • Project
  • Property
  • Contract
  • Supplier
  • Shipment
  • Task

And these things have important relationships between them : A Customer may have several site Addresses.  A Job may have several different kinds of Checklist attached.  An Invoice will have several Products for each Job for a Customer .. and so it goes.

 

Relations

A good app [ mobile or otherwise ] will have a data-model that reflects the REALITY of your business, and it will be flexible enough to handle the relationships between the data items.

diagram_consult

This is the old-school database stuff they figured out in 1940, which has been the staple of business IT for the past 60 years – they call them ‘Relational’ databases for a reason.

These days we want more flexible data, there is the whole NoSQL movement, key-value stores, XML and JSON.  To model reality and business we need natural tree and graph structures, not everything is a table.  Just dont throw away the baby with the bathwater : we need relations.

If you don’t have Relations you cant do the fun stuff :

  • one to many [ Comment Wall can have many Posts ]
  • trees and heirarchies [ Deep Product Catalog, Organization chart ]
  • graphs and social networks [ facebook, linkedin, crm, sales ]
  • people interacting [ messaging ]

This lack of relationships is killer for IT departments – they cant run a retail business or a supply chain or a sales organisation or a manufacturing plant without this flexibility.  Its also killer for startups exploring new business models who need an app to manage their operations or customer needs accurately and in a flexible way.

 

The Solution : Relations

The solution is to have a tool that is great for making forms… but is also great for handling relations between different kinds of things.

We need some deeper engineering that allows you to link things together,  so you can build these kinds of real apps for business :

  • Product Catalog
  • Topic Wall with Comments
  • Invoices where you can select existing products, or add a new one
  • Jobs that can be assigned to different stakeholders
  • Flexible forms with multiple sub-clauses [ Property report with any number of rooms ]
  • Social Network features …

 

Its early days, but this part we got right from the start – CollabAPI does support relations.

This means we can create apps for real business scenarios :

  • a custom CRM
  • sales business social network
  • a manufacturing process workflow
  • a real-estate property management system

 CollabAPI Beta

If you’d like to be on the beta list to try CollabAPI App Builder tool for your business mobile app… get in touch.

The more Things and Relations your app has, the better !

gord

justgord at gmail dotcom

Havent posted for a good while.. been incredibly busy working on a side project which seems to have a life of its own.

Collabapi.com is not quite ready for release, but I’ve been using it to get real work done for a while.  Its basically a much quicker way to develop data centric apps.  This kind of app is useful for tracking all the information you need to run a business well – the stuff that goes on paper / word / excel forms.  It would be great if there was a quick way to make it mobile / web and have the data in electronic format from the get-go so you could search it more easily and so on.

Example App :  Gym Membership Sales Pipeline

We can start by making a form each for our Salespeople, and our potential Customers.  I configure up the data model in the App Designer for these, save those changes… then the app comes up on web and tablet straight away :

ca_quicksales_salesperson

ca_quicksales_customer_profile

I did this by configuring the fields, checkbox items etc, and the app reflects this ‘datamodel’  : 

ca_designer_quicksales_cust_profile

Apparently there’s a sales-cycle thing we want to keep track of -

  • initial contact
  • see if the customers interested
  • what are their goals
  • book a meeting
  • get them to signup
  • success! happiness! cash!

So here’s a go at modeling up a sales call…


ca_quicksales_sales_call

… hmm, promising and a good place to start, I can actually put that in front of the Gym Owner and her Chief Sales Maven, and they can try it out on the web or on their tablet device.

so.. collabapi.com

The point of this article is not to say ‘you can do apps real quick in Collabapi’ … which is kinda true.

The coolness is really just the way we can iterate and experiment : get something out there quickly and get the users to make suggestions.  

Its more of a GSD or MVP / lean-startup approach to making apps.  Its not just for business apps, but I think it will be really handy for business … putting the love back into the ‘small-data’ that’s important to most people.

I’ll talk a bit about the technology under the hood at some stage – and there is a lot of tech under the hood – but for now, that’s a good place to pause and have a cup of tea :]

cheers,  gord.

justgord at gmail dotcom

Just watched a really interesting documentary on the Flash Crash of 2010 :

Money & Speed: Inside the Black Box

Some stand-out points :
> CFTC / SEC attribute the root cause as Waddell & Reed ‘dumping’ $4.1bn shares
> Eric Hunsader @ Nanex looks at the W&R trades [ see video at 34m18s ]
> W&R trades don’t look like dumping, they maximize sell price during local up runs
> there are other trades that do look like aggressive dumping, ie. rapid sequential bursts down

The Nanex explanation of the Flash Crash : FlashCrashAnalysis

Price manipulation ?

This raises an interesting Question :

Is it possible for a black box algorithm to use a rational probabilistic strategy to drive down stock price in bursts like this, in order to later buy the stock at a very low artificially deflated price ?  You’d need a lot of stock to do this : is there a threshold of stock volume, say 5% of all stock, under which its impossible to create this effect ?

Price Delay Arbitrage ?

Another aspect of this, is the possibility to do ‘Diffusion Arbitrage’ for want of a better name :

If you can drive the market so quickly that derived instruments take seconds to reprice ( due to the storm of new data), then you have that window to trade ahead of the market in options or indexes based on the underlying you have manipulated.

In this case the delay was a whopping 5 to 35 seconds : see for example Nanex’s FlashCrashSummary , showing the delayed drop and recovery of the Dow.

Introduction

Tagninju is an ergonomic tag-centric Time and Cost tracking tool.

Its very simple to use and extremely flexible :

  • use keyword tags to organise and group entries
  • rather than type a long description, keep it terse, with tags
  • tags suggest : topic, person, subject, code, urgency, project, specifics
  • inbuilt auto clock timer with pause and continue
  • set todos into the future quickly
  • provides rapid insight into costs and time

Uses

TagNinju app is handy for :

  • gain real insight into your time usage [ procrastination or productivity ]
  • keep yourself motivated with objective progress notes
  • track progress towards a goal like weight loss, fitness, savings
  • budgeting : shopping list and track expenses quickly
  • track hours worked on jobs for freelancers and contractors
  • HTML5 local storage means works on mobile tablet or web

Story

I noticed a lot of time dissapeared on unimportant things, and my productivity and motivation was inconsistent. Some days I would feel motivated and get a lot done, other days Id languish and could not really recall what I spent time on or what goals had been achieved.

I looked for a good app, but the note takers were too general, and a spreadsheet was not easy to use on mobile, many time tracker systems were slow or overkill. Eventually I started working on a simple web app to do this. I added an automated timer clock, and this at least allowed me to note down tasks. I started off writing readable sentence notes, but migrated to a terse form with just keywords. I added a simple filter search and found that worked well : I could zoom into areas of interest by keyword, such as shopping or weight or fee or run or billable.

I gradually noticed a useful psychological side-effect of tracking my time : I wanted to get stuff done just so that I could note it down! Id catch myself thinking.. Hmm I havent put in any entries for exercise the last 2 days, I better do some situps or a run so I can put that in.
So actually noting things down had the effect of pushing me to get more good things done.
Theres a kind of objectivity, and also the effect of your motivated self observing your unmotivated self and kind of comparing the two.

I recently heard a talk by memory expert Josh Foer, about autopilot subconscious plateaus. This is where your activity matches your expectation set point at the OK level and so your conscious mind doesnt need to be engaged. We do this everyday for routine tasks, we perform them uncounsciously or rather subconsciously, on auto-pilot.

Autopilot is great for things we dont want to improve : washing dishes, shaving, driving to work.
For things we do want to improve, we need some way of making the activity stand out to our conscious minds so we can evaluate performance and goals and try a different strategy. Time tracking seems to help with this, it makes you review what youve just been doing.

Im not recommending tracking everything, in fact I think its good to decide to not track some areas, maybe the weekends or reading time in the evening. But it can give real insight and motivation for those areas we want to improve : lose weight, gain fitness, reduce cigarettes, study more effectively etc.

Tips

You might find these tips handy :

  • tap timer to pause the clock and restart it
  • tap and drag out from timer box to select a time period
  • use meaningful tags, use multiple tags
  • use quick filter search to zoom into that topic or area

Coming soon

These are some future features which might make Tagninju more useful :

  • sync between versions [ entries shared across devices : mobile, web and tablet ]
  • dropbox integration
  • csv import / export [ to and from spreadsheet ]
  • bar charts to show time and cost spent by tag
  • shared groups

Some of these features will be more useful to professionals, small business founders and freelancers and will be released as part of the upcoming paid version : TagNinju Pro.

Suggestions

Im interested to see how people use TagNinju for tracking time and cost, for achieving goals and personal growth.

Please do email me with your suggestions and feedback at justgord@gmail.com

Guest post by my son, after a wee bit of prompting from dad to make a diagram and work it out :

 

GridmathsExponentsCropped

So I thought about how well Angel Investors and Startups mesh and ‘hook-up’ :

I think the whole space of Angel Investing is ripe for disruption.. I think we’re sitting in a local minimum, when there is a much more optimal way to do this.

From the Investor side : Paul Graham observes that YCombinator backs a group of good founders, knowing its high risk and that one or two in the group will succeed wildly and pay back the others who will grow modestly or fail..and there is no way to know which one that will be.

From the startups point of view : Crowd-funding via IndieGogo and KickStarter are probably a much more accessible way to get that initial funding to develop an MVP, do market validation and launch. The TIME overhead for a startup to find a good angel investor is likely not worth it in many cases.

Most investors want to invest at vastly larger amounts than early stage startups need. Its an impedance mismatch that prevents deal flow for both sides.

So I think we will move in the next one or two years to a crowd-sourced angel investment model that’s something like this :

- social website for startups to present, like Kickstarter
– first 30 investors fund at say $2000 per 1% equity
– standard terms : legal agreement, company setup
– platform takes admin costs of say 5% to 15%
– platform assists discussion for mentoring, progress, milestones, further rounds

AngelList is already doing something like this, but it needs to be even simpler and cheaper in time cost to participate.

As an entrepreneur I see just this huge mismatch between the investors on the Buy side and startups on the Sell side. But this problem is solvable : it has been addressed before in the case of farmers selling corn or hogs and buying barrels of oil. The solution is to make a market with standard terms and open it up so people can trade more efficiently.

Facts back up this assertion – there are so many startup hubs popping up everywhere to fill this gap and impedance match between money and startups … but I think we need to go further and standardize that into an open platform.

This is not just an idea for me.. I have skin in the game. I believe my own startup GridMaths.com has potential to be of great social good in helping students learn Math in a deeper more visual way, and I believe it can do this and make orders of magnitude more money back for investors.

I’d like to think some benevolent Aunt in Utah who has saved her pennies could back a company that helps her niece improve her Math : if she has 5$ to buy the app she can do that, if she has $5000 or $50000 and wants to take a stake in the company to make it great, there should be a way for her to do that too. But at the moment, she cant do that directly.. she would have to wait until everything is set in concrete 10 years down the track, when the innovation is all but over and the company has 500 staff and launches an IPO.

Capitalism needs to evolve, to become fine grained, and with that change our economies will become more stable and less brittle in the process.

This could be a way to disperse the large amounts of cash waiting to invest, and at the same time bring the Angels back to Angel Investing.

I get the feeling a lot of people are surprised when they find out you can _understand_ math.. it isn’t just a series of random facts and some Rube Goldberg machinery.

I think this problem must start quite early in school, and get enforced so often it becomes a belief system.   For example its rare that the distributive rule is related to areas of rectangles.. but that’s such a good visual explanation, it should be the default way of introducing the idea :

gridmaths_024

After a couple of these diagrams you can mention it works for any rectangle with sides of length a+b and c+d , namely :  (a+b)(c+d)=ac+ad+bc+bd.

Maybe with tablet computers we can make Math more intuitive,  when good visualizations can be seen by most students.

I wonder if teachers are so constrained to teach the points of the curriculum, handle admin tasks and control the class, that there is no time left for cultivating Math ‘understanding’ ?  But surely its faster to learn / teach by understanding?

If you never get that little rush of endorphin from understanding, I could see how Math would be very boring and random.. because its not really math then, its something else ( and that’s not good, is it Precious?   Not at all.. no it isn’t.. Precioussss… hmm… ghollum ! )

Follow

Get every new post delivered to your Inbox.

Join 31 other followers