What is the proposed idea/solution? Reading through the available rollup field formulas, I'm surprised there's no Mode() or Median() available for use. https://support.airtable.com/docs/rollup-field-reference How does is solve the user problems? Mode and Median are a staple in 6th grade mathematics, and I can't even begin to summarise how they solve countless user problems that they're used for. The target audience is anyone working with a rollup field wanting to quickly extract mode and medium data from their linked record array. In my current example, I have a Rollup containing several dates, and I need the most common date - IE, the mode(values) needs to return the date that occurs most often within the array. mode(["2023-01-09" , "2023-01-09", "2023-01-08" , "2023-01-09"]) returns "2023-01-09", similarly how max() returns 2023-01-09 and min() returns 2023-01-08. So importantly, Mode() needs to work not only on numbers and integers, but also dates as well - or possibly even strings. For example, a Rollup mode(values) of ["Dog", "Dog", "Dog", "Cat", "Dog", "Cat", "Cat", "Dog", "Mouse"] returns "Dog". ... View more

When using “Color/Select field” on a custom view, you can only choose single-select fields. Adding lookup fields leading to single-select fields would be nice. My use case: I have a list of people assigned to groups. The group table has a single-select field named “Color” where each option has its own color. I want a view showing people colored according to the group they belong to. In a more simple case, I would use a single-select field named “Group”, where each value would have its own color. But here, as I need to store informations about groups, I need them to have their own table. ... View more

Airtable is such a wonderful app, I can create forms. But I would love to use Airtable to enable paperless application forms that require signature. Such as Leave application for HR purpose. Applicant needs to sign the form, and the immediate supervisor needs to approve or not approve it. Thank you. Either a new feature, or a work-around would be highly appreciated. :slightly_smiling_face: ... View more

Could we please have a better error message when attempting to change password? In what way is the password invalid? How can I make it valid? ... View more

I’d find it quite useful to be able to embed and/or link to individual records. Ideally, this would be without sharing an entire table. ... View more

It’s great to be able to “Limit record selection to a view” when selecting a Linked Record, however, this means that the number of views gets out of hand quickly. It also means creating views that you will never look at (as they are only needed for filtering Linked Record options). I would prefer the ability to filter linked records by conditions instead. This would add flexibility and prevent the creation of unnecessary views. Bonus points if you could filter based on data from both the current record, and the Linked Record. For example, show if {Current record field} contains_______ and {Linked Record field} contains _________. ... View more

It would be very useful to be able to edit a lookup cell from either the source or destination table. Currently, if I’m working in a destination table and notice an error, missing information, or data that needs updating, I need to go to the source table and find the correct cell to edit that information. This is a challenge in a table with 107 columns! :bow_and_arrow: It would be much more convenient to be able to edit the information in the destination table and have the corrected information populate back to the source table. ... View more

I think this has been posted already, but I wanted to recreate the topic and give more details so more users can find themselves actually wanting the same thing. I’m sure many companies (like ours) fell in love with Airtable first they saw the great features it has. When you see how you can greatly simplify project, database, or table management in general, you realise that with Airtable you can save a lot of your owns or your employees’ time. But then… When I started to create some big tables, I found out this app lacks some simple regional options such as: Cannot change the decimal separator (not every country uses a “.” dot) Cannot set a custom date format (not every country in Europe uses MM/DD/YYYY) In Germany we use MM.DD.YYYY and this must be respected. I know there is a workaround to create another column and use DATETIME_FORMAT() formula to reformat the date from original column - but this is not a solution. Strings like month or day names should be translated to the chosen language of the base. So if you ever implement Regional and Language Options, please make it so users can change it for a base, and not whole program. So, before we migrate completely to Airtable, and switch to one of Business plans - we’d like these fundamental options implemented. Of course, we already are using Airtable, but just to create base concepts that we will use once this is implemented. Thank you for your time, and please make this a priority. ... View more

I’m imagining being able to access the data in a linked record in a similar way to how you access child properties of objects in many programming languages. Example You have an ORDERS table and a PRODUCTS table. PRODUCTS contains Item Name, Item Code and Price columns. The ORDERS table has a Linked Record field called Products. You could then access the Products properties within a formula field in the ORDERS table like this: Products.{Item Name} Products.{Item Code} Products.Price ... View more