![]() It is possible to create many different views of the same data, which lets you build different productive dashboards for your work. In Grist, select a contact to see contact info and related interactions in one layout. In Airtable, related records pop up one at a time in a card. In Grist, you determine how to pull up data, in part or whole, and whether it’s a card or table. In Airtable related records pop-up in a card as a quick reference to related information. That data wrangling is always a little different, but we start with making sure there’s an available field and sometimes we work with a software vendor to extend the schema of the data they track to accommodate for what we might have in Airtable if possible – or choose to repurpose data into other fields.Both Grist and Airtable make it possible to relate records across different tables. Once done, the data is imported and magically appears in another tool. Sometimes this is just changing the order of columns, or renaming columns so the data conforms to a specific template. Those are just some examples but it’s much more common that we’ll be conforming the data into a specific format so it can be imported into another tool, like a custom software solution. Tag data with one of the supplied tags in a training file:.Assign a polarity score to the sentiment of the text in a given column:.For example, this project will look up an IP address we might have in Airtable and provide a geolocation: or this project or the following are used to perform various machine learning tasks on those files: I’ve built a few for specific use cases I’ve had. We can then take the csv files and enrich them, edit them, etc. The export excludes any raw data that’s been filtered out, so use the filtering options in Airtable to constrain what’s being exported.Dragging objects between Kanban boards doesn’t export with the csv.The order they appear in when using Airtable is the order they will appear in the csv. ![]() Files can then be manipulated easily and imported into other tools. ![]() This is where the power of having that data in centralized repository comes into play. The files will open in most standard spreadsheet tools but specifically in the default tool to handle csv files (usually Excel on Windows or Numbers on a Mac). Repeat that process for each tab to get all the data in separate file. csv file will then download and appear in your Downloads directory. Simply open the sheet and click on the ellipses icon in the top bar.įrom here, click on “Download CSV”. To export data from Airtable, we’ll repeat a very simple task on each of the grids (or sheets if it were Excel). And when this happens, it’s time to grab our data out of that Airtable Workspace. With the Page Designer we can actually make Airtable start resembling a web app.īut, as with that inventory tracking system we outgrew in VisiCalc, there’s definitely a point where we’ve taken any tool like this to its limit and we need a custom database, SaaS tool, or some other more advanced solution. We can use it like a Kanban board, make blocks in a single sheet, pivot tables, translations, and do much more. Then along game Google Sheets and suddenly we could interact with data online concurrently. We have sheets instead of tables and we have a grid of objects that visually at least looks very much like a database. ![]() In those cases, Excel is kinda’ like a simple database. ![]() And a lot of software can end up really just being a database with little actions or transforms to data. We like to overcomplicate what software does in our brains, but that’s the gist. If we’re interacting with operating system APIs, then that database might be in registry hives (Windows) or defaults domains (Mac). The thing I like about Airtable is that a lot of software – in fact most software, is a database, logic that puts data into the database and takes things out of the database, and then actions based on the data. It’s a little more than that and it’s been kinda’ cool to watch Airtable mature. I have to say that when I first saw Airtable I thought, oh look – Excel online. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |