Airtable finally added this calendar month as a date filter option which is great, however there needs to be a last calendar month instead of just last month. We need to submit every month our expenses from the previous month. So for example today, I need to be able to see all expenses from January (i.e. last calendar month). How it is now if I do last month, it will show me expenses from Jan 14 - Feb 14 which is not useful. ... View more

I have a table with many, many fields (150+).  Not all of these fields need to be populated.  In fact, most of them are sparsely populated based on conditions present in other fields. It would be awesome if in GRID VIEW there were a way to selectively "gray out" field values based on a formula (unique formulas per field would be ideal).  That way, users could visually know when to "skip" a certain field and focus their attention on others. I need this functionality specifically in GRID VIEW, because my users do a lot of visual comparisons between ADJACENT records -- and there's no easy way to do this visual comparison in any other view types currently. ... View more

What is the proposed idea/solution? I want to be able to add a color based on a formula. For example I have a bunch of subtasks under a parent task. I want to color the records where due date is greater than the parent task end date because this is a task I need to be flagged since the whole task should be done before it is currently planned. Ideally the formula would be,  IF({parent task end date} - {due date} < 0) and then I can set the color to yellow. ... View more

What is the proposed idea/solution? ...when changing the name of a Field in a Synced Table, the updated name should also be Synced. This would likely require a feature, whereby a Synced Field and a local Field can have the same name without a conflict. This should not be a problem, because it's easy to determine what is synced field vs local due to the lightning bolt icon. How does is solve the user problems? ...without this feature, any changes to a Field Name are not propagated to other Synced Tables. This causes confusion. How was this validated? ...Try changing the field name of a Synced Table and find out! It's frustrating. Who is the target audience? ...all users who use Synced Tables. ... View more

What is the proposed idea/solution? ... A new feature that transposes the Rows and Columns of a View. How does is solve the user problems? ... It is useful to transpose the Rows and Columns of a Table for for viewing and / or calculations. In Airtable it is more efficient to create Records for time rather than Fields (e.g. each Row is a unit of Time like a Week, Month, Quarter, Year, etc. and not the column). The ability to see each unit of Time as a column moving from left to right is standard practice. How was this validated? ...This is a core feature to all spreadsheet applications. Who is the target audience? ...All Users ... View more

The current grid view summarisation options are great, but we need the summaries to calculate the combined values when using formula fields. E.g. Each record calculates a % using two number fields. The summarisation doesn't give the total combined % but rather a sum, average, or another inappropriate function. ... View more

Capacity Rather than having time against items spread evenly over X days, having another junction table that tracks time entries would be great. For example, I have a 10-hour task to do over 3 days and spend from 10am to 4pm working on it on the first day. This leaves 4 hours of work to do, which can then be spread over the next two days. Should I then do none of that work on day 2, all 4 hours of it would need to be done on the 3rd day. Available hours The available hours are powerful, but don't allow us to track half days or exclude certain types of time off, both of which are crucial to utilisation. Many people take half days but these would appear in the timeline view as either normal days or time off, leaving the user in a position where they have to know when people are off work. It'd be ideal to select a view in the "Time off" table to filter out people who are off sick, at a conference or have had their leave request rejected, for example. ... View more

"When I use the selection field to group the list, and I want to change various records to a newly created group/selection, I have to go into each record and change each selection/group." ... View more

What is the proposed idea/solution? I'm trying to use an interface to present financial information; however, numbers are left aligned in list view and there is no option for totals. Even columns that are right aligned in Grid view are left aligned in List view. Can this be corrected so that it allows the option to right align? How does is solve the user problems? It will allow us to use list view for financial information in a way that is more intuitive to users. How was this validated? ... Who is the target audience? Everyone and anyone that looks at financial information in a list view or interface. ... View more