Show and Tell

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 ge

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 m

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 ite

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

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 man

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

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." }),

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

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

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

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

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

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

Looking for ideas. We’ve implemented it for launching custom emails (mailto:) to single and multiple recipients, and for launching a form through a URL. What other cool applications are you doing?!