My idea is to have a function that would allow you to group, sort, or filter by the comments added by users. For example, we run a manufacturing company, and have several users in airtable communicating with each other and leaving notes on orders pertaining to updated project or customer information. A lot of times, this is for alerting others that something needs to be changed or updated, as not everybody is handling that specific task. What I’m interested in is having the ability to filter all of the projects we have so that users can only see projects that have comments attached to them from other users (or even themselves). As of right now, the only way to find these is to scroll through the list of current projects and look for the icon saying that something was noted / updated / changed. With over 600 projects, it’s a bit of a daunting task. ... View more

It would be amazing if we could restrict linking records to only ones that appear in a specific view, and also if we could disable creating new records if one wasn’t found. ... View more

Please remove sorting as a default requirement for creating groups. It seems totally unnecessary, and is problematic. Why does the Group function require sorting? If I create, say, 100 entries in 10 categories, why can’t I group them by category in the order I entered them? Currently, AT automatically orders them alphabetically, with my only options being A-Z or Z-A. Alphabetical ordering is often completely inappropriate to the content! This means I have to do a clunky workaround by creating an artificial numbered column just to get them to stay in the correct order. The Group function and the Sort function should be wholly independent. Please fix. Thanks! ... View more

I commonly have fields with 15 or so options. I usually design the options elsewhere and then put them here. My issue is that I am not able to paste multiple options at the same time. Even if I select multiple cells, either in Airtable or a spreadsheet application, and paste into the options box, it puts all the cell contents in one option instead of creating multiple options. To give a concrete example, consider the following table. Options Description High High chance of conversion Medium Medium chance of conversion Low Low chance of conversion I select the three options in the first column and paste into the options part of a field’s configuration screen. My problem is that I get something like this: High Medium Low as one option, rather than three options. Could you please have this become three options? ... 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

Hello Airtablaryens, I can’t believe that I took so long to discover Airtable. But now that we have one another in each others lives, the rest is history. Now, feature request; I just created a “frequency” - Single Select - column for when subscribed payments would occur, with the options Weekly, Fortnightly, Monthly, Annually. Next to this column is a “Payment” currency column for the input of currency. And finally next to that is an “Annual Total” Formula column, where; Annual Total = Payment * Frequency That’s the moment when I realised, that I’ll need nested IF loops to get the job done, as Weekly = 52, Fortnightly = 26, Monthly = 12, Annually = 1… Yet this would be so much easier & neater if I could use a switch statement - Select Case. en.wikipedia.org Switch statement In computer programming languages, a switch statement is a type of selection control mechanism used to allow the value of a variable or expression to change the control flow of program execution via a multiway branch. Switch statements exist in most high-level imperative programming languages such as Pascal, Ada, C/C++, C#, Visual Basic .NET, Java, and in many other types of language, using such keywords as switch, case, select or inspect. Switch statements come in two main variants: a structured... It sure would be nice for the devs to include this. :blush: Otherwise; IF(Frequency = "Weekly", Value*52,IF(Frequency = "Fortnightly", Value*26,IF(Frequency = "Monthly", Value*12,IF(Frequency = "Yearly", Value,0)))) Looks so ugly >_< Cheers, K ... View more

@Katherine_Duh Somehow I missed the What’s New announcement of WORKDAY() — or, more likely, I saw it, but it didn’t sink in as I wasn’t working on anything related at the time. Just last night, though, I posted an example database in response to a Support question, and in the base description I noted three things that should be fixed before putting my admittedly ‘toy’ base into production. One had to do with bullet-proofing the formula I wrote to find the previous workday to a given date; I mentioned some provision likely should be made for identifying holidays or other non-workdays that fell within the business week. After seeing your Announcements post on the new ratings field, I went to see if there was anything else listed in ‘What’s New’; that’s when I noticed the entry on WORKDAY() . Reading through it, I noted with excitement the information on the optional holidays parameter. “If only WORKDAY() would take a negative value for numDays ,” I thought, “it would be perfect for this base.” I came here to post a feature request asking for just that — and then remembered, virtually everywhere I’ve tried, Airtable functions have accepted negative values. I was delighted to find that WORKDAY({Date},-1) does indeed return the most recent weekday prior to {Date} . I’ve since modified the base to make use of WORKDAY() , and I wanted to thank everyone who made that possible. :slightly_smiling_face: ... View more

In Excel, you can use the ROW() function to return the row number of the current cell. A feature like this in Airtable would be useful, as I have a list of events that I want to recalculate their date depending on the order that the user has the rows in. I can’t use the autonumber feature, because that doesn’t renumber when the user reorders the rows. There doesn’t appear to be any way to get Airtable to work out what the order of records is, and calculate a formula based on that. ... View more

Airtable automatically creates a Sum for Number, Currency and Autonumber fields, even though it sometimes doesn’t provide any useful information. For some numeric info, I’ve used a “Single line text” field to avoid having to change a useless Summary in several Views. How about if numeric fields had an option for a “default” summary, with “None” as one of the options? Any new View with that field would display the default summary. This could also be useful for non-numeric fields, e.g. it would sometimes be nice to have an “Empty” or “Filled” summary for all Views that have a particular field. Thanks. ... View more