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

Field names have to be hard-coded into a formula, which makes it so you can't do something like indicate which field name to pull from in a multiselect field. You can only use a switch with hardcoded field names, or use a whole bunch of if statements to make different things happen depending on the multiselect options. I'd love to be able to write like: FIELDS({multi-select that says which fields to return}) and have that return the value of all those fields as an array ... View more

I'd like to see a formula function for looking up values in linked records, something like: LOOKUP({Linked Record field}, {Field in linked table}) Basically, a two-criteria lookup similar to "INDEX MATCH MATCH" in Excel without needing to import all the fields from the linked table into the current one. Or just a dot/membership operator in SQL databases. Currently, if I want to fetch data from a linked record, I need to use a Lookup field. This is fine if I want to display  the field's values in my table or consistently refer to it in a formula; but if I have multiple fields I want to reference in a single formula, then I would need to add a Lookup field for each of the source fields. This adds an number of extra fields to my base that only serve a single formula field and clutter up my field lists. (Or I would need to do something hacky with the formula, or use scripts/automations.) For example, say I have two tables: Articles and Authors. Articles has fields like Article Author, Article Type, and Article Cost. Authors has fields like Name, Email, and the rate schedule (News Rate, Feature Rate, Review Rate), as below: Articles Article Author – Linked record: Authors Article Type – Single select: News, Feature, Review Article Cost – Formula: ? Authors Name – Short Text Email – Email News Rate – Currency Feature Rate – Currency Review Rate – Currency Articles Written – Linked record: Articles If I want to lookup an author's email address, I can add a Lookup field and it's a good reference to have for every record in my article table. However, for an article's cost, I only want to see the relevant rate from the author's record. Currently, in order to do this, I'd need to add Lookup fields for each rate because the Formula field can only reference fields in the current table: Articles Article Author – Linked record: Authors Article Type – Single select: News, Feature, Review Article Cost – Formula: SWITCH({Article Type}, "News", {News Cost}... News Cost – Lookup: Author.{News Rate} Feature Cost – Lookup: Author.{Feature Rate} Review Cost – Lookup: Author.{Review Rate} But now I have three fields dedicated to this one formula. The fields are of no other use in that particular table and are basically clutter that I have to hide in every view. If a LOOKUP function existed, then I don't need those extra fields, and instead my formula would look something like SWITCH({Article Type}, "News", LOOKUP({Article Author}, {News Rate})... This would benefit anyone working with rate cards, inventories, or schedules (or any case where they need to perform a variable-field lookup). Another use case is doing a "deep" lookup, such as getting the country code for a phone number based on a city. Say you have a base with tables Phone Numbers, Cities, Countries; and Phone Numbers are linked to Cities, and Cities are linked to Countries; and {Country Code} is a field within Countries. Because Lookup fields in Airtable only go to one other table (you can't lookup a Linked Record field in another table and get data from that third table), you would have to add a Lookup field to Cities for {Country Code}. ... View more

What is the proposed idea/solution? ... I often use the 'modify' function when using automations (especially for creating/updating). It would be super helpful if we could set this on the preferred fields in tables so that every record - even for records that are already in the table - is modified automatically.  I use the formula field for LOWER and UPPER functions - however, title case is one that I use frequently, but it isn't available. How does is solve the user problems? ... Saves time & confusion on automation set up as well as increases data validation & reliability. Who is the target audience? ...anyone ... View more

This is very useful for multiple nested conditions, and is basically a string of multiple IF-conditions, with the 'ELSE" condition being another IF.   The google sheets documentation for the IFS function clearly explains this.   It would be very helpful to make long nested formulas much more readable! Thanks for the great work with Airtable 🙂 ... View more

What is the proposed idea/solution? Enable date formatting on formula columns How does is solve the user problems? My use case for this would be to insert templates or build template tables for project management on events we do over and over again. For example, if we plan a webinar, we know which tasks need to get done in what order and how many days apart. We have a formula for how many days before or after the live webinar date each task needs to be done. If I include a column for the live date and include the variance to live date, I should be able to auto calculate the due date for each task but there isn't a format that allows for this. ... View more

Enable a formula on a record level (like gsheet). My use case for this would be to insert templates or build template tables for project management on events we do over and over again. For example, if we plan a webinar, we know which tasks need to get done in what order and how many days apart. We have a formula for how many days before or after the live webinar date each task needs to be done. Since it's not always the same number of days for each record I can't use a formula in the current set up.  ... View more