Hi there, When we create a date field, we’re allowed to choose from 5 different date formats. It would be amazing if we also had the additional option to add the DAY NAME in front of the date. So, in other words, our date field could be formatted to look like this: Wed 5/22/19 I know that we can create another field called “Day Name” and create a formula to calculate the day name, but it would be much more convenient (and more user-friendly) if the day name was simply just another type of date formatting that could be directly applied to the date field itself. (We’re coming to Airtable from the FileMaker world, and this is how FileMaker handles date fields — FileMaker can apply any type of formatting directly onto a date field, without requiring any additional fields nor additional formulas.) Thanks, Scott ... View more

There is already this feature request (forum URL plus “/t/request-entity-relationship-diagram/2490”) that asks for a visual representation of the different elements in a base, which would be great BUT also… I’m trying to ditch my LucidChart subscription so that I can use Airtable for everything, but right now the ability to create ERDs (for content models for content strategy) is the one thing I still need LucidChart (or Visio) for. My job requires very large (e.g. 500k+ pages) site migrations, so not having visual representation of relationships between content types can make projects very difficult for everyone across our team to reason about. I could see having something like “cardinality” or the more colloquial “crow’s foot notation” in column B to show the relationships between the content types listed in columns A and C. The visual presentation could come up in a block on the right-side panel. This is different from the above request, which shows the actual relationships between rows/items added to AirTable, whereas I want to be able to arbitrarily create this visualization and house it within a base with all my other project assets. ... View more

I have a rollup field on our Customer Tracker that concatenates the project stage for each of the projects associated with a single customer. I want to filter on projects that are post-implementation to flag CSM’s to update Customer health information. Currently, I can only filter on one entry, and when I had others into the filter, it filters out everything. Thanks ... View more

It would be amazing if Airtable had the ability for records to AUTOMATICALLY link to records in other tables, once Airtable knows what “match criteria” we’re looking for. Right now, Airtable requires us to manually link every single record by hand. ... View more

In a sheet with a lot of columns and formulas added, it difficult to easily identify the input columns from columns that are automatically populated through formulas, roll-ups and look-up functions. It would be useful to be able to colour code the header label/icon of a column or an entire vertical column: When customising a column/field type it if the user could assign a colour to the column. This could colour code the header, icon or perhaps the entire column (similar to the appearance when a column is used for sorting). OR: Perhaps this could even be automated eg. Field types that populate column with automated data (eg. look-up, formula and roll-up field types) could have a different coloured icon/header/column to the columns where data needs to be manually input. This would make it clearer which are input columns vs automated formula columns. For example, when creating creating an excel spreadsheet I would always colour code the input columns codes to make these easy to identify against the automated columns that users don’t need to touch. Many thanks ... View more

It would be great to have a native solution to this problem. Let’s say I used the SendGrid block to email all Users in a certain grid view. Now I want to document that the email was sent out to them in a separate Emails table. Currently I have to manually add each emailed user to a linked Users field. Instead, it would be great to have a method of automatically adding multiple linked records to that linked cell. Here are two approaches to this: 1. Add a new paste option If someone has a linked cell selected: And then pastes a few records, I should get the option to add them to that cell (as long as they include a valid primary field that matches existing records). For what it’s worth, all you need to do for this to work is replace newlines with commas 2. Bulk add everyone from a given view Similar to how SendGrid can automatically send emails to everyone in a filtered view, allow the addition of multiple records at once. Right now, adding 20 people to a sent email is really complicated and frustrating. Either of these approaches (or many others you might come up with) would solve that. ... View more

It’s awesome that lookup fields automatically bring in data from other tables, and that these lookup fields always keep their data constantly updated in real-time between the multiple tables. However, sometimes we want to lookup data from Table A into Table B, and KEEP THAT DATA STATIC in Table B. In other words, we DON’T want the lookup data in Table B to be constantly updated. The #1 classic example of this is creating an invoice in an invoice table that looks up prices from a products table. For historical accounting purposes & historical tax reporting purposes, it is very important that each invoice ALWAYS stays at the EXACT SAME PRICE after submitting the invoice to a client. But with Airtable’s lookup fields, whenever we increase prices in our products table, all of our old historical invoices also increase their prices as well. In reality, we only want the new prices to affect NEW INVOICES moving forward. We still want to keep all of our old invoices locked down to their old prices for historical purposes. In other words, new prices should only affect new invoices moving forward… but should leave old invoices alone. We got some workarounds in this thread, but it would be significantly easier if this functionality was directly built into Airtable. We are coming to Airtable from the FileMaker world, where a “lookup field” in FileMaker copies & pastes the data (such as price) from Table A into Table B in a STATIC FASHION, so that prices always remain static on old invoices for historical purposes. FileMaker, of course, also gives us Airtable’s ability to have lookup fields that automatically update in real time as well (but these are called “related fields” in FileMaker). So we have both options in FileMaker. Airtable only gives us one option. We would really love Airtable to give us the ability to have lookup fields that do “static copying & pasting” of data instead of real-time linking of data. Just go ahead & steal FileMaker’s methodology of doing this! 🙂 ... View more

It would be great if we could have more control over collaborator permissions. For example, the big one for us is that we would like collaborators to EDIT records, but NOT DELETE any records. ... View more

Using the Org chart block to represent site architecture is awesome! The Matrix block allows drag-and-drop to reorganise records. If the same drag and drop functionality existed in Org chart blocks, it would be easy to reorganise heirarchically related records, such as site architecture, and user flows. Right now, either switching back to a table view or expanding a record from the org chart loses context. Using drag and drop would maintain context when assigning a new parent (or child) This would make it easy to restructure hierarchically related records. ... View more