The “find in view” feature could be a lot better. Here are the problems I see: Search text obscures field names: when you click the magnifying glass or type ⌘+F, the text-entry window covers up the field names. You can’t tell what field you’re looking at unless you scroll left/right to get around the search window. Search only returns “perfect match” results: If I search for “John Doe” I also want to see results for “John S. Doe,” “John Q. Doe” and “Dr. John Doe.” As it is, these variants are outside of my search results. Unless I know their middle initials or titles and know that they were entered into Airtable with those variants, I have to search for “Doe” and look through every single Tom, Dick, and Harry “Doe” to find the John I want. Search is limited to a single field: Similar to the above, I want to find a 2016 transaction made by Jane Smith, but if I search for “Jane Smith 2016” no results are found. Search results should be more like filter results: My people table has 5,000+ contacts and three different formula fields that incorporate their name. So if I search for “John”, I find a lot of Johns distributed throughout my base and have to click through “John” three times in each record until finding the one I want. I often end up creating a filter just for the purposes of finding a single record. It’s beautiful the way a filter eliminates everything you’re not looking for and collapses all the “Johns” into an easy-to-scan group of records. But it’s time-consuming to create a custom filter for the purposes of locating a single record. Couldn’t search work more like the filter? Anyway, those are my observations/suggestions. Overall I think Airtable is terrific and I love seeing it get better and better. ... View more

In many different areas of Airtable, important fields have their information completely cut off. You can see this with calendar views, gallery views, kanban views, forms, and linked records. Below is an example of a cut-off linked record. What year is the linked record? Is the time of the linked record AM or PM? What makes this kind of absurd is that Airtable actually KNOWS that these are date & time fields, but Airtable itself doesn’t even give enough room for its own date & time fields to display properly. ... View more

When sending out records from Airtable, it would be great if I didn’t have to type in the email to send the record/s to. If I have the contact email stored in my table or base, why can’t AT pull that list of emails for me? ... View more

This post inspired me to make this product suggestion. We already have the DATETIME_FORMAT function, which lets us use a formula field to reformat the data from a date-type field into a text string of our specifications. But it would be really great to have that exact same ability to reformat a number field or a currency field into a text string of our specifications. For example, take these 2 fields: Currency Field — formatted as currency with $ sign and precision of 2 decimal points Number Field — formatted as decimal with precision of 4 decimal points If we put these 2 fields into a formula that results in anything other than a single number result, they lose all of their formatting. So instead of a desired sentence which looks something like this: “You bought 0.4500 pounds at $2,200 each.” The formula currently looks like this: “You bought 0.45 pounds at 2200 each.” We can easily add in the dollar sign, but adding in the commas and trailing zeros is harder to do in a calculation. ... View more

When could we prefill linked record field in a form view? It could be really helpful to be able to prefill also linked record field with RECORD_ID() value for instance. ... View more

I need to add a linked record to several hundred rows, without deleting the existing linked records. When I try to paste the new record into the rows, it deletes everything that’s already in that cell and replaces it with only the pasted record. Doing this by hand would obviously not be time effective. Please tell me this is a feature and I’m just not seeing how to do it! Deleting a linked record from multiple rows would also be helpful! ... View more

Hi - We’re looking to pull a percentage of a task complete and reflected that % as a progress bar in a cell for a single record. We want the progress bar to be continuous (up to an integer) as the % of the task completed is updated… I.e. (just one of many use cases) if we have a record that is counting # of forms submitted for a given record, and the total number is noted in the record, the percentage of completed forms with respect to the completed record is reflected in an updating graphic progress bar. Bootstrap plugin example: https://www.w3schools.com/bootstrap/bootstrap_progressbars.asp. The progress bar Airtable feature should update from as the percentage cell on the record self-updates upon completion of a given trigger elsewhere in the Airtable ecosystem. Many thanks! ... View more

Currently if a formula field will return only a date or a number, Airtable will have formatting options for that formula field. However, if the formula will return a string or might return a string, or might return anything other than a date/number, there are no formatting options. Sometimes I write a formula so that it will usually output a date or number, but will return a string if an error condition is met. For example, a formula might calculate the number of days between two dates (a number) but output a string if the end date is before the begin date. This product suggestion has multiple parts to deal with these situations: Allow formulas to output errors which are distinct from the calculated value. For example, if a formula calculates a negative number, but negative numbers are not allowed from a business logic point of view, have the formula report an error that would be recognized as an error, not just another value. This would be similar to the #ERROR message, but could include a human readable string saying what the error is from a business logic point of view. Once formulas can report errors as errors, many formulas that sometimes return strings could then be considered to always return a number or a date or an error or blank, and thus could have formatting options. Increase the formatting options for formula fields to include formatting options for all the formula types. For example, a formula could be formatted as a centered check box (not just a left aligned emoji), as a rating with stars, as a select (with the colors of a select). ... View more

I would like to use a ARRAY_FIRST() and a ARRAY_LAST() function, taking an array as argument, and resulting in the first (or the last) element of this array. For now, I have to ARRAY_JOIN(my_array, ",") first, and the look after the string before the first “,”… which is a little tricky and need 2 formulas. ARRAY_JOIN(my_array, ",") → my_joined_array (formula 1) IF(FIND(',', my_joined_array) = 0, my_joined_array, LEFT(my_joined_array, FIND(',', my_joined_array) - 1) ) → the final value (formula 2) I would like to write ARRAY_FIRST(my_array) as an unique formula… Thanks, Rémi ... View more