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
I’ve created an Airtable to share with a large global research community working on fake news (https://airtable.com/shrhv3Vlezp7oOZIZ) and wondering if there are any tips out there for how to make this: More easy to navigate / accessible for people who are new to Airtable? Foster collaboration? would love to have other people add records to this as well, but a little worried about making it a completely open/editable database. Thanks! :slightly_smiling_face:
Is Airtable capable of creating a table-view is this? Basically, I’m trying to track 8 episodes through various stages of my editorial process. I want to record when each of its milestones happens (rough cut, notes received, fine cut, etc etc). But I also want to see the status of every episode at the same time. So basically each point within the table would be its own database record B7, B9, C7, C9 etc… Kindly let me know if a followup explanation is needed. Thank you in advance,
need help setting up an inventory database. Anyone interested in the job??
An intro : A few days ago, working on one of my bases (dedicated to my pets), I requested some help to know if there was a way to track down, within Airtable, the Opening and Closing times of stores (or whatever opens and closes at some point), as the {Date} fields and {Duration} fields actually don’t allow an easy solution :thinking: . Well, fortunately, W_Vann_Hall gave me a nice perfectly working solution for which I’m still very thankful :slightly_smiling_face: :thumbs_up: , put everything in a demo base Airtable - :clock8: Business Hours demo so I could see how it looked and gave me all the explanations so I could understand how it works. I was well served! :winking_face: The only tiny problem was that I needed to track down mid-day closing and opening times too :face_without_mouth: . (From where I am, there are lots of stores that close at mid-day) It took me quite a while, a lot of thinking :thinking: and testing and a lot of coffee :coffee: , but today, I finally
I recorded this video of a system I built using Airtable, Lob, and Zapier for automating & managing physical mail campaigns. I hope it is useful to anyone who is interested in using Airtable to manage this type of business workflow!
I love Airtable, but its not perfect. I also love Zapier. I wrote a blog post about how to combine the 2 to overcome a shortcoming of airtable: Medium – 30 Mar 18 Airtable Dynamic URL to Attachment Using Zapier – Dan (Danny) Fellars – Medium Today’s zap includes just 1 solution: Airtable. Airtable is quickly becoming my new best friend. However, its not perfect. I wanted to… Reading time: 3 min read Enjoy!
Hi, I’m learning to use the new Maps block and would like to be able to add a track from a GPX file to my Map block. Is this possible? Thanks!
In a recent reply to a post in Support, I set out a step-by-step process to create a table intended to drive an Airtable Chart Block bargraph, based upon the multi-record calculation routines I described earlier. In this case, the routines are not used to access values across multiple records; instead, they drive the population of a third table, allowing for the date and value from the previous X number of entries to be charted. At each new record from the [Main] table is added, the Xth value is dropped, the remaining values are moved up one position each, and the current day and value displayed as the most recent. Aside from linking each newly added [Main] record to [Calc] — a task that adds two mouseclicks to the record creation process and that may easily be automated using Zapier or equivalent middleware — once implemented, the routine should require no additional maintenance for nearly twenty years. Again, the reply describing the steps needed to implement the chart is here; the i
I work for a consulting company called Optimi. In our work, we’ve seen plenty of folks (especially small businesses) who don’t have the financial information they need when they’re making critical decisions. Here’s how we used Airtable to solve this problem: Medium – 26 Mar 18 Showcase: how we use Airtable to enable financial decision making Hi! Rupert here from Optimi, writing again about our work with Enspiral Dev Academy (see previous blog post here). Enspiral Dev Academy is… Reading time: 5 min read Would love to hear any comments or feedback on this story :slightly_smiling_face:
Hi! A little while ago, I pulled information from a baker’s dozen rankings of episodes from the first four seasons of Black Mirror, Charlie Brooker’s dystopian look at technology and society, produced originally by Channel 4 and later by Netflix. I had been amused by there being general critical consensus as to the series’ high quality but absolutely no agreement as to the merit of individual episodes. I thought by gathering the data into one base and subjecting them to various analyses I might be able to identify trends or commonalities not apparent at first glance. Nope: They don’t exist — or, if they do, they are still too subtle for my ham-handed processes to identify. Accordingly, I followed the time-honored tradition of less-than-scrupulous researchers everywhere: If the data are inconclusive, change the goals. I had been looking for a project with which to test Airtables new Blocks feature, still in beta test at the time. If I couldn’t use Airtable to identify previously hidden
The link below is to a base I developed for tracking medical expenses. It can track expenses for any number of patients, medical services, and providers. The base allows the recording of charges, insurance amounts (disallowed and allowed), deductibles, co-insurance and co-pay amounts. It also can track amounts paid by insurance to the provider and to the insured, as well as payments made in settlement of bills from providers. There is a main Medical Expenses table and additional Patient, Service, and Provider tables. Each field has a description of what it is for, and there are several different views of the main Medical Expenses table. Of course, the sample data in the base is just that and is intended to show the various types of entries that can be necessary in recording expenses, insurance rulings, and personal payments. Copying the base is enabled on this read-only link. I hope that some will find it useful. Medical Expense Tracking Van Zeck
I need to change the ‘description’ associated with my account userid, but haven’t been able to find where to do it. Where might I look?
Yup, you just need to create a calendar view, share the calendar, copy the ical and then suscribe to this calendar with mac calendar, outlook calendar or google calendar. On the local calendar you can add “1 minute before” reminders. Working amazing for me and i can do “time blocking” with that :grinning_face_with_big_eyes: REMEMBER! You need to add start and end time to every task. I fucking loooooove airtable, can anybody send me some stickers here? i need to share the love (and take out the trello)
Check this out: https://airtable.com/shrzfQcmUqy92gkPi I’ve always wanted to journal daily but felt like I didn’t have the time to do it. However, whenever I do find old emails to friends, they transport me back into moments I’d long forgotten. So, I’m trying an experiment. What if I record my feelings during the day and occasionally add notes that will give my future self context? And what if I only select one of 5 emojis for my feelings - glad, sad, mad, embarrassed, bored, or afraid? Will I make this a daily habit with such a low threshold of commitment? And to make it easier, what if I automatically record the time, date, and weather? Will that give me more context in the future, without extra data entry work? If you copy this base and make it your own, let me know!
Late last week, I published v 1.00 of my Wardrobe Manager base, with an update submitted this past Monday. Descended from an earlier project intended to inventory the 1,200+ items in a local photo/video studio’s collection, this version has been tailored for the individual who wants or needs a more structured approach to managing his or her wardrobe. Where my bases have more often tended to be a tactical solution for an immediate problem, Wardrobe Manager is my first attempt at writing an application in Airtable. As a result, it includes more robust error-checking and alerting capabilities, better supports customization and expansion, and is more thoroughly documented than my earlier efforts. (A standalone [documentation] table within the base contains five separate guides featuring, as of v. 1.01, some 80 pages of documentation.) Screenshots Supported Functionality The system provides Database of clothing items. Wardrobe Manager supports – but does not require – an extremely deta
Hi AirTable Users! AirTable is a fantastic tool that can be used in so many different ways, just like any out-of-the-shelf-spreadsheet-toosl, but easy, and in even more ways, especially when you are online! So for all BI developers out there, targeting all Qlik Sense Developers - I have find a way to integrate AirTable with Qlik Sense - I¨m sure it is possible to do also with other BI tools…such as Power BI and Tableau, as long as they are web-based. Example. Inside the Qlik Sense App in a simple Widget, you can embed a AirTable Form, allowing Qlik Sense Users to give feedback into an AirTable database. Then, you can load this feedback back into the Sense application presenting the overall feedback. The complete concept without ant coding or paid licenses! Amazing! The solution can also be used for Budget-processing, or any kind of solution where a Qlik user must be able to give back Data for further processing. Link to part 1 of 3 on my blog post on how to do this. //Robert
I’ve been using Airtable for a while now on a limited basis. I really want to deploy to my entire company as a project management tool (one base with tables for Clients, Departments, Projects, Tasks, Notes, Events, etc), but two key features are missing for me: A Dashboard- What I’d like is a kind of “me view” that any user can use as a home page for the base… it would automatically display (in some simple grid/block form) everything related to a given collaborator… every client, project task, message, etc, that they are associated with… with clickable links to the actual record in Airtable. This is far more than a custom Airtable “View”, because it involves data from more than one table. A Reporting Tool - Basically, we need to be able to (at a moment’s notice) generate a printable project status report from a given Airtable view (a grid/spreadsheet-style view of dozens of projects, ideally with page headers/footers, numbered rows, labeled columns, and all the other features you’d
I don’t have a sales background and I’m thinking this must exist already and I am probably reinventing the wheel. . . I need my table to track when and how I contacted each prospect so that I can see at a glance when I have made contact with someone, and when I should follow up and how I should follow up and notes about each connection. I am hoping to find examples that do something like this. . . . Thanks!
I have just published the latest in my blog series about using Airtable combined with other Apps to handle specific business needs. In this post, I am exploring the use of Process Street, a tool for creating template based Checklists for making repeatable procedures, with Airtable. It provides an interesting option when you need people who you don’t want to access your bases directly, to have a means to interact with data in a structured manner. You can read more: Automating Processes with Airtable and Process Street
This week I nested an IF function three layers deep. It was hard to read and hard to write. There must be a better way, I thought. I read some articles that said to avoid nested IFs using AND / OR. Then I watched this video on how to use it: Bingo! Now I feel empowered to get even fancier with my formulas (if I need to) because I have these additional functions.
I need to calculate summary weighted averages - for example the weighted average interest rate for a number of loans that are records in a loan table. The summary bar is very limited and you cannot create any calculated fields there that I can see. e.g. Loan Amt Rate $100 5% $150 3% $600 9% The weighted average interest rate is: ( (100*.05) + (150*.03) + (600*.09) ) / (100 + 150 + 600) = .07 = 7% Any ideas as to how i can do this?
I’m looking for a solution within a form to inserat data into the database. Each data has separated fields for billing and delivery address. But sometimes they are equal, and it would be much easier to just set a checkbox if theses addresses are the same. If not, there should appear all the fields in the form to enter a different address for the delivery. Can anyone help me or show me a case where a form is done like that? thanx a lot.
I’ve just written a blog post which some people may find interesting on the topic of sending Email (or other) alerts from Airtable using Scheduled Zapier Zaps. If you’re interested check it out: Sending Notifications from Airtable I’d welcome any thoughts and comments!
I’ve noticed there have been some posts recently about Scripts for Airtable - for coders wanting a way to build clickable actions on top of airtable. I thought it might be a good idea to write an article for the non coders amongst us who may have similar needs - and it turns out that this is possible using Zapier (when Airtable is used in the Google Chrome browser). I’ve written an an article in my blog about how to configure a “Push Zap” to send an email to an employee (using my KasPer Lite base in the Universe) letting them know how much holiday (vacation) they have remaining in the current year - and also updating the Activities table in the base to record that the email was sent. You can find a link to the article here: Using Push Zaps
I’m revealing a basic hole in my failed upbringing, but I could really remedial training on ARRAYs . I’ve looked at the formula documentation but … And, I’ve looked at the AT Community, but … So, I’m pretty sure that ARRAYS are useful and solve problems that I’m bound to have, or do have and don’t recognize the obvious solution. So, any pointers to entry-level training with lots of examples, documentation or videos will surely correct my personal shortcomings in this area.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.