We use airtable bases per client and naturally as all software or businesses evolve the system (in this case the most current client’s base is now more advanced or effective than the ones before it) which means we then need to go back and update all previous bases to match the same design/flow as the most up to date base. What I’m proposing is two-fold (perhaps it’s even a Block) That you can assign version milestones that take a snapshot of what your current base looks like and then as you edit the base, similar to how github works it can keep up with the changes and even notate them, similar to how your dynamic API directory updates (which is absolutely incredible, btw 🙂 ) For example: This base will be assigned the ‘template’ of CRM As soon as I assign it with that template, it now will be considered CRM v1.0 As soon as I begin marking up edits that are taking place within the restructuring or re-labeling of that base. – Perhaps, I can open up a block that shows me a ‘version history’ broken down by base, table, view, and field. Once I’m ready to release a new version (take a snapshot), I can click a button that will ask me to either assign it as a new version or a minor update. – If it’s a new version it will jump to CRM v2.0 – If it’s a minor update, it will simply jump to CRM v2.1 When a user logins in and a recent update has been pushed, they will be able to review the ‘revision history’ so they can always stay in the loop with what things have changed (especially for their personal views) Now that we’ve implemented this new ‘Template’ feature that you can assign to bases we can move on two my second request. For people or businesses like ours (especially since you can’t link bases) that need to separate bases per account. It would be EXTREMELY helpful if you had the ability to update your bases version to the most recent update. For example: If I have 5 clients bases all assigned with the template project management v1.7 and have been working in this 6th client’s base and made some significant tweaks to the views and how the base functions and everyone loves it (so I decided to push the updates to the template as project management v2.0 now I have two options… The current unfortunate way which is unrealistic for how much work is involved. This requires us to clone the most recent base 5 times and then copy and paste all of the old data into the new base (losing all history comments, etc) OR keeping meticulous notes of the adjustments made to the newest base (v2.0) and then going back to all the previous bases which could be way more than 5 for example and manually updating them, which is 100% not realistic in 99% of the use cases. OR The currently make-believe way that provides the simple and EXTREMELY helpful ability to go into each one of those 5 bases or even select them all from the main view and choose which version I’d like to update to and then it tells me what I might lose if that’s the case. (the second alert part is optional, I know what I’m getting myself into and I could always revert with a snapshot right 🙂 ) Hope this helps!! ❤️ Would love to speak more on it if you’re interested. Happy Friday ... View more

We are trying to use Airtable to depict information with restriction on copying data and it doesn’t make sense for us to have the print view option. How do I disable it? ... View more

It would appear that the ‘Date’ field does not record seconds. Here’s why I think this: Here are the formulas I’m using to expose this: DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h:mm:ss’) DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm:ss’) I hope I’m wrong about this. I need to be able to grab seconds from a ‘Date’ record. View discussion of this in Dates and Timezones category ... View more

For capturing text and urls from other apps (for example, to a table of bookmarks) it would be great to have the ability to share to some field of some table of some database in the standard android way. ... View more

A client of mine just discovered a small issue with Airtable when it comes to the “Send Record” command. (“Send Record” is the command you can choose when right-clicking on a record.) If you have an attachment field as part of your record, Airtable will place a small thumbnail of your attachment in the outgoing email. This is fantastic! 🙂 However, if your attachment field is actually a LOOKUP FIELD that displays an attachment, then the thumbnail is no longer placed in the outgoing email. Airtable just places a link to the attachment instead. What’s interesting is that all other types of lookup fields (text, dates, numbers, etc.) seem to get placed in the outgoing email just fine — it seems like only attachments cause this issue. ... View more

When I try to have important information from another table shown in my current table, I use the lookup field. But what I don’t like is that the lookup is transformed into a simple text representation. So when I lookup a “single select” field that has rounded borders and colors, as a lookup, it’s only text with no color and no round borders. When I lookup a priority field with a star representation it’s even worse. It gets transformed into a number. So instead of having 4 stars, I get the number 4. Which is harder to read. All lookup fields lose their color and visual representation, which makes the table look dull and hard to read. I’d like to request the feature that lookup fields look exactly like in the table looked up from. If it’s pink hearts, it should be pink hearts. If it’s colored single select fields it should look like it. Information would be much easier to read and look at this way. Cheers Chris ... View more

It would be awesome to have “master” views from which others can be derived/scoped, a.k.a. sub-views based on other views! A use-case of my own: I have a highly customized view I use all the time, it has lots various filters, groupings, hidden fields, sorts, … Sometimes I need to filter this view by an specific requirement (ex. a time span). Currently I have a duplicated view of the original with the added filter. Nevertheless, if I change something in my original view I have to remember to change it in the sub-view as well. ... View more

Some existing workarounds can be found at Formula to replace special characters - slug creation But they’re highly unfriendly, and don’t actually cover a proper “slug” use-case. Is it possible to have official functions for this? For instance: KEBABCASE - Replaces all special chars by -. See https://lodash.com/docs/4.17.15#kebabCase for implementation details SLUG - Similar to KEBABCASE but also converts non-ascii characters (accents become non-accent) This is really, really needed for urls generated by content. Like article’s title and such. List of all existing functions: Airtable - Support Formula field reference For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation... ... View more

When table define linked itself, it should be organized like a tree. For instance, Place table: Fields: name, upper China, Shanghai, China Pudong, Shanghai Beijing, China Tree View is very user friendly when users want to choose a place. Is there a Tree View? ... View more