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

A problem we often come across is we can’t change the display name of the record in calendar view or linked field – it always takes the primary field. A workaround is to use ‘formula’ as the primary field to customize the display name. However this causes further issues: You might want a different display name for different purposes. Eg. When a project record links to several tasks fields, you want to show the task name only. But when displaying all task fields in a calendar view, you want to show the task name AND the related project name. Project: write a blog post about X; links to 3 tasks “find cover image”, “research” and “write” But when displaying the calendar in Tasks table, I’d like to see “Find cover image[assignee][status]” or some other form of display. These short tasks names fit nicely within the Project record view But these Task record names in Calendar view are not very useful Ideally we could choose a different field (eg last one) for displaying in calendar/linked records If you’re creating a new linked record from within a parent record, if the primary field is a formula, you won’t be able to edit the text unless you expand the record. E.g. Project: write about X; links to tasks: click on “+” to add a new task. ==> can’t edit the primary field because it’s a formula. Therefore if we could keep the primary field a text field, BUT specify a different display name field when creating a linked field, we could easily create a new child record as well as seeing desired record display name within the parent record. This applies to calendar view too. When adding a new record from calendar view, if the primary field is a formula it’s difficult to add the text you want, especially for non-technical users. When creating a new task from within calendar view, you can’t edit the primary field ... View more

Would be a useful feature to minimise selection from a linked table’s rows. Example: Our business has subcontractors who become active and inactive at different periods, their activeness represented by a checkbox data column. If they are inactive, they should not be able to be selected when assigning a subcontractor to a service. ... View more

Add role-based viewing permissions for tables, views, and fields. We already have permission editing ability for tables and fields in regard to who can edit or delete. It would be great to also have a permission of who can view the field or table. Additionally, I think it is just as important to extend all of the same permissions to views as well. ... View more

Airtable needs to replicate how Excel helps with formulas: Highlight elements of the formula and show brackets in different colours and different formulas in different colours Provide basic guidance… if a bracket is missing, then tell me it is missing and suggest me where it should be and ideally perhaps show a tally of brackets I add so I can later see how many closing brackets I need to add without having to go through the formula and recount the brackets; If there is a circular reference, then show me the parts that are involved; If there is a missing argument in a formula, then show me where is the missing argument, and perhaps suggest what argument is missing; some of the formulas are specific to AirTable requirements e.g. VALUE() and BLANK(), often these are used to deal with errors in other formulas, so I would appreciate if AirTable could suggest how to fix typical errors e.g. non-number argument in a formula that requires a number and so on… When creating new formula the window shows the sample format, but clicking on the individual argument doesn’t take me to the part (and highlight the part) of that argument in my formula. I could go on and on… ... View more

It can be difficult to understand what someone’s formula is doing when the editing window is so small and the formula is huge, spanning many lines and wrapping many times, sometimes with deeply nested IF statements. It would be great to have a larger space to view and work with the entirety of the formula, especially if the formula is also prettily formatted and structured to make it more readable! ... View more

I’m using the Map Block for a research project and it works great, but I think it could benefit from two hopefully simple-to-implement features: 1. A collapsible record list showing the records that appear on the map. This could of course function exactly like the Record List Block, and may look similar to Calendar views (the calendar or in this case map appear on the left side of the screen, and a record list on the right). Right now I’m using both blocks in tandem, but they don’t technically relate to one another so I have to collapse/minimize the map block to see a full list of records. Seeing the map and the list of records side by side would be very useful. I could then expand a particular record easily without having to find its location on the map, selecting the correct marker, and then clicking expand record. 2. A “zoom to record feature” for maps. It would be nice to either search within the Map block to find a record, or select from the record list described above and have the ability to zoom to the record’s location on the map. Right now, navigating back and forth between non-proximate sites in the Map block is cumbersome, and one would need a general idea of where a site is geographically to get to it; that, or clicking on each marker until they select the right record. ... View more

I hesitate to make suggestions here, because of how even the most popular and basic requests have yet to be implemented, but I will anyway. I would like to be able to execute an HTTP request against values in other fields. This is possible in Excel and would be just as valuable here. The most basic implementation would use the GET method where I would define the URL and querystring separately. GET Endpoint: https://my.rest.endpoint.com/api/doTheThing Querystring: myVal1={{Field Name}}&myVal2={{Field Name2}} Yes, this would be an advanced feature that would generate support requests. Perhaps it could be hidden behind an Advanced Features toggle in a workspace’s or base’s settings. ... View more

This product would be very useful for both higher education and P-12 applications if it was FERPA compliant. FERPA came up a few times in the HIPPA section, but it is worth examining on its own as FERPA compliance is likely more of a contractual issue than a technical issue. Schools (P-12 and higher ed.) have a responsibility to keep student data private and only contact with software companies who agree contractually to abide by the same data responsibilities. Perhaps Airtable already has all the technical data controls needed to be FERPA compliant and the only issue is the necessary contractual guarantees to meet educational standards. The educational software market is a massive multi-billion dollar market and growing rapidly … in case you are worried about the returns from putting in a bit of work on this. Partly because of the FERPA issues, the current data solutions in education are poor. There are either massive, unwieldily databases like Student Information Systems or folks at the department/school/classroom level trying to build excel sheets to manage all the data. A solution between those 2 (your product) would be really useful for a large number of applications. ... View more