I would like to build a database that has records in flux and records that are locked. The records that are in flux–the current period, whether monthly, quarterly, or annually, would be separated from locked records by a closing date (or other number/field I suppose) that determines the cutoff or closing whereby that prior records are deemed complete and not subject to change. So I am imagining a field type that is “Closing number” that could be a date or some other ordinal type that could be included in a table, and then an option under the “+” tab at the upper right of the menu, which offer “Closing date”. If you selected “Closing date” from the menu, you could choose a particular date or number, and all prior records would be locked. You could reverse this, but only after getting a warning message and perhaps entering your password. This same method could be used to protect sensitive information as well: You could have a field type: “Protection” and designate user levels to access/view/modify the information. ... View more

Now that Blocks are out of beta, I’d love to suggest an alternate palette. We’d kill to have a “Dark Mode”, a la Klipfolio or Numerics, for full-screen display on a 4K TV. Related, we’d love the ability to get HTML embed code per block, again in two UI skins, one “Dark”. This would allow us to use native Airtable design within other dashboard platforms (so long as they support embeds). Thank you! A. ... View more

It would be great to allow specified groups of fields to be repeated by the user. i.e. duplicate fields in form view. ... View more

This one might be a little bit “out there,” but I think that if it were possible it might address a number of requests for additional functions supported by Airtable’s Formula Fields… I’m wondering if it might be possible support Formula Fields whose values are based on the result of some ad-hoc Javascript function. For example, the user might specify other Airtable fields as the Javascript function’s params, specify the JS function itself, and have the Formula Field’s value reflect the result. It sounds like a lot of work, but if it were possible, it would expose Javascript’s functions to users, and reduce the need for Airtable to continually add support for new functions. It might also help to meet some of the needs that we’re seeing for localization. Just a thought. ~ Tim ... View more

These posts are asking about a feature similar to the “filterByFormula” in the standard API, to programmatically filter record selection.   Can table.selectRecordsAsync() query a table or view? Scripting app I see that you can get all records from a table or view - and even sort them. But what if you want a subset - for example all those records connected to another record? It’s not always possible or desirable to create views for this type of thing?   More efficient way to query records? Scripting app Is there a way to retrieve specific records without iterating through all the results of a table using table.selectRecordsAsync() or view.selectRecordsAsync()? Something like SELECT / WHERE queries in SQL? Or in AirTable terms, a Filter? This would be far more efficient than having to iterate through returned records checking for the records I’m interested in… My request is slightly different and I think falls into the “interactive” idea behind the scripting block: session.selectedRecords() . The idea Each record can be selected with a checkbox on the far left-hand side of the row, or all records can be selected from the box at the top. The UI allows users to “Send” or “Delete” the selected records from the base when right-clicking after selection. Providing a scripting block some way to detect which records are selected could help with more granular use-cases. For example, the user wants to update 4 records in “GroupX” and 2 records in “GroupY”. Right now, there are easy ways to filter records matching “GroupX” OR “GroupY” but not a mix (absent other algorithms for detecting the desired records). Potential issues One implementation issue that comes to mind is when does this selection get stored. If a user runs a scripting block with “N” records selected, provides some information via an input.textAsync() and deselects some records before submitting the text, does the script use the selected records at script start or at moment of execution? What do others think? And anyone from Airtable, can you give hints if this might be in the works (or any other session variables for that matter)? ... View more

I would love if there was a way to put the hex code or RGB for a colour into a cell and have the cell display that colour. I frequently use Airtable for design and product purposes, and this would be an extremely helpful feature for that. ... View more

Is it possible to upload files in bulk? I tried to do that but it put them all into a single record. Also, is it possible to link a data field to a specific PAGE in a pdf? (We’re a small law firm and receive large pdf files with multiple documents combined. So we frequently will bookmark to a particular page in a large file.) ... View more

Allow checking of a checkbox if in Kanban views if the checkbox is viewable in the visible card body. Right now I can see the checkbox, but I have to drill into the record to edit such. I’d rather be able to toggle the checkbox on/off directly in the card without having to drill into such. This would also be useful in the Gallery view. ... View more

I love the configurability of views and filters. However, for the bases I use most frequently, I end up with a dozen or so different views mostly differing by combinations of a smaller number of filters, and I’d have more if it didn’t become too difficult to remember, configure, and update them. It would be very useful to be able to add a bar of buttons to toggle frequently used pre-defined filters on and off. The Kanban views in JIRA have this, and I really miss having something similar in AirTable (in both Kanban and Grid views). Thanks again for the great product - and keep making it better. ... View more