I have created a database to keep track of educational programs and I am finding that it would be very helpful if the time in a date-time field could be a range. For example: August 20, 2019 4:30 - 6:00pm. Right now, I get around that by doing the following, but then I have to fill in two separate fields and it would be great to have it in one. ... View more

Duration fields are awesomely useful. However, if one wants to simply transfer the displayed duration (e.g. 1:45) to another field via a formula, Airtable passes along the stored value in seconds. Converting that back into a duration-like display is doable, but a little tricky, as I found out in this recent discussion: Convert Seconds to h:mm in forumla Ask the community I’m having trouble with something that seems very simple. I’d like where it says “0.9 available” for it to show that time formatted as “h:mm”, as it does in the “Time Available” field next to it. [image] Here the formula for the Name field: [image] Essentially I think I need to convert seconds to hours, minutes and seconds within a formula, but I can’t find a way to do it and feel I’m probably just missing something simple. Thanks so much. I tried the TIMESTR() function, but that just gave an error, so I ended up writing my own seconds-to-duration formula. My suggestion: expand the TIMESTR() function’s capabilities to also convert durations into strings. I suppose a new function named something like DURSTR() might also work, but because durations are all about time, wrapping that conversion into TIMESTR() feels like it makes more sense. ... View more

Hi Airtable. I’d like the ability to override the contents of formulae-text cells with text of my own. I most commonly use this for record titling/naming. We use Airtable as a meeting/diary manager. So if we put in the people who attend, the formulate title could be “Roger meets David”, but we could override that title to become “Financial Planning Meeting 3”, say. You can think of it as “overriding” or as “defaulting” but the point is that there are lots of time when i want formula-based default titles which can be changed to something else later. ... View more

Currently the sort order of a single select field is only useable when records in the same table are sorted by that field. Very often single selects are looked up in another table, causing the sort order to be lost and the records sorted alphabetically instead. To preserve the sort, the current alternatives are to 1. Create a formula field in the destination table that prepends numbers to each option in the lookup, which is not so pretty and error prone if options or names in the single select ever change, or 2. Break out the single select field into a new table with an additional ‘Sort Order’ field, which has to be filled in for each record, then looked up in the destination table – usually overkill. Since sorting order is already baked into single select fields, it would be awesome for this sorting behavior to carry over to any tables that look that field up! I can see how preserving the sorting behavior of the single select may cause confusion as a user if you’re unaware that the source field is a single select, but that may be alleviated if the lookup was also formatted with the same colors as the original single select, similar to how lookups of linked records are now formatted the same as linked records. ... 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

Some of the AirTable universe bases that I see as examples/templates have cover pages as well as left-hand navigation for the different views (as opposed to seeing it via a dropdown). I was wondering if it’s possible to have your internal base have a look and feel similar to that. I can imagine that this would be very useful for collaboration, especially in cases I want to share bases that will be used by different groups of people who are unaware that the drop-down is the way to find the different views. Anyone manage to solve this problem? ... View more

When sharing in external places like iMessage or Slack that support a rich preview, it would be much more helpful if links to specific records or specific bases/views actually said in the preview what the name of the card or base/view was rather than every link always just saying “Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.” That way someone can see what we’re talking about before having to click the link. Alternately more readable url’s would be nice. ... View more

It would be great to see an option to add sections to the page builder. This could really increase the flexibility of the visual data on the page by having option of when to display that data if particular fields are empty. For example, you have a linked record that may not always get completed dependant on the task, but currently if you want to print that data you would have to set it up in the page builder anyway and print blank fields. By creating a section, you could drop a group of fields in there and select which ones need to be complete before this section will show. This would also work really well with larger invoices, rather than guess the number of lines you may need, the sections would push the lower order section down the page. Hopefully this makes some sense because it would be awesome to use… in my opinion 😄 ... 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