Data entry is a pain I’ve written about more than once. Yes, it’s monotonous. Yes, it’s tedious. Yes, it’s prone to human error. Still, sometimes, it’s a necessity. How else are you going to get data into your databases if someone doesn’t enter it?
Remember that game of TELEPHONE? You’d sit in a line with other kids – the first kid would whisper a sentence to the second kid. Only one time – that’s all you got. The second kid would look a little puzzled, obviously not quite sure about what they heard, but would turn to the third kid and repeat the whisper. On an on this would go, until you got to the end of the line. That poor kid at the end now had to say what they heard – ALOUD – and of course it was nothing like the original sentence.
The free version of Airtable is perhaps one of the best “freemium” softwares that I’ve ever used. In the free version, you get unlimited access to bases, a large number of records per base (1,200), access to all views, collaboration/commenting, etc. In truth, the free version unlocks about 90% of the software’s capabilities. That’s not shabby.
Getting organized is a critical part of business – and a huge part of that is developing and improving business procedures, commonly referred to as workflows.
The first time you stare at hundreds (if not thousands) of records of data, it’s easy to fall into the trap of thinking that data is overwhelming and messy. Thanks to Airtable’s views however, that doesn’t have to be the case.
For people new to databases, learning the ropes can seem overwhelming. But as is often the case, great strides can be made by breaking down information into smaller, more easily digestible pieces.
‘Linking tables’ is one of those very critical pieces – at least, this is what it’s called in Airtable. The more common term within databases is ‘building relationships.’ Relationships are those connections that link data in one place (table) to data in another place (table).