Automatically ordering Multiple Select categories

Suzu_D · ‎Sep 16, 2020

Yo! I have been using Airtable for a little while now, coming from Trello, and I love it. Great work the Airtable team has done. There is one way I believe this already-great program can become even better, though. What about adding an option that allows a Multiple Select category to automatically arrange record data, based on the order the options appear in the dropdown menu? Notice how the “Damage” option appears before “Wounds” in the top record, but then after it in the record at the bottom? It would be of considerable benefit to a-many of us if we could get a tick option in the Multiple Select dropdown menu to automatically sort each record’s cell data. Thanks for reading.

Christian_Rodri · ‎Aug 04, 2016

I imagine lots of people use Airtables to keep track of ordered lists that they want to filter, reorder, and remanipulate, but ultimately return back to the original ordered list. Further, I imagine that from time to time they want to change how that ordered list is ordered… ENTER THE RANK TYPE! It: only accepts integer values when a number is changed, if increments everything at or above it! A table could even have multiple rank columns for different dimensions! It’s like magic! Orderly magic!

cerickso · ‎Jun 13, 2023

Enable a formula on a record level (like gsheet). My use case for this would be to insert templates or build template tables for project management on events we do over and over again. For example, if we plan a webinar, we know which tasks need to get done in what order and how many days apart. We have a formula for how many days before or after the live webinar date each task needs to be done. Since it's not always the same number of days for each record I can't use a formula in the current set up.

cerickso · ‎Jun 13, 2023

What is the proposed idea/solution? Enable date formatting on formula columns How does is solve the user problems? My use case for this would be to insert templates or build template tables for project management on events we do over and over again. For example, if we plan a webinar, we know which tasks need to get done in what order and how many days apart. We have a formula for how many days before or after the live webinar date each task needs to be done. If I include a column for the live date and include the variance to live date, I should be able to auto calculate the due date for each task but there isn't a format that allows for this.

Databaser · ‎Jun 13, 2023

What is the proposed idea/solution? You can "hide identical fields", but not computed fields (which can't be merged). Let users choose to also hide the computed fields. How does is solve the user problems? It will be easier to have an overview of the records when those fields are hidden. Less scrolling

Abbie_Friesen · ‎May 11, 2017

Similar to how the grid view can group items, I’d like to be able to group items within the gallery view.

Sho · ‎Jun 11, 2023

What is the proposed idea/solution? The referenced field order can be changed to the selected View by setting "Limit record selection to a view" How does is solve the user problems? The fields you want to see when selecting linked records should be different for each table or View. While "Limit record selection to a view" allows filtering of records, it would be helpful to be able to set the field order as well. Who is the target audience? Users frequently using the link record --- The field order of a table when referenced from a linked record depends on the first View of the referenced table. It would be very helpful if we could set the recently added (I forget when, but it wasn't there in the past) "Limit record selection to a view" on the link record to change the field order to the selected View. This may also be related to this post. Change Field Order on Linked Record

Layne_Peterson · ‎May 08, 2017

Link fields in other tables show up as options for a Lookup field, but not the link fields to the self-linking table. I see a feature request for Rollups on self-linking tables (Roll Ups for Fields Linked Within The Same Table). Is there no way to use the linked field within the table for Lookup at this time?

Admin_Expert · ‎Sep 04, 2020

I want to insert images into an automated email. I have the email set up. I have used the markdown syntax for very basic formatting. But we really need to add a signature line that includes our company logo.

Ken_Moholt-Sieb · ‎Apr 20, 2017

A table view that allows the user to draw simple shapes and place them to form a layout, and then place records in those places. Starting with a simple gridded background (i.e. like graph paper) place a circle or a rectangle in the grid and then connect that shape with a record in the table, or perhaps a query of the table. In my particular situation, I’m working on a winery production database that will keep track of wine lots and barrels and tanks. A common way of managing tanks is to use a whiteboard with circles in permanent ink drawn on the board to represent the tank layout in the tank room and then use white-erase pen to write in the lot and date of fill and planned date to empty. This is a similar problem to POS systems in restaurants, that have a view where you can draw simple circles or rectangles to represent tables and keep track of seating and reservations that way. A manufacturer with process flow or a warehouse with stocking will have similar needs. You could use this kind of view for a seating chart or for an office inventory as well.

Automatically ordering Multiple Select categories

"Rank" column type

Record level formulas

Date format for formulas

Hide computed fields in Dedupe app

Group Galleries

Setting field order when referencing linked records

Self-linking tables (and lookup/rollup/count fields)

Email Automation Image attachment

Floor Layout with simple shapes that can be positioned

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...