Often I'm needing to cycle the Autonumber field to cater for changes made to table data. We could really use a simple method to reset the number count for the Autonumber field. Currently, the only method is to change the field from Autonumber to either Text/Number field, and then change it back again into Autonumber, which then resets the count as desired - but is a pain. Please also consider other counting methods too, maybe a simple method that allows the user to adjust the base, be it Base 10, Base 16 (hex), and a simple alphanumeric, where select letters can be removed (such as the letter l and I, as not to be confused with 1, and Q and O to avoid mixups with 0.)   ... View more

What is the proposed idea/solution? When searching within a view, add a toggle to display only matching records / hide non-matching records How does it solve user problems? Quickly surface matching records within a view to see results "at a glance" instead of jumping to each match. Prevents having to click "next" button repeatedly if there are multiple search term matches within a single record. It's different from setting a filter within a view, because each filter rule only applies to a single field. Who is the target audience? Any user. Interestingly, the mechanism already exists in Airtable, but only in the Calendar and Timeline views. Click the "See records" button, and type in a search term in the sidebar that appears. You will see a filtered list of records, and it searches all fields. It's a feature I use everyday, but I've never seen it mentioned anywhere. ... View more

What is the proposed idea/solution? New Comment automation trigger with conditional logic Add actions to list, create, delete and update records On a JavaScript record object, add methods to list, create, delete and update comments ... How does is solve the user problems? Automation triggered by new comments could be used at the user's discretion. One example is to send a message/notification to a third-party service like Microsoft Teams. The ability to create comments from automations/scripting could be used at the user's discretion. One example is to leave a comment (as an automations user) if a record didn't meet certain conditions. The current method requires: Generate an access token with data.recordComments:read and/or data.recordComments:write scope Add a Script action to an automation Craft a fetch request for each comment operation and exposing the access token Would be much simpler to create an instance of a record object and use a method like:    record.createComment() record.deleteComment() record.updateComment() record.listComments()   ... Who is the target audience? All users ... ... View more

What is the proposed idea/solution? Add the ability to embed a custom image into a dashboard. Add the ability to embed a custom image into an interface. Add the ability to add a custom image to a base instead of the base name. How does is solve the user problems? Adds in branding and personalization for the company/ team using Airtable. Allows teams to recognize the base they are in if they are dealing with more than one company/ team. How was this validated? I am not sure how to answer this. Who is the target audience? All companies, business, teams who want to further personalize their Airtable experience. If someone like myself deals with multiple teams, I want to be sure I am providing a dashboard that reflects the teams branding instead of just choosing a color that closely resembles the branding. ... View more

When you choose a list interface, there is the ability to sort and filter the data.  However, if you choose the list element on blank canvas the there is no ability to sort. Also sorting on grid view in blank canvas would be very helpoful ... View more

I'd like to see a formula function for looking up values in linked records, something like: LOOKUP({Linked Record field}, {Field in linked table}) Basically, a two-criteria lookup similar to "INDEX MATCH MATCH" in Excel without needing to import all the fields from the linked table into the current one. Or just a dot/membership operator in SQL databases. Currently, if I want to fetch data from a linked record, I need to use a Lookup field. This is fine if I want to display  the field's values in my table or consistently refer to it in a formula; but if I have multiple fields I want to reference in a single formula, then I would need to add a Lookup field for each of the source fields. This adds an number of extra fields to my base that only serve a single formula field and clutter up my field lists. (Or I would need to do something hacky with the formula, or use scripts/automations.) For example, say I have two tables: Articles and Authors. Articles has fields like Article Author, Article Type, and Article Cost. Authors has fields like Name, Email, and the rate schedule (News Rate, Feature Rate, Review Rate), as below: Articles Article Author – Linked record: Authors Article Type – Single select: News, Feature, Review Article Cost – Formula: ? Authors Name – Short Text Email – Email News Rate – Currency Feature Rate – Currency Review Rate – Currency Articles Written – Linked record: Articles If I want to lookup an author's email address, I can add a Lookup field and it's a good reference to have for every record in my article table. However, for an article's cost, I only want to see the relevant rate from the author's record. Currently, in order to do this, I'd need to add Lookup fields for each rate because the Formula field can only reference fields in the current table: Articles Article Author – Linked record: Authors Article Type – Single select: News, Feature, Review Article Cost – Formula: SWITCH({Article Type}, "News", {News Cost}... News Cost – Lookup: Author.{News Rate} Feature Cost – Lookup: Author.{Feature Rate} Review Cost – Lookup: Author.{Review Rate} But now I have three fields dedicated to this one formula. The fields are of no other use in that particular table and are basically clutter that I have to hide in every view. If a LOOKUP function existed, then I don't need those extra fields, and instead my formula would look something like SWITCH({Article Type}, "News", LOOKUP({Article Author}, {News Rate})... This would benefit anyone working with rate cards, inventories, or schedules (or any case where they need to perform a variable-field lookup). Another use case is doing a "deep" lookup, such as getting the country code for a phone number based on a city. Say you have a base with tables Phone Numbers, Cities, Countries; and Phone Numbers are linked to Cities, and Cities are linked to Countries; and {Country Code} is a field within Countries. Because Lookup fields in Airtable only go to one other table (you can't lookup a Linked Record field in another table and get data from that third table), you would have to add a Lookup field to Cities for {Country Code}. ... View more

What is the proposed idea/solution? In the Date field, would be nice to have more date formats, or the chance to write our own format, including day names, shortened months, invisible years/days, etc. How does is solve the user problems? Helpful for UX, legibility and general aesthetics. Who is the target audience? Anyone who uses dates in creative ways in their bases ... View more

What is the proposed idea/solution? ... I often use the 'modify' function when using automations (especially for creating/updating). It would be super helpful if we could set this on the preferred fields in tables so that every record - even for records that are already in the table - is modified automatically.  I use the formula field for LOWER and UPPER functions - however, title case is one that I use frequently, but it isn't available. How does is solve the user problems? ... Saves time & confusion on automation set up as well as increases data validation & reliability. Who is the target audience? ...anyone ... View more

What is the proposed idea/solution? The ability for passed query string parameters (key/value pairs) and Headers to be parsed and made available as DATA OUT from the Airtable Automation trigger for When Webhook Received. How does is solve the user problems? The ability to provide query string parameters and Headers separate from POST data. How was this validated? By testing query string parameters and headers being sent as part of the webhook request and those variable values not being present in the received webhook data payload. Who is the target audience? Advanced users of Airtable Automations. ... View more