Welcome

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.