With the varying possibilities that Airtable presents, it can be tasking to know where to start. You can view the list of keyboard shortcuts by holding "Cmd/Ctrl and /" ⌘ ? to bring up a list of keyboard shortcuts that'll work within Airtable. Studies show that using keyboard shortcuts expedite common operations 10 times faster than working with the mouse.Īirtable provides a helpful list of key combinations that we've found to increase work efficiency and accomplish more tasks with increased precision. Speed up your workflow with Keyboard shortcutsĪnother important tip that has been particularly useful for us is using keyboard shortcuts. One of the best things about Airtable is that you can edit the view configuration or copy another view's configuration.Ģ. While one way might work best for you, it might not be the same with your team members. It's normal for small and large teams to work in different ways. Knowing your way around the views can help with collaboration. You can use views to filter, group, sort, show (or hide) specific fields or records in the table. Airtable also allows you to view the same data and information in other ways whether that’s as a form builder, calendar format, visual gallery, Kanban board, timeline, or Gantt views.Īs you begin to populate your table with multiple layers of information, each view can be formatted to manage information in that view without affecting the entire table. When you add a new table to your base, the default view type is the grid view. One of Airtable's top features is that you can look at the same information in different ways. Filter information with the right view type In this post, we will be sharing five of our favourite tips and tricks to help demonstrate what's possible to get the best out of Airtable. As a database, it allows you to link records to one another, enable data entry, formula calculations. As a spreadsheet, you can structure information in a table with grid view, columns and rows. However, while this is powerful, it can be a steep learning curve for new users and experts alike.Īirtable is a hybrid of a spreadsheet and relational database. With new features being released on our favourite tools, knowing new tips and tricks will help supercharge your workflow.Īirtable can connect just about everything, which is great. Cash flows are assumed to be due in the same order they are arranged in the cash flow values array.Learning new software can be overwhelming. NOTE: There must be at least one negative and one positive value as part of the cash flow. Internal Rate of Return - Returns the internal rate of return for a series of cash flows.Net Present Value - Returns the net present value of an investment based on a constant rate of return and a series of future payments/investments (as negative values) and income/return (as positive values).Rate - Returns the interest rate per period for a loan or investment.Principal Payment - Returns the calculated principal portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.Interest Payment - Returns the calculated interest portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.Payment - Calculates the payment for a loan based on a constant stream of equal payments and a constant interest rate.Future Value - Returns the future value of an investment based on periodic, equal, payments and a constant interest rate.Present Value - Returns the present value of an investment, or the total amount that a series of future payments is worth now.You can store the data in a text or number field. Count Items - Determine the count of all items across all fields.Sort Arrays - Sort the array (range of data) and store newly sorted data in another field.Reverse Array - Reverse the order of your field data and store in another field.Slice a subset from the array - Extract a subset of data from an range of data to store separately and add to a different field.Select Random Item(s) - Select a random count of items from all fields provided.Use the Unique Arrays function if don't want duplicates in your output. Combine Arrays - Store data from multiple fields into a single field.Unique Arrays - Search 1 or multiple fields for unique data and store the unique values in another field. This is useful for searching fields and finding any values that are not present and adding it to another field. Items in One List But Not in Others - Extract values from one field that are not found in multiple other fields and add it to another field.Extract/Convert to String - Extract data from Attachment, Collaborator, or Button fields to store info into separate text fields.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |