The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
Any lucky beta tester around? I would love to hear about the cool new features that are being tested.
Hello, I am hoping someone can help me. I have a simple Table that lists my customers, City, Postal Code. What I would like to do is create another table that can list all the Cities and Total the number of customers in each city. Thank you all for any help.
I am really proud to show you R750Exporer: https://r750explorer.me (German) About the App The App is a combination of treasure hunt (German: Schnitzeljagd) and geocaching for the city Radolfzell near Lake Constance. Radolfzell celebrates currently to be 750 years old. Some locations will be shown in a Google Map with additional historic information from city archive. If you reached the location, you could unlock questions by code. These codes are located on stickers at the locations. Giving correct answers, you could then reach the high score and win some cool items from our sponsors. How is it done During one week, we have developed with 10 youngsters (no IT skills, 14 - 18 years) supported by our IT apprentices this Java based app. We have done it in “an agile way” creating userstories, paper mockups and some (flexible) sprints. from Zero to 100% in five days! Starting on Monday we managed relaxed go-Live on Friday. Technology We decided to prefer Java to be more typesafe. It was eas
New to Airtable. Enjoying it so far. Working on a table to match People (skills & interests) with available Projects (skills needed & different clients/topics). Any lessons/best practices learned out there? Cheers
Apologies if this has been posted before but I need to generate a ‘sexy’ appearance for my meeting details. The table layout is too much detail and spread too widely, the Calendar is fine for previewing dates, but the expanded (extended?) view you get is too Duplo - fields are too tall, so lots of scrolling for detail. Setting up a Form or a Kanban View has the same problem - the Form view is back to Duplo style, and the Kanban involves too much scrolling. I just want: Title Venue picture Venue location Date (and, ideally duration - ie start and finish times) URLs for Web Facebook and Twitter links Contact details Other details like cost and timings -All set out closely -but legibly- together like an address label or a ‘for sale’ block in a newspaper. No editing options required - this would be display only, driven by entries from other views. This is just to set out a catalogue of what’s on offer, and allow folks to sign up if they’re interested. Has anyone achieved a ‘st
Wanted to share that my crew has found success wrapping Airtable forms in an Automator web pop-up. We use it for Creative Requests, and have added a custom icon, pushing the app to all Requestor’s docks. ChrisWrites.com – 29 Jun 12 Turn Any Website into an App with Automator - ChrisWrites.com Mac OS X makes it possible to launch webpages as standalone apps from Finder without the need to open Safari. This can be quite handy to get to websites quickly and does away with the usual Safari controls for bookmarking and entering web addresses.... A.
From time to time I find myself moderating brainstorming sessions, and have been experimenting with the K-J technique. In most cases I have participants who are remote and therefore cannot use sticky notes. I have tried several experiments using Trello, but the limited voting capabilities and the need for authentication to do anything other than add comments is a showstopper. A fair fraction of the participants either won’t create an account, or find it too daunting to add cards. The ability to easily create forms that don’t require authentication is a huge boon for this. Furthermore, with a little gymnastics with formulae and counting, it’s possible to create interesting voting schemes: e.g. 3 points for your highest priority, 2 for the second, 1 for the third. Here is a simple example, with three separate forms. First, for participants to enter their names. Second, for them to enter answers to the focus question. Third, after discussion and creation of categories of answers, for them
I made a diagram explaining to myself what the capabilities of airtable are relative to whatever task I’m doing. And how airtable fits in the larger grand schemes of data management principles and heavy-data processing based tasks I ended up modifying it slightly gitpush / gitpull is just my abbreviations for subversion-control-push and subversion-control-pull
Recently, we created a custom Vue.js web app for a national retail chain to use for internal management walks. Here are some of the features we included: Two fields (store number, date) act as a kind of key and after they are entered, the form fetches existing records that match those keys. If no record exists, it creates a record. Dropzone.js for uploading pictures and integrating with the camera on a phone/tablet. Star ratings fields. Email a read only view of the record using a field. Simple navigation I don’t want to share the link to the forms on here, but there has to be other companies interested in custom airtable forms and views for their business. If you would like a look contact me via rowandtable.com
I use airtable mostly as a product database + putting purchase orders to my vendor overseas. Each vendor uses their own weird excel cataloging system (Everyone in China does this), so I use airtable instead to send my own unique database of products in PDF format I don’t want to bother letting them know what my airtable system is and want to keep things simple This is how I control document workflows for letting my vendor overseas changes on my end: Make the relational database schema with all the items in there Add quantities to those items Create a specific view for those product items (Product SKU, Description, Image, and Quantity) Print it out using CutePDF printer (makes the adobe PDF) run OCR recognition on the PDF too Modify in AdobeAcrobat if needed Send file to vendor Whenever I have to revise the PO to resend back out to the vendor (e.g. quantity numbers change, or I have to revise my order to reflect the current container number I am putting my products through) I do the
Hello! this is my first post on this airtable forum. Its only been a few days since I’ve used this software, but I am finding so many applications I can use from this program. I’ve only touched the surface of what I can do so far though One important thing for me, at least, is taking revision logs of things I change overtime when I build my database schemas / naming conventions I tend to add many notes describing each column of data I am using. But more specifically, I like embedding image links so I can add more complex data in my field description, including but not limited to schema designs Here’s a sample gif of what I am talking about, using the “Product&Catalog Orders Template” Naturally, I will put database schema design templates or NamingConventions in these notes. Since I want my column name values to be ideally short for visibility purposes, but my description to be as long as possible to explain any logic behind what data should be populated in those cells, and their c
Can anyone share any social media templates?
From 2007 until around 2011 I was the Director of Operations for the Destiny Search Project of which I was also a Founder. The original Destiny Search Project was formed in 2007 after the disappearance and search for missing Destiny Norton in Salt Lake City, Utah. In 2008 the group was organized into a Non-Profit and operated for several years. This included searches for Camille Cleverley, Hser Ner Moo, Susan Powell and others. Unfortunately with the departure of some of the board of directors operations came to a close. For some time, it was hoped to bring back the project and improve upon it, and make it available nationwide. At one time an open source software project was even started but it also ended when the primary operations had been ended. Now several years later, and with new technology and online tools available the hope that Destiny Search Project could allow for community volunteer based organized searches for missing person can now be realized. The goal of this new projec
This is the Job Search database that I extended to include: applications, companies, positions, contacts and activities. I recently found a new job using this database. The main areas I would like to improve, but don’t see a way to do so yet in Airtable: 1) Auto-populate a position when I get a hit on an application, 2) auto-select and/or auto populate the company when I select a position or contact, 3) restrict the list of linked rows to just the rows that are a match for that company / position. But aside from having to do a bit of extra work (to keep the company and contact fields populated) it worked great. https://secure.gooddata.com/reportWidget.html#project=/gdc/projects/bv476s1u3u4agy2lib60h8opnbiv9btg&report=/gdc/md/bv476s1u3u4agy2lib60h8opnbiv9btg/obj/3396&title=yes&transparentBackground=yes
I am a part-time social dance teacher and also work as an IT support person in two private companies working in dance teaching business. Some months ago I got a task from my boss - to build an application for scoring, to be used in a dance competition. The competition in question is a peculiar one: you see, in a normal dance competition, there are fixed couples dancing, and nominated judges give the scores. All existing scoring apps are build around this hypothesis. Ours was different however: it was based on peer review, ie. every leader danced with every follower and the dancers gave scores for each other. No existing application bends to this peculiar case, so I needed to build one from scratch. I also needed to make my application an online one, so at first I thought about SQLite + PHP. Then I ran into Airtable and thought, well this might actually have great potential. And it did! It didn’t take long to have the basic setup, and I must say the Views for a table helped me immen
:red_circle: :radio_button: :large_blue_circle: :white_circle: :black_circle: :o: :fire: :green_heart: :purple_heart: :yellow_heart: These simple emoji are enough to make certain records or fields stand out.
Airtable has worked so well on student side of the school I work for, that I’m making a major leap into using it for our marketing activities. Which activities? All of them: Project Management Publishing Calendar Partner CRM Vendor Contacts Media Hit Database Collateral Management Campaign Results Swipe File and Event Planning It makes sense for all of this to be in one database, not spread across a half dozen applications. There are products that attempt to do this, but they cost $$$ a month and often trade functionality for usability.
I would be interested to know whether there is a possibility to synchronize between two versions of a base. My use-case is as follows: I would like to have a stable RELASE version of a base to which users have access through the API (with a defined API key). At the same time I would like to have the possibility to modify/extend a copy of that RELEASE version (let’s call it WORKING_COPY) and once this copy has reached a certain status it shall again be used as the new RELEASE version with the unchanged API key. I found it easy to duplicate a base in order to e.g. work on that duplicate as the WORKING_COPY but I don’t see a possibility to bring back those changes to the originating base (with the defined API key). Is there a way of achieving this or are there alternate solutions for my use case? Thank you, Stefan
If you run a Wordpress website and you want to be able to easily pull data from Airtable into Wordpress, this is for you. Airfields is a Wordpress plugin I’ve built that allows data from Airtable to be accessed using Wordpress’ get_post_meta and get_post_custom functions. There is also a shortcode you can use in the post editor that will output the value of whatever Airtable field you specify. The way it works is that in the Airfields admin settings you will provide (App ID, API Key and) the name of an Airtable table and a field from that table in which either the post slug or the post ID will be stored. Then, any posts that match will have its custom data populated from the fields of the corresponding record from Airtable. This works with pages, posts, and any custom post type and can be used to display any field type Airtable supports. This should be considered a beta. If you’re a Wordpress plugin developer interested in helping develop this plugin, let me know. And if you’re interes
I was playing around with rollups today and couldn’t quite get or to work like I thought it should. Even worse I couldn’t find examples of how others are using it. An examples, real or made up? Thanks!
I write knitting patterns, they had to be tested - if everything is correct or not. So I have tests - for every pattern. I collect data as volunteers, yarn used, if finished, etc. I have testers - because some people joins to more tests. I want to keep their email address here, know in which tests they knitted and how. So I would like to rate them - did the finish in time, sent the survey back, etc. I don’t see, how I should connect all this data together. How it works now: I have a Google doc, one table for all tests, with the data mentioned before. And I have an other table: rows are testers and columns are the tests, I give a “note” for them. I hope this can be understand :slightly_smiling_face:
Many of my tasks have a bunch of quick jobs to tick off. They’re not worthy of being a separate task. So far I’ve resorted to just writing them down in the notes cell as a sort of bulleted list. Is there a way to turn them into a proper checklist? Perhaps zapier or some other work around?
This: http://www.fakenamegenerator.com/order.php Use that free service to seed data into your base. A few uses: Test workflows and Airtable features without mucking up your real data Sell a boss or train a co-worker on Airtable. I find that just showing my people how Airtable works was better than describing its potential Get Airtable support without giving them access to your real data
Would anyone like to share some of their database templates they have created? I am very interested in seeing how others are using airtable especially for customer information tracking and small business records. Thanks!
“This is the next big thing” That’s what one of our instructors literally said. And her job is to teach database design! My marketing coordinator is raving about it, and my admissions officer is already evangelizing it around the company. The biggest draw so far? The app and how it displays records, and how easy it is to add a new field. As the guy who has to choose which software we adopt, my sole criteria for buying an app is will everyone use it. Adoption is the problem that keeps me up at night. So far Airtable has cleared that bar.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.