Show and Tell

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.)

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.

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

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.

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 Monda

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 ca

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

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 sep

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 ha

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

Can anyone share any social media templates?