Submitted on
Jun 23, 2020
12:40 PM
Submitted by
ScottWorld
on
Jun 23, 2020
12:40 PM

It would be a real game-changer — and totally awesome — if the column headers at the top of Airtable’s grid view would wrap lengthy field names onto multiple lines. Other spreadsheet programs allow for variable heights of the column headers — we should have the same capability in Airtable. Currently, Airtable cuts off the text of lengthy field names, but it’s our only choice if we want to keep our columns tight & narrow. If we want to see long field names, we are required to keep our columns extra-wide, which wastes a lot of screen space. Check out the screenshot below for an example of this problem. Notice how much wasted space there is, simply because we want to see the field names above. Our users often request descriptive field names so that they can understand exactly what they are looking at in the rows below. But descriptive field names end up making the column extremely wide. Yes, we could come up with some sort of abbreviation for the field names, but it’s nicer for our users to see the entire field name. Yes, our users could also hover our mouse over the field names to see the entire name in a tooltip, but that is inconvenient & it takes time for the tooltip to appear. In other words, what I’m requesting is either: The column headers should automatically increase their size vertically to accommodate longer field names. We should be able to manually change the height of the column headers. Thanks! 🙂 — ScottWorld, Expert Airtable Consultant
... View more
Submitted on
Feb 24, 2016
03:58 PM
Submitted by
Outdoor_School
on
Feb 24, 2016
03:58 PM

It would be incredibly useful to me if Airtable was to become HIPPA compliant and be willing to sign Business Associate Agreements. http://www.hhs.gov/hipaa/for-professionals/privacy/guidance/business-associates/
... View more
Submitted on
Mar 13, 2019
02:30 PM
Submitted by
Ron_F
on
Mar 13, 2019
02:30 PM

Hi, As far as I can tell, currently you can set row heights to Short/Medium/Tall/Extra Tall. This height setting is applied to every row in the base. It’d be nice if there could be a “dynamic height” option, where each individual row is set to a height depending on its longest content. So a row that has a cell which requires 5 lines to display will have a height of 5 lines, while a row whose longest cell is only 1 word will be still be the “Short” height. This would be really useful for bases where we have text content that varies greatly in length (for example, user responses to an open-ended survey question). Right now, I have to set the height to “Extra Tall” to fit in most answers, but this wastes a lot of space because there are also lots of short answers which end up taking up way more space than they need.
... View more
Submitted on
Mar 21, 2016
09:10 AM
Submitted by
Rebecca_Flores
on
Mar 21, 2016
09:10 AM

Unless Im missing it, I would like the ability to lock changes to fields in a base and/or records. Would help prevent accidental deletion. I discovered several days later I had done this…
... View more
Submitted on
Nov 03, 2017
10:06 AM
Submitted by
David_Von_Lehma
on
Nov 03, 2017
10:06 AM

When adding linked records to a column you can only select one at a time. This means you have to click “Link to a record” and re-enter the search term each time. Would love to be able to hold down “Ctrl” or “Cmd” and select multiple linked records at once. It would be a big time saver.
... View more
Status:
Launched
Submitted on
May 22, 2016
10:42 PM
Submitted by
Aaron_Owen
on
May 22, 2016
10:42 PM

I’m really excited about the recently released calendar views. Thank you for including this in AirTable. It really helps to visualize certain data that’s associated with date and time.
That said, I’m curious if you plan on supporting date ranges? My use case is that I track events that are happening in the world, specifically film festivals. I have a table that contains a list of 1200 film festivals and their start and end dates. I’d love to be able to see the ability to create a view that shows the range of dates that the festivals are occurring. Right now I can only choose either the start or end date, which is helpful, but doesn’t show me overlapping dates between the different events.
... View more
Status:
New Ideas
Submitted on
Feb 10, 2023
10:53 AM
Submitted by
Perrin_Romney
on
Feb 10, 2023
10:53 AM

What is the proposed idea/solution? Make Interfaces available on the iPad How does is solve the user problems? In construction, we use iPads for most of our inspection and statusing. To not have an interface useable on the iPad app is a major barrier to being able to use this in the field. How was this validated? ... Who is the target audience? Anyone who uses Airtable not sitting down
... View more
Submitted on
May 22, 2018
01:36 PM
Submitted by
Jeremy_Oglesby
on
May 22, 2018
01:36 PM

There are several requests floating around the forums related to the need/desire for more formula field functions - mostly related to arrays, linked records, or javascript like functionality.
I’m going to create this #feature-requests post with some of the initial ones that I have posted myself, or have seen in the forums, and I will endeavor to keep it updated with new ones that I find or see posted; and, I will even endeavor to cross them off the list as Airtable implements them :winking_face:
To keep the format clean, I’m going to make a section that lists just the function requested and a brief description of functionality - I think the intention for use and the use-cases should be clear by the structure of the function. This will be followed by a section with links to some of the posts I have seen addressing the need/desire for some of these functions.
Airtable users - If you have an idea for a function that is not currently in the list, post it as a reply here and I will try to add it to the list in this OP if the intention is clear and the functionality seems feasible.
@Airtable_Support, @Airtable_Team, @Katherine_Duh, @Howie, @Kasra - please consider :grinning_face_with_big_eyes:
Functions List
LOOKUP(table, field, linked-records-field)
Lookup field functionality, but can be evaluated within a formula field
ROLLUP(table, field, ROLLUP-FUNCTION())
Rollup field functionality, but can be evaluated within a formula field
ARRAY_DIFF(array 1, array 2)
Takes two arrays (or strings of objects with a separator that can easily be converted to an array) - returns {array 3} which contains all objects from {array 1} that do not also exist in {array 2} (ie, subtract {array 2} from {array 1})
ARRAY_EACH(array, variable, FUNCTION())
Takes an array and a compatible Function - loops over the array and for each object, saves the object in the variable, and allows the user to use the variable in the chosen, compatible, string function (such as SUBSTITUTE() , or FIND() ) or in logical Functions (such as IF() , OR() , AND() ); works like a JS for loop
ARRAY_INTERSECT(array 1, array 2, array 3, ...)
Takes any number of arrays (or strings of objects with a separator that can easily be converted to an array) - returns an array with only objects that exist in every array provided to the function
Links List
Formula Fields: Values Based On Javascript Functions Product Suggestions
This one might be a little bit “out there,” but I think that if it were possible it might address a number of requests for additional functions supported by Airtable’s Formula Fields…
I’m wondering if it might be possible support Formula Fields whose values are based on the result of some ad-hoc Javascript function. For example, the user might specify other Airtable fields as the Javascript function’s params, specify the JS function itself, and have the Formula Field’s value reflect the result. …
Array intersect formula Product Suggestions
I have 2 tables, and I need a result that shows only inputs that are the same in both tables.
Hence, to compute the intersection of a number of arrays.
array intersect ( array1, array2 [, array#… ] )
Returns an array containing all the values of array1 that are present in all the arguments.
Where:
array1
The array with master values to check.
array2
An array to compare values against.
…
A variable list of arrays to compare.
Any workarounds at this point?
Comparing two arrays and remove values that appear in both Product Suggestions
Hi airtable!
I have a list (an array) of items in two columns. Each row represents two different lists (one in each column). I’d like to be able to compare the two columns and remove what is common in both. For example
Row 1:
Column 1: Apple, Orange, Pineapple, Kiwi
Column 2: Apple, Kiwi
Result: Column 3: Orange, Pineapple
Row 2:
Column 1: Banana, Orange, Grape, Kiwi, Pineapple, Passion Fruit
Column 2: Orange, Grape, Pineapple
Result: Column 3: Banana, Kiwi, Passion Fruit
etc.
The …
Look-Up from a Look-Up Field Product Suggestions
A very useful feature to have would be the ability to “drill-down” another level when working with Look-Up fields.
We use AirTable to manage our company E-mail accounts and Distribution Lists (Distribution Lists are email addresses that contain members and distribute messages to all who are assigned to it, i.e. info@company.com can go to John, Mary, and Paul). Here is the basic set-up between 3 tables:
Table PEOPLE contains a list of all employees, and links to EMAIL which contains all email a…
How can I make a lookup field show only unique results? Ask the community
The result I am looking for is similar to the ARRAYUNIQUE function for a Rollup field. However, the results are a link to another table, and it seems that using a rollup can only show text results as opposed to clickable records. How can I make lookup field show only unique results, or make the unique results of a rollup field clickable?
Dynamic (calculated) link to a record in a linked table Ask the community
How to create a dynamic (calculated) link to another table?
There is a Table#1 (Daily Expenses) [ID, Date, Sum, subject,MonthNo].
Where MonthNo=MONTH({Date})
There is a Table#2 (Months of the year) just as follows:
MonthNo MonthName
1 January
2 February
3 March
etc.
Linking Table#1 to Table#2 will allow me to calculate monthly expenses directly in a Table#2 by means of Lookup(Sum) function.
How can I do this? If I choose a standard Link field then every time later I will have to select…
COUNTIF AND COUNTIFS Formulas Product Suggestions
It would be great if the COUNTIF and the COUNTIFS formulas were implemented in Airtable. I use them in most of my excel spreadsheets, and it is a little frustrating not being able to use it here. Are there any plans to add more formulas?
Support lookups and references/links within formulas Product Suggestions
First off, Airtable is great! One thing though: I’d really like to not have to create additional columns in order to simply do something like the following:
Formula:
if(lookup(row_10,"column_1"),lookup(row_12,"column_4"),lookup(row_53, "column_2"))
Also, I have a lot of varied data and I’m trying to use one big table for everything with lots of different views rather than use lots of different tables with aggregate tables and views based on those smaller tables. I can link to a row within the…
... View more
Status:
New Ideas
Submitted on
Dec 19, 2023
03:44 PM
Submitted by
benburne
on
Dec 19, 2023
03:44 PM

What is the proposed idea/solution? The proposed solution is to enable interface creators in Airtable to add images to an interface during the design process. This feature would allow the inclusion of static imagery, such as logos, background images, instructional graphics, or decorative elements, directly into the layout of Airtable Interfaces. The aim is to enhance the aesthetic appeal and instructional clarity of these interfaces. How does it solve the user problems? This feature addresses the need for more visually engaging and informative interfaces. By allowing creators to add relevant images, it makes interfaces more intuitive and tailored to specific use cases. For instance, a logo can reinforce branding, instructional images can guide users through complex datasets, and decorative elements can improve the overall user experience, making data interaction more enjoyable and efficient. How is this validated? Validation for this feature can come from user feedback, requests, and the observed trends in interface design across other platforms. Users who seek to create more personalized and visually appealing interfaces often express the need for such capabilities. Additionally, benchmarking against other data management tools that offer advanced interface customisation options, including imagery, can further validate the need and effectiveness of this feature.
... View more
Submitted on
Apr 10, 2016
12:21 PM
Submitted by
Al_Ansar_FC
on
Apr 10, 2016
12:21 PM

It would be great to have a way to switch tables to display from right-to-left for Arabic for example.
... View more