Announcements

We’re excited to announce a new input method for the scripting block: input.fileAsync! This enables script users to upload files, which the script can then use to do things like create or update records. If you’ve ever wanted to preprocess the data in your files before importing it to your base with the CSV or XML import block, you can now do so with input.fileAsync! Because you can access the file contents from inside the script, you could also do things like conditional record creation or custom fuzzy matching to update existing records. We’re excited to see how you can use this to empower your scripts! The returned value from the file input gives you access to the uploaded File itself, as well as the parsed contents of the file (if supported). Currently, parsing is automatically performed for .csv, .xls, .xlsx, .json, .xml, and .txt files, giving you immediate access to the underlying data. Check out the full documentation for input.fileAsync in the API reference inside the block, o

The page designer block now has a new Set as default font option, which will change the default to the selected font for all new text elements. Any existing text elements with the default also switch to the new font.

We are searching the Airtable community for power-users who’d love to join the Airtable team full-time as an Implementation Specialist! We’re hiring in New York, Austin and San Francisco HQ – check out our careers page to apply.

Hello! We just launched the new web clipper block—you can read more about it here. One of the features of the web clipper block that we’re especially excited about is the ability to export your web clipper recipes and import other people’s web clipper recipes. And so, we think it’s only appropriate that we have a place on the community forum for people to share their web clipper recipes with one another. You’ll now see a new “Web clipper” section in the “Ask the community” category. Here, you can ask others for help, show off your work, or talk about tricky CSS selectors. Also, to celebrate the launch, we’re running a contest until November 9, 12:01 a.m. PST for you to send us your best web clipper recipes. The winner gets a pair of Airpods! Learn more here.

Hi folks! In case you haven’t checked out What’s new in a while, there are a couple of new feature updates that have been released in the last couple of months: New formula function: the ENCODE_URL_COMPONENT() function replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Page designer block update: you can now add borders to all image and text elements on your page. Gantt block updates: you can now export Gantt charts as PDFs , and view your Gantt chart on a 5 year date range.

Due to changes in Google’s APIs, and very low usage of these integrations, we’ve decided to temporarily remove the ability to attach files directly from Google services (Drive, Gmail, Photos) from our iOS & Android mobile apps. We understand that this decision may have implications for existing workflows and sincerely apologize for any inconvenience it creates. Looking further down the roadmap for Airtable on mobile, removing legacy functionality allows us to explore a wider range of possible product decisions. In the meantime, we recommend using either our web or desktop apps to attach files from Google services. We appreciate your understanding!

Airtable plans to end support for direct file uploads from Evernote and Flickr at the end of May 2019. After this date, users will no longer be able to select these services from the sidebar in the file picker dialog; instead, users will have to download files to their local device and reupload them to Airtable. Although our metrics indicate that these integrations are rarely used, we recognize that these changes can be disruptive to some users. We are making the difficult decision to disable this functionality because it is unfortunately required to implement internal reliability and security improvements that will benefit all our users.

Hi Community! Today we’re spring cleaning the Community Forum. While every topic in the forum sparks joy, they aren’t always organized in a way that is easy to find or to follow. We’re adding some new faces to the forum this month (including me!) and we’ll be reorganizing categories as a way to make solutions more visible. Who am I? I’m Danielle! I’ve been at Airtable for about a year and I focus on all things Community, from events to giveaways and everything in between. I’m excited to spend more time celebrating our forum community! What are we changing? Removing Bugs - if you are experiencing a bug, we’d like to know right away! Please submit bug reports directly to support@airtable.com from now on, instead of posting them on the forum. Cleaning Misc - because most Misc posts can fit in existing categories. Adding Formulas - so that all formula discussions can be easily found. Consolidating iOS , Android , and Feature Requests - these categories will become Product Suggestions!

Announcements about Airtable, usually pertaining to new features, improvements, or fixes. For real-time updates on our new features and fixes, check out our What’s New page.

It’s what it sounds like: you can now use chart blocks to create pie and donut charts!

If you have editor, creator, or owner permissions, you can now create new records directly from matrix block. Simply click the + button in the bottom right corner of the desired matrix cell. New records will automatically be filled with the appropriate values in the field used to define the rows of the matrix and the field used to define the columns of the matrix.

Hi everyone! I know we’re not always as consistent with posting in this forum category as we could be (to say the least), but I figured that this latest new formula was especially worth signal-boosting, given how many people who come to the forums are either formula experts or aspiring formula experts. Using the new formula: SWITCH(expression [, pattern, result]... [, default]) you can take an expression, a list of possible values for that expression, and for each one, a value that the expression should take in that case. It can also take a default value if the expression input doesn’t match any of the defined patterns. This is formula is particularly helpful if you often find yourself fumbling through complicated nested IF() statements, since this can replace IF() in situations where you’re comparing a value to a series of explicit values. Consider the following example, in which you want to return different emoji flags depending on the value in a status field. With a nested IF() form

Today’s the day: we’ve officially launched Airtable Blocks! Blocks are modular apps that live on top of your Airtable bases that will allow you to extend your workflows in completely new ways. We’re initially releasing 27 blocks, including ones that let you visualize your information like map, chart, and timeline, and ones that take the information from your base and put it into action, like Google Cloud Vision, translate, and send SMS. (And of course, there will be more blocks coming soon…) The launch post on our blog has all the details. Blocks is normally a feature for Pro and Enterprise plans, but don’t worry, free and Plus users: we’re giving everyone a free trial of Blocks until the end of Saturday, March 31. If you have questions about how to use any of the blocks, check out our knowledge base, which is full of articles and videos to help you out. Even more questions, or ideas for new blocks? Drop us a line at blocks@airtable.com.

Today we launched three new features related to data security and permissions: a new permission level, commenter; password-restricted share links; and email-domain restricted share links. You can read more about all these features on our launch post. Commenter permissions Commenters can see and directly comment on records in a workspace or base, but cannot modify any of the records, fields, tables, or collaborative views. They can also make personal views for themselves (if they’re part of a Pro plan workspace). Password-restricted share links This is a feature only available on Pro and Enterprise plans. You can choose to restrict access to a base or view share link with a password. If you do this, anyone that wants to view the contents of your share link will need both the randomly generated URL and the password. Email domain-restricted share links This is a feature only available on Pro and Enterprise plans. You can choose restrict access to a base or view share link to an email doma

The latest field type, duration, is now live! It’s designed to store time durations measured in hours, minutes, seconds, or milliseconds. There are five different formatting options: h:mm - for hours and minutes, e.g. 1:23 h:mm:ss - for minutes and seconds, e.g. 3:45, or hours, minutes, and seconds, such as 1:23:40 h:mm:ss.s - for minutes, seconds, and deciseconds, e.g. 3:45.6, or hours, minutes, seconds, and deciseconds, such as 1:23:40.0 h:mm:ss.ss - for minutes, seconds, and centiseconds, e.g. 3:45.67, or hours, minutes, seconds, and centiseconds, such as 1:23:40.00 h:mm:ss.sss - for minutes, seconds, and milliseconds, e.g. 3:45.678, or hours, minutes, seconds, and milliseconds, such as 1:23:40.000 You can also now format the output of computed fields as durations, and use durations in formula fields. You can read more about it here.

With our new adjustable row heights, you can now choose to have your records display more text and larger images while in grid views! Select from one of four different row height settings: stick with the default short height to maximize the number of records you can see on your screen, or pick tall to see larger images and more text per each record. Questions? You can learn more about row height here. (If you can’t see the row height button, try refreshing and/or making sure that you’re in a grid view.)

Our newest field type has arrived! Use the collaborator field to assign projects and tasks to your teammates. Check out this post on managing projects more efficiently with collaborator fields to learn more about how you can use collaborator fields. If you have any questions on getting started with the collaborator field, you can read our collaborator field support article.

Today we launched a set of new calendar-centric features for users on Pro plans, which includes record coloring, date ranges, and plotting multiple date fields on the same calendar view. Record coloring With record coloring, you can apply color to records based on the color of an associated single select field or set up custom filtering conditions. With custom filtering conditions, you can make it so that certain records will automatically receive colors based on certain conditions—so you can call out overdue tasks, urgent bugs, big sales ops, or whatever else needs highlighting. Record coloring is especially useful on calendar view, where it colors the entire card (but it works in other views too). Date ranges Select two different date fields in the date picker to define ranges in a calendar view. Just like single-date field record cards, you can pick up and move the card for a date range to reschedule, or click and drag on the ends to lengthen/shorten the duration. Plotting multiple

Hey everyone! Have you ever wondered how other people use Airtable? Now you can find out. Airtable Universe, which has been in public beta, is live! Airtable Universe is a platform for users like you to publish the workflows that run their businesses. Some cool examples: The one-of-a-kind UX research system WeWork’s Tomer Sharon invented to build the $20B brand The complete staffing system used by Insomniac, the largest producer of EDM festivals in the world The project management system that Sandwich Video uses to get ads from pitch to production to the Super Bowl Just head over to Airtable Universe and start exploring! David P.S. As of today, anyone can publish on Airtable Universe. Have something that you’d like to show off? Create your bio and share it with the world!

Hey folks! Here’s a few colorful new updates for you all: The rating field ⭐ We’ve just launched a new field type: the rating field! Go forth and rank all the things! Set the maximum number of symbols in the field customization menu. To give a rating, hover your cursor over the cell and select the desired number of symbols (click on the existing number of symbols or type using the 0 key to clear a cell). Nothing too complicated, but you can read a little more about it here if you have further questions. The default symbol for the rating field is the yellow star, but if you have a Pro plan… Pro plan features: new checkbox field styles, and additional rating field styles Pro plan users can now customize their checkbox and rating fields further by changing the color/symbol used. Just adjust the style from the field customization menu! For reference, here’s all the styles available on the Pro plan for the checkbox field: and here’s all the styles available on the Pro plan for the

Today, we’re putting all our cards on the table and launching kanban view! Check out our launch post for more information, or, if you have some questions on how to get started, check out our kanban view support docs.