Delete unused / combine duplicates in single/multiple select fields

Desiree_Snoek · ‎Mar 29, 2021

I’d love to see an option that scoops out which items of a list are not in use (anymore) and enables me to delete all these options from the list in one click. I’d also like to be able to combine values in the single & multiple select fields. Especially when you have accidentally added a bunch of records and made a typo in the field, which will then have caused a new option to be created. Ideally I’d open up the Customize field type screen, select two or more values and hit a button ‘combine’. I’ve been using the collectorz.com programs to catalogue my books & dvds for years and they have this option available, it’s an option that I highly appreciate and would love to see here, too!

Drew_Nemer1 · ‎Nov 20, 2022

I have often incorporated many complicated automations in order to prevent employees from updating records to certain statuses without inputting certain required fields first. I wish there was a way that I can make a field editable dependent on conditions, such as if these other fields are not blank. Instead of creating an automation work around. For instance, I don’t want employees to mark a record as complete unless if they input the Field A and Field B. Right now I have an automation that goes on condition that if a record is marked complete and Field A and/or Field B is not completed, that it would revert to the previous status and send an email to the employee notifying them. However, I would like it so that that the employee literally cannot click and edit the Single Selection Field unless they completed the previous steps in the workflow I am attempting to generate.

Miguel1 · ‎Nov 18, 2022

I’m having the same problem as this post Group by date rather than datetime - #3 by Jason_Carlin Grouping by date with time creates a new group for each time for the same day not for just the day, I tried creating a new formula column with just the date and grouping it but having it grouped by a formula removes the option to ad cell to the group and cannot paste several cells either

Anna · ‎Nov 18, 2022

Hi! I’ve been using Galleries a lot recently to share information in our community - and while I love them, I’ve found myself wishing for a number of improvements/options: Option to hide empty (unfilled) fields. Yes, I know that means that the fields wouldn’t necessarily line up across the cards, and I’m okay with that! Option to change card width. Sometimes a wider card would just look better. Option to wrap long text and multi-select options. Ability to choose additional fields to appear in the expanded view without having to show all fields. Option to hide the Customize cards, Filter, and Sort buttons at the top. Option to hide the Primary field. Often for me this is an autonumbered ID field that I don't want to share out. I think some or all of this can be enabled with miniExtensions but it sure would be great if it could be done within Airtable! :pray:

Jay_DeDapper · ‎Jun 13, 2019

Commenting would be far more helpful if it behaved in Airtable as it does in products like G Suite and Office 365 – comments can be resolved and therein no longer displayed as an action item (in the case of Airtable denoted by the small number in the far left column of the record).

Sean_Murphy1 · ‎Aug 10, 2023

I appreciate being alerted when an automation fails. It's a must-have feature for potentially critical automations. Right now, according to the official documentation, the last user who turned it on receives the alert. This setup isn't sufficient for bigger organizations. It would be more effective if we could specify multiple recipients, whether for all automations in a base, specific sections, or individual ones. Being the sole recipient is concerning. Are there any temporary workarounds available? I suppose I could write a rule in my email client to forward them to other colleagues but I'm old fashioned and use a local email client which isn't always running.

Jacob_Turley · ‎Aug 29, 2018

Right now it looks like you only support a single level version of a pivot table. It would be great if you could support multi level, i.e. rows by assigned collaborator, and by deal stage(basically getting deals per assignee per stage)

Shandi_Greve_Pe · ‎Jan 09, 2020

Feature suggestion: the ability to hide/archive a table within a base. I’m not talking about records, nor am I talking about creating a link to a view to share with others. I actually want to hide a table that I’m not currently using but that I also don’t want to delete. (For example: I have three content calendars, and I ended up not using one. I don’t want to delete it because I hope to use it in the future, but I also don’t need it cluttering my view every day.) Thanks!

Paul_Teplitz · ‎May 31, 2018

Hi there: Part of how I use Airtable is as a CRM, and I am setting up a table that my staff can use to track customer interactions. We are interacting with hundreds of customers, and it’s very useful to be able to know which staff member was involved in previous communications with a customer. Just like there is a “created time” field type, it would be great to have a “created by” field type. Alternatively, a formula that returned the username of the active user would also be a potential solution. Thanks, Paul

Kamille_Parks · ‎Dec 20, 2018

Right now, to format values pulled from a Currency field in a Formula field, users have to use something akin to the following formula to get “$65,756” to display as such. Otherwise, AirTable displays it as “65756”, no commas, no currency symbol: IF( LEN(CONCATENATE({Trip Budget}))<4, {Trip Budget}, IF( AND(LEN(CONCATENATE({Trip Budget}))>3,LEN(CONCATENATE({Trip Budget}))<7), LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-3)&","&RIGHT(CONCATENATE({Trip Budget}),3), IF( AND(LEN(CONCATENATE({Trip Budget}))>6,LEN(CONCATENATE({Trip Budget}))<10), LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-6)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3), IF( AND(LEN(CONCATENATE({Trip Budget}))>9,LEN(CONCATENATE({Trip Budget}))<13), LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-9)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),9),3)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3), ) ) ) ) This is obviously inconvenient, and it doesn’t even take into account decimals or amounts greater than $999,999,999. I propose a new formula function that operates something like this: CURRENCY([number or field reference], [currency symbol]) => CURRENCY(12345.6,"$") = $12,345.60

Delete unused / combine duplicates in single/multiple select fields

Conditional Fields outside of Automations

Group by date ignoring the time

Gallery Feature Wishlist

Resolving Comments

Define Recipients for Automation Failure emails

Multi-level Pivot Table

Hide/archive tables in a base

"Created by" field type (or username called by formula)

Add a CURRENCY() function for Formula Fields

Format Formula as Checkbox

CSV Import in Interfaces

React to Record Comments

Allow Emoji reactions to comments

Multiplying by percent column yields result that i...