This is great for getting a feel for the premium features that don’t come at the free tier.Īs you compare the pricing, you should know that bases are the basic building blocks of Airtable. Airtable overview Pricing and plansĪirtable offers a freemium version, but also a free trial of Airtable Pro for 14 days. Attach an image or QR code directly in a cell for a product inventory. I’ve heard it called “Excel on steroids.” Think of it as a spreadsheet/database hybrid you can use for project management, CRM, DMS, ERP, sales pipelines, and more.Īt the same time, Airtable has more flexibility and some capabilities that put it in a completely different category from Excel, Sheets, and traditional spreadsheets.Ĭustomize the cell field type and have it scour other tables for data without writing a single line of formula. If you're a Pro or Enterprise plan user with creator permissions and you want to ensure that your preferred record coloring conditions won't get accidentally changed, you can lock the view, which will prevent all collaborators from altering a view's configuration until it's been unlocked by someone with creator permissions.Airtable is an incredibly useful tool for organizing just about anything. To remove a condition, click the trash can icon next to that condition.Ĭlick the trash icon next to the color to remove a color (and all its associated conditions Not the third color rule in the image below named "Otherwise": Any records not meeting the specified conditions for any of the other colors will get the default color. You can also specify a default color by clicking the "Add default color" option. This will change the priority of the different colors-colors closer to the top of the list of colors will get higher priority than those closer to the bottom of the list. You can rearrange the colors and their associated conditions by clicking and dragging on a color's drag handle. (This makes it easier to quickly create lots of conditions that are similar to one another.)Ĭolors' conditions will automatically collapse to save space as you add more colors and conditions, but you can expand a color to view or edit its conditions by clicking on it.Ī record can only have one color -so in the case of a record which matches multiple conditions, that record will receive the color of the first condition it matches, starting from the top of the conditions list. To add a new color (and associated set of conditions for that color), click the + Add color option at the bottom of the dialog.Īlternatively, you can duplicate a color and all its conditions by clicking the duplicate button next to a color. From this color picker, you can specify the color for a set of conditions. Adding a second condition will create a condition group, which is a collection of conditions tied together via a conjunction ("And" or "Or"):īy taking advantage of creating and using condition groups, you can create views with deeply customized record coloring:Ĭlicking on the color swatch for a set of conditions will bring up a color picker with all the Pro plan colors. To add another condition for a color, click on the "Add condition" button. To set an individual condition, you'll need to select a field, an operator, and a comparison value(or values). The interface for creating conditions and condition groups for coloring is the same as the interface for creating conditions for filtering records. In the above image, every record meets the "undefined" condition, so every record gets the color applied to it. When you first open the Conditions dialog, it will have one color and one "undefined" condition (essentially, a condition you haven't set yet). Adding a condition to color-code your recordsĬlick the "Color" option in the view bar to color your records by conditions, then choose "Conditions." Coloring records based on conditions allows you to define rules, and any record that meets those rules will automatically receive the specified color.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |