Show and Tell

It always surprises me when professed experts are unable to truly understand a market’s topology. How is it possible to claim to track the no-code sector with the list of tools and services referenced in this article? Seriously (trends.vc)!?! These are the “no-code players”? I can think of one that’s missing - rhymes with fair-label. :winking_face: Carrd Webflow Bildr Adalo Glide Softr Bubble Sharetribe Buildbox The market is clearly made of some very serious players from Airtable (of course) to Google Tables and waypoints at Microsoft Lists and even Amazon Honeycode. Airtable still dominates this movement but that could change if its technology leadership voice is weak. BuiltOnAir is probably the closest Airtable has to a pronounced and definitive content resource for its no-code thought-leadership. Thoughts? trends.vc Trends #0033 — No-Code

Base -> HTML -> PDF This “show and tell” is based on a project I worked on for the Computer Museum of America (see this post: TimeLine of Computer History). Airtable Pro plans can make use of the Page Designer block, but if you don’t have a Pro plan or want something that is a bit more customisable, then this might work for you. Really, this is about outputting base data into a PDF, but uses HTML as an interim step. The benefit of HTML is that is hugely customisable and, by using CSS, you can pick from a huge range of colours, fonts, layouts and so on. Possible use cases for this might include product catalogues, invoices, brochures, data reports and so on. Or even large format wall displays 100ft long :slightly_smiling_face: The code I used in the CMOA project was very specific to that piece of work, so this is a more generic way to get similar results, with a number of code improvements added along the way. You can find the code in this repo: GitHub jo

Hi Airtable lovers! :rocket: I wanted to share a personal project I’ve been working on :slightly_smiling_face: I started my Youtube channel because I want to help more people build (and more importantly, UNDERSTAND) nocode databases because I know how challenging it can be to get started. The first tutorial series is on building a great CRM. Here’s the channel: https://www.youtube.com/airopsconsulting Here’s the most recent video: https://youtu.be/exIYtS4EdFA This video is great if you want to learn about how to link tables within your base and why using views is so important! Thanks!

Would love to share with the community here a UserStyle that modifies the display of Airtable’s Kanban view to make better use of available space and simplify the cards UI. It also applies thin scrollbars all over airtable.com (this block may be removed) and modifies a collaborator field with the title “Action of”, if it exists. Don’t get me wrong, the Airtable team is doing a great job, but the chrome is a bit on the heavy side with all those borders. Several design choices are “embedded” within the implementation, therefore impossible to modify. See here for the UserStyle and instructions on how to use it: https://github.com/Arty2/userstyles#airtablecom-neat-kanban

So I typically input the data from my excel and copy past it here. But many of my records look weird, and i have to manually fix them. How can I Avoid this problem ? in the scrreen shot only the partial name shows up.

UPDATE 09/05/2020 - The new “updated record” trigger for automations makes this workaround unnecessary (more notes in a comment farther down in this thread), but I’ll leave the thread here anyway. Using Airtable’s new (but still technically in beta for Pro-plan users and up at the time I’m writing this) automation features, how can an automation pick up all changes to a field? It wouldn’t be a new record trigger, and the only other option right now is a new record in a view. If the field in question was simply going from empty to not-empty, the triggering view—and any connected automation—would pick it up after the first few characters, and wouldn’t operate on the full contents because the record would need to leave the view and re-enter it again to re-trigger the automation. So how can a lengthy change to a single field re-trigger an automation multiple times so that its full contents are processed? As with many things, it’s a matter of time. In the early days of Airtable’s automatio

This is either an awfully clever work-around for Airtable’s limitations on data lookup or an incredibly convoluted method to achieve something that can easily be managed within Airtable itself, had I not overlooked something basic. You tell me… On my current project, my main table tracks items currently within a collection. An item may currently be onsite or in one of several offsite conditions – for instance, on loan, on lease, gifted, sold, lost, out for cleaning, or out for repair. The total number of on- and offsite statuses is fewer than 10. An item may pass through any number of statuses, but it can only be in one status at a time. As I chewed my way through the base design, I quickly realized there was substantial overlap among data required to track offsite status: Who had the item, the date the item went offsite, the date it was due back (if applicable), the date it actually returned, and so on. I created an outRecord table to log each status change for an item, with a one-to-

Here is a demo of a script that I am working on. This script creates a new record and all associated linked records in other tables. Default values are set in a “template” record, not hard coded into the script “Smart” defaults can be calculated values, such as the current date New linked records are created, including multiple levels of links Changing the defaults or linked records requires no editing of code Multiple templates are possible Some notes: Initial table/view/template can be hard-coded if desired to speed up data entry. Minor design changes to the base are required for some functionality (mostly creating new formula fields). The script only adds new records; it does not alter any existing records. I am not releasing this script yet, as I still want to tweak some aspects. The script is also extremely long and represents many, many hours of work. I look forward to hearing what people think of this script. If you are interested in

I am new to JavaScript, and one of the reasons why I took learning it to use it on airtable. Often I need to sum, count and averages of values in a table and hold the value in a block for a while for others to see. This can be done using existing blocks but one each for sum, count and average - which is tedious. This script makes life easier in such cases. It lets user select the field and table, and even filter conditions before summing, counting and averaging them. I am planning to add error handling. and warnings to this soon. GitHub link is here: https://github.com/indrex/airtablesum

I am using AT for our CRM and database for our company. So we are able to link financials to the customers and marketing reps commissions. The more I play with AT the more I see it has amazing capabilities. I am a visionary and have some cool ideas on how to use it further but would like to see if there are other users interested in having a ZOOM call or other medium to further explore the idea. We are also in the process of using it for our HR process by using digital forms. Below is a link to a form for those interested in joining the group. https://airtable.com/shrlVF9kevgnyaqrT

I’ve recently started using Airtable to cut down on the number of spreadsheets that don’t talk to each other, and loving the improvements we have made so far. One of the struggles was not being able to use a lot of features due to dates and times being in seperate columns in all our other documents, and wasn’t able to find other community posts solving this in a simple way. After a few weeks of messing about, I finally found the DATEADD formula is the simplest: DATEADD({Date},{Start Time},‘seconds’) I use a similar formula to calculate the end times. I can now use all the lovely DATETIME formulas I’ve been excited to try out without having to do manual input, which was the goal all along. Has anyone else had to discover this themselves? Any other workarounds people have created?

EDIT: Updated to incorporate solution for batching more than 50 records Why this script I import transaction records into Airtable from my bank on a regular basis via CSV files. Those transaction records have names that are pretty ugly most of the time (like [Amazon.com*6X6AN17G3]) and often there will be multiple transaction names that actually link back to the same company as a payee. I want to know, for example, how much I paid out to “Fry’s Grocery Store” in total, no matter which Fry’s location I went to. And, I want to view that data in a Chart block, with pretty colors from Single Select options, for example. So I used to manually match transactions with a colored Single Select value: Needless to say, it was a tedious manual process, and I very frequently encountered the same Import name over and over – so I knew this was something the Scripting block could help me with, at least to some extent. What the script does This script checks all imported transactions that do not ha

Heya community! Dan (@openside) and the team have been hard at work making our own slew of tools to compliment Airtable. Today I’m excited to announce they are now live! Here’s what we’ve been making: Actions - Advanced connector to integrate Airtable with your other software tools Forms - Sophisticated Airtable forms with extended features Schema - Monitor and be notified when anything in your Airtable schema changes Backups - Automated backups for your Airtable bases Scripts - Specialized script manager to integrate with Airtable’s scripting block Storage - Secure storage and proxy for your Airtable script data Our new site just launched where you can go check them all out here. We’d love for you to give them a try with a free trial (link on the site). If it’s a fit, go ahead and use coupon “ON2AIR10” for a discount on any app bundle as a thank you for giving it a try! We really think we’ve made the best tools for Airtable out there, and know it wouldn’t be possible without you

After consulting for the last 2 years, I started this Youtube channel to make Airtable more accessible because I know how difficult it can be to get started. Currently, I’m working on a CRM tutorial series where you can build a simple and fully customized CRM. So many of my past clients disliked their CRM and some still use pen and paper! Even if you are not looking for a CRM right now, I still walk through a ton of concepts in the tutorials that can be helpful across many types of Airtable projects. Here’s the link to the channel: youtube.com/airopsconsulting Here’s the first CRM tutorial https://www.youtube.com/watch?v=1qJZvdOY01g&t Thanks for stopping by!

Sometimes you import some data that looks like this: But you want table data that looks like this: This script does that: let settings = input.config({ title:'Table Optimizer', description: "Converts data that's stored over many fields, into data that's stored in one field with multiple parameters in a new table", items: [ input.config.table('sourceTable',{ label: 'Source Table', description: 'The originating table' }), input.config.text('fieldsConvert',{ label: 'Fields to Convert', description: "Type out the fields you'd like to convert separated by a comma. Example: Field 1,Field 2,Field 3. All convert fields must be of the same type." }), input.config.table('destinationTable',{ label: 'Destination Table', description: 'The desitination table' }), input.config.field('field1',{ label: 'Data Field', parentTable: 'de

I’ve solved for how to use a list of ID numbers to highlight the rows with those ID’s. Search only lets you identify one row, and filters have to be chained together one after the other. When you have a table with 1,000 items, and an external source gives you a list of 50 ID’s that all need the same update how do you select them? My solution requires adding a formula field. By pasting all of your ID values as a string literal to search for that rows ID in you can create a flag that then lets you filter a view. Here is an example of the formula: SEARCH( Identifier, “12345 qwerty 292303 zx11k9i2”) In this case Identifier is the name of your ID field in the table. Each row of your string (you should be able to paste a column from excel) is one of the ID’s you wish to modify. The result of this will be a column with blank rows and arbitrary numbers. The number is the location in your pasted string where the ID was found but that isn’t important. Next you will probably want to create a view

Hey everyone! I wanted to share a guide I wrote today on how to create a Slack reminder todo app. It takes advantage of Airtable’s neat Trello-style Kanban view for management, and as a bonus, you’ll catch a glimpse of the start (and probably end) of my poetry career. You can see all the code as well as fork and deploy your own working version onto Autocode from the link. Would love to hear what you all think! Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode View and Fork this Source Code on Autocode

I recently redesigned one of my personal Web sites - an art portfolio - using an Airtable base on the backend. If you’re interested, you can check it out here: http://art.timdietrich.me The site is PHP-based. It pulls all of the artwork (including the information about each piece and the images themselves) from the Airtable base via the Airtable API. It also uses Stripe to handle credit card payments, and saves the orders back to the Airtable base. And for email notifications and receipts, it uses Mandrill. More information is available on my blog: http://timdietrich.me/blog/airtable-based-art-portfolio-site-launched/ Thanks for checking it out - and let me know if you have any questions about it. – Tim

In response to a long-running post about needing a find and replace function here: Would love a find/replace option! Product Suggestions I am adding my own request to this list. Not sure why it is still missing, this is an essential database feature. Here’s a script that does just that: // This is free and unencumbered software released into the public domain. // // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. // IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR // OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, // ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR // OTHER DEALINGS IN THE SOFTWARE. // // AUTHOR: Jonathan Bowen (www.dragondrop.uk) // SCRIPT: Script for Airtable script block to find and replace text // DISCLAIMER: // - T

As you may know, Airtable has direct integration with Slack ‘out of the box’. I have just published an article my blog which discusses how to use this to build an absence approval workflow, starting from an employee’s request through to notifying them of approval (or otherwise) - and with a little help from Zapier along the way. The blog post can be found here: Approval Workflows Article The article uses my KasPer Lite base which is available in theUniverse. I hope you find this useful and look forward to any comments…

Hey everyone! I recently launched a tool for creating websites / web apps without coding using Airtable. We have templates for building sites: A discovery site like Product Hunt A job board like Indeed A service marketplace like Fiverr A gallery like Instagram An events site like Meetup A social networking site like LinkedIn You can create your own site with Airtable for free on Pory. Looking forward to getting some feedback and suggestions :pray:

The uploading of images in the airtable is slow. If I try to upload images in bulk, it shows uploading and if I check after 30 mins …no images are being uploaded. Each image is more than 6 mb. Can anyone please let me know what can be the problem and how I can make the process faster. thank you

Hello! We’ve seen a lot of great ideas come from the community forum. It’s a place where everyone helps each other learn and can share the great stuff they’ve made with Airtable. To keep the good ideas coming, we want to challenge you to create something that’ll benefit the community. As a bonus, the most interesting, creative, and useful creations will receive some fun prizes :slightly_smiling_face: First up, we want to see how you can use Airtable to help manage your finances. Of course, a great budget framework is versatile and can work in a professional context as well. We know the community wants to see templates in the personal finance category, but don’t feel you need to limit your idea to a single use-case. You could create a budgeting tool, an expense tracker, or even an anti-budget. Be creative and use your skills to come up with a unique base that others can use and benefit from! We’ve even put together a starter template and a brief guide to get the ball rolling. You

Hi folks, I’ve been working on getting all of the transactions from various accounts (different credit cards, debit, investments) into one base for YEARS. Up until now, it’s been a series of monthly CSV imports (using CSV import block) which was a huge pain. Frankly, most months I’d give up and not do it. That is until I discovered TillerMoney and Parabola. Tillermoney imports all of my transactions into a spreadsheet and Parabola lets me setup a nightly runs to sync transactions between the Tillermoney sheet and my airtable base. From there, I can easily map each transaction to a category using a linked record on the vendor (working on standardizing vendor names with a script!) Here’s a quick video on how I’ve set everything up including the Parabola run and a template base to start from A few Qs that I expect to come up: Why not use the sheet? I work at Airtable so it would be awkward… more seriously, mapping vendors to a category is a pain. Why not use Mint or another tracking app?

I represent the University of Colorado Denver - where I work - and the Digital Pedagogy Lab (DPL), where I am leading a workshop on Maker Education in late July. I am not spam or scam - this is a sincere introduction and invitation. We are hosting a virtual Maker Faire in the last week of July, and I was hoping Airtable – or an Airtable developer - might give just a bit of time and expertise – to essentially offer a ‘how it’s made’ style demonstration of what’s possible. Possibly even an Airtable for Educators type of demonstration. That’s the idea. The DPL event itself has about 500 participants registered this year, from universities around the country. Within DPL, we’re aiming for a mini-Maker Faire for a couple of hours during the week. All video virtual – folks tuning-in and browsing from home. I would really like to have Airtable at the table and demonstrated as a no-code maker platform. I am humbly fishing for an expert to give us 1 to 1.5 hours of your time on either July